Пример #1
0
        static void Main(string[] args)
        {
            IWorkbook workbook = new XSSFWorkbook();
            ISheet    sheet1   = workbook.CreateSheet("new sheet");
            ISheet    sheet2   = workbook.CreateSheet("second sheet");
            ISheet    sheet3   = workbook.CreateSheet("third sheet");
            ISheet    sheet4   = workbook.CreateSheet("fourth sheet");

            // Freeze just one row
            sheet1.CreateFreezePane(0, 1, 0, 1);

            // Freeze just one column
            sheet2.CreateFreezePane(1, 0, 1, 0);

            // Freeze the columns and rows (forget about scrolling position of the lower right quadrant).
            sheet3.CreateFreezePane(2, 2);

            // Create a split with the lower left side being the active quadrant
            sheet4.CreateSplitPane(2000, 2000, 0, 0, PanePosition.LowerLeft);

            FileStream sw = File.Create("test.xlsx");

            workbook.Write(sw);
            sw.Close();
        }
Пример #2
0
        static void Main(string[] args)
        {
            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();
        }
Пример #3
0
        static void Main(string[] args)
        {
            InitializeWorkbook();

            ISheet sheet1 = hssfworkbook.CreateSheet("new sheet");
            ISheet sheet2 = hssfworkbook.CreateSheet("second sheet");
            ISheet sheet3 = hssfworkbook.CreateSheet("third sheet");
            ISheet sheet4 = hssfworkbook.CreateSheet("fourth sheet");

            // Freeze just one row
            sheet1.CreateFreezePane(0, 1, 0, 1);
            // Freeze just one column
            sheet2.CreateFreezePane(1, 0, 1, 0);
            // Freeze the columns and rows (forget about scrolling position of the lower right quadrant).
            sheet3.CreateFreezePane(2, 2);
            // Create a split with the lower left side being the active quadrant
            sheet4.CreateSplitPane(2000, 2000, 0, 0, PanePosition.LOWER_LEFT);

            WriteToFile();
        }
Пример #4
0
        public static void Write()
        {// 创建工作薄
            IWorkbook wb = new XSSFWorkbook();
            // 创建工作表
            ISheet sheet = wb.CreateSheet("Hyperlinks");
            //-----文件保护
            //sheet.LockFormatRows();
            //sheet.LockFormatCells();
            //sheet.LockFormatColumns();
            //sheet.LockDeleteColumns();
            //sheet.LockDeleteRows();
            //sheet.LockInsertHyperlinks();
            //sheet.LockInsertColumns();
            //sheet.LockInsertRows();
            //sheet.ProtectSheet("123456");
            // 创建第一行
            IRow row = sheet.CreateRow(0);
            // 创建第一列
            ICell cell = row.CreateCell(0);

            cell.SetCellValue(123);
            //创建第一列为链接
            ICell cell1 = row.CreateCell(1);

            cell1.SetCellValue("baidu");
            //除此之外,HyperlinkType 枚举类型还可以是: HyperlinkType.File(文件路径)、HyperlinkType.Email(电子邮件地址)、HyperlinkType.Document(内部文档跳转)。
            XSSFHyperlink link = new XSSFHyperlink(HyperlinkType.Url)
            {
                Address = "https://www.baidu.com"
            };

            cell1.Hyperlink = link;

            //设置单元格字体
            IFont font = wb.CreateFont();

            font.Color              = IndexedColors.Red.Index;  //设置颜色
            font.IsItalic           = false;                    //斜体字
            font.Underline          = FontUnderlineType.Double; //下划线
            font.IsStrikeout        = false;                    //删除
            font.IsBold             = false;                    //粗体
            font.FontHeightInPoints = 20;
            // 绑定字体样式到样式对象上
            ICellStyle style1 = wb.CreateCellStyle();

            style1.SetFont(font);
            cell1.CellStyle = style1;

            //设置单元格边框样式
            ICellStyle style = wb.CreateCellStyle();

            style.BorderBottom      = BorderStyle.Thin;
            style.BottomBorderColor = IndexedColors.Black.Index;
            style.BorderLeft        = BorderStyle.DashDotDot;
            style.LeftBorderColor   = IndexedColors.Green.Index;
            style.BorderRight       = BorderStyle.Hair;
            style.RightBorderColor  = IndexedColors.Blue.Index;
            style.BorderTop         = BorderStyle.MediumDashed;
            style.TopBorderColor    = IndexedColors.Orange.Index;

            // 设置边框对角线样式
            style.BorderDiagonalLineStyle = BorderStyle.Medium; // BorderDiagonalLineStyle 属性必须在  BorderDiagonal 和 BorderDiagonalColor 之前设置
            style.BorderDiagonal          = BorderDiagonal.Forward;
            style.BorderDiagonalColor     = IndexedColors.Gold.Index;

            IDataFormat format = wb.CreateDataFormat();

            ICell cell3 = sheet.CreateRow(0).CreateCell(0);

            // 小数保留两位 - "1.20"
            cell3.SetCellValue(1.2);
            ICellStyle cellStyle = wb.CreateCellStyle();

            cellStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("0.00");
            cell3.CellStyle      = cellStyle;
            // 绑定样式
            cell3.CellStyle = style;
            // 设置列宽,第一个参数为第几列(从 0 开始计数),第二个参数为宽度值,注意值为 256 的倍数
            sheet.SetColumnWidth(1, 100 * 256);
            sheet.SetColumnWidth(2, 150 * 256);

            // 设置行高,注意值为 20 的倍数
            sheet.CreateRow(1).Height = 200 * 20;
            sheet.CreateRow(2).Height = 300 * 20;
            cell.SetCellValue(new XSSFRichTextString("This is a test of merging"));

            ISheet sheet1 = wb.CreateSheet("new sheet");
            ISheet sheet2 = wb.CreateSheet("second sheet");
            ISheet sheet3 = wb.CreateSheet("third sheet");
            ISheet sheet4 = wb.CreateSheet("fourth sheet");

            // CreateFreezePane 方法参数说明:
            // 第一个参数表示要冻结的列数,从 1 开始计数,如果不需要冻结设为 0。
            // 第二个参数表示要冻结的行数,从 1 开始计数,如果不需要冻结设为 0。
            // 第三个参数表示右边区域可见的首列序号,从 1 开始计数,如果不需要设置则设为 0。
            // 第四个参数表示下边区域可见的首行序号,从 1 开始计数,如果不需要设置则设为 0。

            // 冻结第一行
            sheet1.CreateFreezePane(0, 1, 0, 1);
            // 冻结第一列
            sheet2.CreateFreezePane(1, 0, 1, 0);
            // 冻结列和行(忽略右下象限的滚动位置)
            sheet3.CreateFreezePane(2, 2);
            // 创建一个左下角为活动象限的分割
            sheet4.CreateSplitPane(2000, 2000, 0, 0, PanePosition.LowerLeft);
            // 参数格式:new CellRangeAddress(起始第几行,结束第几行,起始第几列,结束第几列)
            // 合并 A1 和 B1 两个单元格
            sheet.AddMergedRegion(new CellRangeAddress(1, 1, 1, 2));
            // 保存文件
            FileStream sw = File.Create("assert/test.xlsx");//new FileStream("G://test.xlsx", FileMode.Open, FileAccess.Write);//

            wb.Write(sw);
            sw.Close();
        }
Пример #5
0
 public void CreateSplitPane(int xSplitPos, int ySplitPos, int leftmostColumn, int topRow, PanePosition activePane)
 {
     _sheet.CreateSplitPane(xSplitPos, ySplitPos, leftmostColumn, topRow, activePane);
 }