I have 3 different table and i want to automate the process that can write all three tables in one Excel spreadsheet and the name of spreadsheet with current date. How to achieve it?
currently i have 3 different tables after applying the row filter and Excel writer node.
Will the names of the worksheets always be the same? Also will the workbook name be the same except for incuding the current date?
The sheet name remain same but the Excel workbook needs to be different everyday with current date name( 10.17.2023.xlsx)
This should work. You can rename the file, tabs and change the filepath to fit your needs. You can also eliminate the column headers in the Excel Writer node if you don’t want them. To see the file after execution tick “Open file after execution.”
2 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.