Hi, I have multiple excels in a Folder.
I each of the excel I have three sheets I have to read the data from the three sheets and feeding in a ExcelTempate where once feeded the value I have to convert the same template in .PDF format. Kindly suggest.
screenshot of the folder.
same for rest of the excel file.
Like in Excel101 I have
Note: In each excel I have sheet1, sheet2 & sheet3 (3 sheets) I have to read the data from all 3 sheets and feeding into an exceltemplate then save that template in .pdf format.
@Palaniyappan @HareeshMR @Lahiru.Fernando