利用java代码对excel读取:
package com;
import java.io.IOException;
public class ExcelReader {
public static void main(String[] args) throws IOException {
URL url=ClassLoader.getSystemResource("myexcel.xls");
HSSFWorkbook HWB=new HSSFWorkbook(url.openStream());
List<Object> list=null;
int sheetCount=HWB.getNumberOfSheets();
for(int i=0;i<sheetCount;i++){
HSSFSheet sheet=HWB.getSheetAt(i);
int rowCount=sheet.getPhysicalNumberOfRows();
for(int j=0;j<rowCount;j++){
HSSFRow row=sheet.getRow(j);
int cellCount=row.getPhysicalNumberOfCells();
list=new ArrayList<Object>();
for(short k=0;k<cellCount;k++){
HSSFCell cell=row.getCell(k);
if(cell.getCellType()==HSSFCell.CELL_TYPE_STRING){
list.add(cell.getStringCellValue());
}else if(HSSFDateUtil.isCellDateFormatted(cell)){
java.util.Date d=cell.getDateCellValue();
list.add(new java.sql.Date(d.getTime()));
}else{
list.add(cell.getNumericCellValue());
}
}
System.out.println(list);
}
}
}
}
利用java代码将数据存入excel:
package com;
import java.io.FileNotFoundException;
public class ExcelWriter {
public static void main(String[] args) {
//创建工作薄
HSSFWorkbook HWB=new HSSFWorkbook();
//创建单元格的风格
HSSFCellStyle cellStyle=HWB.createCellStyle();
cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
HSSFFont font=HWB.createFont();
font.setColor(HSSFColor.RED.index);
font.setFontHeightInPoints((short)16);
cellStyle.setFont(font);
//创建工作表
HSSFSheet sheet=HWB.createSheet();
sheet.setDefaultColumnWidth((short)12);
HWB.setSheetName(0, "第一个表格",HWB.ENCODING_UTF_16);
//创建行
HSSFRow row=sheet.createRow(0);
//创建单元格
String[] strs={"李刚","赵云","曹操","诸葛亮","苍井空"};
for(short i=0;i<strs.length;i++){
HSSFCell cell=row.createCell(i);
cell.setCellStyle(cellStyle);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(strs[i]);
}
try {
HWB.write(new FileOutputStream("person.xls"));
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}