RYANBOSLEY

Export Attribute Table to CSV in IE11 - Not Formatted Properly in Excel

Discussion created by RYANBOSLEY on Jan 9, 2015
Latest reply on Jan 30, 2015 by jeremiahglascock16

FYI, in the Developer version of the WAB,  I noticed that when exporting the Attribute Table to CSV in IE11, Excel didn't seem to be recognizing the comma delimiters and rows would show up in a single column. I tried a workaround found in this thread on stackoverflow:

 

javascript - execCommand in internet explorer saves the csv file using USC-2 Little endian encoding, how to save it with…

 

And made the following edit to the widgets/AttributeTable/Widget.js file:

2015-01-09_115343.png

 

And the CSV now displays as expected in Excel (2010). Hope this helps.

 

Update: This issue seems to not have been fixed in the 1.1 version. The workaround I used in the 1.1 version is this:

 

2015-05-26_110649.jpg

Outcomes