package com.xx.emidas.activity.biz.utils;
import java.io.BufferedOutputStream;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.lang.reflect.Field;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.ws.rs.core.Application;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import org.apache.commons.collections.CollectionUtils;
import org.apache.struts2.ServletActionContext;
import com.dianping.combiz.util.DateUtils;
/**
* 批量导出excel生成zip
* @author hongwang.zhang 16-01-29
*
*/
public class ExcelGenerateZIP {
static HttpServletRequest request=ServletActionContext.getRequest();
static int recordNum = 60000;
public static void main(String[] args) {
int s=getSheetCount(52300);
System.out.println(1);
}
/**
* 确定分页的个数
*
* @param rCount 总得记录条数
* @return
*/
private static int getSheetCount(int rCount) {
if (recordNum <= 0)
return 1;
if (rCount <= 0)
return 1;
int n = rCount % (recordNum); // 余数
if (n == 0) {
return rCount / recordNum;
} else {
return (int) (rCount / (recordNum - 1)) + 1;
}
}
//忽略警告
@SuppressWarnings("unchecked")
public static String batchExp
java导出多个excel压缩zip下载
最新推荐文章于 2024-05-07 20:33:37 发布