The module is Python In dealing with Excel Module ( This module can only handle .xlsx Of Excel, If it's any other format , Please change to .xlsx Format .). This module is better than other processing Excel Module , It's a lot easier to use .
install openpyxl modular
For this tutorial, you should use Python 3.7 and openpyxl 2.6.2. To install the package, you can do the following: $ pip install openpyxl. From openpyxl import loadworkbook from openpyxl.drawing.image import Image # Let's use the helloworld spreadsheet since it has less data workbook = loadworkbook. Python Releases for Mac OS X. Latest Python 3 Release - Python 3.9.5; Latest Python 2 Release - Python 2.7.18; Stable Releases. Python 3.9.5 - May 3, 2021. Download macOS 64-bit Intel installer; Download macOS 64-bit universal2 installer; Python 3.8.10 - May 3, 2021. Simple usage — openpyxl 2.4.7 documentation. 用 openpyxl 处理 xlsx 文件 – 李林克斯. Openpyxl 2.4.7: Python Package Index. A Python library to read/write Excel 2010 xlsx/xlsm files. Openpyxl / openpyxl / source / — Bitbucket.
Execute the following command under the terminal , Can finish openpyxl Module installation .
Import openpyxl modular
operation Excel
Here is Excel Of Sheet1 The contents of the form .
B | D |
---|---|
11 | 1111 |
22 | 2222 |
33 | 3333 |
44 | 4444 |
55 | 5555 |
Select the specified sheet
Both of the above methods can select the specified Sheet page , Select and use according to the demand scenario .
Select the specified cell
It should be noted that this is from Excel The first line of , The first column starts , instead of 0.
Get the contents and properties of the cell
for example , To the above Sheet1 The first line of , The first column of cells . give the result as follows :
Gets all the cells in the specified row
How to merge cells
Now? , Suppose the cells are as follows , There are merged cells .
The result of program execution is as follows :
You can see that after merging cells ,A1 Cells are still cells , And read the contents of the cell ; and A2 Cells show merged cells , And can't read the content . That means , When the cells we read are merged cells , So when reading the value, you need the first cell .
Write Excel
Write excel It can be divided into two situations , In the original Excel Write on , Or create new Excel, And then write .
In the original Excel Write on
It should be noted that , If the cell is a merged cell , Then only the first cell can be written , That is to say Cell Type of cell , Can't write MergedCell Type of , Because it's read-only .
In the newly created Excel Write on
Create... In the program Excel, Import first openpyxl Medium workbook
Next, create a new Excel.
modify sheet name
establish sheet
Install Import Openpyxl For Python In Mac Operating System
Delete sheet
More details
Bob Savage <bobsavage@mac.com>
Python on a Macintosh running Mac OS X is in principle very similar to Python onany other Unix platform, but there are a number of additional features such asthe IDE and the Package Manager that are worth pointing out.
4.1. Getting and Installing MacPython¶
Mac OS X 10.8 comes with Python 2.7 pre-installed by Apple. If you wish, youare invited to install the most recent version of Python 3 from the Pythonwebsite (https://www.python.org). A current “universal binary” build of Python,which runs natively on the Mac’s new Intel and legacy PPC CPU’s, is availablethere.
What you get after installing is a number of things:
A
Python3.9
folder in yourApplications
folder. In hereyou find IDLE, the development environment that is a standard part of officialPython distributions; and PythonLauncher, which handles double-clicking Pythonscripts from the Finder.A framework
/Library/Frameworks/Python.framework
, which includes thePython executable and libraries. The installer adds this location to your shellpath. To uninstall MacPython, you can simply remove these three things. Asymlink to the Python executable is placed in /usr/local/bin/.
The Apple-provided build of Python is installed in/System/Library/Frameworks/Python.framework
and /usr/bin/python
,respectively. You should never modify or delete these, as they areApple-controlled and are used by Apple- or third-party software. Remember thatif you choose to install a newer Python version from python.org, you will havetwo different but functional Python installations on your computer, so it willbe important that your paths and usages are consistent with what you want to do.
IDLE includes a help menu that allows you to access Python documentation. If youare completely new to Python you should start reading the tutorial introductionin that document.
If you are familiar with Python on other Unix platforms you should read thesection on running Python scripts from the Unix shell.
4.1.1. How to run a Python script¶
Your best way to get started with Python on Mac OS X is through the IDLEintegrated development environment, see section The IDE and use the Help menuwhen the IDE is running.
If you want to run Python scripts from the Terminal window command line or fromthe Finder you first need an editor to create your script. Mac OS X comes with anumber of standard Unix command line editors, vim andemacs among them. If you want a more Mac-like editor,BBEdit or TextWrangler from Bare Bones Software (seehttp://www.barebones.com/products/bbedit/index.html) are good choices, as isTextMate (see https://macromates.com/). Other editors includeGvim (http://macvim-dev.github.io/macvim/) and Aquamacs(http://aquamacs.org/).
To run your script from the Terminal window you must make sure that/usr/local/bin
is in your shell search path.
To run your script from the Finder you have two options:
Drag it to PythonLauncher
Select PythonLauncher as the default application to open yourscript (or any .py script) through the finder Info window and double-click it.PythonLauncher has various preferences to control how your script islaunched. Option-dragging allows you to change these for one invocation, or useits Preferences menu to change things globally.
4.1.2. Running scripts with a GUI¶
With older versions of Python, there is one Mac OS X quirk that you need to beaware of: programs that talk to the Aqua window manager (in other words,anything that has a GUI) need to be run in a special way. Use pythonwinstead of python to start such scripts.
With Python 3.9, you can use either python or pythonw.
4.1.3. Configuration¶
Python on OS X honors all standard Unix environment variables such asPYTHONPATH
, but setting these variables for programs started from theFinder is non-standard as the Finder does not read your .profile
or.cshrc
at startup. You need to create a file~/.MacOSX/environment.plist
. See Apple’s Technical Document QA1067 fordetails.
For more information on installation Python packages in MacPython, see sectionInstalling Additional Python Packages.
4.2. The IDE¶
MacPython ships with the standard IDLE development environment. A goodintroduction to using IDLE can be found athttp://www.hashcollision.org/hkn/python/idle_intro/index.html.
4.3. Installing Additional Python Packages¶
There are several methods to install additional Python packages:
Packages can be installed via the standard Python distutils mode (
pythonsetup.pyinstall
).Many packages can also be installed via the setuptools extensionor pip wrapper, see https://pip.pypa.io/.
Install Import Openpyxl For Python In Mac Os
4.4. GUI Programming on the Mac¶
There are several options for building GUI applications on the Mac with Python.
PyObjC is a Python binding to Apple’s Objective-C/Cocoa framework, which isthe foundation of most modern Mac development. Information on PyObjC isavailable from https://pypi.org/project/pyobjc/.
The standard Python GUI toolkit is tkinter
, based on the cross-platformTk toolkit (https://www.tcl.tk). An Aqua-native version of Tk is bundled with OSX by Apple, and the latest version can be downloaded and installed fromhttps://www.activestate.com; it can also be built from source.
wxPython is another popular cross-platform GUI toolkit that runs natively onMac OS X. Packages and documentation are available from https://www.wxpython.org.
PyQt is another popular cross-platform GUI toolkit that runs natively on MacOS X. More information can be found athttps://riverbankcomputing.com/software/pyqt/intro.
4.5. Distributing Python Applications on the Mac¶
The standard tool for deploying standalone Python applications on the Mac ispy2app. More information on installing and using py2app can be foundat http://undefined.org/python/#py2app.
4.6. Other Resources¶
The MacPython mailing list is an excellent support resource for Python users anddevelopers on the Mac:
Another useful resource is the MacPython wiki: