--实际开发中根据功能需要,导出数据到excel需要分多页显示,以下实现方法记录下来方便记忆。
package com.test;
import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class ExcelExportTest {
public static void main(String[] args) {
try {
File f= new File("d:" + File.separator + "test.xls") ;
OutputStream out = new FileOutputStream(f);//导出本地
//OutputStream out = response.getOutputStream();//输出客户端
List> data1 = new ArrayList>();
List> data2 = new ArrayList>();
List> data3 = new ArrayList>();
for (int i = 1; i < 5; i++) {
List rowData = new ArrayL