Python Forum
convert old excel files(xls) to xlsm
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
convert old excel files(xls) to xlsm
#1
Hi guys,

I would like to do some copy paste things from one excel to another, but one of them has .xls extension.

I wanted to use openpyxl library but it says that it doesn't support old file format as xls.

Any ideas how i can achieve my goal which is "save as" file (with different extension), while keep formatting (fonts, colors), and macros?
Reply
#2
Convert the file to xmlx, then you can use: https://openpyxl.readthedocs.io/en/stable/
Almost dead, but too lazy to die: https://sourceserver.info
All humans together. We don't need politicians!
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Convert Xls files into Csv in on premises sharpoint Andrew_andy9642 3 1,088 Aug-30-2024, 06:41 PM
Last Post: deanhystad
  Copy Paste excel files based on the first letters of the file name Viento 2 1,618 Feb-07-2024, 12:24 PM
Last Post: Viento
  python convert multiple files to multiple lists MCL169 6 3,365 Nov-25-2023, 05:31 AM
Last Post: Iqratech
  How to loop through all excel files and sheets in folder jadelola 1 9,470 Dec-01-2022, 06:12 PM
Last Post: deanhystad
  Creating csv files from Excel file azizrasul 40 12,463 Nov-03-2022, 08:33 PM
Last Post: azizrasul
  Convert Excel file into csv with Pipe symbol.. mg24 4 2,312 Oct-18-2022, 02:59 PM
Last Post: Larz60+
  Separate text files and convert into csv marfer 6 4,882 Dec-10-2021, 12:09 PM
Last Post: marfer
  Working with excel files arsouzaesilva 6 4,624 Sep-17-2021, 06:52 PM
Last Post: arsouzaesilva
  Problem in saving .xlsm (excel) file using pandas dataframe in python shantanu97 2 6,255 Aug-29-2021, 12:39 PM
Last Post: snippsat
  win32com — How to resolve “AttributeError: xlUp” for Excel files? JaneTan 2 6,496 Aug-18-2021, 05:27 AM
Last Post: snippsat

Forum Jump:

User Panel Messages

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