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 InsertMergeCell( int nLineIndex, int nColIndex, int nColspan) { Debug.Assert(nColspan >= 2, ""); string strStartCellName = GetCellName(nColIndex, nLineIndex); string strEndCellName = GetCellName(nColIndex + nColspan - 1, nLineIndex); ExcelUtil.InsertMergeCell(worksheetPart.Worksheet, strStartCellName, strEndCellName); }