781      阿里云  技术社区[云栖]

JXCELL实例学习与研究（三） 之 EXCEL实现复选框 与 选择区域填充颜色

代码如下：

主要是第一列显示复选框，以后三列显示其列头的复选框，具体有段EXCEL的操作方式，木有看得太懂，大致就是操作EXCEL的，需要查询一下EXCEL语句

import com.jxcell.DataValidation;
import com.jxcell.View;

public class DataValidationSample
{

    public static void main(String args[])
    {
        View m_view = new View();
        try
        {
            m_view.setText(0, 1, "Apple");
            m_view.setText(0, 2, "Orange");
            m_view.setText(0, 3, "Banana");

            DataValidation dataValidation = m_view.CreateDataValidation();
            dataValidation.setType(DataValidation.eUser);
            dataValidation.setFormula1("\"dddd\0gggg\0hhh\"");
            m_view.setSelection("A1:A5");
            m_view.setDataValidation(dataValidation);

            dataValidation = m_view.CreateDataValidation();
            dataValidation.setType(DataValidation.eUser);
            dataValidation.setFormula1("$B$1:$D$1");
            m_view.setSelection("B1:D5");
            m_view.setDataValidation(dataValidation);

            m_view.write(".\\datavalidation.xls");
            com.jxcell.designer.Designer.newDesigner(m_view);
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
}

以下为选择区域填充颜色：

import com.jxcell.CellFormat;
import com.jxcell.ConditionFormat;
import com.jxcell.View;

public class ConditionFormatSample
{

    public static void main(String args[])
    {
        View m_view = new View();
        try
        {
            m_view.getLock();
            ConditionFormat condfmt[]=new ConditionFormat[3];
            condfmt[0] = m_view.CreateConditionFormat();
            condfmt[1] = m_view.CreateConditionFormat();
            condfmt[2] = m_view.CreateConditionFormat();

            // Condition #1
            CellFormat cf=condfmt[0].getCellFormat();
            condfmt[0].setType(ConditionFormat.TypeFormula);
            condfmt[0].setFormula1("and(iseven(row()), $D1 > 1000)", 0, 0);
            cf.setFontColor(0x00ff00);
            cf.setPattern((short)1);
            cf.setPatternFG(0x99ccff);
            condfmt[0].setCellFormat(cf);

            // Condition #2
            condfmt[1].setType(ConditionFormat.TypeFormula);
            condfmt[1].setFormula1("iseven($A1)", 0, 0);
            cf.setFontColor(0xffffff);
            condfmt[1].setCellFormat(cf);

            // Condition #3
            condfmt[2].setType(ConditionFormat.TypeCell);
            condfmt[2].setFormula1("500", 0, 0);
            condfmt[2].setOperator(ConditionFormat.OperatorGreaterThan);
            cf=condfmt[2].getCellFormat();
            cf.setFontColor(0xff0000);
            condfmt[2].setCellFormat(cf);

            // Select the range and apply conditional formatting
            m_view.setSelection(0, 0, 39, 3);
            m_view.setConditionalFormats(condfmt);

            m_view.write("./conditionFormats.xls");
            com.jxcell.designer.Designer.newDesigner(m_view);
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
            m_view.releaseLock();
        }
    }

}

最后更新：2017-04-02 22:16:23

  上一篇： Javascript的this用法

  下一篇： asp.net中viewState的应用