To read workbooksheets from a excel file

May i know how to write vb.net expression to read the first excel sheet and the second excel sheet

Hi @sathish_Kumar6

Why do you like to read the workbook sheets in VB.net? Do you have any specific reason

Regards
Gokul

sheet names will change everytime so if we use getworkbook sheet vb.net expression then it will get the first sheet and second sheet eveytime so that would be helpful for me

Hi @sathish_Kumar6

In this case you can try with Get Workbook Sheets activity to get all the sheet name dynamically. Use Read range activity and pass the output of Get Workbook Sheets

image

Regards
Gokul

Hi,

How about the following?

wkb.GetSheets()

Regards,

1 Like

thank you @Yoichi

1 Like

thank you for the reply

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