update column name in excel file in c# -
i have excel file columns below:
no. | index | module | orikey
when import data excel file, no. column cause error. hence, plan change no. column name no before import data. causes same error:
no value given 1 or more required parameters.
using (oledbcommand cmd1 = new oledbcommand("update [" + listtable[1] + "] set [no.] = 'no'", excelconnection)) { cmd1.executenonquery(); } so there mthod update column name.and have set extended properties=\'excel 12.0;hdr=yes;imex=2\'", cannot use column number data
Comments
Post a Comment