I have to get all columns values with the information inside evey cell. But i am not able to do this, i could not think in way that i can do this, so i got this scrip, that reads it by columns, but iam afraid that if i do it for every single column the information may got lost and without references from one to other, so how can i extract to get as result na intire line?
Here’s what i got extracting only the cells in a specified column:
Fine
Hope these steps would help you resolve this
—use a excel application scope and pass the file path as input
—inside the scope use a read range activity and get output with a variable of type datatable named dt
—now use a WHILE loop and mention the condition like this counter < dt.columns.count
Where counter is a int32 variable defined in the variable panel with default value as 0
—inside the while loop use a FOR EACH ROW loop and pass the variable dt as input
—inside the for each row loop use a WRITE LINE and mention like this row(counter).ToString
This will give all the row and all the column values in sequence in output panel