Comprehensive Guide to Resolving 'No module named 'openpyxl'' Error in Python 3

Problem Background Analysis

Module import errors are common technical issues in Python development. When developers attempt to import the Workbook class from the openpyxl module, the system throws an ImportError: No module named 'openpyxl' exception. This situation typically occurs in environments using Python 3.4 on Ubuntu 14.04 32-bit systems.

Root Cause Investigation

Through thorough analysis, the core issue lies in the distinction between Python 2 and Python 3 package management tools in Ubuntu systems. By default, the pip command is associated with Python 2's package manager, while pip3 is specifically designed for Python 3 package management. When developers use the pip install openpyxl command, the module is actually installed in the Python 2 environment, causing Python 3 to fail in recognizing and importing the module.

Detailed Solution Explanation

To address the aforementioned issue, the most direct solution is to use the correct package management command:

pip3 install openpyxl

This command ensures that the openpyxl module is installed in Python 3's package directory, thereby resolving the import error.

Best Practices with Virtual Environments

Referring to supplementary materials, using virtual environments represents a superior approach to avoid such problems. Virtual environments create independent Python runtime environments for each project, effectively isolating dependencies across different projects. The steps to create and activate a virtual environment are as follows:

python3 -m venv myenv
source myenv/bin/activate
pip install openpyxl

Within the activated virtual environment, all package installation operations are confined to the current environment, preventing system-level environmental pollution and version conflicts.

Environment Verification Methods

To confirm the correspondence between Python and pip, the following commands can be used for verification:

which python3
which pip3

These two commands should return the locations of executable files under the same base path. Inconsistent paths indicate environment configuration issues.

Comparison of Alternative Installation Methods

Besides using pip3, conda serves as a viable package management alternative. For users of Anaconda or Miniconda, the following command can be executed:

conda install -c anaconda openpyxl

It's important to note that conda might experience update issues in certain versions, so using officially recommended channels for installation is advised.

Preventive Measures Summary

To prevent similar module import issues, developers are recommended to: always clarify the currently used Python version; create independent virtual environments for each project; use corresponding version package management tools; regularly check environment configuration consistency. These practices significantly enhance development efficiency and reduce environment-related problems.