Java中队Excel操作的PIO实例

最新推荐文章于 2022-12-06 16:04:05 发布

ihopes

最新推荐文章于 2022-12-06 16:04:05 发布

阅读量908

点赞数

分类专栏： Java

本文链接：https://blog.csdn.net/wujinsong2010/article/details/23708989

版权

Java 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

主要是用到了PIO，代码如下：

package iExcelDemo;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

/**
 * @author wujinsong
 */
public class ExcelHelper {
    /**
     * 产生的excel名称
     * @param excelName
     *            excel名称
     */
    public void createExcel(String excelName) {
        try {
            // 产生工作簿对象
            HSSFWorkbook workbook = new HSSFWorkbook();
            // 产生工作表对象
            HSSFSheet sheet = workbook.createSheet();
            // 设置第一个工作表的名称为firstShee
            // 为了工作表能支持中文
            workbook.setSheetName(0, "firstSheet");
            // 产生一行
            HSSFRow row = sheet.createRow((short) 0);
            // 产生第一个单元格
            HSSFCell cell = row.createCell((short) 0);
            // 设置单元格内容为字符串型
            cell.setCellType(HSSFCell.CELL_TYPE_STRING);
            // 为了能在单元格中写入中文，设置字符编码为ENCODING_UTF_16
            cell.setCellValue("测试成功");
            FileOutputStream outputStream = new FileOutputStream(excelName);
            workbook.write(outputStream);
            outputStream.flush();
            outputStream.close();
            
        }
        catch (Exception e) {
            
        }
    }
    
    /**
     * 将数据库中的结果集读出到exel中
     * 
     * @param resultSet 结果集
     * @param excelName excel名称
     * @param sheetName excel的sheet名称
     */
    public void resultSetToExcel(ResultSet rs, String excelName, String sheetName) {
        try {
            HSSFWorkbook workbook = new HSSFWorkbook();
            HSSFSheet sheet = workbook.createSheet();
            workbook.setSheetName(0, sheetName);
            HSSFRow row = sheet.createRow((short) 0);
            HSSFCell cell;
            ResultSetMetaData md;
            md = rs.getMetaData();
            int colCount = md.getColumnCount();
            
            for (int i = 1; i <= colCount; i++) {
                cell = row.createCell((short) (i - 1));
                cell.setCellType(HSSFCell.CELL_TYPE_STRING);
                cell.setCellValue(md.getColumnLabel(i));
            }
            
            int iRow = 1;
            while (rs.next()) {
                row = sheet.createRow((short) iRow);
                for (int j = 1; j <= colCount; j++) {
                    cell = row.createCell((short) (j - 1));
                    cell.setCellType(HSSFCell.CELL_TYPE_STRING);
                    cell.setCellValue(rs.getObject(j).toString());
                }
                iRow++;
            }
            
            FileOutputStream outputStream = new FileOutputStream(excelName);
            workbook.write(outputStream);
            outputStream.flush();
            outputStream.close();
        }
        catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    
    /**
     * 从excel中读取数据
     * 
     * @param excelName
     */
    public void readExcel(String excelName) {
        try {
            FileInputStream inputStream = new FileInputStream(excelName);
            HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
            HSSFSheet sheet = workbook.getSheet("firstSheet");
            HSSFRow row = sheet.getRow(0);
            HSSFCell cell = row.getCell((short) 0);
            System.out.println(cell.getStringCellValue());
            
        }
        catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}

可以去https://github.com/iswu2013/iExcelDemo/下载。

转载请注明出去！