时间戳

首页 > 解决方案 > 在单张纸上显示两个响应

javascript - 在单张纸上显示两个响应

问题描述

我有3个json响应summary_data和summary_data1，我想在第一个excel表中获取它，在第二个表中获取另一个响应summary_data2。无法合并 summary_data 和 summary_data1

预期输出为 在此处输入图像描述

const summary_data = [
{Geo:"US West",SalesStage:"Closed Won",count:2,pipelinevalue:356},
{Geo:"US East",SalesStage:"Closed Won",count:8,pipelinevalue:35},
{Geo:"US West",SalesStage:"Qualified",count:16,pipelinevalue:6},
{Geo:"US East",SalesStage:"Qualified",count:3,pipelinevalue:3},
{Geo:"US East",SalesStage:"Identified",count:50,pipelinevalue:6},
{Geo:"US West",SalesStage:"Identified",count:39,pipelinevalue:3},
{Geo:"NSU",SalesStage:"Identified",count:20,pipelinevalue:8}];
const summary_data1 = [
{Geo:"US West",SalesStage:"test",count:2,pipelinevalue:356},
{Geo:"US East",SalesStage:"sfdsf Won",count:8,pipelinevalue:35},
{Geo:"US West",SalesStage:"sdf",count:16,pipelinevalue:6},
{Geo:"US East",SalesStage:"sdf",count:3,pipelinevalue:3},
{Geo:"US East",SalesStage:"Ideffntified",count:50,pipelinevalue:6},
{Geo:"US West",SalesStage:"Idefdfntified",count:39,pipelinevalue:3},
{Geo:"NSU",SalesStage:"Idendfgtified",count:20,pipelinevalue:8}];
summary_data2=[{a:100,b:10},{a:200,b:20}];
 //summary_data.sort((a,b)=>orderedObj[a.SalesStage] - orderedObj[b.SalesStage]);
 window.saveFile = function saveFile () {
var data =summary_data;
var data1 = summary_data,summary_data1;
    var data2 = summary_data2;
    var opts = [{sheetid:'One',header:true},{sheetid:'Two',header:true}];
    var res = alasql('SELECT INTO XLSX("restest344b.xlsx",?) FROM ?',
                     [opts,[data1,data2]]);
}
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

<script src="https://cdn.jsdelivr.net/alasql/0.3/alasql.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.7.12/xlsx.core.min.js"></script>
<button onclick="saveFile()">Save XLSX file</button>

标签： javascriptexcel

解决方案

推荐阅读