How to find first free column in an excel worksheet? Is there any direct action that i can use

Help StudioX
,
1

Hi,

kindly help
How to find first free column in an excel worksheet? Is there any direct action that i can use?

Thanks and Regards,

2

One way to do it in an easy to understand manner is to Read the first 2 rows of an excel column (if your Excel has a header) or just the first row (if there is no header) using the Read Range activity.

Check if any of the columns in the data row has zero length. The position of that column would give you the position of that cell.

Example. If DataTable.Rows(row_number)(5) is empty, then your column is D(row_number).

Just a quick thought. Maybe there are other fancy ways. :thinking: