XLS文件的读写

依赖jar：poi.jar

一、        写xls文件

package excel;

 

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFCell;

import java.io.FileOutputStream;

 

publicclass CreateXLS {

    publicstatic String outputFile = "D:/cc.xls";

 

    publicstaticvoid main(String args[]) {

        try {

            HSSFWorkbook workbook = new HSSFWorkbook();

            //新建一个为"hello"的工作表

            HSSFSheet sheet = workbook.createSheet("hello");

            //获取第一行

            HSSFRow row = sheet.createRow((short) 0);

            // 获取第一行的第一列

            HSSFCell cell = row.createCell((short) 0);

            //定义单元格的类型

            cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);

            // 向单元格输入值

            cell.setCellValue(88);

            HSSFCell cell1 = row.createCell((short) 1);

            cell1.setCellType(HSSFCell.CELL_TYPE_STRING);

            // 中文需设置setEncoding，且该方法必须在setCellValue之前执行否则报错

            cell1.setEncoding(HSSFCell.ENCODING_UTF_16);

            cell1.setCellValue("我去");

            FileOutputStream fOut = new FileOutputStream(outputFile);

            workbook.write(fOut);

            fOut.flush();

            fOut.close();

            System.out.println("文件生成...");

        } catch (Exception e) {

            e.printStackTrace();

        }

    }

}

 

二、        读xls文件

package excel;

 

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFRow;

import java.io.FileInputStream;

 

publicclass ReadXLS {

    publicstatic String fileToBeRead = "D:/cc.xls";

 

    publicstaticvoid main(String argv[]) {

        try {

            HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileToBeRead));

            //获得"hello"的工作表

            HSSFSheet sheet = workbook.getSheet("hello");

            // 获取的第一行

            HSSFRow row = sheet.getRow(0);

            // 获取的第一列

            System.out.println(row.getCell((short)0).getNumericCellValue());

            // 获取的第二列

            System.out.println(row.getCell((short)1).getStringCellValue());

        } catch (Exception e) {

            e.printStackTrace();

        }

    }

}

 

结果：

88.0

我去