Export specific column values in excel to datagrid using VB.NET

Question

0.00/5 (No votes)

See more:

How to export particular column values which does not have header to datagrid

...

dta = New OleDbDataAdapter("Select * from [linexcel$])

...

How can I specify the column(column B and D) instead of '*'. It does not have constant header.

...

What I have tried:

dta = New OleDbDataAdapter("Select  A1 from [linexcel$])

Posted 3-Mar-20 22:50pm

Member 14747725

Updated 13-Mar-20 13:53pm

Add a Solution

Comments

Richard MacCutchan 4-Mar-20 7:01am

I have tried a number of combinations based on suggestions provided by Google, but have not got a working solution. I suggest you just use the standard SELECT * construct and extract the fields you want manually. Alternatively you could look into using the Excel Interop features if you have Office installed.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2020-03-04T02:14:00

Solution 1

Use this:

SQL

Select  [F1] As ColumnA, [F2] AS ColumnB from [linexcel$]

Posted 4-Mar-20 2:14am

Maciej Los

MarcusCole6833 · Answer 2 · 2020-03-04T08:02:00

Solution 2

My Suggestion is using the EPP DLL for doing this is using the epp library gotten from github here

GitHub - JanKallman/EPPlus: Create advanced Excel spreadsheets using .NET[^]

reference their website is here

Features - EPPlus Software[^]

using the .net framework you can pull up their packages via Nuget

A basic Example lies here

Getting Started · EPPlusSoftware/EPPlus Wiki · GitHub[^]

Posted 4-Mar-20 8:02am

MarcusCole6833

Comments

Richard Deeming 4-Mar-20 14:43pm

It's a shame that EPPlus is moving to a noncommercial licence. I can understand why they're doing it, but I guess it means we'll have to be more careful about recommending it in future - if it costs money to use, then a recommendation could be seen as spam.

MarcusCole6833 4-Mar-20 15:04pm

Thank you for that!!

codejet · Answer 3 · 2020-03-13T13:54:00

Run initial select statement to obtain column names

dta = New OleDbDataAdapter("Select * from [linexcel$])
Dim tbl As New DataTable
dta.Fill(tbl)

' Column B and D would would be at index 1 & 3 respectively
Dim ColBName As String = tbl.Columns(1).ColumnName
Dim ColDName As String = tbl.Columns(3).ColumnName
dta  = New OleDbDataAdapter("Select " & ColBName & "," & ColDName & "  from [linexcel$]"