⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 cellfrmt.java

📁 The jxcell allows any Java developer to automate any manual spreadsheet process within their organiz
💻 JAVA
📖 第 1 页 / 共 3 页
字号:
🔍
123 
            m_view.setSelection(ftrRange);
            cellFmt.setTopBorder(CellFormat.eBorderMedium);
            cellFmt.setBottomBorder(CellFormat.eBorderMedium);
            SetSolidPattern(cellFmt, m_view.getPaletteEntry(15).getRGB(), java.awt.Color.black.getRGB());
            m_view.setCellFormat(cellFmt);
            //m_view.update();

            m_view.setSelection(bodyRange);
            SetSolidPattern(cellFmt, m_view.getPaletteEntry(15).getRGB(), java.awt.Color.black.getRGB());
            m_view.setCellFormat(cellFmt);
            //m_view.update();

            m_view.setSelection(colRange);
            SetSolidPattern(cellFmt, m_view.getPaletteEntry(15).getRGB(), java.awt.Color.black.getRGB());
            m_view.setCellFormat(cellFmt);
            //m_view.update();


        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
  
    }//classic3
    
    
    private void Accounting1(CellFormat cellFmt)
    {
        String numberFormat;
        try{
            m_view.setSelection(colRange);
            m_view.setCellFormat(cfmt);

            m_view.setSelection(hdrRange);
            cellFmt.setTopBorder(CellFormat.eBorderThin);
            cellFmt.setBottomBorder(CellFormat.eBorderThin);
            AdjustFont(java.awt.Color.magenta.getRGB(), true, true, false, cellFmt);
            AlignRight(cellFmt);
            m_view.setCellFormat(cellFmt);
            //m_view.update();
            
            m_view.setSelection(bodyRange);
            numberFormat = "#,##0.00_);(#,##0.00)";
            cellFmt.setNumberFormat(numberFormat);
            m_view.setCellFormat(cellFmt);
            //m_view.update();

            m_view.setSelection(savedSelection);
            m_view.setSelection(m_view.getSelStartRow() + 1, m_view.getSelStartCol()+1,
                            m_view.getSelStartRow() + 1, m_view.getSelEndCol());
            cellFmt.setBottomBorder(CellFormat.eBorderNone);
            numberFormat = "$ #,##0.00_);(#,##0.00)";
            cellFmt.setNumberFormat(numberFormat);
            m_view.setCellFormat(cellFmt);
            //m_view.update();
            
            m_view.setSelection(ftrRange);
            cellFmt.setBottomBorder(CellFormat.eBorderDouble);
            cellFmt.setNumberFormat(numberFormat);
            m_view.setCellFormat(cellFmt);
            //m_view.update();

        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
    } //Accounting 1
    
    
    private void Accounting2(CellFormat cellFmt)
    {
       
        String numberFormat;

        try{
            m_view.setSelection(colRange);
            m_view.setCellFormat(cfmt);

            m_view.setSelection(hdrRange);
            cellFmt.setTopBorder(CellFormat.eBorderThick);
            cellFmt.setTopBorderColor(java.awt.Color.lightGray);
            cellFmt.setBottomBorder(CellFormat.eBorderThin);
            cellFmt.setBottomBorderColor(java.awt.Color.lightGray);
            AlignRight(cellFmt);
            m_view.setCellFormat(cellFmt);
            //m_view.update();

            m_view.setSelection(bodyRange);
            numberFormat = "#,##0.00_);(#,##0.00)";
            cellFmt.setNumberFormat(numberFormat);
            m_view.setCellFormat(cellFmt);
            //m_view.update();

            m_view.setSelection(savedSelection);
            m_view.setSelection(m_view.getSelStartRow() + 1, m_view.getSelStartCol()+1,
                            m_view.getSelStartRow() + 1, m_view.getSelEndCol());
            cellFmt.setBottomBorder(CellFormat.eBorderNone);
            numberFormat = "$ #,##0.00_);(#,##0.00)";
            cellFmt.setNumberFormat(numberFormat);
            m_view.setCellFormat(cellFmt);
            //m_view.update();

            m_view.setSelection(ftrRange);
            cellFmt.setBottomBorder(CellFormat.eBorderThick);
            cellFmt.setBottomBorderColor(java.awt.Color.lightGray);
            cellFmt.setTopBorder(CellFormat.eBorderThin);
            cellFmt.setTopBorderColor(java.awt.Color.lightGray);
            numberFormat = "$ #,##0.00_);(#,##0.00)";
            cellFmt.setNumberFormat(numberFormat);
            m_view.setCellFormat(cellFmt);
            //m_view.update();

        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
        
    } //Accounting2
    
    private void Accounting3(CellFormat cellFmt)
    {
        String numberFormat;
        try{
            
            m_view.setSelection(colRange);
            AdjustFont(java.awt.Color.black.getRGB(), false, true, false, cellFmt);
            m_view.setCellFormat(cellFmt);
            //m_view.update();
            
            m_view.setSelection(bodyRange);
            numberFormat = "#,##0.00_);(#,##0.00)";
            cellFmt.setNumberFormat(numberFormat);
            m_view.setCellFormat(cellFmt);
            //m_view.update();
            
            m_view.setSelection(savedSelection);
            m_view.setSelection(m_view.getSelStartRow() + 1, m_view.getSelStartCol() + 1,
                            m_view.getSelStartRow() + 1, m_view.getSelEndCol());
            numberFormat = "$ #,##0.00_);(#,##0.00)";
            cellFmt.setTopBorder(CellFormat.eBorderNone);
            cellFmt.setBottomBorder(CellFormat.eBorderNone);
            cellFmt.setNumberFormat(numberFormat);
            m_view.setCellFormat(cellFmt);
            //m_view.update();
            
            m_view.setSelection(ftrRange);
            numberFormat = "$ #,##0.00_);(#,##0.00)";
            cellFmt.setNumberFormat(numberFormat);
            m_view.setCellFormat(cellFmt);
            //m_view.update();
            
            m_view.setSelection(m_view.getSelEndRow(), m_view.getSelStartCol()+1,
                            m_view.getSelEndRow(), m_view.getSelEndCol());
            cellFmt.setTopBorder(CellFormat.eBorderThin);
            cellFmt.setBottomBorder(CellFormat.eBorderDouble);
            m_view.setCellFormat(cellFmt);
            //m_view.update();
            
            m_view.setSelection(savedSelection);
            m_view.setSelection(m_view.getSelStartRow(), m_view.getSelStartCol(),
                            m_view.getSelStartRow(), m_view.getSelEndCol());
            cellFmt.setTopBorder(CellFormat.eBorderNone);
            cellFmt.setBottomBorder(CellFormat.eBorderMedium);
            cellFmt.setBottomBorderColor(java.awt.Color.green);
            AdjustFont(m_view.getPaletteEntry(16).getRGB(), false, true, false, cellFmt);
            AlignRight(cellFmt);
            m_view.setCellFormat(cellFmt);
            //m_view.update();
            
        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
    } //Accounting3   
    
    
    private void Effects3D1(CellFormat cellFmt)
    {
        try{
            SetSolidPattern(cellFmt, java.awt.Color.lightGray.getRGB(),0);

            Set3DBorder(cellFmt, m_view.getSelStartRow(), m_view.getSelStartCol(),
                          m_view.getSelEndRow(), m_view.getSelEndCol(),
                          java.awt.Color.darkGray.getRGB(), java.awt.Color.darkGray.getRGB(),java.awt.Color.darkGray.getRGB());
            m_view.setCellFormat(cellFmt);

            m_view.setSelection(bodyRange);
            Set3DBorder(cellFmt, m_view.getSelStartRow(), m_view.getSelStartCol(),
                          m_view.getSelEndRow(), m_view.getSelEndCol(),
                          java.awt.Color.lightGray.getRGB(), java.awt.Color.darkGray.getRGB(), java.awt.Color.lightGray.getRGB());
            m_view.setCellFormat(cellFmt);
         
            m_view.setSelection(hdrRange);
            AdjustFont(java.awt.Color.magenta.getRGB(), true, false, false, cellFmt);
            AlignCenter(cellFmt);
            m_view.setCellFormat(cellFmt);
            
            m_view.setSelection(colRange);
            Set3DBorder(cellFmt,m_view.getSelStartRow(),m_view.getSelStartCol(),m_view.getSelEndRow(), m_view.getSelEndCol(), java.awt.Color.lightGray.getRGB(), java.awt.Color.lightGray.getRGB(),java.awt.Color.darkGray.getRGB());
            AdjustFont(java.awt.Color.black.getRGB(), true, false, false, cellFmt);
            m_view.setCellFormat(cellFmt);

            m_view.setSelection(ftrRange);
            Set3DBorder(cellFmt,m_view.getSelStartRow(),m_view.getSelStartCol(),m_view.getSelEndRow(),m_view.getSelEndCol(), java.awt.Color.lightGray.getRGB(), java.awt.Color.darkGray.getRGB(), java.awt.Color.darkGray.getRGB());
            AlignRight(cellFmt);
            m_view.setCellFormat(cellFmt);
            
        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
        
    }//Effects3D1       
          
    private void Colorful1(CellFormat cellFmt)
    {
        int color = java.awt.Color.red.getRGB();
        try{
            m_view.setSelection(savedSelection);
            cellFmt.setBottomBorder(CellFormat.eBorderThin);
            cellFmt.setBottomBorderColor(java.awt.Color.red);
            SetSolidPattern(cellFmt,java.awt.Color.darkGray.getRGB(),java.awt.Color.black.getRGB());

            //outline border
            cellFmt.setTopBorder(CellFormat.eBorderMedium);
            cellFmt.setLeftBorder(CellFormat.eBorderMedium);
            cellFmt.setRightBorder(CellFormat.eBorderMedium);
            cellFmt.setTopBorderColor(java.awt.Color.red);
            cellFmt.setLeftBorderColor(java.awt.Color.red);
            cellFmt.setRightBorderColor(java.awt.Color.red);
            
            AdjustFont(color, false, false, false, cellFmt);
            m_view.setCellFormat(cellFmt);
            
            m_view.setSelection(hdrRange);
            SetSolidPattern(cellFmt, java.awt.Color.black.getRGB(),java.awt.Color.black.getRGB());
            AdjustFont(color, true, true, false, cellFmt);
            AlignCenter(cellFmt);
            m_view.setCellFormat(cellFmt);
            
            m_view.setSelection(colRange);
            SetSolidPattern(cellFmt, m_view.getPaletteEntry(11).getRGB(),java.awt.Color.black.getRGB());
            AdjustFont(color, true, true, false, cellFmt);
            m_view.setCellFormat(cellFmt);
        }
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }
    }//Colorful1
    
    private void Colorful2(CellFormat cellFmt)
    {

        
        try{
            int color = m_view.getPaletteEntry(14).getRGB();
            m_view.setSelection(hdrRange);
            cellFmt.setTopBorder(CellFormat.eBorderMedium);
            cellFmt.setBottomBorder(CellFormat.eBorderThin);
            SetSolidPattern(cellFmt, m_view.getPaletteEntry(9).getRGB(),java.awt.Color.black.getRGB());
            AdjustFont(color, true, true, false, cellFmt);
            AlignRight(cellFmt);
            m_view.setCellFormat(cellFmt);
            
            m_view.setSelection(ftrRange);
            cellFmt.setBottomBorder(CellFormat.eBorderMedium);
            cellFmt.setTopBorder(CellFormat.eBorderThin);
            m_view.setCellFormat(cellFmt);
            
            m_view.setSelection(colRange);
            AdjustFont(java.awt.Color.black.getRGB(), true, true, false, cellFmt);
            m_view.setCellFormat(cellFmt);
            
            m_view.setSelection(savedSelection);
            SetHatchPattern(cellFmt, m_view.getPaletteEntry(16).getRGB(), java.awt.Color.red.getRGB());
            m_view.setCellFormat(cellFmt);
            
        }
        
        catch (com.jxcell.CellException e){
            System.out.println(e.getMessage());
        }

    }//Colorful2
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -