Different Output From The Same Excel Between Excel Application And Excel Workbook

Help Activities
, ,
1

Hi, I try to get last row from the excel

image
image1701×662 13.2 KB

I try to use workbook at first and it’s work fine, but when I read other excel, I get Identifier expected error, then I switch to Excel Scope, with everything same, but the output is different, Excel Workbook output is 7, but Excel Applicatioin Scope output is 9. This is the ss
image
image1354×674 31.8 KB

image
image1391×701 34.9 KB

2

Hi @Hendaryie_Tjoeng
First thing is that some fields are merge in row 4 & 5. When you read range from A5, reading headers may have issues.
For your question, what is ‘output’ you mentioned? If you’re talking about the data table, they’re the same between with excel scope and without excel scope.

image
image1007×562 136 KB

3

I have to get how many column in the excel, and write a new header in the right, but when i count the column using workbook and excel scope, the output is not same

4

Please share your excel if possible.

5

@healsko_ho instead of just passing single cell range A5, try to give exact rage of your data. To get Last Row of the data you can use Find First/Last Data Row

Once you have the range like A5:G9 you should have your data accurately.

Regards,
Ashok :slight_smile: