Could someone please guide me on how to export excel sheet data into multiple PDF pages dynamically while saving the excel file as Pdf?
You can try using the Save Excel File as PDF Activity.
You would require to use this inside the Use Excel File Activity. Currently, there isn’t an option in the activity to export a specific worksheet by its name directly to PDF. However, you can control which sheet gets exported by setting the Start Page and End Page properties. If you set both to 1, it will export only the first worksheet in the Excel file.
emphasized text
Alternatively, you can copy the required worksheet into a new Excel file and then use the Save Excel as PDF activity on that new file. This ensures that only the desired sheet is converted to PDF.
Let us know if you need further help.
Hi @MohammedShabbir,
Thanks for the response.
Let me explain you the requirement in brief.
So the basic requirement is bot should adjust all the columns within the width of the pdf page based on the data added into excel sheet and complete text in the each table cell should be clearly visible and it should insert rows given (10 or 20 it should be configurable) into the pdf page and the no of pages should be adjusted dynamically based on the given rows and excel data in that sheet. When we save this excel sheet as pdf , this pdf should show only the given rows in given no of pages to be exported.
Could you help us on this.