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

Popular posts from this blog

How to provide Authorization & Authentication using Asp.net, C#? -

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

How to use Authorization & Authentication in Asp.net, C#? -