Universal Data Exporter ASP Support Product Page

In progress

Export Excel Column Headers Not Correct

Reported 05 Oct 2010 17:23:54
has this problem
05 Oct 2010 17:23:54 Ben Clark posted:
At some point, the creation of column headers in exporting to Excel has stopped working correctly. Initially, I noticed it several months ago, but I thought it was because of extra code I had added. Today I added the extension on a simple page and got the same error.

Here is the breakdown.

There is a single Ajax Datagrid on the page.

When you press the Export to Excel button, it exports the file with the correct name.

Opening the exported file, the columns are there and the options set for coloring are correct, but the header is messed up including some unknown div wrapper.

Expanding the column, you can see the full div wrapping the header.

I have gotten this same error on several attempts to add the extension to the page and am not sure what I need to do to correct it.



Replied 07 Oct 2010 13:01:10
07 Oct 2010 13:01:10 Miroslav Zografski replied:
Hello Ben,

Extension has a check box named "Strip HTML Tags".
Check to see if it is checked or not.

Replied 07 Oct 2010 22:31:55
07 Oct 2010 22:31:55 Ben Clark replied:
The "Strip HTML TAGS" Option is turned on... here is the function call...

generateJSONASP('dmx_grid3','Excel','utf-8','ScriptLibrary/udeJSON.asp',{markup: ['true','helvetica','12','#FFFFFF','#005AA3','true','false','helvetica','10','#232323','false','false','#AAFFF7','0.3','#666666','10','true',docname,'false',' ','true','#FFFFFF','0']});
Replied 16 Dec 2011 22:14:02
16 Dec 2011 22:14:02 John Jackson replied:
When I export an Excel binary file my headers look like this:

<div style="width: 100px; text-align: left;">Event</div>

There is no Strip HTML option on the Excel binary export. What needs to be done to get the headers to display correctly? I am using DW CS5, Excel 2010 and IE 9 on a Vista Home Premium SP2 workstation.

Replied 18 Dec 2011 22:06:34
18 Dec 2011 22:06:34 John Jackson replied:
I did find the Strip HTML option and turned it off, when I did this all the cells had <div style="width: 100px; text-align: left;">xxxxx</div> in them.

I forgot to mention the exporter is linked to a DMXZone grid.


Reply to this topic