I am trying to generate a PDF from excel template. When I open the excel template from MS Excel and simply save it and generate the PDF then the Value appears in both PDF and excel Template . But without opening the same template when I try to create PDF then in place of value, #N/A appears in both pdf and excelTemplate(see 12th row of Staging sheet in excelTemplate.xlsx).
Steps to follow:
Without opening the excel file(excelTemplate.xlsx) attached here try to generate the PDF then, #N/A appear in PDF.
Open the template and simply save it and try to generate PDF then, value appears in PDF.
Workbook workbook = new Workbook(io);
workbook.save(“myresult.pdf”); // i have used Display sheet of excelTemplate.xlsx to generate pdf
The excel file is attached with this post resourceUsed.zip (103.9 KB)
in zip format