We are currently evaluating Aspose.cells for our project. Our requirement is to have the application output report both in excel and pdf.
We faced some formatting issues when using Aspose.Cells to export the generated excel file like this:
//Instantiate the Workbook object
Workbook workbook = new Workbook();
//Open an excel file
//Save the document in Pdf format
1: The font in PDF report is smaller then the excel report, resulting more rows appeared in PDF per page then excel.
2. Column width for pdf seems to be smaller then excel some times, resulting the content of the cell to be wrapped at different character (see G2_AC_test.pdf page 4 first column).
3. Top border of the first row of table on a new pdf page, is thiner then the excel report (G2_AC_test.pdf page 2).
4. We are not able to find any options to control the PDF page number. Our requirement required us to restart the page number for each excel tab.
Attached are the sample report we generated with ASPOSE.cell. Do let us know if there are existing API we can use, or there will be any fixes going to realise by ASPOSE to solve these issues.