| | |
|---|
| | | String excelName=""; |
|---|
| | | //创建单个sheet |
|---|
| | | HSSFSheet sheet = wb.createSheet("bom信息"); |
|---|
| | | sheet.setDefaultColumnWidth(3000); |
|---|
| | | sheet.setColumnWidth(1,5000); |
|---|
| | | sheet.setColumnWidth(2,5000); |
|---|
| | | sheet.setColumnWidth(3,5000); |
|---|
| | | sheet.setColumnWidth(4,5000); |
|---|
| | | sheet.setColumnWidth(6,5000); |
|---|
| | | sheet.setColumnWidth(7,5000); |
|---|
| | | sheet.setColumnWidth(8,5000); |
|---|
| | | sheet.setColumnWidth(16,6000); |
|---|
| | | sheet.setDefaultRowHeight((short)(1000)); |
|---|
| | | //图片元素 |
|---|
| | |
|---|
| | | sheet.getRow(rownum).createCell(14).setCellValue("表面处理/物料详情"); |
|---|
| | | sheet.getRow(rownum).createCell(15).setCellValue("备注"); |
|---|
| | | sheet.getRow(rownum).createCell(16).setCellValue("图片"); |
|---|
| | | |
|---|
| | | //将选中的文件存入指定目录下打包下载 |
|---|
| | | if(list!=null&&list.size()>0){ |
|---|
| | | for (int i=0;i<list.size();i++) { |
|---|
