Export Excel like transpose table

Hello everyone

May I ask some questions.

I want to export excel but it is not normal form.

Please see my picture

The data in my entity

my requirement format to export excel

I want to export data form my entity like my requirement picture.

How can I achieve this.

It is possible to use advance excel.Please point me.

Thanks you.

Hi,

You can refer to these two components from the forge, There are so many different methods that are available in these components which you can use and design excel as per your need. Please try this out.

https://www.outsystems.com/forge/component-overview/1044/excel-package

https://www.outsystems.com/forge/component-overview/355/advanced-excel

Thanks,

Sachin

Hanno wrote:

Thanks you for your answer I am so happy.

But I cannot download from link you sent.

I can download only Advanced.Excel-Demo-2.1.23_O11.oap .

If you know another way to download Advanced.Excel-Demo-2.2.1_O11.oap Please let me know.

Regards.

Hi May Zin Linn 

Yes, you can use advanced excel.

Please take a look at the demo project included in this download: https://www.outsystems.com/forge/Popup_DownloadConfirmation.aspx?VersionId=18214&IsMostRecentVersion=True&IsDownloadDemo=True&IsCurrentVersion=False&ShowWarnings=False&IsDevVersion=False

Regards

Hanno

 

 

May

Please go here: https://www.outsystems.com/forge/component-versions/355

and download the latest version

Hanno wrote:

Thanks you Hanno.

I can download new version and check out the demo.

There are many server actions in the demo and I found the action (Cell_Writesinglecells) .

Honestly I said I don't know this action is suitable for my requirement because there are many data in my entity this action can write per cell.If you can help me please let me know which action in the demo can achieve for my requirement.

I am so sorry for your time and Thanks you very much.

May

Please go here: https://www.outsystems.com/forge/component-versions/355

and download the latest version

 

 

Hi May

You should look at Cell_WriteRange action.

See the documentation tab for more details: