Get the cell value for a column without header

Help Studio
, ,
1

Hi
I have an excel file that contains columns with header and without headers.
I want to get the cell value for column without header.
Example
image
Here in this image attached I have marked a box in black above rate
How to get the cell value for that cell.
Here I have attached the excel sheet for the same.
Rate.xlsx (10.3 KB)
Can anyone help me how to solve this?
Thanks in advance.

2

Could you please tell us what will be your expected output?

3

Hi

Assuming that top blank row is not included, try this:
dt.Rows(0)(0).ToString

Cheers

Steve

4

Hi @Vinit_Mhatre
The result according to the provided sheet has to be cell value as “G37”
Cheers.

5

Hi @Kunal_Jain

How about the following?

image
image900×1455 54.7 KB

image
image1172×803 40.8 KB

Main.xaml (16.8 KB)


RowNumber=System.Text.RegularExpressions.Regex.Match(Cell,"[^-0-9]").Value
CellNumber=Cint(System.Text.RegularExpressions.Regex.Match(Cell,"[^A-Z]+").Value)

Cheers!!

6

@Kunal_Jain

In the use excel file activity

Use log message with Excel.Sheet("SheetName").FirstCell

Cheers