I have the same request. I can generate the reports exactly as I want them and export the report to a PDF.
I need to be able generate a mirror of the PDF report in an excel file, but through many attempts can not make this happen.
Save data from current record? Yes
Conditional Formatting? No
Other Formatting? I don't think so, though you can if you use an xml export with some additional work if I understand some posts by Comment correctly.
You might consider exporting an excel sheet with the data along with generating the PDF to provide the "camera ready" view of how it all looks. The customer would then edit the excel sheet while referring to the PDF--not as nice as what you wanted, but maybe that would serve.