java 生成excel下载_java 生成excel 文件 & 微信小程序下载文件

微信小程序下载文件

uni.downloadFile({

url: 'http://192.168.101.158:8080/asserts/img/wx_icon/test.xls', //仅为示例，并非真实的资源

success: (res) => {

let xlsFilePath=res.tempFilePath

if (res.statusCode === 200) {

uni.saveFile({

tempFilePath:xlsFilePath,

success:(res)=>{

console.log(res)

//res.savedFilePath文件的保存路径

//保存成功并打开文件

uni.openDocument({

filePath:res.savedFilePath,

success:(res)=>{

console.log('成功打开文档')

}

})

},

fail:()=>console.log('下载失败')

})

console.log('下载成功');

}

}

});

java 生成excel 文件

package com.fusdom.utils;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.File;

import java.io.FileOutputStream;

import java.lang.management.ManagementFactory;

import java.lang.management.MemoryUsage;

import java.util.Date;

/**

* Hello world!

*

*/

public class test {

public static void main( String[] args ) {

String[] data = {"73982", "1", "NH", "1", "2018122510", "2", "0", "0", "0", "12233", "0", "楼层组件优化", "0"};

Date startTime = new Date();

MemoryUsage startMemory = ManagementFactory.getMemoryMXBean().getHeapMemoryUsage();

// 创建工作薄

XSSFWorkbook workbook = new XSSFWorkbook();

// 创建工作表

XSSFSheet sheet = workbook.createSheet("sheet1");

//设置数据

for (int row = 0; row < 2; row++) {

XSSFRow sheetRow = sheet.createRow(row);

for (int column = 0; column < data.length; column++) {

sheetRow.createCell(column).setCellValue(data[column]);

}

}

//写入文件

try {

workbook.write(new FileOutputStream(new File("excekkl.xls")));

workbook.close();

} catch (Exception ex) {

System.out.println(ex.getMessage());

}

Date endTime = new Date();

MemoryUsage endMemory = ManagementFactory.getMemoryMXBean().getHeapMemoryUsage();

System.out.println("Cost time(ms): " + (endTime.getTime() - startTime.getTime()));

System.out.println("Cost memory(): " + (endMemory.getUsed() - startMemory.getUsed()));

// System.out.println("Hello World!");

}

}

标签：文件,java,column,res,new,Date,import,微信

来源： https://blog.csdn.net/qq_41896729/article/details/112320777