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
  Copy Paste excel files based on the first letters of the file name Viento 2 423 Feb-07-2024, 12:24 PM
Last Post: Viento
  python convert multiple files to multiple lists MCL169 6 1,535 Nov-25-2023, 05:31 AM
Last Post: Iqratech
  How to loop through all excel files and sheets in folder jadelola 1 4,461 Dec-01-2022, 06:12 PM
Last Post: deanhystad
  Creating csv files from Excel file azizrasul 40 5,583 Nov-03-2022, 08:33 PM
Last Post: azizrasul
  Convert Excel file into csv with Pipe symbol.. mg24 4 1,324 Oct-18-2022, 02:59 PM
Last Post: Larz60+
  Separate text files and convert into csv marfer 6 2,860 Dec-10-2021, 12:09 PM
Last Post: marfer
  Working with excel files arsouzaesilva 6 3,150 Sep-17-2021, 06:52 PM
Last Post: arsouzaesilva
  Problem in saving .xlsm (excel) file using pandas dataframe in python shantanu97 2 4,270 Aug-29-2021, 12:39 PM
Last Post: snippsat
  win32com — How to resolve “AttributeError: xlUp” for Excel files? JaneTan 2 4,216 Aug-18-2021, 05:27 AM
Last Post: snippsat
  How do I read in a Formula in Excel and convert it to do the computation in Python? JaneTan 2 2,638 Jul-07-2021, 02:06 PM
Last Post: Marbelous

Forum Jump:

User Panel Messages

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