报表导出ExcelUtil2

最新推荐文章于 2021-11-18 18:58:40 发布
最新推荐文章于 2021-11-18 18:58:40 发布
阅读量163 收藏
点赞数
分类专栏： java 文章标签： java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/suyijianke/article/details/84041474
版权

 

import java.io.IOException;
import java.io.OutputStream;
import java.io.UnsupportedEncodingException;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.net.URLEncoder;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.*;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.hibernate.Hibernate;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;

import com.sinovatech.shop.order.model.dto.TOrderDTO;


import java.awt.Font;
import java.beans.*;

 
abstract public class ExcelUtil2 {
private   Log log = LogFactory.getLog(ExcelUtil2.class);

private   String shtName = "";
//列属性名
private   String[] cNames = null;
//列显示名
private   String[] cLabels = null;
 
//每页显示行数
private   int rpp = 5000;

private   HSSFCellStyle style = null;
private HSSFWorkbook  wb;
public ExcelUtil2(){
}
public   void exportBySql(HttpServletResponse response,Session session, String querySql,String countSql,
String fileName, String sheetName, String[] colTitle, int rowPerPage)  {

if (rowPerPage <= 10000 && rowPerPage >= 1) {
rpp = rowPerPage;
}
if (!"".equals(sheetName) && null != sheetName) {
shtName = sheetName;
} else {
shtName = "sheet";
}
 
this.cLabels=colTitle;
 wb = new HSSFWorkbook();
style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
//--
SQLQuery query=session.createSQLQuery(querySql);
int curPage=1;
int count =getCount(session,countSql);
int totalPage = ((count + rpp) - 1) / rpp;
for(int i=0;i<totalPage;i++){
curPage=i+1;
int firstResult=(curPage - 1) * rpp;
query.setFirstResult(firstResult);
query.setMaxResults(rpp);
List list= query.list();
HSSFSheet sheet = createSheet(wb, curPage,count);
setSheetColumnTitle(sheet);
for(int rowCnt=0;rowCnt<list.size();rowCnt++){
Object entity=list.get(rowCnt);
HSSFRow row = sheet.createRow(rowCnt + 1);
setCelValue(rowCnt + 1,entity,row,  wb,   sheet); 
}
}
 
try {
OutputStream os = response.getOutputStream();
response.reset();
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment; filename="
+ getFileName(fileName));
wb.write(os);
 
} catch (IOException ex) {
log.info("Export Excel file error ! " + ex.getMessage());
}
}
public   void exportBySql(HttpServletResponse response,Session session,Class cls, String querySql,String countSql,
String fileName, String sheetName, String[] colTitle, int rowPerPage)  {

if (rowPerPage <= 10000 && rowPerPage >= 1) {
rpp = rowPerPage;
}
if (!"".equals(sheetName) && null != sheetName) {
shtName = sheetName;
} else {
shtName = "sheet";
}
 
this.cLabels=colTitle;
 wb = new HSSFWorkbook();
style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
//--
SQLQuery query=session.createSQLQuery(querySql).addEntity("order1",cls);
int curPage=1;
int count =getCount(session,countSql);
int totalPage = ((count + rpp) - 1) / rpp;
for(int i=0;i<totalPage;i++){
curPage=i+1;
int firstResult=(curPage - 1) * rpp;
query.setFirstResult(firstResult);
query.setMaxResults(rpp);
List list= query.list();
HSSFSheet sheet = createSheet(wb, curPage,count);
setSheetColumnTitle(sheet);
for(int rowCnt=0;rowCnt<list.size();rowCnt++){
Object entity=list.get(rowCnt);
HSSFRow row = sheet.createRow(rowCnt + 1);
setCelValue(rowCnt + 1,entity,row,wb,sheet); 
}
}
 
try {
OutputStream os = response.getOutputStream();
response.reset();
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment; filename="
+ getFileName(fileName));
wb.write(os);
 
} catch (IOException ex) {
log.info("Export Excel file error ! " + ex.getMessage());
}
}
public   List<HSSFRow> insertRow(HSSFWorkbook wb, HSSFSheet sheet,
   int starRow, int rows) {
List<HSSFRow> list=new ArrayList<HSSFRow>();
  sheet.shiftRows(starRow + 1, sheet.getLastRowNum(), rows);

  starRow = starRow - 1;
  
  for (int i = 0; i < rows; i++) {

   HSSFRow sourceRow = null;
   HSSFRow targetRow = null;
   HSSFCell sourceCell = null;
   HSSFCell targetCell = null;
   short m;
   
   starRow = starRow + 1;
   sourceRow = sheet.getRow(starRow);
   targetRow = sheet.createRow(starRow + 1);
   targetRow.setHeight(sourceRow.getHeight());

   for (m = sourceRow.getFirstCellNum(); m < sourceRow.getPhysicalNumberOfCells(); m++) {
    
    sourceCell = sourceRow.getCell(m);
    targetCell = targetRow.createCell(m);
    
    targetCell.setEncoding(sourceCell.getEncoding());
    targetCell.setCellStyle(sourceCell.getCellStyle());
    targetCell.setCellType(sourceCell.getCellType());

   }
   list.add(targetRow);
 }
return list;

}
public int getCount(Session session,String countSql){
 return      ((Long)session.createSQLQuery( countSql )
.addScalar( "count" , Hibernate.LONG)
.uniqueResult()).intValue(); 
}
public   void export(HttpServletResponse response,Session session, String hql,
String fileName, String sheetName, String[] colTitle, int rowPerPage)  {

if (rowPerPage <= 10000 && rowPerPage >= 1) {
rpp = rowPerPage;
}
if (!"".equals(sheetName) && null != sheetName) {
shtName = sheetName;
} else {
shtName = "sheet";
}
 
this.cLabels=colTitle;
 wb = new HSSFWorkbook();
style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
//--
Query query = session.createQuery("select count(*) "
+ hql);
int curPage=1;
int count =Integer.parseInt(String.valueOf(query.uniqueResult()));
int totalPage = ((count + rpp) - 1) / rpp;
for(int i=0;i<totalPage;i++){
curPage=i+1;
int firstResult=(curPage - 1) * rpp;
query = session.createQuery(hql);
query.setFirstResult(firstResult);
query.setMaxResults(rpp);
List list= query.list();
HSSFSheet sheet = createSheet(wb, curPage,count);
setSheetColumnTitle(sheet);
for(int rowCnt=0;rowCnt<list.size();rowCnt++){
Object entity=list.get(rowCnt);
HSSFRow row = sheet.createRow(rowCnt + 1);
setCelValue(rowCnt + 1,entity,row, wb,   sheet); 
}
}
 
try {
OutputStream os = response.getOutputStream();
response.reset();
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment; filename="
+ getFileName(fileName));
wb.write(os);
 
} catch (IOException ex) {
log.info("Export Excel file error ! " + ex.getMessage());
}
}
abstract public void setCelValue(int rowIndex,Object entity,HSSFRow row,HSSFWorkbook wb, HSSFSheet sheet);
 
 

/**
 * 创建一个Sheet页并返回该对象
 * 
 * @param wb
 *            HSSFWorkbook
 * @param seq
 *            int
 * @return HSSFSheet
 */
private   HSSFSheet createSheet(HSSFWorkbook wb, int seq) {
int sup = seq * rpp;
int sub = (seq - 1) * rpp + 1;
if (sub < 1) {
sub = 1;
}
HSSFSheet sheet=wb.createSheet( );
shtName=shtName + "(" + sub + "-" + sup + ")";
 
wb.setSheetName(seq-1,shtName,HSSFWorkbook.ENCODING_UTF_16);   
 
return sheet;
}
/**
 * 设置Sheet页的列属性 123. *
 * 
 * @param sht
 *            HSSFSheet 124.
 */
private   void setSheetColumnTitle(HSSFSheet sht) {
HSSFRow row = sht.createRow(0);
for (int i = 0; i < cLabels.length; i++) {
HSSFCell cell = row.createCell((short) (i));
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(cLabels[i]);
cell.setCellStyle(style);
//sht.autoSizeColumn(i,true);
}
}
private   HSSFSheet createSheet(HSSFWorkbook wb, int seq,int totalSize) {
int sup = seq * rpp < totalSize ? seq * rpp : totalSize;
int sub = (seq - 1) * rpp + 1;
if (sub < 1) {
sub = 1;
}
HSSFSheet sheet=wb.createSheet( );
 
wb.setSheetName(seq-1,shtName + "(" + sub + "-" + sup + ")",HSSFWorkbook.ENCODING_UTF_16);   
 
return sheet;
}
/**
 * 获得导出的文件全名
 * 
 * @param tableName
 *            String
 * @return String
 */
private static String getFileName(String fileName) {
 fileName+= new Date().getTime() + ".xls";
try {
return URLEncoder.encode(fileName, "UTF-8");
} catch (UnsupportedEncodingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
 
}
public void setCellValue(HSSFCell cell, Object value) {
setCellValue(cell, value, null, (short) -1);
}
public void setCellRichTextString(HSSFCell cell, Object valueObj,
Object specialValueObj, short fontColor) {
if (valueObj == null) {
return;
}
String value = String.valueOf(valueObj);
String specialValue = String.valueOf(specialValueObj);
HSSFRichTextString richString = new HSSFRichTextString(String
.valueOf(value));
if (specialValue != null && value.contains(specialValue)) {
HSSFCellStyle cellStyle = cell.getCellStyle();
HSSFFont font = wb.createFont();
font.setColor(fontColor);
richString.applyFont(value.indexOf(specialValue), value
.indexOf(specialValue)
+ specialValue.length(), font);
}

cell.setCellValue(richString.getString());
// System.out.println("我执行了---");
}
public void setCellRichTextString(HSSFCell cell, Object valueObj,short fontColor) {

if (valueObj != null) {
String value = String.valueOf(valueObj);
HSSFRichTextString richString = new HSSFRichTextString(String
.valueOf(value));
HSSFFont font = wb.createFont();
font.setColor(fontColor);
richString.applyFont(font);
cell.setCellValue(richString.getString());
}

}

public void setCellValue(HSSFCell cell, Object value, Object specialValue,
short fontColor) {
// 设置页编码格式,可选.
// targetCell.set(sourceCell.ENCODING_COMPRESSED_UNICODE);
// System.out.println("cell===="+cell);
int cType = cell.getCellType();

switch (cType) {
case HSSFCell.CELL_TYPE_BOOLEAN:
cell.setCellValue(Boolean.valueOf(String.valueOf(value)));
break;
case HSSFCell.CELL_TYPE_ERROR:
cell.setCellErrorValue(Byte.valueOf(value.toString()));

break;
case HSSFCell.CELL_TYPE_FORMULA:
cell.setCellFormula(parseFormula(String.valueOf(value.toString())));

// parseFormula这个函数的用途在后面说明
break;
case HSSFCell.CELL_TYPE_NUMERIC:
cell.setCellValue(Double.valueOf(value.toString()));

break;
case HSSFCell.CELL_TYPE_STRING:
setCellRichTextString(cell, value, specialValue, fontColor);
// cell.setCellValue(new HSSFRichTextString(String.valueOf(value)));
break;
case HSSFCell.CELL_TYPE_BLANK:
if (value != null)
cell.setCellValue(value.toString());
break;
default:
System.out.println("cType=" + cType + "  setCellValue 没有匹配项");
break;
}
}

public Object getCellValue(HSSFCell cell) {

int cType = cell.getCellType();

switch (cType) {
case HSSFCell.CELL_TYPE_BOOLEAN:

return cell.getBooleanCellValue();

case HSSFCell.CELL_TYPE_ERROR:

return cell.getErrorCellValue();

case HSSFCell.CELL_TYPE_FORMULA:
return parseFormula(cell.getCellFormula());
// parseFormula这个函数的用途在后面说明

case HSSFCell.CELL_TYPE_NUMERIC:

return cell.getNumericCellValue();

case HSSFCell.CELL_TYPE_STRING:

//return cell.getRichStringCellValue();
return cell.getStringCellValue();
case HSSFCell.CELL_TYPE_BLANK:
return cell.getStringCellValue();
default:
System.out.println("cType=" + cType + "  getCellValue 没有匹配项");
return null;

}

}

private String parseFormula(String pPOIFormula) {
final String cstReplaceString = "ATTR(semiVolatile)";
StringBuffer result = null;
int index;
result = new StringBuffer();
index = pPOIFormula.indexOf(cstReplaceString);
if (index >= 0) {
result.append(pPOIFormula.substring(0, index));
result.append(pPOIFormula.substring(index
+ cstReplaceString.length()));
} else {
result.append(pPOIFormula);
}
return result.toString();
}
}



---调用方式
//导出号码订单
public void exportExcelNum(HttpServletResponse response,  String querySql,String countSql,
String fileName, String sheetName, final String[] colTitle, int rowPerPage,final String AccMoney,final String ty){
ExcelUtil2 excelUtil=new ExcelUtil2(){
@Override
public void setCelValue(int rowIndex,Object entity,HSSFRow row,HSSFWorkbook wb, HSSFSheet sheet) {
// TODO Auto-generated method stub
TOrderDTO dto=(TOrderDTO) entity;
List<TItemDTO> items=dto.getItems();
int i=0;
for(TItemDTO item:items){
if(item==null)
continue;
if(!(item.getSubType()).equals(ty))
continue;
System.out.println("--------"+i);
if(i>0){
  row=this.insertRow(wb, sheet, rowIndex+i-1, 1).get(0);
}
for(int col=0;col<colTitle.length;col++){
HSSFCell cell = row.createCell((short) col);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
String title=colTitle[col].trim();
sheet.setColumnWidth((short) col,  (short )5000);
if(title.equals("下单日期")||title.equals("下单时间")){
cell.setCellValue(dto.getOrderTime()==null?"":DateUtil.getFormatDate(dto.getOrderTime(),"yyyy-MM-dd hh:mm:ss"));
continue;
}
else if(title.equals("持有人")){
cell.setCellValue(dto.getConsignee()==null?"":item.getItemInfo().getOwnerName());
continue;
}
else if(title.equals("支付状态") ){
cell.setCellValue(dto.getPayStateChar()  );
continue;
}
else if(title.equals("子订单")||title.equals("子订单编号")||title.equals("子订单号")){
cell.setCellValue(item.getId());
continue;
}
else if(title.equals("状态")||title.equals("物流状态")){
cell.setCellValue( item.getWlstatusChar() );
continue;
}
else if(title.equals("金额(/元)") ){
cell.setCellValue( item.getSubtotal()+"" );
continue;
}
else if(title.equals("订单状态") ){
if("0".equals(dto.getState())){
cell.setCellValue("生成订单");
}else if("1".equals(dto.getState())){
cell.setCellValue("已结单");
}else if("2".equals(dto.getState())){
cell.setCellValue("作废");
}else{
cell.setCellValue("");
}
continue;
}
else if(title.equals("商品名称") ){
cell.setCellValue( item.getProduct()==null?"":item.getProduct().getName()+"" );
continue;
}
else if(title.equals("所在地") ){
Map<String, String> cityMap = OrderUtil.putAreaToMap();
cell.setCellValue(cityMap.get(item.getProduct().getUndefine1())+"");
continue;
}
else if(title.equals("截止日期")||title.equals("截止时间")){
cell.setCellValue(dto.getOrderEndTime()==null?"":DateUtil.getFormatDate(dto.getOrderEndTime(),"yyyy-MM-dd hh:mm:ss"));
continue;
}
else if(title.equals("营业厅")){
cell.setCellValue(item.getItemInfo()==null?"":item.getItemInfo().getOFFICENAME()+"");
continue;
}
else{
cell.setCellValue( title+" ，没有对应的列" );
}
 
}
i++;
}
row=this.insertRow(wb, sheet, rowIndex+i-1, 1).get(0);
for(int col=0;col<colTitle.length;col++){
if(col==colTitle.length-1){
 HSSFCell cell = row.createCell((short) col);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
 sheet.setColumnWidth((short) col,  (short )5000);
 cell.setCellValue("已收金额："+AccMoney);
}else{
HSSFCell cell = row.createCell((short) col);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
sheet.setColumnWidth((short) col,  (short )5000);
cell.setCellValue("");
}
}
 
}
};
 
excelUtil.exportBySql(    response,  this.getSession(),  TOrderDTO.class,   querySql,  countSql,fileName,   sheetName,   colTitle,   rowPerPage);
  
}

suyijianke
关注
专栏目录
项目学习《第九天》ExcelUtil 将数据导出excel表
SuJxxx的博客
04-21 602
今天早上，终于解决了无法读取mapper配置文件的问题！！！！！！！ 修改了yml配置文件中mapper-locations 以前是这么写的 mapper-locations: classpath/mapper/*.xml 以下是修改后的 mybatis: config-location: classpath:/mybatis-config.xml mapper-locations: cl...
java统计报表，导出excel，自定义存储目录
weixin_49462255的博客
11-03 1088
java统计报表，导出excle，自定义存储目录 做一个将查询出来的数据写入excel，并且点击导出按钮是，可以选择导出路径 **直接上完整代码 1.utils工具类，里面可以自己设置样式，详细看注释 import java.io.File; import java.io.FileOutputStream; import org.apache.commons.io.FileUtils; import org.apache.poi.hssf.usermodel.*; import org.apache.poi
Excel工具类ExcelUtil
04-19
工具类JAVA代码 博文链接：https://uule.iteye.com/blog/1864863
ExcelUtils-2.00.zip
05-29
We're headache on making web report all long. ExcelUtils is a helper to export excel report in java web project. It's like velocity, has own tags, but these tags is written in excel file. By these tags, you can custom your excel report format freely, not edit any your source, just ExcelUtils parses your excel template and fills values to export your report. It is based POI project and beanutils project. It uses excel and template language's profit to make web reports easily. After my hardwork, the parser is finished finally, in which report is exported by Excel Template. It's funtions include: 1、${model.name} means getting property of the name from the model object. 2、${!model.name} means that last cell and this cell merge if model.name value equals last cell value. 3、#foreach model in ${list}，means that iterate list，modelId is implied index of the list. 4、#each ${model} ${width1},${width2}，model can be a Map,JavaBean,Collection or Array object, #each key will show all property of the model.${width?} means merge ${width?} cells. If only one width, all property use the same width. If more than one, use the witdh in order, not set will use "1". 5、${list[0].name} means get the first object from list, then read the property of name. 6、${map(key)} get the value from the map by the key name. 7、${list[${index}].name} [] can be a variable. 8、${map(${key})} () can be a vriable. 9、#sum qty on ${list} where name like/=str sum qty on ${list} collection by where condition. 10、In net.sf.excelutils.tags Package, you can implement ITag to exentd Tag key. eg, FooTag will parse #foo. 11、ExcelResult for webwork. 12、${model${index}} support. 13、#call service.method("str", ${name}) call a method 14、#formual SUM(C${currentRowNo}:F${currentRowNo}) means output excel formula SUM(C?:F?) ? means currentRowNo.
导出Excel文件表格工具类之EasyExcelUtil
hkl_Forever的博客
10-14 2522
【代码】导出Excel文件表格工具类之EasyExcelUtil。
Java之Excel导出工具类使用教程
kanglong129的博客
01-04 1166
前言： 本工具类经过PostMan和web页面严格测试可用，经过了多个版本迭代优化，可以直接使用，也方便大家根据自己的业务需求，修改定制自己的导出工具。 市面上有很多封装好的导出工具(如：阿里的easyExcel，GitHub上xxl-excel等)，但如果直接引用依赖，扩展性和定制性比较差，所以博主通过apache.poi，自己实现一款Excel导出工具，方便定制使用。本工具类支持Spring...
使用poi操作Excel的几点注意事项
09-06 1080
首先说说现在我所知道的java编辑Excel文件的两大开源工具：jakarta poi和JavaExcelAPI（简称JXL），这两套工具我都试用了一这段时间，感觉各有优劣吧。poi在某些细节有些小Bug并且不支持写入图片，其他方面都挺不错的；JXL就惨了，除了支持写入图片外，我暂时看不到它比POI好的地方，我碰到的主要的问题就是对公式支持不是很好，很多带有公式的Excel文件用JXL打开后，公式
导出 excelUtil
12-07
在实际项目中，"导出excelUtil"常用于报表生成、数据导出功能，例如用户可以在Web应用中下载包含他们数据的定制报告。此外，它也常用于数据导入，允许用户上传Excel文件以批量插入或更新数据库中的数据。 总的来说...
excelUtil导入导出
08-15
3. **模板化导出**：ExcelUtil可能提供了一种模板机制，允许开发者定义一个Excel模板，然后填充数据生成报告或报表。这种方式在处理批量生成类似格式的Excel文件时非常高效。 4. **错误处理**：在导入数据时，...
Java根据模板导出Excel报表并复制模板生成多个Sheet页
08-31
本文提供了一个工具类ExcelUtil，用于根据模板导出Excel报表并复制模板生成多个Sheet页。该工具类使用POI技术来读取模板文件，并将数据写入到Excel文件中。 知识点七：模板路径的使用 模板路径是指Excel模板文件的...
ExcelUtil导出工具类
wanglu0102的博客
01-04 2223
package com.ztw.common.util; import cn.afterturn.easypoi.excel.ExcelExportUtil; import cn.afterturn.easypoi.excel.ExcelImportUtil; import cn.afterturn.easypoi.excel.entity.ExportParams; import cn.af...
导出Excel工具类
12-27 97
1 import java.io.OutputStream; 2 import java.lang.reflect.Method; 3 import java.text.SimpleDateFormat; 4 import java.util.Date; 5 import java.util.List; 6 import java.util.M...
152.使用ExcelUtils导出Excel
weixin_33736649的博客
07-11 1366
2019独角兽企业重金招聘Python工程师标准>>> ...
java excel 插入新行_POI ，Java 操作 Excel 實現行的插入（insert row）
weixin_36123285的博客
02-23 1057
POI ，Java 操作 Excel 實現行的插入(insert row)前幾天，正在做一個項目，主要用 POI 來操作 Excel其中，要使用一個，插入功能。主要是因為從數據庫，返回結果集(數據明細)，來動態車生成新行，插入明細在網上找了找，沒有找到，好的方法自己寫了一個：public static void insertRow(HSSFWorkbook wb, HSSFSheet sheet,...
ExcelUtil导入导出
davidhhs的博客
07-09 1647
说明：数据库使用mysql，导入的字段类型只能是有varchar，Date 类型火狐导出文件时做特殊设置，不能用url编码package com.lw.util;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;impo...
Java poi 集合转存Excel ExcelUtil工具类案例
SilenceKiio的博客
11-18 1327
话不多说，先上工具类。里面的逻辑是将读到的数据转存list再进行插入excel、如果是读数据库 也可以将里面的逻辑改成遍历实体，道理是一样的。excel工具类有俩种方法，java excel 和apache poi；本文是利用apache poi 进行编写，另一种方法在另一篇文章中。 package utils; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.ss.usermodel.BorderStyle; impor..
python 项目工具类,项目常用工具类整理（六）--ExcelUtil
weixin_42135753的博客
03-25 728
package com.liyang.util;import java.io.ByteArrayInputStream;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;imp...
excelUtils 导入导出 utils
weixin_43832604的博客
03-27 1831
excel 导入导出 utils package com.example.utils; import org.apache.poi.EncryptedDocumentException; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import...
ExcelUtil工具类导出
最新发布
09-01
要导入ExcelUtil工具类，你...2. 打开你的Java开发环境（如Eclipse、IntelliJ IDEA等）。 3. 在你的项目中创建一个新的包（package），用于存放ExcelUtil工具类。你可以根据自己的项目结构和需要来选择合适的包名。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值