[Excel Report] Can u provide a sample

[Excel Report] Can u provide a sample

  
Forge Component
(5)
Published on 2017-11-27 by Miguel Meireles
5 votes
Published on 2017-11-27 by Miguel Meireles
Hi Everyone,

I am new to Outsystems. I want to use this Excel Report Extention. I am able to download and add reference. I am not able to implement it properly, can you please provide some sample for this extension?

Thanks
Salini

Hi Salini,

a link for the Manual https://meiras.outsystemscloud.com/ExcelReportDemo/ExcelReport.docx

hope it helps
Hi Miguel Meireles,

Thanks for the link. After going through the document, I tried to implement as shown in the attached screen shot. I am able to see only "CreateExcelReport" action. Hope it is the same as "PopulateExcelReport" action in document. It generates an empty excel file. Please help.


Thanks & Regards
Salini

Hi

send you a demo
Hi Miguel Meireles,

Thanks a lot for the sample. I am able to generate excel report. 
Now I want to display an image dynamically from the database (for eg., profile pic).
Is it possible using this template?

Actually I am getting the image as binary data. 

Regards
Salini


Hi Salini

You can try to create the template with the image link, I do not know whether it will work.

best regards
Miguel Meireles

Miguel Meireles wrote:


Hi

send you a demo

Hi Miguel

I'm having an error when trying this demo. Can you help?

I'm using OutSystems 10. 

Thanks.


XiaoHui wrote:

Miguel Meireles wrote:


Hi

send you a demo

Hi Miguel

I'm having an error when trying this demo. Can you help?

I'm using OutSystems 10. 

Thanks.


Hi XiaoHui,

I apolgize for demo you are using,  the demo is deprecated.

I put this demo in the forge you can download (https://www.outsystems.com/forge/Component_Overview.aspx?ProjectId=3945), and install.


Miguel Meireles wrote:

Hi XiaoHui,

I apolgize for demo you are using,  the demo is deprecated.

I put this demo in the forge you can download (https://www.outsystems.com/forge/Component_Overview.aspx?ProjectId=3945), and install.


Hi Miguel

Thanks for the new demo file. It's working. 

I added new data and new graph in new sheet and uploaded the Book2.xlms into Resources, but I'm not able to generate the records and graph to excel. Can you teach me how to do it?

I want to generate something like the below graph.

I will fix those header like Female, Male, 21-30, 31-40.... the number will be calculated from records in entities.

I have several graphs would like to generate.

Attached with the oml that edited by me.


XiaoHui wrote:

Miguel Meireles wrote:

Hi XiaoHui,

I apolgize for demo you are using,  the demo is deprecated.

I put this demo in the forge you can download (https://www.outsystems.com/forge/Component_Overview.aspx?ProjectId=3945), and install.


Hi Miguel

Thanks for the new demo file. It's working. 

I added new data and new graph in new sheet and uploaded the Book2.xlms into Resources, but I'm not able to generate the records and graph to excel. Can you teach me how to do it?

I want to generate something like the below graph.

I will fix those header like Female, Male, 21-30, 31-40.... the number will be calculated from records in entities.

I have several graphs would like to generate.

Attached with the oml that edited by me.



Hello XiaoHui,

I made a demonstration with your request (http://mmeireles.outsystemscloud.com/teste_Excel/test.aspx ) , and I sent the oml file.
I hope I have been able to Help.

Miguel Meireles wrote:

XiaoHui wrote:

Miguel Meireles wrote:

Hi XiaoHui,

I apolgize for demo you are using,  the demo is deprecated.

I put this demo in the forge you can download (https://www.outsystems.com/forge/Component_Overview.aspx?ProjectId=3945), and install.


Hi Miguel

Thanks for the new demo file. It's working. 

I added new data and new graph in new sheet and uploaded the Book2.xlms into Resources, but I'm not able to generate the records and graph to excel. Can you teach me how to do it?

I want to generate something like the below graph.

I will fix those header like Female, Male, 21-30, 31-40.... the number will be calculated from records in entities.

I have several graphs would like to generate.

Attached with the oml that edited by me.



Hello XiaoHui,

I made a demonstration with your request (http://mmeireles.outsystemscloud.com/teste_Excel/test.aspx ) , and I sent the oml file.
I hope I have been able to Help.

Hi Miguel,

Thanks for your sample, it works perfectly! I will implement it in my project.

Regards

Xiao Hui