How to read excel sheet data using VB.net

Help Community
1

How to read excel sheet data using VB.net.
i want to export excel sheet data as Datatable.

2

you can use readrange activity to achieve this

3

If i use read range activity then i am getting read range error. so i want read excel sheet through vb.net or VBA and i want to return those data as data table.

4

what is the error you are getting

5

could not read range and i tried read range workbook activity also. it is also not working.

6

Can you please specify the exact error here?

7

could not read range. my excel file contains 16k records and more then 35 columns
1

8

If you’re getting an error with Read Range then you’re doing something wrong. You should fix it, instead of trying to do it with vb.net. Excel activities work fine if you configure them properly.

9

Show the properties of your Read Range and Excel Application Scope.

10

In excel application scope with read range activity if my selection range is A1:Z600 its working fine and A1:Z700 again getting this error.

11

If you just want to read all the data, you don’t specify the end of the range. Just specify “A1” as the range so it’ll start at that cell.

12

yes i want to read whole sheet and am specifing range as “”

13

Again, please show the properties of your Excel Application Scope and Read Range. Take screenshots and paste them here.

14

Untitled
Untitled1357×704 158 KB