Excel sheet formatted values in c#

Question

How to get an Excel sheet cell with formatted values in c#?   for e.g.   I have excel cell value 3224.5990453 after formatting with a number with decimal places it will be 3224.60     I want to  to take 3224.60, while reading the excel file in c# it is taking 3224.5990453 instead of 3224.60

Sachin Singh · Answer

i don't know how are you reading excel , but you are always free to use Math.Round() method string  testingExcel = @ "C:\TestingExcel.xlsx" ;   Application xlApp =  new  Application();   Workbook xlWorkbook = xlApp.Workbooks.Open(testingExcel, Type.Missing,  true );   _Worksheet xlWorksheet = (_Worksheet)xlWorkbook.Sheets[1];   Range xlRange = xlWorksheet.UsedRange;
int i=0;
foreach  (Range c  in  xlRange.Rows.Cells)   {
Console.WriteLine( "Row"+i+ "At Address: "  + c.Address +  " - Value: "  + Math.Round(c.Value,2));
i++;
}   xlWorkbook.Close();   System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlWorkbook);   System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xlApp);
in the above example the cell value will be round to two decimal places.

Tanveer Khan · Answer

How do I can find the excel sheet cell value format dynamically in C#?