Comments on Paul Kukiel -
and what i'm interested in.: Flex datagrids and Excel part 2

@Anju singh Sorry about that as I was moving to C...

2010-03-02T17:40:06.904-05:00

@Anju singh

Sorry about that as I was moving to CF9 I messed up some of the links. All those links and demos should now be restored.

i cant see the flex application, and the link is b...

2010-03-02T17:28:30.474-05:00

i cant see the flex application, and the link is broken http://cf9.kukiel.net/blog/datagridexcel/

can you please share the new link.,...

Thanks alot paul, for this post

2009-07-13T03:55:02.218-04:00

Thanks alot paul, for this post

Thanks a lot and it helped me a lot.

2009-06-08T12:52:52.345-04:00

Thanks a lot and it helped me a lot.

Hi Madhava, I would say its something to do with t...

2009-06-08T12:16:18.967-04:00

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

When I try to implement the excel.php wiht excel.j...

2009-06-08T11:03:13.649-04:00

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"));

Another issue that I had was printing descriptions...

2009-04-13T12:02:19.046-04:00

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, " ");

That is exactly the the solution. In the Web Admin...

2009-04-01T13:51:59.551-04:00

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.

The code looks fine. Perhaps its a server setting...

2009-04-01T13:40:59.833-04:00

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.

Without seeing all the code I'm just not sure. I ...

2009-03-30T15:35:53.212-04:00

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.

theData = new ArrayCollection([ ...

2009-03-30T14:52:43.977-04:00

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"}
]);

Perhaps the first Item in the arrayCollection is e...

2009-03-30T14:34:46.044-04:00

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

I have tried to change your test application to ac...

2009-03-30T14:31:25.050-04:00

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?

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

2009-01-06T15:09:54.543-05:00

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

Comments on Paul Kukiel - and what i'm interested in.: Flex datagrids and Excel part 2

@Anju singh Sorry about that as I was moving to C...

i cant see the flex application, and the link is b...

Thanks alot paul, for this post

Thanks a lot and it helped me a lot.

Hi Madhava, I would say its something to do with t...

When I try to implement the excel.php wiht excel.j...

Another issue that I had was printing descriptions...

That is exactly the the solution. In the Web Admin...

The code looks fine. Perhaps its a server setting...

Without seeing all the code I'm just not sure. I ...

theData = new ArrayCollection([ ...

Perhaps the first Item in the arrayCollection is e...

I have tried to change your test application to ac...

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

Comments on Paul Kukiel -
and what i'm interested in.: Flex datagrids and Excel part 2