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.