[PYTHON] Offline installation procedure for openpyxl

I did it, so make a note.

Prerequisites

Things necessary

Download the latest version below in advance from pypi.org

name format Remarks
openpyxl .whl
jdcal .whl Required for openpyxl.
et_xmlfile setup.py Required for openpyxl. tar.Only gz format can be downloaded, so unzip it

Installation

py -m pip install .\jdcal-1.4.1-py2.py3-none-any.whl   # py -By putting m at the beginning, you can hit pip even if pip does not have PATH.
python .\dist\et_xmlfile-1.0.1\setup.py install --user #If user is not specified, it will be installed in the current directory.
py -m pip install .\openpyxl-3.0.5-py2.py3-none-any.whl

sample

A script that displays all Sheet names and the number of Sheets in sample.xlsx

get_sheet_names.py


import openpyxl
book = openpyxl.load_workbook("sample.xlsx")
names = book.sheetnames
print(names)
print("---------")
print(len(names))

Recommended Posts

Offline installation procedure for openpyxl
Python 3.6 installation procedure [for Windows]
Teamviewer for Linux installation procedure (CentOS)
Pylearn 2 installation procedure
WSL2 (Windows Subsystem for Linux) installation procedure
PostgreSQL 10.0 installation procedure
blockdiag installation procedure
Linux mint installation procedure
AWS CLI installation procedure
django-debug-toolbar installation procedure memo
ubuntu20.04 + Geth installation procedure
Anaconda3 environment installation procedure
Scrapy environment installation procedure
Python CMS Mezzanine installation procedure
Installation notes for TensorFlow for Windows
CentOS 8 installation procedure (latest version)
Docker Easy Installation Procedure (CentOS)
ubuntu 20.04 + VirtalBox installation procedure summary
Installation procedure for Python and Ansible with a specific version
OpenCV3 installation for Python3 @macOS
Python 3 series installation for mac
nwdiag Problems with offline installation
Cocos2d-x ~ Installation Guide for Mac ~
Create Scratch Offline Editor for Linux
JupyterLab3.0 Debugger Installation Method for Windows
OpenCV installation procedure on Raspberry Pi
[Go] Procedure for installing Go on WSL2
PySpark 1.5.2 + Elasticsearch 2.1.0 Installation procedure and execution