cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

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

AP_10343008
13-Aquamarine

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.

1 ACCEPTED SOLUTION

Accepted Solutions

@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

View solution in original post

2 REPLIES 2

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

@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

Top Tags