I tried referencing this thread:
http://ko.infragistics.com/community/forums/p/71482/361380.aspx
But I still don't get it. I tried accessing my workbook object with a for loop like this:
int columns = Workbook.Worksheets[0].Rows[0].Cells.Count(); int rows = Workbook.Worksheets[0].Rows.Count(); for (int row = 1; row < rows; row++) { for (int column = 0; column < columns; column++) { var data = Workbook.Worksheets[0].Rows[row].Cells[column].Value.ToString(); } }
I still get null reference exceptions whenever it hits a blank cell. Could someone kindly provide a code example of how to achieve the following:
"Actually, if you would like to get all cells, empty or not, an indexed based approach is the way to go. Use a for loop to access rows in order and then the cells of each row in order. The rows and cells which were not loaded from the file will be lazily created and returned from the indexer."
Many thanks!
Hi,
Maybe you could try GetCellText() method. For example:
int columns = wb.Worksheets[0].Rows[0].Cells.Count();
int rows = wb.Worksheets[0].Rows.Count();
for (int row = 1; row < rows; row++)
{
for (int column = 0; column < columns; column++)
var data =wb.Worksheets[0].Rows[row].GetCellText(column);
Debug.WriteLine(data);
//var data = wb.Worksheets[0].Rows[row].Cells[column].Value.ToString();
}
Let me know if you have any questions.
Thanks Georgi! I'll try this with my current project as soon as I can.