Share this post

Link to post

Share on other sites

Doesn't work with the native exporter. You would probably need an XML export and an XSLT stylesheet to convert it to what you want. Or export it to excel and then do some post processing there (through VBscript on Windows or AppleScript on Mac).

Share this post

Link to post

Share on other sites

I create .xls all the time as XML with XSLT. But I have not found the way for EXCEL to preserve the "list" (return delimited text) that is in a single field. I researched and know there is a way to manually add these character. But I suppose, as Wim says, export so that the return-in-field is a character (like a pipe "|"?) and then when in EXCEL post process. Or maybe they need to be CRLF (carriage return+line feed) or just LF instead of the CR.

Wim, what character would be correct even if post-processed?

replying to myself Or perhaps, the column (or cell) needs to have wrap turned on to see the "list"?

Share this post

Link to post

Share on other sites

If you don't mind iterating through the found set, you can build the XML into a global field and export. This will allow you to set formatting (bold, larger text, etc) for column headings, as well as provide for the multiple lines in a single cell. Multi-lines are embedded as &#10; which is CHR(10) = linefeed. Note that cell format must also be set to wrap the text and the row height must be set to accommodate the extra lines. I had to do this recently to generate an Excel file using VBA, from a process control system (Alarm list setpoints). http://www.telerik.com/community/forums/aspnet-ajax/grid/excel-export-with-multi-line-cells.aspx was useful.