Pdf from xlsx file

Aspose.Cells Product Family
1

The attached xlsx file when converted to pdf file in Apose.Cells shows only the first line when there are multiple lines. Check rows 3, 6, 9, 12, 15 and 18 and their corresponding rows in pdf file. Thanks,

2

I find a way to overcome this issue by using the method:
workbook.Worksheets[0].AutoFitRow
for each row that has issue showing the whole content before converting to pdf file.

3

Hi,

Thanks for your posting and using Aspose.Cells.

It is good to know that you were able to resolve your issue by using the autofit rows method. We have also tested it with the following code using the latest version: Aspose.Cells
for .NET v8.6.2.2 and found that the output pdf is correct now. I have attached the output pdf for your reference.

C#
string filePath = @“D:\Downloads\Menu_999999_ZZZZZZ_NDC_20151201143402579.xlsx”;

Workbook workbook = new Workbook(filePath);

Worksheet worksheet = workbook.Worksheets[0];

worksheet.AutoFitRows();

workbook.Save(“output.pdf”);