We are receiving an Excel workbook with multiple worksheets. I only want to process the last worksheet with a Static Name that has data on the worksheet. Can we have a solution to process that last worksheet?
Note: The name of the worksheet changes every time the file is received.
This requirement can be achieved by following below steps:-
- Create an Excel schema with any sheet name.
- Write a custom plugin to fetch the name of all the Worksheets from Excel Source Excel file along with the sheet size and based on that store the name of last Worksheet name in a variable.
- Use the Custom plugin activity just after Excel Schema so that the sheet name is set in the variable.
- Over-ride the sheet name with the name set in the first step. Over-Ride Sheet Name.