作者首先查询了一些资料,还是没有解决,网上大多数做法是修改sheet.FitToPage = false
再有是需要在对应的sheet中先手动插入一条分页符,再删除,或者使用createsheet新建,来插入分页符。
但是均无用,贴上code
XSSFWorkbook xssfworkbook = new XSSFWorkbook();
ISheet aimsheet = xssfworkbook.CreateSheet("hahaha");
if (aimsheet != null)
{
for (int i = 0; i < 100; i++)
{
for (int j = 0; j < 100; j++)
{
IRow row = aimsheet.GetRow(i);
if (row == null)
{
row = aimsheet.CreateRow(i);
}
ICell cell = row.GetCell(j);
if (cell == null)
{
cell = row.CreateCell(j);
}
cell.SetCellValue(i.ToString() + j);
}
}
aimsheet.PrintSetup.UsePage = true;
aimsheet.PrintSetup.Landscape = true;
aimsheet.FitToPage = false;
aimsheet.Autobreaks = false;
aimsheet.SetRowBreak(28);
aimsheet.SetRowBreak(29);
int[] a = aimsheet.RowBreaks;
aimsheet.IsPrintGridlines = true;
aimsheet.SetColumnBreak(10);
}
string savePath = ".\\AAA.xlsx";
//保存文件
FileStream savefile = new FileStream(savePath, FileMode.Create);
xssfworkbook.Write(savefile);
savefile.Close();
最终尝试将XSSFWorkbook 改为 HSSFWorkbook 保存文件路径相应修改,即可!