public ExcelSheetData GetSheetData()
{
ExcelSheetData data = new ExcelSheetData();
ExcelRangeInfo lastCell = GetLastCellCoords();
int numberOfRows = lastCell.Start.Row;
int numberOfColumns = lastCell.Start.Column;
int iRow = 1;
for (int r = 1; r <= numberOfRows; ++r)
{
object[] values = new object[numberOfColumns];
for (int c = 1; c <= numberOfColumns; ++c)
{
Range cellRange = GetCell(r, c);
values[c - 1] = cellRange.Value2;
}
ExcelRowData rowData = new ExcelRowData(1, iRow, values);
data.Rows.Add(rowData);
iRow++;
}
return(data);
}
public ExcelSheetData CreateFromGrid(DataGridView grid)
{
ExcelSheetData data = new ExcelSheetData();
int rowCount = grid.Rows.Count;
int colCount = grid.Columns.Count;
for (int r = 0; r < rowCount; r++)
{
List <object> values = new List <object>();
for (int c = 0; c < colCount; c++)
{
values.Add(grid[c, r].Value);
}
ExcelRowData rowData = new ExcelRowData(1, r + 1, values.ToArray());
data.Rows.Add(rowData);
}
ExcelBorderData borderData = new ExcelBorderData(1, 1, rowCount, colCount);
borderData.Borders.Add(new ExcelBorderItem(ExcelBordersIndex.xlAround, ExcelBorderWeight.xlThick, ExcelLineStyle.xlDouble));
borderData.Borders.Add(new ExcelBorderItem(ExcelBordersIndex.xlInside, ExcelBorderWeight.xlHairline, ExcelLineStyle.xlContinuous));
data.Borders.Add(borderData);
return(data);
}
void insertRowData(ExcelRowData rowData)
{
for (int c = 0; c < rowData.Values.Count; ++c)
{
int c0 = rowData.Range.Start.Column + c;
int r0 = rowData.Range.Start.Row;
insertValue(r0, c0, rowData.Values[c]);
}
}
