Good Day all,
My question is When I get the schema of an EXCEL worksheet with Column headers I get what's expected the names of the columns but when I get the schema of a worksheet without headers I get the first row of data as the Column Names. The trouble is in determining if a worksheet has headers or not, so as to program my connection string correctly. Anyone have thoughts on this? I created a worksheet with the schema as it is in the dataView.
Thank you
KRod
Jump to PostI'm not really sure what you're asking here. You wish to check to see if there are headers in an Excel file with VB.NET?
I'm not really sure what you're asking here. You wish to check to see if there are headers in an Excel file with VB.NET?
That's it exactly.
Well I have come to the conclusion: Added a CheckBox to the Form for Has or HasNot Column Names, Let user Preview the WorkSheet, set Connection String from that. Kind of ruins any automation though.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.