pyBegin / projects / xls-to-xlsx
🐍

XLS TO XLSX

![View My Profile](https://github.com/odhyp)

52 lines🖥 Desktop only
View source folder on GitHub →contributed by@odhyp

Python Version pywin32 Version View My Profile

XLS TO XLSX

Icon Author: Created c. 2018 by Microsoft Corporation

Description

A simple Python script that converts Microsoft Excel '.xls' file to '.xlsx' file.

Languages or Frameworks Used

This script requires Python 3 and pywin32.

Example

Input the '.xls' file path:
C:\Users\user\Documents\report.xls
Successfully converts report.xls
Do you want to delete the old report.xls file (y/n)? y
Successfully removes report.xls

The converted file report.xlsx is saved in the same directory as the input file.

How to run on localhost

  1. Ensure you have Python 3 installed on your system.
  2. Navigate to this project directory or where xls_to_xlsx.py is saved.
  3. To install the required dependencies, open a terminal and run:
pip install -r requirements.txt
  1. Make sure you close all running Microsoft Excel applications before executing the script.
  2. To run the script, open a terminal and run the following command:
python xls_to_xlsx.py
  1. Follow the prompts to input the file path.
  2. The output file is then saved in the same directory as the input file.
  3. Input either 'y' to delete the old '.xls' file or 'n' to keep it instead.

Author

odhy