This is a reactive web. Currenly I have a server action to create and download excel, but I want to be able to download from excel to pdf and also send email attachment with pdf. Appreciate If anyone can provide the guide and the solution with oml file.
Required:
Hi @Jia Wen Loo it will not great if you creat Excel to pdf because of data of Excel.
You can follow a approach that I have used in past. Just get the data from the Excel and populate that data on a screen with the design you want and then print that screen using any forge component and generate that screen into pdf.
I hope this will help. Let me know if any other help required.
Hi Yashpal, Thanks for replying me. I have tried the solution that you said using ReactivePrintPDFButton forge, but I have facing some issue which is print screen with table, the print screen won't show all of the table data and it will cut off a few columns.
Appreciate if you can provide the solution for resolving this?
Hi you can use the ultimate pdf forge componen. Inside that component you will get a layout webblock using that you can define the layout of the pdf and that will make your pdf into pages. Just set all the data into the content placeholder.
I hope will help you. If this resoles then please mark it for the reference.
Thank you
Hi Yashpal, I have created using ultimate pdf and their layout block before. But the issue still exist, even I used landscape the table column will still be cut off....
So you have more columns than the screen size right.
Hi @Jia Wen Loo ,
Please use this component ExcelToPDF
For more detail please refer below post
https://www.outsystems.com/forums/discussion/50440/exceltopdf-excel-to-pdf/
Hope this will help you. Let me know if you need any help.
Thanks,
Amit
Absolutely! There are several solutions and online tools that can help you convert Excel files to PDF. One popular method is using Excel itself—just 'Save As' and choose the PDF format. for more info you can visit Downloading SOftware site
Hi @Jia Wen Loo
To convert the Excel File to PDF, you can use ExcelToPDF Forge. Once you have generated the PDF, you can send it through email using the "Send Email" tool provided in OutSystems.
For a better understanding, you can refer to the OML file shared below.
Thank You.
But mine is reactive web, can this forge still be used?
Yes, I have created it in Reactive. You can check the OML file that I shared with you.
Regards,
Rishabh.
To convert an Excel file to PDF in a Reactive Web application, use ExcelToPDF Forge. Send the generated PDF as an email attachment using the "Send Email".