Problem with Excel Automation in .Net

[romcab]

Hi guys,

I'm trying to manipulate excel file in C# and I'm currently having problem about Getrange method of WorkSheet object. My problem is that during compile time, I don't know the end cell so I cannot specify the range. What I did was to iterate it but it fails since I cannot retrieve the value per ever row. Hope you can help guys.

Excel.Range excelCell = (Excel.Range)excelWorksheet.get_Range("B4:FZ4", Type.Missing);
System.Array myvalues = (System.Array)excelCell.Cells.Value2; //Assign it to an array

//using iteration
for (int i = 5;; i++)
{
string temp = "A" + i;
string row = "A5:" + temp;
Excel.Range cell = ws.get_Range(row, Type.Missing);

if (cell.Value2.ToString() != null)
{
Console.WriteLine("Row = {0}, Value = {1}", row, cell.Value2.ToString());
//Console.WriteLine(cell.Value2.ToString());
}
else
{
Console.WriteLine("Stop at row = {0}", row);
break;
}