Hello,
I have defined number format of cells in Excel.
When I convert that Excel file into PDF, I get other format.
Excel format: 1 920,08
PDF format: 1,920.08
Excel screenshot:
PDF screenshot:
How can I retain excel data format ?
My Spire.XLS version is: spire.xls.free-2.2.0
I simply load xlsx document and save it as code snippet bellow:
com.spire.xls.Workbook wbToExcel = new com.spire.xls.Workbook();
wbToExcel.loadFromFile("ExcelOutput\\" + Utils.getCustomerInformation(customer, 1) + "_credit_note.xlsx");
wbToExcel.saveToFile("PDFOutput\\" + Utils.getCustomerInformation(customer, 1) + "_credit_note.pdf", FileFormat.PDF);