We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Excel sheet is not getting converted to pdf properly

Hi,

We are not able to attach the excel sheet column in the PDF document when we try to make it an inline attachment. It seems there is some property of the excel column that is not being handled by the aspose. Please let us know the workaround and the main issue in this.

We are using java Aspose 2.7.0 and Cells 2.5.4

Here is the code template :

Workbook exl = new Workbook();<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

exl.open(fileName);

for (int i = 0; i < exl.getWorksheets().size(); i++) {

try {

for (int a = 0; a < exl.getWorksheets().getSheet(i).getLastRowIndex(); a++)

exl.getWorksheets().getSheet(i).autoFitRow(a);

} catch (Exception e) {

}

}

exl.save(pdfFileName, FileFormatType.PDF);

Hi,

Thanks for your posting.

There is some problem with this file. When I open it inside a Print Preview, Ms-Excel 2010 shows me error as shown in screenshot. Aspose.Cells for Java actually prints what is shown inside a Print Preview.

Screenshot: