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); } } }