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