Skip to main content
Oct 10, 2023 9:42 PM UTC
Solved

How to add 3 sub sheets in excel to add each infotable data in each sheet of excel.

I have 3 infotables. How to export one excel sheet which having 3 sub sheets to add each infotable data in each sheet of excel. 
(or)
How to export all 3 infotables in same file by differentiating each infotable separtely.

Note: There is no common column present in all the 3 infotables.

PEHOWEAnswer
Oct 11, 2023 9:53 PM UTC

@AP_10343008 

When creating a Extension to create an Excel file. You can use the Apache POI library (https://poi.apache.org/) which has the code to create and update an excel file.

 

Have Fun

2 replies

Oct 11, 2023 7:09 AM UTC

create custom extension which consume multiple infotables... and write it on each sheet.

PEHOWEAnswer
Oct 11, 2023 9:53 PM UTC

@AP_10343008 

When creating a Extension to create an Excel file. You can use the Apache POI library (https://poi.apache.org/) which has the code to create and update an excel file.

 

Have Fun