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