V10导出功能问题

收藏

导出之后的excel无法看到sheet页，且数据未空导出后的excel：

export.xlsx (7.15 KB, 下载次数: 0)

2016-12-6 16:21 上传

点击文件名下载附件
阅读权限: 100

数据源：

[{
"fid": "5WMAAAAKdGqYqmvn",
"fseq": 0,
"fparentid": "5WMAAAAKdGhH2/En",
"ffseq0": null,
"fproducttypeid": "5WMAAAAHWK0tKS5V",
"fproducttype": "高层（精装）",
"fproducttypenumber": "02!1!4!3",
"farea": 101043.1,
"fremark": null,
"saleArea": null,
"rentArea": null,
"businessTypeName": "高层（精装）",
"entity": {
"fid": "5WMAAAAKdGqYqmvn",
"fseq": 0,
"fparentid": "5WMAAAAKdGhH2/En",
"ffseq0": null,
"fproducttypeid": "5WMAAAAHWK0tKS5V",
"farea": 101043.1,
"fremark": null,
"saleArea": null,
"rentArea": null
}
},
{
"fid": "5WMAAAAKdGuYqmvn",
"fseq": 1,
"fparentid": "5WMAAAAKdGhH2/En",
"ffseq0": null,
"fproducttypeid": "5WMAAAAGp4ctKS5V",
"fproducttype": "底商",
"fproducttypenumber": "01!06!01",
"farea": 9264.02,
"fremark": null,
"saleArea": null,
"rentArea": null,
"businessTypeName": "底商",
"entity": {
"fid": "5WMAAAAKdGuYqmvn",
"fseq": 1,
"fparentid": "5WMAAAAKdGhH2/En",
"ffseq0": null,
"fproducttypeid": "5WMAAAAGp4ctKS5V",
"farea": 9264.02,
"fremark": null,
"saleArea": null,
"rentArea": null
}
},
{
"fid": "5WMAAAAKdGyYqmvn",
"fseq": 2,
"fparentid": "5WMAAAAKdGhH2/En",
"ffseq0": null,
"fproducttypeid": "5WMAAAAEzTstKS5V",
"fproducttype": "物业及设备用房 ",
"fproducttypenumber": "04!01",
"farea": 450.88,
"fremark": null,
"saleArea": null,
"rentArea": null,
"businessTypeName": "物业及设备用房 ",
"entity": {
"fid": "5WMAAAAKdGyYqmvn",
"fseq": 2,
"fparentid": "5WMAAAAKdGhH2/En",
"ffseq0": null,
"fproducttypeid": "5WMAAAAEzTstKS5V",
"farea": 450.88,
"fremark": null,
"saleArea": null,
"rentArea": null
}
}]

复制代码

导出时的JSON:

{
"version": "10.0.1",
"allowUserDragDrop": false,
"scrollbarMaxAlign": true,
"tabStripVisible": false,
"sheets": {
"Sheet1": {
"name": "Sheet1",
"rowCount": 3,
"columnCount": 9,
"data": {
"columnDataArray": [
null,
{
"style": {
"hAlign": 2,
"cellType": {
"digit": 2
}
}
},
{
"style": {
"hAlign": 2,
"cellType": {
"digit": 2
}
}
},
{
"style": {
"hAlign": 2,
"cellType": {
"digit": 2
}
}
}
],
"defaultDataNode": {
"style": {
"hAlign": 0,
"themeFont": "Body",
"borderLeft": {
"color": "#cfcfcf",
"style": 1
},
"borderTop": {
"color": "#cfcfcf",
"style": 1
},
"borderRight": {
"color": "#cfcfcf",
"style": 1
},
"borderBottom": {
"color": "#cfcfcf",
"style": 1
}
}
}
},
"rowHeaderData": {
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"colHeaderData": {
"dataTable": {
"0": {
"0": {
"value": "业态"
},
"1": {
"value": "计容建筑面积"
},
"2": {
"value": "可租赁面积"
},
"3": {
"value": "可销售面积"
},
"4": {
"value": "备注"
}
}
},
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"selections": {
"0": {
"row": 0,
"rowCount": 1,
"col": 0,
"colCount": 1
},
"length": 1
},
"theme": "Office",
"rows": [
{
"visible": true
}
],
"columns": [
{
"name": "fproducttype",
"displayName": "业态",
"size": 300
},
{
"name": "farea",
"displayName": "计容建筑面积",
"cellType": {
"digit": 2
},
"size": 150
},
{
"name": "rentArea",
"displayName": "可租赁面积",
"cellType": {
"digit": 2
},
"size": 150
},
{
"name": "saleArea",
"displayName": "可销售面积",
"cellType": {
"digit": 2
},
"size": 150
},
{
"name": "fremark",
"displayName": "备注",
"size": 200
},
{
"name": "fproducttypeid",
"displayName": "业态主键",
"size": 300,
"visible": false
},
{
"name": "fproducttypenumber",
"displayName": "业态编码",
"size": 300,
"visible": false
},
{
"name": "fid",
"displayName": "主键",
"size": 80,
"visible": false
},
{
"name": "fseq",
"displayName": "序列号",
"size": 80,
"visible": false
}
],
"autoGenerateColumns": false,
"frozenlineColor": "rgba(255,0,0,0)",
"isProtected": true,
"index": 0
}
}
}

复制代码

dept_estate_dev · dept_estate_dev

现在导出可以了，可是导出的sheet没有标题，这个问题大概什么时候可以修复呢？

dexteryao · dexteryao

再引用spread js后添加如下方法，判断是否导出列头的方法，你可以根据业务具体在修改下。
导出多少行列头也可以根据情况修改。

var oldToJSON = GC.Spread.Sheets.Workbook.prototype.toJSON;
GC.Spread.Sheets.Workbook.prototype.toJSON = function(options){
var json = oldToJSON.call(this, options);
var tempSpread = new GC.Spread.Sheets.Workbook();
tempSpread.fromJSON(json);
for(var sheetPro in tempSpread.sheets){
var sheet = tempSpread.sheets[sheetPro]
//判断是否需要导出列头
if(sheet.getText(0, 0, GC.Spread.Sheets.SheetArea.colHeader) !== "A"){
sheet.addRows(0, 1);
for(var col = 0; col < sheet.getColumnCount(); col++){
sheet.setValue(0, col, sheet.getText(0, col, GC.Spread.Sheets.SheetArea.colHeader));
}
}
}
var newJSON = oldToJSON.call(tempSpread, options);
return newJSON;
}

复制代码

dept_estate_dev · dept_estate_dev

dexteryao 发表于 2016-12-6 17:59
再引用spread js后添加如下方法，判断是否导出列头的方法，你可以根据业务具体在修改下。
导出多少行列头 ...

单列的可以，但是多列及合并列的情况无法导出，麻烦是否可以完善一下？

dexteryao · dexteryao

问题已收到，制作demo需要些时间。

dexteryao · dexteryao

导出多行表头，并且添加样式

var oldToJSON = GC.Spread.Sheets.Workbook.prototype.toJSON;
GC.Spread.Sheets.Workbook.prototype.toJSON = function(options){
var json = oldToJSON.call(this, options);
var tempSpread = new GC.Spread.Sheets.Workbook();
tempSpread.fromJSON(json);
var hearderStyle = new GC.Spread.Sheets.Style();
hearderStyle.borderLeft =new GC.Spread.Sheets.LineBorder("black",GC.Spread.Sheets.LineStyle.medium);
hearderStyle.borderTop = new GC.Spread.Sheets.LineBorder("black",GC.Spread.Sheets.LineStyle.medium);
hearderStyle.borderRight = new GC.Spread.Sheets.LineBorder("black",GC.Spread.Sheets.LineStyle.medium);
hearderStyle.borderBottom = new GC.Spread.Sheets.LineBorder("black",GC.Spread.Sheets.LineStyle.medium);
for(var sheetPro in tempSpread.sheets){
var sheet = tempSpread.sheets[sheetPro]
var headerRowCount = sheet.getRowCount(GC.Spread.Sheets.SheetArea.colHeader)
//判断是否需要导出列头
if(headerRowCount > 1 || sheet.getText(0, 0, GC.Spread.Sheets.SheetArea.colHeader) !== "A"){
sheet.addRows(0, headerRowCount);
for(var row = 0; row < headerRowCount; row++){
sheet.setStyle(row, -1, hearderStyle);
for(var col = 0; col < sheet.getColumnCount(); col++){
sheet.setValue(row, col, sheet.getText(row, col, GC.Spread.Sheets.SheetArea.colHeader));
var span = sheet.getSpan(row, col, GC.Spread.Sheets.SheetArea.colHeader)
if(span && span.row === row && span.col ===col){
sheet.addSpan(span.row, span.col, span.rowCount, span.colCount)
}
}
}
}
}
var newJSON = oldToJSON.call(tempSpread, options);
return newJSON;
}

复制代码

dept_estate_dev · dept_estate_dev

此处第24行，如果我的表头只有1行，并且没有span，我的内容第一行有一个5行span，返回的span是内容的span。最终会报错

dexteryao · dexteryao

不是很确定出现问题的原因，您修改下代码试下。哪里的逻辑就是判断如果表头存在span ，并且是span开始的第一个单元格就添加一个span。
if(span && span.row === row && span.col ===col && (span.rowCount > 1 || span.colCount > 1){

dept_estate_dev · dept_estate_dev

此处span拿到的不是表头的span

dexteryao · dexteryao

可否提供下json 。这个问题我这里没有重现出来。还得调查下

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

[已处理] V10导出功能问题

13 个回复

讲师达人

悬赏达人

元老葡萄

SpreadJS 认证

SpreadJS 高级认证

微信认证勋章