foreach (CellRange cs in sheet.Cells)
{
if (cs.IsBlank)
{
//write your data
cs.Value = "data";
}
}
string[,] data = new string[,] { { "Person1", "Person2", "Person3" }, { "100", "200", "300" }, { "10", "20", "30"}};
int nRow = data.GetLength(0); // The dimensions of rows.
int nCol = data.GetLength(1); // The dimensions of colums.
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
for (int i = 0; i < nCol; i++)
{
for (int j = 0; j < nRow; j++)
{
//insert the data
sheet.Range[i + 1, j + 1].Value = data[j, i];
}
}
workbook.SaveToFile("16104.xlsx", ExcelVersion.Version2010);
for (int i = 0; i < sheet.Rows.Length; i ++ )
{
if (i + 1 < sheet.Rows.Length)
{
CellRange row = sheet.Rows[i + 1];
if (row.IsBlank)
{
row.Cells[0].Value = "test";
break;
}
}
}