Using SQL Developer 23.1.1.345 Build 345.2114
Currently, when exporting from the cart, there is an option for 2003 + xlsx but when the tables are downloaded and opened in Power BI or Excel, there is a limit of 256 columns until i perform the below step
we take an additional step every day to open, save and close in the Office 365 Excel to be compatible with Power BI data.
The option Under Tools>Preferences>Database>Utilities>Export>Excel > Format option is greyed out.
The reason i went looking for this is we are trying to export oracle tables to latest xlsx format which will be compatible with Power BI.
Not sure if the option in Preferences is the default option no matter what i choose under cart?
Seems like a bug or I may be missing something.
The goal is to export all tables into excel format everyday.
Please help!!
