手把手教你小程序导出Excel

// 云函数入口文件
const cloud = require('wx-server-sdk')
const nodeExcel = require('excel-export')
const path = require('path');
cloud.init();
const db = cloud.database();
const MAX_LIMIT = 100;
// 云函数入口函数
exports.main = async (event, context) => {
	const _ = db.command;
	console.log("|" + event.action + "|" + Date.now());
	switch (event.action) {
		case 'ToDEMO': {
			var tableHead = ["预约日期", "预约人姓名", "预约人电话","被访人姓名", "登记日期"];
			var tablewidth = [20, 20, 30, 40, 20];
			var tableMap = {
				styleXmlFile: path.join(__dirname, "styles.xml"),
				name: Date.now() + "-export",
				cols: [],
				rows: [],
			}
			//添加表头
			for (var i = 0; i < tableHead.length; i++) {
				tableMap.cols[tableMap.cols.length] = {
					caption: tableHead[i],
					type: 'string',
					width: tablewidth[i]
				}
			}
			//-----------------------------------------
			const countResult = await db.collection('BookInfo_DB')			
				.count();
			const total = countResult.total
			const batchTimes = Math.ceil(total / 100)
			for (let i = 0; i < batchTimes; i++) {
				let Reg_data = await db.collection('BookInfo_DB')				
					.orderBy('indate', 'desc')
					.skip(i * MAX_LIMIT).limit(MAX_LIMIT)
					.get();
				for (let key = 0; key < Reg_data.data.length; key++) {
					let indate = Reg_data.data[key].v_name,
						Pdate = Reg_data.data[key].act,
						Ptime = Reg_data.data[key].book_time,
						telnet = Reg_data.data[key].indate;
						
					/*let ti = 0;
					aname.forEach(item => {*/
						tableMap.rows[tableMap.rows.length] = [
							Pdate,
							Ptime,
							//item,
							telnet,
							indate
						]
					/*})*/
				}
			}
			//-----------------------------------------
			var excelResult = nodeExcel.execute(tableMap);
			var filePath = "outputExcels";
			var fileName = "BookInfo_DB-" + Date.now() / 1000 + '.xlsx';
			return await cloud.uploadFile({
				cloudPath: path.join(filePath, fileName),
				fileContent: Buffer.from(excelResult, 'binary')				
			});
			//---------------------------------------------------------------------------------		
		};

	default: {
		return "OK";
	}
	}

}

 downloadExcel(pdate) {
    var that = this;
    wx.showLoading({
      title: '数据准备中。。',
    })
    let fileID = "";
    wx.cloud.callFunction({
      name: 'Excel_TO',
      data: {
        pdate: '' + pdate
      },
      success: res => {
        console.log(res);
        fileID = res.result.fileID;
        wx.cloud.getTempFileURL({
          //获取文件下载地址
          fileList: [res.result.fileID],
          success: res => {
            wx.downloadFile({
              url: res.fileList[0].tempFileURL,
              filePath: wx.env.USER_DATA_PATH + '/' + pdate + '预约名单' + Math.ceil(Math.random() * 99) + '.xlsx', //本地文件路径
              success(res) {
                let data = res.filePath;
                wx.openDocument({ //打开文档
                  filePath: data,
                  showMenu: true
                });
              },
              fail(res) {
                wx.showModal({
                  title: '下载错误',
                  content: '请稍后再试',
                  showCancel: false
                });
              },
              complete(res) {
                console.log(fileID);
                wx.cloud.deleteFile({
                  fileList: [fileID],
                  success: res => {
                    console.log("DEL ok-->" + res.fileList)
                    console.log(res.fileList);
                  },
                  fail: err => {
                    console.log("DEL err-->" + res.fileList)
                  }
                })
              }
            });
          },
          fail(res) {}
        });
      },
      fail(res) {},
    });
    wx.hideLoading();
  }