Synopsis
This is a simple code to extract data information from an excel (with a predefined format) and send it to a new Replicon expense sheet using webservices.
Motivation
Simplify my expenses reports
Installation
-
Install Python - https://www.python.org/downloads/ (I am using python 3.8)
-
Check if python is in the path environment variable
a) Command+r > type "rundll32 sysdm.cpl,EditEnvironmentVariables"
b) Check if there is somenthing like "C:\Program Files (x86)\Python37-32\scripts;C:\Program Files (x86)\Python37-32" in the PATH variable
c) Add it if necessary
-
Open a command window and install the required python modules using the following command:
pip install repl_uploader
- Install de xlwings addon on excel typing the following command on a command window:
xlwings addin install
-
Garantee that the Project Name Format in your replicon is set to "Name - Code"
a) Login on your Replicon account
b) Go to settings (engine wheel - upper right corner)
c) Change "Project Name Format" to "Name - Code"
-
When a new release is available, upgrade with the following command:
pip install --upgrade repl_uploader
API Reference
xlwings - http://docs.xlwings.org/en/stable/quickstart.html
Author
- Thiago Weidman
Contributors
- Danilo Passos - The guy who made the worksheet template (Yeap, I stole the idea).
- Rodrigo Tomazeli - The Beta tester and "implementer"
- Manuel Cardoso - The new features specifier :)
Metadata
Release files for repl-uploader 2.2.7
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| repl_uploader-2.2.7.tar.gz | 30.4 kB | Without provenance | Details for repl_uploader-2.2.7.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| repl_uploader-2.2.7-py3-none-any.whl | Python 3 | none | any | Details for repl_uploader-2.2.7-py3-none-any.whl |
Total release size: 63.9 kB
Release files / repl_uploader-2.2.7.tar.gz
| Download URL | repl_uploader-2.2.7.tar.gz |
|---|---|
| Size | 30.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
ede32756dbeee52876403c6bfec1ca488e4854e1a81f574dad0ccf68e16fa73d
|
|
BLAKE2b-256 checksum How to use checksums |
d3a88a14d91fc63536a926c37e3c08625220ea78f391ecf8a6730f0d454b0bda
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.9.12
|
Release files / repl_uploader-2.2.7-py3-none-any.whl
| Download URL | repl_uploader-2.2.7-py3-none-any.whl |
|---|---|
| Size | 33.5 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
fd75e219ff1f561fe4c072e16c75b1738a79651fc46cc0fdc667d12578465919
|
|
BLAKE2b-256 checksum How to use checksums |
f5cd79cd459ba76366149f7e5d8f301477242e967df7c3e9d3dd1419575bdc25
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.9.12
|
Security for repl-uploader 2.2.7
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.