468,244 Members | 1,827 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,244 developers. It's quick & easy.

Trouble Reading Column Name in excel File into Dataset, C#

Hi,
I am reading excel file and reading values from that
I am using provider As : "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + Filename + ";Extended Properties=\"Excel 8.0;Hdr=No;IMEX=1\"";

EXCEL File

WINDOWS FILE EXEL 2003_______ 23 _______24
File Name : abc.txt______________145______124
File Data : 04/05/2009
Sample Name: xyz
Sample Weight: 23 gm
Sample Description: Dry

Time____Mass_____dm_________Sol 1____Sol 2____Sol 3
0.01____13.8355___138.355______-8910_______0.55______24.87
0.02____14.8355___144.355______-3310_______0.21______33.87


but After reading values into Dataset values look like

DATASET

WINDOWS FILE EXEL 2003_______ 23 _______24
File Name : abc.txt______________145______124
File Data : 04/05/2009
Sample Name: xyz
Sample Weight: 23 gm
Sample Description: Dry

Time____Mass_____dm__________________________Sol 3
0.01____13.8355___138.355______-8910_____0.55______24.87
0.02____14.8355___144.355______-3310_____0.21______33.87
Column Name 'Sol 1' and 'Sol 2' is missing even though it is reading the readings. Just not able to read column names.

I am not sure about what is exact problem. so please help me in solving this.

Thanx in advance.
Apr 6 '09 #1
1 4047
r035198x
13,262 8TB
Recheck your configurations, Perhaps you mistyped something somewhere?
Apr 6 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Andre Ranieri | last post: by
5 posts views Thread by Scott M. Lyon | last post: by
4 posts views Thread by Amit Maheshwari | last post: by
9 posts views Thread by dba123 | last post: by
3 posts views Thread by Brad | last post: by
2 posts views Thread by rwiegel | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.