Python Forum
Missing graph after combining xls files
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Missing graph after combining xls files
#1
Hello,
I have multiple xls files , some with graphs.I am combining these files into worksheets of a single xlsx workbook.
After combining, the final output xls workbook does not have the graphs.Below is the code Iam using to combine the xls file:
import pandas as pd
import os
import csv
import glob    
path = './'
all_files = glob.glob(os.path.join(path, "*.xlsx"))
writer = pd.ExcelWriter('out.xlsx', engine='xlsxwriter')

for f in all_files:
    df = pd.read_excel(f)
    df.to_excel(writer, sheet_name=os.path.splitext(os.path.basename(f))[0], index=False)

writer.save()
Is there anything missing in the above code?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Find specific subdir, open files and find specific lines that are missing from a file tester_V 8 3,487 Aug-25-2020, 01:52 AM
Last Post: tester_V
  How can I compare Python XML-Files and add missing values from one to another kirat 2 2,628 Aug-30-2019, 12:17 PM
Last Post: perfringo
  edit text files/ add lines if missing (regex) wardancer84 3 2,755 Nov-08-2018, 02:47 PM
Last Post: wardancer84
  Combining several py files ebolisa 5 2,963 Oct-09-2018, 07:16 PM
Last Post: ebolisa

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020