void SetCellFormat(Excel.Cell excelCell, DataGridViewCell gridCell) { try { excelCell.NumberFormat = CellFormat(gridCell); } catch { } }
void ExportHeaders(Excel.Worksheet worksheet) { for (int column = 0, worksheetColumn = 1; column < m_grid.ColumnCount; column++) { if (IsExportableColumn(column)) { Excel.Cell currentHeader = worksheet[1, worksheetColumn++]; currentHeader.Value = m_grid.Columns[column].HeaderText; currentHeader.Font.Bold = true; currentHeader.AutoFitEntireColumn(); } } }
void ExportCells(Excel.Worksheet worksheet) { for (int column = 0, worksheetColumn = 1; column < m_grid.ColumnCount; column++) { if (IsExportableColumn(column)) { for (int row = 0; row < m_grid.RowCount; row++) { Excel.Cell currentCell = worksheet[row + 2, worksheetColumn]; currentCell.Value = CellValue(m_grid[column, row]); SetCellFormat(currentCell, m_grid[column, row]); } worksheetColumn++; } } }