Documentation / Tutorials / Tutorials & How to’s

Write Data in Excel and Download

/ Tutorials & How to’s / Write Data in Excel and Download

[aw2.set heads="Column1,Column 2,Column 3" /]
[aw2.set module.heads_data="{heads.comma}" /]

[aw2.set module.xlsresults.header.new="{module.heads_data}" /]

[aw2.get module.xlsresults.header dump=true /]

[aw2.set module.row_data.new="Data1" /]
[aw2.set module.row_data.new="Data 2" /]
[aw2.set module.row_data.new="Data 3" /]

[aw2.get module.row_data dump=true /]

[aw2.set module.xlsresults.rows.new="{module.row_data}" /]

[aw2.get module.xlsresults dump=true /]

[aw2.set module.filename="data.xls" /]

[excel.write_bulk file_name='{module.filename}' folder="{realpath.app_folder}" data='module.xlsresults' file_format="Excel5"/]
[aw2.get app.path /]/file/xls/?filename=[aw2.get module.filename /]

 

Data:

Categories
Most Popular

Leave a Reply

Your email address will not be published.