Update Excel File Issu

Dhaivat Shah

16y13.7k.NET

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dhaivat Shah16y ago
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 Hobbs16y ago
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.