testexcel.java

来自「将Excel和Word的类型库都转换过来了」· Java 代码 · 共 94 行

package org.nethawker.test;

import org.nethawker.excel11.*;
import com.jacob.com.Variant;
import com.jacob.com.Dispatch;
import java.awt.Color;

public class testExcel {
    public testExcel() {
    }

    public static void main(String[] args) {
        Application app;
        Workbooks wbs;
        Workbook wb;
        Worksheet sheet;
        Range rangeA1, rangeA2;
        ChartObjects TheCharts;
        ChartObject TheChart;
        Chart RealChart;

        try {

            // Create a new application
            app = new Application();

            // Make the application visible
            app.setVisible(true);

            // Get all workbooks
            wbs = app.getWorkbooks();

            // Add a blank workbook
            wb = wbs.add();

            // Get the active sheet

            sheet = new Worksheet(wb.getActiveSheet());
            rangeA1 = sheet.getRange(new Variant("A1:D1"));
            String[] values = {"North", "South", "East", "West"};

            rangeA1.getFont().setColorIndex(new Variant(3));
            rangeA1.setHorizontalAlignment(new Variant(Constants.xlCenter));
            rangeA1.merge();
            rangeA1.getBorders().setColorIndex(new Variant(1));
            rangeA1.getBorders().setWeight(new Variant(XlBorderWeight.xlThick));
            rangeA1.getBorders().setLineStyle(new Variant(XlLineStyle.xlDashDot));
            rangeA1.setValue(new Variant(values[1]));


            // Get cell A1
            rangeA1 = sheet.getRange(new Variant("A2"));
            // Set the values into the range
            rangeA1.setValue(new Variant(5.2));

            sheet.getRange(new Variant("B2")).setValue(new Variant(10));
            sheet.getRange(new Variant("C2")).setValue(new Variant(8));
            sheet.getRange(new Variant("D2")).setValue(new Variant(20));

            // Make a Chart
            // Get range
            rangeA1 = sheet.getRange(new Variant("A1:D2"));
            // Make a Chart Group
            TheCharts = new ChartObjects(sheet.chartObjects());
            // Add a Chart
            TheChart = TheCharts.add(100, 30, 400, 250);
            // Get the real chart
            TheCharts.setVisible(true);
            RealChart = TheChart.getChart();

            // Get the Wizard
            RealChart.chartWizard(new Variant(rangeA1), // source
                                  new Variant(XlChartType.xl3DPie),
                                  new Variant(7), //Format,
                                  new Variant(XlRowCol.xlRows),
                                  new Variant(1), // CategoryLabels,
                                  new Variant(0), // SeriesLabels,
                                  new Variant(2), // HasLegend,
                                  new Variant("Sales Percentages")); // Title
            // Wait five second;
            Thread.sleep(5000);

            // Close the workbook without saving
            wb.close(new Variant(false));

            // Quit the application
            app.quit();
        } catch (Exception e) {
            System.out.println("message: " + e.getMessage());
        }
    }

}