Excel from SAP - dealing with formats and VBA

[MasterOfDestr]

What I want to achive:
Either
1. Copy and paste data including formats into main report file. Next extracting format (KG, PCs, EUR, USD ect) in separate column
or
2. Extracting format (KG, PCs, EUR, USD ect) in separate column in source excel. Next copy and paste data into main report file.
or
3, Whatever activities that can be done to have data with extracted forma in main report file.


I'm testing possibilities using openpyxl using this documentation but without success.

Is there any additional information that would you like to have?

Quite a lot of people seem to want to know how to get things from Excel, but they don't want to share what they have.

Nuclear Secrets!

You can check the openpyxl documentation here.

Or you could post a small example Excel file, then no one has to guess what you may, or may not, have.

Then you just need to make clear what, exactly, it is that you want to achieve, assuming you are clear about that.

Or, this 1-liner:

from magic import wand

resultXL = wand.wave("my_old_ excel", "my_total_solution_excel")