This is one of the common question that I keep on skipping for a while to write an article about how to export data in Business Central.
The Process is similar but during the Upgrade or writing code we kind of used a function C/AL World CreateBookAndOpenExcel which is not supported with Business Central.