|
Python code to copy data from multiple workbooks into master sheet
|
|
Aug-21-2019, 11:23 AM
(Aug-21-2019, 11:14 AM)perfringo Wrote: pandas seems good choice - read data from files into dataframe with .read_excel method (defining sheet_name, usecols, skiprows) and write into Excel file using .to_excel method. Pandas ruins the formatting and I want the format to still be present in the Master sheet |
|
|
| Messages In This Thread |
|
Python code to copy data from multiple workbooks into master sheet - by Fatman003 - Aug-20-2019, 02:26 PM
RE: Python code to copy data from multiple workbooks into master sheet - by perfringo - Aug-21-2019, 11:14 AM
RE: Python code to copy data from multiple workbooks into master sheet - by Fatman003 - Aug-21-2019, 11:23 AM
|