I have interface displaying record data in grid format. When the user clicks Export to PDF, the currently filtered results (or all records if no filter is applied) should be downloaded in PDF format.
Discussion posts and replies are publicly visible
1. Read excel using readexcelsheetpaging function. this will return headers and data separately.
2. Create an html template, pass headers and data as input and generate an html document using "HTML Doc from Template" smartservice.
3. Pass this html doc to "HTML to Pdf" smart service.
readexcelsheetpaging function requires excel document, but i dont have excel doc.
You can just get it from MS Excel.
thanks, tried this