1 隐藏单行
1.1 HideRow(int row)
Workbook workbook=new Workbook();
WorkSheet worksheet=workbook.WorkSheet[0];
Cells cells=worksheet.Cells;
//隐藏第一行
cells.HideRow(0);
1.2 HideRows(int row, int totalRows)
Workbook workbook=new Workbook();
WorkSheet worksheet=workbook.WorkSheet[0];
Cells cells=worksheet.Cells;
//隐藏第一行
cells.HideRows(0,1);
2 隐藏多行
HideRows(int row, int totalRows)
Workbook workbook=new Workbook();
WorkSheet worksheet=workbook.WorkSheet[0];
Cells cells=worksheet.Cells;
//隐藏第一行起两行的单元格
cells.HideRows(0,2);
3 隐藏单列
3.1 HideColumn(int column)
Workbook workbook=new Workbook();
WorkSheet worksheet=workbook.WorkSheet[0];
Cells cells=worksheet.Cells;
//隐藏第一列
cells.HideColumn(0);