Dynamic column name in export to excel

Dynamic column name in export to excel

  
Hi All,

I am showing column names dynamically in the grid based on fiter selection.Now I want the same column names in the exported excel.But exported excel is taking values from the entity column name or label from the structure.How can I pass these names dynamically to Export to Excel ?


Thanks,
Prashanth
hi,

The simple and fast way: export creating a csv file.

In forum, you can find a lot of post about this topic.

Cheers,
Sérgio
Sérgio Gonçalves wrote:
hi,

The simple and fast way: export creating a csv file.

In forum, you can find a lot of post about this topic.

Cheers,
Sérgio
Hi,
I wanted to export the data into excel only not in Csv.

Thanks,
Prashanth


 
Sérgio Gonçalves wrote:
hi,

The simple and fast way: export creating a csv file.

In forum, you can find a lot of post about this topic.

Cheers,
Sérgio
Hi,
I wanted to export the data into excel only not in Csv.

Thanks,
Prashanth


 

Hi,
Please check the Advanced Excel component:

http://www.outsystems.com/forge/355/Advanced+Excel/changelog/?ProjectVersionId=0

Hope it helps you.
Kind regards.
Hi Its not working i am getting ther error:-Intellectual Property Error
 
This module is under Intellectual Property Protection, so you cannot upload it to your environment. Go to http://www.outsystems.com/ipp and request rights to use this module.
Hi Rajendra,

Here by the steps to remove the  Intellectual Property Protection (IPP)

http://www.outsystems.com/forums/discussion/10258/ipp-issues/

Hope it helps you.
Kind regards.

Daniel Martins.
Hi Rajendra,
 
I recently worked with a component JS that export a Table Records "as you can see" in your browser, to an excel file, including the cells formatting. The only problem is that you'll not use CSS style classes, because the JS won't save de CSS file in excel file content. For this, you'll just use the CSS styles directly in the "extended properties" of the table elements to be exported.
 
This component basically saves your HTML to XLS. In the community has a example:
 
http://www.outsystems.com/forge/component/17/xlstools/
 
/BN
Hi Breno I am trying to Export the List into Excel Not HTML, Coz We have so many control in the same screen. So we can't Export the HTML.


Thanks 
Rajendra Netlink
Hi Rajendra,
You can use ExcelPackage extension to write your report in excel format , this component gives u liberty to control each cell and row, also u can colour the row and cells as required and its written in .net so u can customize it as per ur requirment.
I iwll try to upload an example oml when i get some time.