Hi all,
I have been searching forum for bringing excel functionality in oracle apex. The page should be in excel format user can do all the functions as in excel like freeze / pivot/ n number of columns(500 columns though with n number of sub columns) and also editable. Once they click save the data should be stored in database.
This looks more complex but just want to know if this is possible in APEX 5.1. We tried using IG , but we faced lot of issues as the report itself has dynamic number of columns and dynamic number of sub columns, maximum can be 500 columns. For pivot we used default smart pivot in IG but that has no freeze column functionality. Hence we dropped using IG and trying to bring entire excel in APEX.
Please suggests if you have any idea or method to achieve this or at least if this is possible in APEX 5.1.
Thanks,
Regards,
Nivetha Ramnath.