Update Excel File Issu

Question

I update Excel file with Decimal Value using OLE DB worked fine in asp.net.
but when i open that excel file, i found that unnecessary apostrophe added with that decimal value.

so i am not able to get accurate value in that excel file.

if any one have answer then please give me.

Dhaivat Shah · Answer

string Updatestring = ""; decimal decValue = 5.25; OleDbCommand objCmdinsert; string strDestinationConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data Source=c:\Test.xls;" + @"Extended Properties=" + Convert.ToChar(34).ToString() + @"Excel 8.0;Imex=2;HDR=NO;" + Convert.ToChar(34).ToString(); OleDbConnection objDestination = new OleDbConnection(strDestinationConnectionString); objDestination.Open(); Updatestring = "Update [sheet1$ F1:F1] set F1=" + decValue; objCmdinsert = new OleDbCommand(Updatestring, objDestination); objCmdinsert.ExecuteNonQuery(); Using Above code, Excel file Updated Successfully. But when i open Excel file the decimal value converted into text. so if any one know the solution then share their knowledge.

Sam Hobbs · Answer

The apostrophe means that the cell value is text. You might need to show the code you use to set the value but if you set the value usng a string then that is the problem.

Update Excel File Issu

Answers (2)