|
Extracting CSV from Excel file
|
|
May-11-2020, 05:13 PM
Hello, I was curious if anyone knew how or could point me to some tutorials that could help me with a project. I have some excel files that have pivot tables in them using csv's. I was wondering if it was possible (since I do not have the csv files) to use Python to extract the csv file from Excel?
Many Thanks!
May-11-2020, 05:14 PM
what is the source of the pivot tables in the excel? Are the data on separate sheet or what?
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link Create MCV example Debug small programs
May-11-2020, 05:24 PM
None of the raw data is stored on another tab. The data is stored in the workbook Data Model.
the raw data must come from somewhere - is it database or what? Speaking of Data Model I guess you are using PowerQuery
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link Create MCV example Debug small programs
May-11-2020, 05:33 PM
Yes, the original data comes from a database. The people who supply me with the excel sheets export the data from a database into a csv then load them into excel to create a pivot table.
your files must have access to these files, what will happen if you refresh the pivot table, or make a change, e.g. add field, etc?
you can inspect the data source of the pivot table and see the data source/location of the files. I don't think you can "extract" the raw data just from the aggregated data in the pivot table. (May-11-2020, 05:37 PM)buran Wrote: I don't think you can "extract" the raw data just from the aggregated data in the pivot table.Actually I may be wrong. Look at https://stackoverflow.com/a/48231808/4046632
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link Create MCV example Debug small programs |
|
|
