Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
How do I do a select from an excel file, where the headers is not in the first row? The first and second row contains some date and logo, so I want to start at third row in my select. is there some way to skip the two rows when reading? the code looks like this: String strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\test.xlsx;Extended Properties=Excel 12.0;"; String strSelect = "SELECT [text] FROM [sheetname$]"; OleDbDataAdapter daMaster = new OleDbDataAdapter(strSelect, strConn); Regards Kim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
ListBox with header row, delete row, protect header row | Excel Programming | |||
Excel-Header-My Company Name won't work in Header (AT&T) & Time | Excel Discussion (Misc queries) | |||
Sort - Header:=xlGuess vs Header:=xlNo | Excel Programming | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) |