dont round number in excel

[armm1396]

hello
i send the result of search to a radGridView1, and radGridView1 to Excel.
but i dont show numbers currectly. i round the number in excel. for example the number 12.34 will be shown to 12. but i wants to show as sama as it is.
below is the code:
thanks very much.

object[,] array_data = new object[rows_count, nCols];
range_data = worksheet.get_Range("A3", Convert.ToChar(65 + nCols - 1 ) + (nRows + 2).ToString());





i = 0;

for (int k = 0; k < nCols; k++)
{
int h = 0;

for (int j = 0; j < radGridView1.RowCount; j++)
{

if ((radGridView1.SelectedRows.Count <= 1) || (radGridView1.Rows[j].IsSelected == true))
{
range_data[h + 1, k + 1 ] = radGridView1.Rows[j].Cells[k].Value;
h++;
}
}

i++;
}

 

[audaxviator]

If you want to display decimals in Excel you need to assign a value to the NumberFormat property on each cells (or a range of cells).

MSDN:

https://msdn.microsoft.com/en-us/library/office/aa206536(v=office.11).aspx

C# demonstration:

https://www.e-iceblue.com/Knowledgebase/Spire.XLS/Demos/Styles/EXCEL-Number-Styles-for-C-VB.NET.html