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 this 707402681_UNITS_Summary.xlsx (…

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)

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

balupad14 (Balamurugan) October 20, 2020, 5:26pm 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

Topic		Replies	Views
Search for a value in another excel Studio	12	1547	September 20, 2020
How do I get the last value in Column A? Learn excel	17	5058	June 22, 2020
StudioX: How to find out last row number and column name, index in an excel range? StudioX excel	8	2591	February 26, 2021
Get last column with row value Studio	6	6172	March 21, 2022
How to Find out last column in Excel Studio excel , activities , studio , hi-all	9	1629	July 19, 2023

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

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

Related Topics