Check Header in Excel
-
hi all, im doing this project using c# and asp.net in visual studio. one question here, i needed to check if it is the Header of the excel sheet telly my heading. (how to read and check the excel heading from the first row?) -- will do a check like.. A1 = code , B1 = name, C1 = Department eg. Excel: | Code | name | Department | thanks! :-O =D
-
hi all, im doing this project using c# and asp.net in visual studio. one question here, i needed to check if it is the Header of the excel sheet telly my heading. (how to read and check the excel heading from the first row?) -- will do a check like.. A1 = code , B1 = name, C1 = Department eg. Excel: | Code | name | Department | thanks! :-O =D
-
hi can you give a few code to help you but i think if you know where are your informations you can use : worksheet.Cells[row, col]
jere
oh.. i use oledb connection to read..
string srcConnString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ sourceFile + @";Extended Properties=""Excel 8.0;HDR=NO;""";
string srcQuery = "Select * from [" + GetExcelSheetNames( sourceFile)[0] + "]";
:)
-
hi all, im doing this project using c# and asp.net in visual studio. one question here, i needed to check if it is the Header of the excel sheet telly my heading. (how to read and check the excel heading from the first row?) -- will do a check like.. A1 = code , B1 = name, C1 = Department eg. Excel: | Code | name | Department | thanks! :-O =D