Package with utilities to work with MS Office applications from Python via COM interface technology

Navigation

Verified details

These details have been verified by PyPI
Project links
GitHub Statistics
Maintainers
Avatar for dornech from gravatar.com dornech

Unverified details

These details have not been verified by PyPI
Project links
Meta
  • License: GPL-3.0-only
  • Author: dornech
  • Tags Excel , MS Office , Microsoft Office , office object wrapper
  • Requires: Python >=3.9
Classifiers
Report project as malware

Project description

Microsoft Office utilities for Python based on PyWin32

Package with utilities to work with MS Office applications from Python via COM interface technology

Features

Set of submodules contains:

  • submodule for Microsoft Office constants -> deprecated, switched to access to win32.com.client.constants
  • submodule for Microsoft VBA constants
  • submodule with utilities for Microsoft Office in general
  • submodule with utilities for Microsoft Excel including "pythonic" access to ExcelAPI
  • submodule for interfacing caller with Microsoft Office applications via Python Wrapper

Note: as I am coming from camel case notation I was struggling a little bit with the Python naming conventions. However, for publishing I tried to increase compliance with Python naming conventions and added snake case method stubs (at least for most important subroutines) as a compromise.

Development

To set up hatch and pre-commit for the first time:

  1. install hatch globally, e.g. with pipx, i.e. pipx install hatch,
  2. make sure pre-commit is installed globally, e.g. with pipx install pre-commit.

A special feature that makes hatch very different from other familiar tools is that you almost never activate, or enter, an environment. Instead, you use hatch run env_name:command and the default environment is assumed for a command if there is no colon found. Thus you must always define your environment in a declarative way and hatch makes sure that the environment reflects your declaration by updating it whenever you issue a hatch run .... This helps with reproducability and avoids forgetting to specify dependencies since the hatch workflow is to specify everything directly in pyproject.toml. Only in rare cases, you will use hatch shell to enter the default environment, which is similar to what you may know from other tools.

To get you started, use hatch run test:cov or hatch run test:no-cov to run the unitest with or without coverage reports, respectively. Use hatch run lint:all to run all kinds of typing and linting checks. Try to automatically fix linting problems with hatch run lint:fix and use hatch run docs:serve to build and serve your documentation. You can also easily define your own environments and commands. Check out the environment setup of hatch in pyproject.toml for more commands as well as the package, build and tool configuration.

To support versioning and changelog generation please refer to the toolchain selected during package generation (see also pyproject.toml). If not deselected, the toolchain includes a pre-commit hook for linting commit messages to ensure commit messages are compliant with the conventional commit format and support an automated changelog generation.

Credits

This package was created with The Hatchlor Enhanced project template. This template is based on The Hatchlor but was substantially improved.

Project details

Verified details

These details have been verified by PyPI
Project links
GitHub Statistics
Maintainers
Avatar for dornech from gravatar.com dornech

Unverified details

These details have not been verified by PyPI
Project links
Meta
  • License: GPL-3.0-only
  • Author: dornech
  • Tags Excel , MS Office , Microsoft Office , office object wrapper
  • Requires: Python >=3.9
Classifiers

Release history Release notifications | RSS feed

This version

1.0.1

1.0.0

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

utils_msoffice-1.0.1.tar.gz (31.8 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

utils_msoffice-1.0.1-py3-none-any.whl (30.8 kB view details)

Uploaded Python 3

File details

Details for the file utils_msoffice-1.0.1.tar.gz.

File metadata

  • Download URL: utils_msoffice-1.0.1.tar.gz
  • Upload date:
  • Size: 31.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.7

File hashes

Hashes for utils_msoffice-1.0.1.tar.gz
Algorithm Hash digest
SHA256 34134615c30243b58aa59218ac9507810c68842e4a92a03155125e3bc6457c59
MD5 5068a6ef284f736135055220cf6c17d2
BLAKE2b-256 d6128ae041d64f17b3649c9f73a9b10dc21480aa7223b0cfebc7d0cb0a3b4288

See more details on using hashes here.

Provenance

The following attestation bundles were made for utils_msoffice-1.0.1.tar.gz:

Publisher: build.yml on dornech/utils-msoffice

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file utils_msoffice-1.0.1-py3-none-any.whl.

File metadata

  • Download URL: utils_msoffice-1.0.1-py3-none-any.whl
  • Upload date:
  • Size: 30.8 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.7

File hashes

Hashes for utils_msoffice-1.0.1-py3-none-any.whl
Algorithm Hash digest
SHA256 07e1b94ec4c14166033b0c6246f1ce678d384cdf0325b3f67c07fc41767f61d3
MD5 f352b37d4a544ebd0d1fbe93baaa3aa9
BLAKE2b-256 84e9c0ef5e0390df2eadd46f1fb55cafb8ec4af764036da4841089e6ab936da6

See more details on using hashes here.

Provenance

The following attestation bundles were made for utils_msoffice-1.0.1-py3-none-any.whl:

Publisher: build.yml on dornech/utils-msoffice

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page