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

[AP_10343008]

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.

[Sathishkumar_C]

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

[PEHOWE · Accepted solution]

@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