350
JXCELL實例學習與研究（二） 之 EXCEL中各種圖表格式的顯示 超鏈接（鏈接到另外的單元格、WEBSITE、E-MAIL、本地磁盤/文件）
import com.jxcell.ChartShape;
import com.jxcell.RangeRef;
import com.jxcell.View;
public class CsvChartTest
{
public static void main(String args[])
{
View m_view;
try
{
m_view =new View();
m_view.read(".\\book.csv");
ChartShape chart = m_view.addChart((short)1, (short)9,(short)9, (short)22);
chart.initData(new RangeRef(0,1,4,7),true); //Sheet1!$A$2:$E$8
m_view.write(".\\columnChart.xls");
chart.setChartType(ChartShape.TypeBar);
m_view.write(".\\barChart.xls");
chart.setChartType(ChartShape.TypePie);
m_view.write(".\\pieChart.xls");
chart.setChartType(ChartShape.TypeLine);
m_view.write(".\\lineChart.xls");
chart.setChartType(ChartShape.TypeArea);
m_view.write(".\\areaChart.xls");
chart.setChartType(ChartShape.TypePie);
m_view.write(".\\pieChart.xls");
chart.setChartType(ChartShape.TypeDoughnut);
m_view.write(".\\doughnutChart.xls");
chart.setChartType(ChartShape.TypeScatter);
m_view.write(".\\scatterChart.xls");
chart.setChartType(ChartShape.TypeBubble);
m_view.write(".\\bubbleChart.xls");
// Designer.newDesigner(m_view);
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
默認：豎向的
TypeBar:橫向柱狀圖
TypePie:餅狀圖
TypeLine:線狀圖
TypeArea:麵積圖
TypeDoughnut:圈圖
TypeScatter:線點圖
TypeBubble:沒怎麼看懂，就是一個灰圖，不過查閱資料，貌似是泡狀圖
超鏈接（鏈接到另外的單元格、WEBSITE、E-MAIL、本地磁盤/文件）
import com.jxcell.*;
import java.io.IOException;
import com.jxcell.designer.Designer;
public class Hyperlinks
{
public Hyperlinks()
{
View m_view = new View();
try
{
//Creating Hyperlink to another cell
m_view.addHyperlink(1,1,1,1,"C3", HyperLink.kRange,"This is Workbook Link!");
//Creating Hyperlink for Website
m_view.addHyperlink(2,1,2,1,"https://www.jxcell.net", HyperLink.kURLAbs,"This is Web Url Link!");
//Creating Hyperlink for e-mail
m_view.addHyperlink(3,1,3,1,"mailto:support@jxcell.com", HyperLink.kURLAbs,"Send Mail!");
//Creating Hyperlink for Opening Files
m_view.addHyperlink(4,1,4,1,"c:\\", HyperLink.kURLAbs,"This is File Link!");
m_view.write(".\\hyperlink.xls");
Designer.newDesigner(m_view);
}
catch (CellException e)
{
e.printStackTrace();
} catch (IOException e)
{
e.printStackTrace();
}
}
public static void main(String args[])
{
new Hyperlinks();
}
}
最後更新：2017-04-02 22:16:22