May

The PDF converting function is expanded in Spire.XLS 7.0.34

We are glad to announce a new hotfix version of Spire.XLS for bug solutions. Spire.XLS 7.0.34 is available today as a download not only specializes in fixing bug, but also upgrading another function in conversion, which enables you a smooth experience. More details are as followed:

Functions:
1. Fix bug of parsing Stylesheet which caused incorrect color of font without color data.
2. Expand the value range of orientation properties in cellrange to -90.

Code Snippet:

[C#]

#region prepare file
String inputFile = @"source.xlsx";
#endregion
using (Workbook workbook = new Workbook())
{
	workbook.LoadFromFile(inputFile, ExcelVersion.Version2010);
	Worksheet worksheet = workbook.Worksheets[0];
	CellRange range = worksheet.Range["A1:F1"];
	
	//Rotation = 180 means orientation=-90 
	range.Style.Rotation = 180;
	range.AutoFitRows();
	Array.ForEach(range.Columns, (c) => worksheet.AutoFitColumn(c.Column));

	using (PdfConverter pdfConverter = new PdfConverter(workbook.Worksheets[0]))
	{
		PdfConverterSettings settings = new PdfConverterSettings
		{
			FitSheetToOnePage = FitToPageType.NoScale
		};
		using (PdfDocument pdfDocument = pdfConverter.Convert(settings))
		{
			pdfDocument.SaveToFile("Bug_117.pdf");
		}
	}
}

Welcome to experience Spire.XLS 7.0.34 with downloading here :
http://www.e-iceblue.com/Download/download-excel-for-net-now.html

Written by Koohji.