256
JXCELL實例學習與研究（四） 之 錄入數據、繪製表格、修整線性表的顏色 密碼的設置與破譯
注釋部分就不注釋了，我都做了筆記，而且內網部分的東西拿不出來
EXCEL錄入數據，並且根據錄入的數據製圖，且修整線性表的顏色
import com.jxcell.*;
import java.awt.*;
public class ChartFormatTest
{
public static void main(String args[])
{
View m_view = new View();
RangeRef newRange = null;
try {
m_view.getLock();
m_view.setTextAsValue(1,2,"Jan");
m_view.setTextAsValue(1,3,"Feb");
m_view.setTextAsValue(1,4,"Mar");
m_view.setTextAsValue(1,5,"Apr");
m_view.setTextAsValue(2,1,"Bananas");
m_view.setTextAsValue(3,1,"Papaya");
m_view.setTextAsValue(4,1,"Mango");
m_view.setTextAsValue(5,1,"Lilikoi");
m_view.setTextAsValue(6,1,"Comfrey");
m_view.setTextAsValue(7,1,"Total");
m_view.setTextAsValue(1,6,"time");
m_view.setNumber(2,6,1);
m_view.setNumber(3,6,2);
m_view.setNumber(4,6,3);
m_view.setNumber(5,6,4);
m_view.setNumber(6,6,5);
m_view.setNumber(7,6,6);
for(int col = 2; col <= 5; col++)
for(int row = 2; row <= 7; row++)
m_view.setFormula(row, col, "rand()");
m_view.setFormula(7, 2, "SUM(C3:C7)");
m_view.setSelection("C8:F8");
m_view.editCopyRight();
ChartShape chart = m_view.addChart(0, 9.1, 7, 20.4);
chart.setChartType(ChartShape.TypeLine);
// chart.setLinkRange("Sheet1!$C$2", false);
chart.addSeries();
chart.setSeriesName(0, "Sheet1!$C$2");
chart.setSeriesYValueFormula(0, "Sheet1!$C$3:$C$7");
chart.setCategoryFormula("Sheet1!$B$3:$B$7");
chart.addSeries();
chart.setSeriesName(1, "Sheet1!$D$2");
chart.setSeriesYValueFormula(1, "Sheet1!$D$3:$D$7");
chart.addSeries();
chart.setSeriesName(2, "Sheet1!$E$2");
chart.setSeriesYValueFormula(2, "Sheet1!$E$3:$E$7");
chart.addSeries();
chart.setSeriesName(3, "Sheet1!$F$2");
chart.setSeriesYValueFormula(3, "Sheet1!$F$3:$F$7");
// chart.getChart().validateData();
chart.setAxisTitle(ChartShape.XAxis, 0, "Category");
chart.setAxisTitle(ChartShape.YAxis, 0, "Amount");
// set fill color
ChartFormat cf = chart.getChartFormat();
cf.setPattern((short)1);
cf.setPatternFG(Color.LIGHT_GRAY.getRGB());
chart.setChartFormat(cf);
cf = chart.getPlotFormat();
cf.setPattern((short)1);
cf.setPatternFG(new Color(204, 255, 255).getRGB());
chart.setPlotFormat(cf);
cf = chart.getAxisFormat(ChartShape.XAxis, 0);
cf.setFontSizeInPoints(8.5);
chart.setAxisFormat(ChartShape.XAxis, 0, cf);
cf = chart.getAxisFormat(ChartShape.YAxis, 0);
cf.setFontSizeInPoints(8.5);
chart.setAxisFormat(ChartShape.YAxis, 0, cf);
cf = chart.getSeriesFormat(0);
cf.setLineStyle((short)1);
cf.setLineWeight(3*20);
cf.setLineColor((new Color(0, 0, 128)).getRGB());
cf.setMarkerAuto(false);
cf.setMarkerStyle((short)0);
chart.setSeriesFormat(0, cf);
cf = chart.getSeriesFormat(1);
cf.setLineStyle((short)1);
cf.setLineWeight(3*20);
cf.setLineColor((new Color(255, 0, 255)).getRGB());
cf.setMarkerAuto(false);
cf.setMarkerStyle((short)0);
chart.setSeriesFormat(1, cf);
cf = chart.getSeriesFormat(2);
cf.setLineStyle((short)1);
cf.setLineWeight(3*20);
cf.setLineColor((new Color(255, 255, 0)).getRGB());
cf.setMarkerAuto(false);
cf.setMarkerStyle((short)0);
chart.setSeriesFormat(2, cf);
cf = chart.getSeriesFormat(3);
cf.setLineStyle((short)1);
cf.setLineWeight(3*20);
cf.setLineColor((new Color(0, 255, 255)).getRGB());
cf.setMarkerAuto(false);
cf.setMarkerStyle((short)0);
chart.setSeriesFormat(3, cf);
cf = chart.getMajorGridFormat(ChartShape.YAxis, 0);
cf.setLineStyle((short)2);
cf.setLineColor((new Color(255, 0, 0)).getRGB());
cf.setLineAuto();
chart.setMajorGridFormat(ChartShape.YAxis, 0, cf);
chart.setLegendPosition(ChartFormat.LegendPlacementTop);
cf = chart.getLegendFormat();
cf.setFontBold(true);
cf.setFontSizeInPoints(8);
chart.setLegendFormat(cf);
m_view.write(".\\out.xls");
}
catch (Exception e) {
System.out.println(e.getMessage());
}
finally
{
m_view.releaseLock();
}
}
}
密碼的設置與破譯
import com.jxcell.View;
import com.jxcell.CellException;
import java.io.IOException;
public class EncryptDecrypt
{
public EncryptDecrypt()
{
encrypt();
decrypt();
}
public void encrypt()
{
View m_view = new View();
try
{
m_view.setTextAsValue(1,2,"Jan");
m_view.setTextAsValue(1,3,"Feb");
m_view.setTextAsValue(1,4,"Mar");
m_view.setTextAsValue(1,5,"Apr");
m_view.setTextAsValue(2,1,"Bananas");
m_view.setTextAsValue(3,1,"Papaya");
m_view.setTextAsValue(4,1,"Mango");
m_view.setTextAsValue(5,1,"Lilikoi");
m_view.setTextAsValue(6,1,"Comfrey");
m_view.setTextAsValue(7,1,"Total");
for(int col = 2; col <= 5; col++)
for(int row = 2; row <= 7; row++)
m_view.setFormula(row, col, "RAND()");
m_view.setFormula(7, 2, "SUM(C3:C7)");
m_view.setSelection("C8:F8");
m_view.editCopyRight();
//set the workbook open password
m_view.write(".\\encrypt.xls", "hi");
}
catch (CellException e)
{
e.printStackTrace();
} catch (IOException e)
{
e.printStackTrace();
}
}
public void decrypt()
{
View m_view = new View();
try
{
//read the encrypted excel file
m_view.read(".\\encrypt.xls", "hi");
//write without password protected
m_view.write(".\\decrypt.xls");
}
catch (Exception e)
{
System.out.println(e.getMessage());
}
}
public static void main(String args[])
{
new EncryptDecrypt();
}
}
最後更新：2017-04-02 22:16:24