convert old excel files(xls) to xlsm

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

convert old excel files(xls) to xlsm

zarize
Wafer-Thin Wafer

Posts: 77

Threads: 35

Joined: Aug 2019

Reputation: 0

Jul-14-2020, 01:01 PM (This post was last modified: Jul-14-2020, 01:07 PM by zarize.)

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?

Find

Messages In This Thread

convert old excel files(xls) to xlsm - by zarize - Jul-14-2020, 01:01 PM

RE: convert old excel files(xls) to xlsm - by DeaD_EyE - Jul-14-2020, 02:12 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Copy Paste excel files based on the first letters of the file name	Viento	2	550	Feb-07-2024, 12:24 PM Last Post: Viento
	python convert multiple files to multiple lists	MCL169	6	1,718	Nov-25-2023, 05:31 AM Last Post: Iqratech
	How to loop through all excel files and sheets in folder	jadelola	1	4,725	Dec-01-2022, 06:12 PM Last Post: deanhystad
	Creating csv files from Excel file	azizrasul	40	6,253	Nov-03-2022, 08:33 PM Last Post: azizrasul
	Convert Excel file into csv with Pipe symbol..	mg24	4	1,445	Oct-18-2022, 02:59 PM Last Post: Larz60+
	Separate text files and convert into csv	marfer	6	3,016	Dec-10-2021, 12:09 PM Last Post: marfer
	Working with excel files	arsouzaesilva	6	3,316	Sep-17-2021, 06:52 PM Last Post: arsouzaesilva
	Problem in saving .xlsm (excel) file using pandas dataframe in python	shantanu97	2	4,499	Aug-29-2021, 12:39 PM Last Post: snippsat
	win32com — How to resolve “AttributeError: xlUp” for Excel files?	JaneTan	2	4,385	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,761	Jul-07-2021, 02:06 PM Last Post: Marbelous

Users browsing this thread: 1 Guest(s)

View a Printable Version

convert old excel files(xls) to xlsm

User Panel Messages

Announcements