Resolved Import Excel Data Grid - Value Format

[LearningScripts]

Hi,

Seeking for help please because I tried to import my excel file to my dataGrid but it is not properly getting the value of the excel cell value. Can you help me enlighten please on how can I get the cell value regardless of the cell format of the excel. Please see screenshots image below as well as my code. THank you.


if (ofd.ShowDialog() == DialogResult.OK)
{
txt_Locate.Text = ofd.FileName;

//Load Data to Data Grid
Microsoft.Office.Interop.Excel.Application xlapp;
Microsoft.Office.Interop.Excel.Workbook xlworkbook;
Microsoft.Office.Interop.Excel.Worksheet xlworksheet;
Microsoft.Office.Interop.Excel.Range xlrange;

xlapp = new Microsoft.Office.Interop.Excel.Application();
xlworkbook = xlapp.Workbooks.Open(txt_Locate.Text);
xlworksheet = xlworkbook.Sheets[1];
xlrange = xlworksheet.UsedRange;

for (int xlRow = 1; xlRow <= xlrange.Rows.Count; xlRow++)
{
data_GRD.Rows.Add(
xlrange.Cells[xlRow, 1].Text,
xlrange.Cells[xlRow, 2].Text,
xlrange.Cells[xlRow, 3].Text);

}
xlworkbook.Close();
xlapp.Quit();
}

 

[Skydiver]

Did you try accessing Value instead of Text?

 

[LearningScripts]

Great!

Did you try accessing Value instead of Text?

Thank you so much sir! My apologies for the silly query