Downloading .xls file with multiple rows and Columns

[Former Member]

Hi ALL,

I need to genarate .xls file with multiple rows and and Columns and sent as an email.Since our customer having Problem with .CSV files need to genarate .XLS file.

Please do the needful.

Thanks

Madhu

[Former Member]

Hi Madhu,

You might also consider using Excel Spreadsheet XML as the target structure (namespace is urn:schemas-microsoft-com:office:spreadsheet). When you double-click the resulting xml on a PC it automatically opens with Excel. So, users don't see a difference. It will open up a lot of options with formatting including creating multiple worksheets if you wanted to. Best of all you can stick with XML.

See my response in this thread:

Thanks,

-Russ

[Former Member]

Madhu,

Please check this blog where prakash have given an example for your scenario:

/people/community.user/blog/2006/09/08/email-report-as-attachment-excelword

Please see for more help:

/people/community.user/blog/2006/09/07/email-reporting

Regards,

---Satish