Breaking News

Home / How To / Top Answers / How to install OpenPyXL in Python?

How to install OpenPyXL in Python?

January 13, 2020 ,


Openpyxl is a Python library to peruse/compose Excel 2010 xlsx/xlsm/xltx/xltm documents.

It was conceived from absence of existing library to peruse/compose locally from Python the Office Open XML position.

All praise to the PHPExcel group as openpyxl was at first dependent on PHPExcel.

Security

As a matter of course openpyxl doesn't prepare for quadratic blowup or billion chuckles xml assaults. To prepare for these assaults introduce defusedxml.

Method 1:

  • Download compress document and unfasten it on nearby framework.
  • Go to openpyxl organizer where setup.py is available.
  • Open order brief under a similar way.
  • Run an order: python setup.py introduce
  • It will introduce openpyxl.

Method 2:

  • Go to https://pypi.python.org/pypi/openpyxl 
  • Download the files and unzip in your PC in the main folder, there's a file call setup.py
  • Install with this command : python setup.py install