Skip to main content
A
AP_1034300816-Pearl
16-Pearl
October 10, 2023
Solved

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

  • October 10, 2023
  • 2 replies
  • 1047 views

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.

Best answer by PEHOWE

@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

S
17-Peridot
Sathishkumar_C17-Peridot
17-Peridot
October 11, 2023

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

    P
    PEHOWE17-PeridotAnswer
    17-Peridot
    October 11, 2023

    @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

    Terms & ConditionsAccessibility statement