Hi Team,
We are observing below issues in pdf out put of excel file using Aspose Cell library.
1. Font size is not matching with excel sheet in exported PDF document.
Check font size in source excel and aspose generated pdf. Compare any cell
2. Alignment and spacing is incorrect in exported PDF document.
Check header section alignment and spacing in generated PDF.
3. Image added in header section of excel document is blur and not properly aligned in exported PDF document.
Check image added in Header section in source excel and aspose generated PDF.
You can compare the Manually Generated Excel sheet and its out put as PDF from MS-Excel with
aspose generated excel sheet with exported PDF programmatically.
Please find attached documents for reference.
We are using below code over the excel file.
Aspose.Cells.Workbook wb = new Workbook();
wb.Worksheets.Clear();
Worksheet ws = wb.Worksheets.Add("Test");
byte[] headerImage = File.ReadAllBytes("141119261548.wmf");
ws.PageSetup.SetHeaderPicture(1, headerImage); <?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-com:office:office" />
for (int row = 0; row <= 10; row++)
for (int col = 0; col <= 10; col++)
ws.Cells[row, col].Value = string.Format("Cell_{0}_{1}", row, col);
wb.Save("Test.xlsx");
wb.Save("test.pdf", SaveFormat.Pdf);
Hope it is clear.
Thanks and Regards,
Nakul