I’m trying to read an Excel file which has not a fixed number of columns but a variable number of columns.
I saved the number of total columns in an integer variable, which varies according to the used Datatable.
I would like to know:
- how I can extract the current number of column in the While Activity;
- how can I can READ only the column with the current column number;
I would like to use READ RANGE Activity to read the column variable because I need a DataTable variable to perform successive tasks.
Thank you in advance,