Judging by our use cases and also questions that pop up on the forums, that’s a pretty common situation to read -> verify/perform actions -> write status to same file (essentially an excel based queue).
It would be useful to have an optional RowNumber column added when using ReadRange on Excel files, possibly with a parameter for offset.
I’m thinking of adding 2 parameters:
Possibly the offset could be calculated from the Range parameter if flag is true, but offset not specified.
This would enable easier update of excel rows - instead of keeping a separately tracked index, we’d be able to have it in the row itself. Since it would be added on read step, modifying the DT (f.e. deleting rows) wouldn’t mess it up and there would be no need for index offsetting on deletion.
RowNumber column could be marked as AutoIncrement with seed 1.