How to link an Excel file with variable number of columns to a destination such as a database without modifying a read script

Question

I am considering using HULFT Integrate to read an Excel file that contains data for each year in each column and link it to a destination such as a database.
If the number of columns in the Excel file increases, is it possible to link it to the destination without modifying the script?

Answer

1. Use the Read from Sheet operation.
   Please specify extra empty columns considering the increase in the number of columns.
2. Use the Switch Row/Column operation.
3. Write it to an intermediate file, such as CSV file.
4. Read the intermediate file
5. Use the Mapping operation.
   Use the Mapper logic [If Loop], [Single-line String Constant], and [Different] to map the data so that "if the data in each row in the first column is not empty, the data in each row is extracted".
6. Link it to a desitination, such as a database.
7. (Optional) Delete the intermediate file

-References

[Switch Row/Column]
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/table_switch_row_column.htm

[If Loop]
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/IfLoop.htm

[Single-line String Constant]
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/SingleLineStringConstant.htm

[Different]
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/StringNotEqual.htm