在SWT中使用OLE操作Excel（三）——设置单元格背景色

packagecom.jrkui.example.excel;

import org.eclipse.swt.SWT;import org.eclipse.swt.layout.FillLayout;import org.eclipse.swt.ole.win32.OLE;import org.eclipse.swt.ole.win32.OleAutomation;import org.eclipse.swt.ole.win32.OleClientSite;import org.eclipse.swt.ole.win32.OleFrame;import org.eclipse.swt.ole.win32.Variant;import org.eclipse.swt.widgets.Display;import org.eclipse.swt.widgets.Shell;public class ColorRangeShell {    public static void main(String[] args) {        new ColorRangeShell().open();    }    public void open()    {        Display display = Display.getDefault();        Shell shell = new Shell();        shell.setText("Color Range Shell");        shell.setSize(400, 300);        shell.setLayout(new FillLayout());        createExcelPart(shell);        shell.open();        while(!shell.isDisposed())            if(!display.readAndDispatch())                display.sleep();        display.dispose();    }    private static final int SHEET_ID = 0x000001e5;    private static final int CELL_ID =  0x000000c5;    private void createExcelPart(Shell shell)    {        OleFrame frame = new OleFrame(shell,SWT.NONE);        OleClientSite clientSite = new OleClientSite(frame,SWT.NONE,"Excel.Sheet");        clientSite.doVerb(OLE.OLEIVERB_SHOW);        OleAutomation workbook = new OleAutomation(clientSite);        OleAutomation worksheet = workbook.getProperty(SHEET_ID, new Variant[]{new Variant(1)}).getAutomation();        //获得单元格        OleAutomation cellA1 = worksheet.getProperty(CELL_ID, new Variant[]{new Variant("A1")}).getAutomation();        OleAutomation cellD1 = worksheet.getProperty(CELL_ID, new Variant[]{new Variant("D1")}).getAutomation();        //获得单元格区域        OleAutomation areaA3D5 = worksheet.getProperty(CELL_ID,new Variant[]{new Variant("A3"),new Variant("D5")}).getAutomation();        colorRangeByRed(cellA1);        colorRangeByRed(cellD1);        colorRangeByRed(areaA3D5);    }    /**     * 获得interior的方法在Range中的Id     */    private static final int INTERIOR = 0x00000081;    /**     * 为ColorIndex赋值的方法在interior中的Id     */    private static final int COLOR_INDEX = 0x00000061;    /**     * 红色在Excel的Index为3     */    private static final int RED = 3;     /**     * 用红色作为Range的背景色     * @param automation     */    private void colorRangeByRed(OleAutomation automation)    {        //获得interior        OleAutomation interior = automation.getProperty(INTERIOR).getAutomation();        //设置颜色        interior.setProperty(COLOR_INDEX, new Variant(RED));    }}

以上是小编为您精心准备的的内容，在的博客、问答、公众号、人物、课程等栏目也有的相关内容，欢迎继续使用右上角搜索按钮进行搜索eclipse
， shell
， private
， new
， eclipse图片背景
， swt ole
， import
， variant
背景色eclipse
swt中ole 退出excel、ole操作excel、swt ole、swt oleautomation、excel单元格操作，以便于您获取更多的相关知识。