导出到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");
}
}