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);
}
public void WriteExcelTitle(int nLineIndex,
int nCols,
string strTitle,
int nStyleIndex = 0)
{
// strTitle = strTitle.Replace(" ", "_"); // 2018/3/23
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);
}
