Export table data to excel with format intact

Hi PowerBi Users,

We have a necessity for venture we are right now taking a shot at. There are reports in PowerBI which clients export to excel and want to retain the format of the visualization (As is in visualization view column, length, front).

I tried doing export to excel but lost the arrangement, is there a different way to do it?
Additionally, when I dump various tables to excel it gets exported as different excel sheets, Users want to have the capacity to capture them in one in one excel with multiple tabs (not different excel sheets)

Choices we were wanting to investigate and not 100% sure if they might work is
1)Macros to run on excel after individual excels are generated to format and combine them Still to explore
2)PowerBI Publisher for excel to connect to PowerBI directly from excel

Did anyone run into this, would value your sources of info.

Thank you
Divya.