纯前端Spreadjs导出Excel数据丢失

收藏

var sheet = this.spread.sheets[3];
var person = this.aa
var typename = [
'oneyear.value.coalescing.accountsReceivable',
'oneyear.value.coalescing.prepayment',
'oneyear.value.coalescing.inventory',
'oneyear.value.coalescing.currentAssets',
'oneyear.value.coalescing.totalAssets',
'oneyear.value.coalescing.currentLiabilities',
'oneyear.value.coalescing.totalLiabilities',
'',
'oneyear.value.coalescing.operatingIncome',
'oneyear.value.coalescing.operatingCosts',
'oneyear.value.coalescing.businessTax',
'oneyear.value.coalescing.interestExpense',
'oneyear.value.coalescing.theChangeOfIncomeFairValue',
'oneyear.value.coalescing.investmentIncome',
'oneyear.value.coalescing.totalProfit',
'oneyear.value.coalescing.netProfit',
'',
'oneyear.value.coalescing.cashFlowFromOperations',
'oneyear.value.coalescing.investingCashFlows',
'oneyear.value.coalescing.cashFlowsFromFinancing',
]
var typename2 = [
'twoyear.value.coalescing.accountsReceivable',
'twoyear.value.coalescing.prepayment',
'twoyear.value.coalescing.inventory',
'twoyear.value.coalescing.currentAssets',
'twoyear.value.coalescing.totalAssets',
'twoyear.value.coalescing.currentLiabilities',
'twoyear.value.coalescing.totalLiabilities',
'',
'twoyear.value.coalescing.operatingIncome',
'twoyear.value.coalescing.operatingCosts',
'twoyear.value.coalescing.businessTax',
'twoyear.value.coalescing.interestExpense',
'twoyear.value.coalescing.theChangeOfIncomeFairValue',
'twoyear.value.coalescing.investmentIncome',
'twoyear.value.coalescing.totalProfit',
'twoyear.value.coalescing.netProfit',
'',
'twoyear.value.coalescing.cashFlowFromOperations',
'twoyear.value.coalescing.investingCashFlows',
'twoyear.value.coalescing.cashFlowsFromFinancing',
]
var typename3 = [
'threeyear.value.coalescing.accountsReceivable',
'threeyear.value.coalescing.prepayment',
'threeyear.value.coalescing.inventory',
'threeyear.value.coalescing.currentAssets',
'threeyear.value.coalescing.totalAssets',
'threeyear.value.coalescing.currentLiabilities',
'threeyear.value.coalescing.totalLiabilities',
'',
'threeyear.value.coalescing.operatingIncome',
'threeyear.value.coalescing.operatingCosts',
'threeyear.value.coalescing.businessTax',
'threeyear.value.coalescing.interestExpense',
'threeyear.value.coalescing.theChangeOfIncomeFairValue',
'threeyear.value.coalescing.investmentIncome',
'threeyear.value.coalescing.totalProfit',
'threeyear.value.coalescing.netProfit',
'',
'threeyear.value.coalescing.cashFlowFromOperations',
'threeyear.value.coalescing.investingCashFlows',
'threeyear.value.coalescing.cashFlowsFromFinancing',
]
var typename4 = [
'oneyear.value.parentCompany.accountsReceivable',
'oneyear.value.parentCompany.prepayment',
'oneyear.value.parentCompany.inventory',
'oneyear.value.parentCompany.currentAssets',
'oneyear.value.parentCompany.totalAssets',
'oneyear.value.parentCompany.currentLiabilities',
'oneyear.value.parentCompany.totalLiabilities',
'',
'oneyear.value.parentCompany.operatingIncome',
'oneyear.value.parentCompany.operatingCosts',
'oneyear.value.parentCompany.businessTax',
'oneyear.value.parentCompany.interestExpense',
'oneyear.value.parentCompany.theChangeOfIncomeFairValue',
'oneyear.value.parentCompany.investmentIncome',
'oneyear.value.parentCompany.totalProfit',
'oneyear.value.parentCompany.netProfit',
'',
'oneyear.value.parentCompany.cashFlowFromOperations',
'oneyear.value.parentCompany.investingCashFlows',
'oneyear.value.parentCompany.cashFlowsFromFinancing',
]
var typename5 = [
'twoyear.value.parentCompany.accountsReceivable',
'twoyear.value.parentCompany.prepayment',
'twoyear.value.parentCompany.inventory',
'twoyear.value.parentCompany.currentAssets',
'twoyear.value.parentCompany.totalAssets',
'twoyear.value.parentCompany.currentLiabilities',
'twoyear.value.parentCompany.totalLiabilities',
'',
'twoyear.value.parentCompany.operatingIncome',
'twoyear.value.parentCompany.operatingCosts',
'twoyear.value.parentCompany.businessTax',
'twoyear.value.parentCompany.interestExpense',
'twoyear.value.parentCompany.theChangeOfIncomeFairValue',
'twoyear.value.parentCompany.investmentIncome',
'twoyear.value.parentCompany.totalProfit',
'twoyear.value.parentCompany.netProfit',
'',
'twoyear.value.parentCompany.cashFlowFromOperations',
'twoyear.value.parentCompany.investingCashFlows',
'twoyear.value.parentCompany.cashFlowsFromFinancing',
]
var typename6 = [
'threeyear.value.parentCompany.accountsReceivable',
'threeyear.value.parentCompany.prepayment',
'threeyear.value.parentCompany.inventory',
'threeyear.value.parentCompany.currentAssets',
'threeyear.value.parentCompany.totalAssets',
'threeyear.value.parentCompany.currentLiabilities',
'threeyear.value.parentCompany.totalLiabilities',
'',
'threeyear.value.parentCompany.operatingIncome',
'threeyear.value.parentCompany.operatingCosts',
'threeyear.value.parentCompany.businessTax',
'threeyear.value.parentCompany.interestExpense',
'threeyear.value.parentCompany.theChangeOfIncomeFairValue',
'threeyear.value.parentCompany.investmentIncome',
'threeyear.value.parentCompany.totalProfit',
'threeyear.value.parentCompany.netProfit',
'',
'threeyear.value.parentCompany.cashFlowFromOperations',
'threeyear.value.parentCompany.investingCashFlows',
'threeyear.value.parentCompany.cashFlowsFromFinancing',
]
var source = new GC.Spread.Sheets.Bindings.CellBindingSource(person);
sheet.setBindingPath(2, 2, 'oneyear.year');
sheet.setBindingPath(2, 3, 'twoyear.year');
sheet.setBindingPath(2, 4, 'threeyear.year');
sheet.setBindingPath(30, 2, 'oneyear.year');
sheet.setBindingPath(30, 3, 'twoyear.year');
sheet.setBindingPath(30, 4, 'threeyear.year');
sheet.setText(7, 7, '01/01/2014');
var num = 3
for (var i = 0; i < 20;i++){
num++
sheet.setBindingPath(num, 2, typename[i])
sheet.setBindingPath(num, 3, typename2[i])
sheet.setBindingPath(num, 4, typename3[i])
}
var num2 = 31
for (var n = 0; n < 20; n++) {
num2++
sheet.setBindingPath(num2, 2, typename4[n])
sheet.setBindingPath(num2, 3, typename5[n])
sheet.setBindingPath(num2, 4, typename6[n])
}
sheet.setDataSource(source);

复制代码

这是插入代码的部分，setValue，setArray，getText输入数据都可以导出，但是setBindingPath 导出就是空的，全部都是空的，一个都没有
然后还有一个问题，有没有好的批量导入导出数据的方法，

Clark.Pan · Clark.Pan

您好：

导出时设置includeBindingSource: true ，这样就可以导出绑定的数据了
相关文档参考：
http://demo.gcpowertools.com.cn/ ... dataSourceSerialize

mzq760191762 · mzq760191762

ClarkPan 发表于 2017-11-15 12:10
您好：

导出时设置includeBindingSource: true ，这样就可以导出绑定的数据了

您好，对于获取数据您有好的建议吗，我这边是后端发送数据到前端测算后再返回后端的，目前导入数据用的setBindingPath绑定导入，有没有批量获取json格式数据的方式，

Clark.Pan · Clark.Pan

您好，我没有明白您说的有没有批量获取json格式数据的方式的意思。您导出是怎么导出的？是用的我们服务器端的导入导出？还是说您自己写的导出Excel

mzq760191762 · mzq760191762

ClarkPan 发表于 2017-11-15 14:03
您好，我没有明白您说的有没有批量获取json格式数据的方式的意思。您导出是怎么导出的？是用的我们服务器端 ...

不是，流程是这样的前端获取数据，然后放入表格进行测算，测算完成后把测算结果返回后端，但是返回的是json格式嘛，一个一个去获取太费事了，所以问问有没有批量获取然后生成json数据

Clark.Pan · Clark.Pan

您好：

getArray方法能够获取页面上指定范围的数据，相关文档您可以参考：
http://help.grapecity.com/spread ... sheet~getArray.html

		自动登录	找回密码
密码			立即注册

[已处理] 纯前端Spreadjs导出Excel数据丢失

5 个回复

讲师达人

悬赏达人

微信认证勋章

SpreadJS 认证

SpreadJS 高级认证

元老葡萄