导出到excel

导出到excel

 

package excelDemo;

import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class Excel {
	public static void main(String[] args) throws Exception {
		//创建Excel文档。
		Workbook wb = new XSSFWorkbook();
		//创建sheet
		Sheet sheet = wb.createSheet("sheet名称");
		//创建一行
		Row row = sheet.createRow(0);
		//创建单元格(一行一列)
		Cell cell = row.createCell(0);
		cell.setCellValue("zhangsan");
		//创建单元格(一行第二列)
		Cell cell2 = row.createCell(1);
		cell2.setCellValue(20);
		//写入到一个excel文件中。
		OutputStream os = new FileOutputStream(new File("C:\\Users\\Windows\\Desktop\\student.xlsx"));
		wb.write(os);
		os.close();
		wb.close();
		System.out.println("ok");
	}
	
}