public void WriteExcelTitle(int nLineIndex, int nCols, string strTitle, int nStyleIndex = 0) { string strStartCellName = "A" + (nLineIndex + 1).ToString(); string strEndCellName = GetColumnName(nCols - 1) + (nLineIndex + 1).ToString(); ExcelUtil.UpdateValue( workbookpart, worksheetPart.Worksheet, strStartCellName, strTitle, UInt32Value.FromUInt32((uint)nStyleIndex), true); if (nCols > 1) { ExcelUtil.UpdateValue( workbookpart, worksheetPart.Worksheet, strEndCellName, "", 0, false); } else { return; } ExcelUtil.InsertMergeCell(worksheetPart.Worksheet, strStartCellName, strEndCellName); }
public void WriteExcelLine( int nLineIndex, string strName, string strValue) { #if NO ExcelUtil.UpdateValue( workbookpart, worksheetPart.Worksheet, "A" + (nLineIndex + 1).ToString(), strName, 0, true); ExcelUtil.UpdateValue( workbookpart, worksheetPart.Worksheet, "B" + (nLineIndex + 1).ToString(), strValue, 0, bString); #endif WriteExcelCell( nLineIndex, 0, strName); WriteExcelCell( nLineIndex, 1, strValue); }
public void WriteExcelCell( int nLineIndex, int nColIndex, string strValue, bool bString, int nStyleIndex = 0) { string strCellName = GetColumnName(nColIndex) + (nLineIndex + 1).ToString(); ExcelUtil.UpdateValue( workbookpart, worksheetPart.Worksheet, strCellName, strValue, UInt32Value.FromUInt32((uint)nStyleIndex), bString); }