Missing rows after xlsx to PDF conversion

Aspose.Cells Product Family
1

It was noticed that the created PDF is missing a few rows that are present in the source document.
Input and output files are attached.
input_and_output.zip (191.0 KB)

Code

public class ExcelPdf
{
public static void Run()
{
var doc = new Workbook(@"./input.xlsx");
doc.Save(@"./output.pdf", SaveFormat.Pdf);
}
}
image.png (354.6 KB)

It would be great if you could help me resolve this issue.

3

@vad492,
Some data was not output because your first worksheet sets the print area to “B1:K121”, so data outside this range will not be output during export. Excel also processes in the same way. You can output all data by calling the following code to delete the print area.

doc.Worksheets[0].PageSetup.PrintArea = "";

Would you like to try it?

4

Thank you for your response. That’s the issue. Problem solved!

5

@vad492,
Thank you for your feedback. If you have any questions, please feel free to contact us.