I'm trying to create an invoice. I have an excel template I fill in and save as binary. I want to be able to save it as a PDF for download and/or sending via email.
I've read just about every post on this forum about saving excel binary data as PDF and I've not gotten it to work.
I tried the ExcelToPDF forge asset but have had no success. It doesn't work in the asset's demo either.
The result is an undefined binary size zero (ExcelToPdfConvertBytes.Return_Byte__). I see this asset says it needs to be paid for. Is that why it's not working?
Is there another method to save excel to PDF or should I be using another method like displaying the excel binary file on a form and use Ultimate PDF to convert?
Hi @Jeff Kest ,
The Forge component was for 'Traditional web'. Maybe that could be a reason for its failure.
If the filled data in the Excel is in a standard structure, you can try to convert it into a RecordList using 'ExcelToRecordList'.
Then, create a PDF screen and design it for using the values in a screen.
Use UltimatePdf component for downloading it as a PDF.