((Excel.Range) excelActiveWorksheet.Cells[rowIndex, columnIndex]).Value2); rowIndex = (int)rowIndex + 1; } testData[i] = new string[tempCollection.Count]; testData[i] = (string[])tempCollection.ToArray(typeof(string)); } // Clean up excelWorkbook.Close(false, Type.Missing, Type....
The latter is the approach I used in developing my PseudoName test data generator tool. I chose this approach for 2 reasons; first an Excel spreadsheet is a simple yet powerful file format for storing static test data, and secondly because lists of test data are sometimes better represented ...