Cool, I am going to have to check this out. Thanks!

I have tried to change your test application to accommodate an arraycollection instead of an RSS feed and I keep getting in the excel sheet that the headers a shifted one cell to the right. Enabling the clipboard functionality and pasting directly into excel does not have this problem.

How can I correct this?

Perhaps the first Item in the arrayCollection is empty? Hence its putting in an empty TAB

theData = new ArrayCollection([
{name:"John Smith",isManager:false,age:34,sex:"M"},
{name:"Jenny Zurich",isManager:true,age:45,sex:"F"},
{name:"Jason Ruins",isManager:false,age:22,sex:"M"},
{name:"Tim Johnson",isManager:false,age:21,sex:"M"},
{name:"Mary Winn",isManager:false,age:20,sex:"F"},
{name:"Joe Rock",isManager:true,age:31,sex:"M"}
]);

Without seeing all the code I'm just not sure. I know I have a copy from arrayCollection mod myself and it is working fine. If you want to pastebin the code I can take a look.

The code looks fine. Perhaps its a server setting. In the Coldfusion / Railo admin there is "Suppress white space" try turn that on see if it helps.

That is exactly the the solution. In the Web Admin of Railo under the Settings menu, there is a sub-item called Output and on that page is a checkbox as follows:

"Removes all white spaces in the output that follow a white space"

I checked that and all was fine.

For Coldfusion 7.02...

In the Administrator, Server Settings menu, Settings sub-menu check the checkbox:

"Enable Whitespace Management
Reduces the file size of the pages that ColdFusion returns to the browser by removing many of the extra spaces, tabs, and carriage returns that ColdFusion might otherwise persist from the CFML source file."

Much thanks to Paul for helping me troubleshoot this problem and find the solution.

Another issue that I had was printing descriptions that were text areas and included tabs, new lines and carriage returns.

In the copyToDatagrid function where 'Remove all " as it messes with the tab delimited string' is, I added this to remove those characters from the the strings:

data = data.replace(/\r/g, " ");
data = data.replace(/\n/g, " ");
data = data.replace(/\t/g, " ");

When I try to implement the excel.php wiht excel.jsp, I get the content in a single cell. The content is not getting delimeted. This is what my code in the jsp. Please throw some light into it:

page contentType="application/vnd.ms-excel"

response.setHeader("Content-Disposition", "attachment; filename=\"Workbook.xls\"");

out.print(request.getParameter("htmltable"));

Hi Madhava, I would say its something to do with the issue Mike had where additional whitespace was being introduced somewhere breakign the tab delimitation. I'm not sure how to over come this with jsp ( assume tomcat ) but you could wrap the data in html table code which excel will also will open and display fine. You can find this example at this link: http://www.saskovic.com/blog/?p=3

Thanks a lot and it helped me a lot.