java excel poi 简单操作

新建c:\test.xls，向（0,0）也就是A1单元格写入指定string

package test;

import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;

public class ExcelTest {

    public static void main(String[] args) {
        run();
    }

    public static void run() {
        //生成Workbook  
        HSSFWorkbook wb = new HSSFWorkbook();  

        //添加Worksheet（不添加sheet时生成的xls文件打开时会报错）    
        Sheet sheet = wb.createSheet("new sheet");  


        Row row = sheet.createRow(0);
        Cell cell = row.createCell(0);
        cell.setCellValue("hahhaha");

        //保存为Excel文件  
        FileOutputStream out = null;  

        try {
            out = new FileOutputStream("c:\\text.xls");  
            wb.write(out);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                out.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
}

pom.xml加入dependency

        <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.9</version>
        </dependency>