拆分工作表单元格
Contents
[
Hide
]
Aspose.Cells - 拆分工作表单元格
C#
Workbook workbook = new Workbook();
//Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];
//Set the active cell
workbook.Worksheets[0].ActiveCell = "A10";
//Split the worksheet window
workbook.Worksheets[0].Split();
workbook.Save("output-Split.xls");
NPOI - HSSF XSSF - 拆分工作表单元格
C#
HSSFWorkbook hssfworkbook = new HSSFWorkbook();
ISheet sheet1 = hssfworkbook.CreateSheet("new sheet");
ISheet sheet2 = hssfworkbook.CreateSheet("second sheet");
//Create a split with the lower left side being the active quadrant
sheet2.CreateSplitPane(2000, 2000, 0, 0, PanePosition.LowerLeft);
//Write the stream data of workbook to the root directory
FileStream file = new FileStream(@"output-Split.xls", FileMode.Create);
hssfworkbook.Write(file);
file.Close();
有关更多详细信息,请访问使用工作表。