Export to Excel is converting all numbers to text format

[TonyLeech]

I'm finding that all my table data is being exported to excel as "String" type in the xml file...

    <Cell><Data ss:Type="String">980</Data></Cell>

I'd like columns like this one...

    { title: "Total", cls: 'bold_column', minWidth: 75, dataIndx: "total", dataType: "integer", align:"center", editable: false},

...to export as a number type for Excel.  I thought that the dataType parameter would do it but it didn't change the export.  Have I overlooked something?

Thanks.

[paramvir]

Currently all the data is exported as a string, more options ( including export of number datatypes ) and functionality has been added in the upcoming version.

[TonyLeech]

Ok.  Thanks for the confirmation.  Do you have a target release date for the updated version?  And as I'm still new to using your fantastic grids will I have to download an updated version or should my files link to external js updates?

[paramvir]

ETA is approx middle of Jan 2016. It would be downloadable from your account.

[TonyLeech]

Ok.  Many thanks as always.

[TonyLeech]

Can you please confirm whether any of the versions of ParamQuery Grid have the option to export numbers yet, or is it still only possible to export as String?  Having read through some of the updates I wondered if exportRender was the thing but it's not helping for me.  Many thanks.

[paramvir]

In version 4.x, numbers are exported as numbers and dates as dates in most cases. It falls back to string when the desired output is not achievable by applying formatting to numbers.

Please compare the exported files from v3.x and v4.x

https://paramquery.com/pro/demos33/export

https://paramquery.com/pro/demos/export

Moreover export in v4 is 2 step process.

1. Export of grid to javascript workbook

2. Export of js workbook to Excel xlsx.

Any customization to spreadsheet which is not achievable by configuration options and parameters to exportData() method alone can be done by imperatively modifying the javascript workbook.

[TonyLeech]

Thanks, that's great.  I'll upgrade my software again soon...I'm still on v3.4.1