我的数据是需要处理的,比如设置列名,日期格式化,处理金额的数字等。有办法在设置数据源之前单独去进行列定义吗?
我的部分 vue 代码如下,单独跑不起来:
<template>
<div>
<gc-spread-sheets :hostClass='hostClass'>
<gc-worksheet ref="excelTest">
<gc-column></gc-column>
</gc-worksheet>
</gc-spread-sheets>
</div>
</template>
<script>
import _ from 'lodash'
import '@grapecity/spread-sheets/styles/gc.spread.sheets.excel2016colorful.css'
import '@grapecity/spread-sheets-vue'
export default {
name: 'HelloWorld',
data () {
return {
hostClass: 'spread-host',
testData: [
]
}
},
created () {
this.getData()
},
methods: {
async getData () {
const { data: res } = await this.$http.get('orguser/org/v1.0/list?status=CONFIRMED')
if (res.status !== 1000000) return this.$message.error(res.message)
this.$message.success(res.message)
this.$refs.excelTest.sheet.setDataSource(res.data)
}
}
}
</script>
我的数据格式,数组中的第一个对象:
{accountPermitsId: "J6714000044403"
auditDate: "2018-09-27 10:29:31"
businessEnd: "长期"
businessStart: "2006-03-04"
corpType: "LIMITED_LIABILITY"
corpTypeDesc: "有限公司"
creditCode: "G10511523000044406"
creditPeriod: "2017-07-23"
legalPerson: "邓敏"
licenseId: "91511523784729819F"
orgId: "7c378335-c40a-457d-9ea8-19290aeb8c5b"
orgName: "宜宾海丰和锐有限公司"
orgType: "INCORPORATED"
orgTypeDesc: "法人企业"
registerDate: "2006-03-04"
registeredCapital: 212832
roles: ["MERCHANT", __ob__: Observer]
rolesDesc: ["贸易商", __ob__: Observer]
status: "CONFIRMED"
statusDesc: "审核通过"}
我想要的是类似 ag-grid 的列定义方法:
var columnDefs = [
{headerName: "#", width: 40, valueGetter: appConst.gridHelper.rowIndex, pinned: 'left'},
{headerName: "企业名称", minWidth:240, field: "orgName", pinned: 'left',template:'<a ng-bind="data.orgName" ui-sref="home.enterpriseView({id:\'{{data.orgId}}\', type:\'auditing\' })"></a>'},
{headerName:"审核通过时间",field:"auditDate",valueGetter: appConst.gridHelper.filter("dateOnly2"), filter: 'date', filterParams: appConst.gridHelper.dateFilterParam},
{headerName:"成立日期",field:"registerDate",valueGetter: appConst.gridHelper.filter("dateOnly2"), filter: 'date', filterParams: appConst.gridHelper.dateFilterParam},
{headerName:"企业法人/负责人姓名",field:"legalPerson",width: 120},
{headerName:"经营期限(开始日期)",field:"businessStart",valueGetter: appConst.gridHelper.filter("dateOnly2"), filter: 'date', filterParams: appConst.gridHelper.dateFilterParam},
{headerName:"经营期限(截止日期)",field:"businessEnd",valueGetter: appConst.gridHelper.filter("dateOnly2"), filter: 'date', filterParams: appConst.gridHelper.dateFilterParam},
{headerName:"注册资本(万元)",field:"registeredCapital", valueGetter: appConst.gridHelper.filter("currency")},
{headerName:"营业执照注册号/统一社会信用代码",field:"licenseId",},
{headerName:"机构信用证代码",field:"creditCode"},
{headerName:"机构信用代码证有效期",field:"creditPeriod",valueGetter: appConst.gridHelper.filter("dateOnly2"), filter: 'date', filterParams: appConst.gridHelper.dateFilterParam},
{headerName:"开户许可证核准号",field:"accountPermitsId"},
{headerName:"企业角色",field:"",width: 120 ,template:'<span> {{data.rolesDesc[0]}} </span>'},
{headerName:"企业类型",field:"corpTypeDesc",width: 120},
{headerName:"机构类型",field:"orgTypeDesc",width: 120},
{headerName:"企业状态",field:"statusDesc"},
];
劳您费心啦! |