Skip to Content (Press Enter)
2024-06-26 06-49-09
Dileep Kumar Verma
172Views
7Comments
Solved
Need to add multiple table in Excel export in Single Sheet
Question
Import/Export Data

Hi I have a use case where I need to display data from different table (Chart1, Chart2 And Chart3 ) to a single Excel sheet and then export it as a excel as mentioned in below format. (attached the excel format)


Please let me know how to achieve this. Is there any sample URL or OML that can help.

Thanks in Advance


Dileep

Dashboard 2 (1).xlsx
0
0
29 Jun 2022
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP
Solution

Hi Dileep,

For your use case, you will have to use the AdvanceExcel forge component.

To export the multiple chart data in the excel based on the shared example.

  1. Create 3 RecordList data type local variable of chart structure type
  2. Assign the Chart data to each record list local variables accordingly
  3. As per the excel template, you will have to add in-between chart title label i.e. Chart1, Chart2 & Chart3 using Cell_Write server action
  4. To write each local variable record list data to excel, use the Cell_WriteRange server action as shown below
  5. The ColumnStart property value will be 1 but the RowStart property will be based on the Chart DataRecordList length + 2 (1 for line gap + Chart Title)


  • Basically, You will have to use most of the Advanced Excel component's server actions to create a Logical flow to build this excel dynamically based on the Chart Data.


I hope this helps you!


Kind regards,

Benjith Sam

See solution in context
1
0
29 Jun 2022
Copy Link
2024-06-26 06-49-09
Dileep Kumar Verma

Thanks a lot  Benjith, It helps to get the idea about the approach. Appreciated ..:)

0
0
29 Jun 2022
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP

Replying to Dileep Verma's comment on 29 Jun 2022 14:49:33

You're welcome, Dileep.

Glad to help you :)


Kind regards,

Benjith Sam

0
0
30 Jun 2022
Copy Link
2023-10-21 19-42-11
Tousif Khan
Champion

Hello Dileep,

Check this thread if it can help -

https://www.outsystems.com/forums/discussion/63058/export-out-different-list-to-same-excel-file/

https://www.outsystems.com/forums/discussion/56965/report-export-excel-from-more-than-1-table-in-1-sheet/

And to customize your excel  while writing the data . You can do formatting it as per your requirement and write cell as you want. 

Use Advance Excel


I hope this will help

Thanks,

Tousif Khan

2
0
29 Jun 2022
Copy Link
2024-06-26 06-49-09
Dileep Kumar Verma

Hi Tousif,

I have checked all above links, unfortunately that is not working as per my use case.

0
0
29 Jun 2022
Copy Link
2023-10-21 19-42-11
Tousif Khan
Champion

Replying to Dileep Verma's comment on 29 Jun 2022 12:06:19

I'll try and work around on this, If I'll  be able to archive it, I'll let you know

1
0
29 Jun 2022
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP
Solution

Hi Dileep,

For your use case, you will have to use the AdvanceExcel forge component.

To export the multiple chart data in the excel based on the shared example.

  1. Create 3 RecordList data type local variable of chart structure type
  2. Assign the Chart data to each record list local variables accordingly
  3. As per the excel template, you will have to add in-between chart title label i.e. Chart1, Chart2 & Chart3 using Cell_Write server action
  4. To write each local variable record list data to excel, use the Cell_WriteRange server action as shown below
  5. The ColumnStart property value will be 1 but the RowStart property will be based on the Chart DataRecordList length + 2 (1 for line gap + Chart Title)


  • Basically, You will have to use most of the Advanced Excel component's server actions to create a Logical flow to build this excel dynamically based on the Chart Data.


I hope this helps you!


Kind regards,

Benjith Sam

1
0
29 Jun 2022
Copy Link
2024-06-26 06-49-09
Dileep Kumar Verma

Thanks a lot  Benjith, It helps to get the idea about the approach. Appreciated ..:)

0
0
29 Jun 2022
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP

Replying to Dileep Verma's comment on 29 Jun 2022 14:49:33

You're welcome, Dileep.

Glad to help you :)


Kind regards,

Benjith Sam

0
0
30 Jun 2022
Copy Link
2024-07-16 17-36-51
Shradha Rawlani

Hi Dileep,

try this forge component by this you are able to edit row and columns according to your requirement

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

Regards

Shradha

1
0
29 Jun 2022
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.