62,054
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 设置打印区域
/// </summary>
/// <param name="workbook"></param>
private void SetPrintArea(IWorkbook workbook)
{
int sheetCount = workbook.NumberOfSheets;
for (int i = 0; i < sheetCount; i++)
{
ISheet sheet = workbook.GetSheetAt(i);
int FirstRowNum = sheet.FirstRowNum;
int LastRowNum = sheet.LastRowNum;
int FirstCellNum = sheet.GetRow(FirstRowNum).FirstCellNum;
int LastCellNum = sheet.GetRow(LastRowNum).LastCellNum;
workbook.SetPrintArea(
i, //工作薄 下标0开始
FirstCellNum, //起始列 下标0开始
LastCellNum, //终止列 下标0开始
FirstRowNum, //起始行 下标0开始
LastRowNum //终止行 下标0开始
);
};
}
/// <summary>
/// 设置打印区域
/// </summary>
/// <param name="workbook"></param>
private void SetPrintArea(IWorkbook workbook)
{
int sheetCount = workbook.NumberOfSheets;
for (int i = 0; i < sheetCount; i++)
{
ISheet sheet = workbook.GetSheetAt(i);
int FirstRowNum = sheet.FirstRowNum;
int LastRowNum = sheet.LastRowNum;
int FirstCellNum = sheet.GetRow(FirstRowNum).FirstCellNum;
int LastCellNum = sheet.GetRow(LastRowNum).LastCellNum;
workbook.SetPrintArea(
i, //工作薄 下标0开始
FirstCellNum, //起始列 下标0开始
LastCellNum - 1, //终止列 下标0开始
FirstRowNum, //起始行 下标0开始
LastRowNum - 1 //终止行 下标0开始
);
};
}