Skip to Content
0
Former Member
May 10, 2010 at 06:47 PM

Generate and send Excel format file by mail in bakground.

137 Views

Hi fellows, i have a requirement, which is to generate an excel file in background and send it attached by e-mail. This file have many characteristics like Freeze pane, Auto filters, and some other format characteristics, One of the ways for achieving this kind of characteristics is using OLE or Desktop Office Integration, but both run in foreground. Other way i found is formatting the excel using XML and then at the moment of sending it by mail, changing extension for xls, but the problem is that it occupies too much space, i imagine cause it is raw xml, for example for a file for 1,000 records and 14 columns generates a file of 1.6Mb which is not like generating the same file using OLE or DOI (24Kb).

I would like to know if there is a way to use an excel component or another way that takes less space for generating the file with format and also send it by e-mail in background??

Thanks.

Noe.