Apache POI的小测试
来源:互联网 发布:数控编程60度倒角公式 编辑:程序博客网 时间:2024/05/20 03:07
- 测试的代码
package com.poi;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.PushbackInputStream;
import java.util.Map;
import java.util.Set;
import java.util.TreeMap;
import org.apache.poi.POIXMLDocument;
import org.apache.poi.openxml4j.opc.OPCPackage;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFHyperlink;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class XSSFWriter {
public static void main(String[] args) throws Exception{
writeData();
// readData();
}
/**
* 解析输入数据的类型
* @param workbook
* @param fis
*/
public static void parseInput(XSSFWorkbook workbook, InputStream fis){
try {
if( !fis.markSupported() ){
fis=(InputStream)new PushbackInputStream(fis, 8);
}
if( POIXMLDocument.hasOOXMLHeader(fis) ){
workbook=new XSSFWorkbook(OPCPackage.open(fis));
}
if( POIFSFileSystem.hasPOIFSHeader(fis) ){
System.out.println(“—–”);
}
System.out.println(“—–++++”);
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 读数据
* @throws Exception
*/
public static void readData() throws Exception{
// InputStream fis=new FileInputStream(“E://xssfCreateExcel.xlsx”);
// Workbook workbook=new WorkbookFactory().create(fis);
// parseInput(workbook, fis);
// Iterator iterator = workboo;
// while( iterator.hasNext() ){//循环读取sheet
// XSSFSheet xssfSheet=iterator.next();
// Iterator iterator2 = xssfSheet.iterator();
// while( iterator2.hasNext() ){
// XSSFRow row=(XSSFRow)iterator2.next();
// Iterator iterator3 = row.iterator();
// while( iterator3.hasNext() ){
// Cell next = iterator3.next();
// switch (next.getCellType()) {
// case Cell.CELL_TYPE_NUMERIC:
// System.out.print(“NUMERIC– ” + next.getNumericCellValue());
// break;
// case Cell.CELL_TYPE_STRING:
// System.out.print(“STRING– ” + next.getStringCellValue());
// break;
// default:
// System.out.print(“RichString– ” + next.getRichStringCellValue());
// break;
// }
// }
// }
// }
}
/**
* POI 写数据到excel
* @throws Exception
*/
public static void writeData() throws Exception{
XSSFWorkbook workbook=new XSSFWorkbook();
FileOutputStream fos=new FileOutputStream(“E://xssfCreateExcel.xlsx”);
XSSFWriter.addData(workbook, “sheet1”);
XSSFWriter.addData(workbook, “sheet2”);
CreationHelper creationHelper=workbook.getCreationHelper();
XSSFHyperlink createHyperlink = (XSSFHyperlink)creationHelper.createHyperlink(XSSFHyperlink.LINK_DOCUMENT);
createHyperlink.setAddress(“”);
Cell cell=workbook.getSheet(“sheet1”).getRow(1).getCell(1);
// cell.setHyperlink(createHyperlink);
// cell.setCellStyle();
cell.setCellType(XSSFCell.CELL_TYPE_FORMULA);
cell.setCellFormula(“HYPERLINK(\”[xssfCreateExcel.xlsx]’sheet2’!Z10\”,\”链接到sheet2\”)”);
workbook.write(fos);
fos.close();
}
/**
* 向workbook的一个名为sheetName的sheet添加固定的数据
* @param workbook
* @param sheetName
*/
public static void addData(XSSFWorkbook workbook, String sheetName){
XSSFSheet createSheet = workbook.createSheet(sheetName);
Map
- Apache POI的小测试
- 利用apache poi读取excel的一个小例子
- Apache-POI操作Excel的一些小技巧
- java apache POI操作Excel的一些小技巧
- apache的poi读写excel
- apache的poi读写excel
- apache的poi读写excel
- apache的poi读写excel
- apache的poi读写excel
- Apache 的 POI提供API
- Apache POI 的简单应用
- Ant+JUnit+Cobertura执行测试用例时,应注意的问题(以Apache POI为例)
- POI (Apache POI)
- 【POI】Apache POI
- Apache POI
- apache poi
- Apache POI
- Apache -poi
- Linux下查看文件和文件夹大小命令简述
- HttpUrlConnection(POST方式)
- work storm 集群 常用命令【时钟同步影响 zookeeper 稳定性?】 -1
- ThreadPoolExecutor(四)——Interrupt
- 函数指针和指针函数
- Apache POI的小测试
- 开通博客啦!~
- L1-029. 是不是太胖了-PAT团体程序设计天梯赛GPLT
- HDU 2016 Multi-University Training Contest 2 1001
- 今日再发
- Hardwood Species
- 模块化开发一个电子商务网站
- 使用Eclipse进行Java Web项目开发注意事项-Tomcat配置
- 5-33 有理数加法 (15分)