I had a excel which has project ID but problem is cell of project ID get change whenever new excel come. How to get that ID

Help StudioX
,
1

I had a excel which has project ID but problem is cell of project ID get change whenever new excel come. How to get that ID.
Like in current attached sheet Project ID is in I2 cell but it might change for other excel it might come in G2 or D2 or K2. How to achieve this707402681_UNITS_Summary.xlsx (11.5 KB)

2

Is the project ID always on row 2? Is it always 9 digits? Can it contains letters? If it’s only digits, is it always the only number in row 2?

3

Yes its always in row2 and always be numeric but yes column change

4

Column change means always last column ?

Regards
Balamurugan.S

5

Yes always last column

1 Like
6

Use the “Find Last Column” activity to find the last column. after that concatenate the Column value with 2.

Video explanation :

Regards
Balamurugan.S

7

Getting this error

image
image1792Ă—961 222 KB

8

If you don’t want to use a custom activity you can always get the last column like this:

ProjectID = DT.Rows(1).ItemArray(DT.Rows(1).ItemArray.Count-1).ToString

Row(0) - first row
Row(1) - second row

See attached file for an example. GetLastColumn.xaml (5.1 KB)

9

Hi @Puneet_Singh1,

Use the excel scope from BalaReva → EasyExcel-> Main. like below.

image
image1903Ă—905 65.6 KB

Regards
Balamurugan.S

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.