How to write condition to read the values from the middle row in excel sheet

[#1]

Below is the .xls spread sheet- need to read from row 83(UGTX1000) to 103 (till blank) and it also read the data’s in Purple color which is linked to row 83. The same thing has to be read in multiple xls sheets.

I used where condition but it only read row 83.

Please let me know if anyone find answer.

[kaushiknsolanki]

Kindy share sample excel.

Regards

Kaushik Solanki

[sunny_talwar]

What is the script that you are using? Can you share that?

[#4]

Script was like below to read the values in single xls sheet.

Directory;

LOAD BUNDLE,

,

,

,

,

FROM

txeappags902v\TSVLicScript\USALic\UserData\TCLICReportUser03032016040204.xls

(biff, embedded labels, header is 2 lines, table is ) Where RecNo() >= '83';

Thanks,

Hema

[#5]

Hello.

This app will allow you to load multiple sheets each from the line 83 to 103.

Thnak you also to Hemalatha Boregowda who give me the idea of filtered. !

You can change

where Recno()>=1502

and   Recno()<=1600

to load the appopriate lines

Best regards

[#6]

Thank you Destin.

[oknotsen]

If your question is now answered, please flag the Correct Answer and possible Helpful answers.

If not, please make clear what part of your question you still need help with .