What to mention when sheet having no header

Help Activities
, ,
1

image

I am trying to add new column before columnA . what to type in relative to column if we dont have header on column A.

2

Hi @Hemant_Deshmukh

You can use the column index number for inserting

Regards

3

i typed “A” but its giving error that this column does not exist

4

@Hemant_Deshmukh

You can give like this

Excel.Sheet("SheetName").Cell("A1")

cheers

5

Hi @Hemant_Deshmukh

FYI Another approach. Please remove Has Headers option then "A" will work.

Check the below image.

image
image786×938 39.3 KB

Happy Automation
Regards

6

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