How can i automate excel sheet by making rows dynamic in that but columns fixed?

Help
1

How can i automate excel sheet by making rows dynamic in that but columns fixed? Please suggest solutions.

2

@Ankita121,

Welcome to our Community!.

Please elaborate your requirement, on high level we can do it with Read range and write range activities. Not sure what exactly your are looking for.

3

It can be done with these activities but how to select the range.

for example : right now i need to pick total value from the sheet but that total value can be anywhere depending on the number of entries. may be it can be in row 23 and the next day it can be in row 35. this is the scenario. how to do this?

4

@Ankita121,

Read the excel data using a read range activity. Then based on the datatable’s row count you can get the total value.

Option1: Read range will give you the excel data, so if your total value is the last row then the same in the datatable as well. Get the value from the datatable’s last row.

yourDataTable.Rows(yourDataTable.Rows.Count-1)("totalColumnName").ToString

Option2:
Use Read range activity and read the whole excel sheet data, then in a Read Cell activity you can pass the cell number as “C” + (yourDataTable.Rows.Count +1).ToString, this way it will give you the cell which one you want to read.

5

Ok . Will try this one . Thank you :slightly_smiling_face: