private void CreateColumnHeader(System.Data.DataTable _DataSet, SheetData sheetData, _GetExcelInfo _ge, UInt32 StartRow)
{
Row row = new Row();
row.RowIndex = StartRow;
Cell cell;
sheetData.AppendChild(row);
for (int c = 0; c < _DataSet.Columns.Count; c++)
{
string CurrentColumn = _ge.GetXCellViaNumber(c + 1);
cell = CreateContentCell(CurrentColumn, StartRow, _DataSet.Columns[c].ToString(), CellValues.InlineString);
//cell.StyleIndex = 0;
row.AppendChild(cell);
}
}
private void CreateContent(System.Data.DataTable _DataSet, SheetData sheetData, UInt32 StartRow, _GetExcelInfo _ge)
{
DataColumnCollection dsColumns = _DataSet.Columns;
Cell cell;
for (int r = 0; r < _DataSet.Rows.Count; r++)
{
Row row = new Row();
row.RowIndex = ++StartRow;
// row = new DocumentFormat.OpenXml.Spreadsheet.Row { RowIndex = ++rowIndex };
sheetData.AppendChild(row);
DataRow dr = _DataSet.Rows[r];
for (int c = 0; c < _DataSet.Columns.Count; c++)
{
string CurrentColumn = _ge.GetXCellViaNumber(c + 1);
DataColumn thisColumn = _DataSet.Columns[c];
CellValues CellDataType = CellValues.InlineString;
string colName = thisColumn.ColumnName.ToUpper();
if (colName == "REQ" ||
colName == "AUTH" ||
colName == "DOC_MAP" ||
colName == "ASG")
{
CellDataType = CellValues.Number;
}
//strip time formatting for DEROS_DATE
if (colName == "DEROS_DATE" ||
colName == "DATE_ARRIVED")
{
string val = _DataSet.Rows[r][c].ToString();
if (!string.IsNullOrEmpty(val))
{
DateTime dt;
if (DateTime.TryParse(val, out dt))
{
val = dt.ToString("yyyy-MM-dd");
}
}
cell = CreateContentCell(CurrentColumn, StartRow, val, CellDataType);
}
else
{
cell = CreateContentCell(CurrentColumn, StartRow, _DataSet.Rows[r][c].ToString(), CellDataType);
}
//cell.StyleIndex = 0;
row.AppendChild(cell);
}
}
}
