Hello All,
I am getteing problem read data from the excel. I am using following code to read data from the excel, now when code line "Excel.Workbook xlWorkbook = xlApp.Workbooks.Open("G:\\TestFiles\\Environment Data1.xls");" open the excel file in background which i dont want to open that it should read data.
// Reference to Excel Application.
Excel.Application xlApp = new Excel.Application();
// Open the Excel file.
// You have pass the full path of the file.
// In this case file is stored in the Bin/Debug application directory.
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open("G:\\TestFiles\\Environment Data1.xls");
// Get the first worksheet.
Excel.Worksheet xlWorksheet = (Excel.Worksheet)xlWorkbook.Sheets.get_Item(1);
// Get the range of cells which has data.
Excel.Range xlRange = xlWorksheet.UsedRange;
// Get an object array of all of the cells in the worksheet with their values.
object[,] valueArray = (object[,])xlRange.get_Value(
Excel.XlRangeValueDataType.xlRangeValueDefault);
// iterate through each cell and display the contents.
for (int row = 1; row <= xlWorksheet.UsedRange.Rows.Count; ++row)
{
for (int col = 1; col <= xlWorksheet.UsedRange.Columns.Count; ++col)
{
// Print value of the cell to Console.
Console.WriteLine(valueArray[row, col].ToString());
}
}
// Close the Workbook.
xlWorkbook.Close(false);
// Relase COM Object by decrementing the reference count.
Marshal.ReleaseComObject(xlWorkbook);
// Close Excel application.
xlApp.Quit();
// Release COM object.
Marshal.FinalReleaseComObject(xlApp);
Console.ReadLine();
Munesh SharmaPosted Sep 23, 2015, 6:35 AM
rahul ahujaPosted Sep 23, 2015, 5:50 AM
Jithil JohnPosted Sep 22, 2015, 8:29 AM
if (cell != null)// Do something with the cells