Made by William Norland, 2023
Fast way to convert large .xls/.xlsx files to CSV by saving them via a vbs running via windows script host.
Dependencies
Excel (Only tested on excel 2016)
Windows operating system (Only tested on Windows 10).
Only tested on Python 3.11, should probably work on any python that has os and subprocess.
Windows script host (Exists on pretty much every windows ever).
Usage
Install
pip install FastXlsToCsv
Import
from FastXlToCsv import XlsConverter
Use
inputFile: str = r”c:\Users\someone\Desktop\ExcelFiles\excelFileThatWantsTobeCsv.xlsx”
inputDir: str = r”c:Users\someone\Desktop\ExcelFiles”
outputDir: str = r”c:\Users\someone\Desktop\FolderForExportedCsvs”
XlsConverter.convertXlFileToCsv(inputFile, output)
XlsConverter.convertXlDir(inputDir, output)
License
Relased under the MIT License, check FastXlsToCsv/LICENSE for more information.
1 maintainer
Release files for FastXlsToCsv 1.2.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| FastXlsToCsv-1.2.1.tar.gz | 3.9 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| FastXlsToCsv-1.2.1-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 8.4 kB
Release files / FastXlsToCsv-1.2.1.tar.gz
| Download URL | FastXlsToCsv-1.2.1.tar.gz |
|---|---|
| Size | 3.9 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
df839a51ecef12c13ddbaad013c7ab3dec0bc101f1d6861be6bebf3b7bca4f01
|
|
BLAKE2b-256 checksum How to use checksums |
21047aaf66a1baf5ff7efcfea7b24416d1c8905589e07a7575fb30b2e197b9d7
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.11.2
|
Release files / FastXlsToCsv-1.2.1-py3-none-any.whl
| Download URL | FastXlsToCsv-1.2.1-py3-none-any.whl |
|---|---|
| Size | 4.5 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
7ed82532cc242728eb3e1fcc429c42888a27188cbdc091e426910148c0374c10
|
|
BLAKE2b-256 checksum How to use checksums |
96d16fd37239e607a71159d05913be125cdce80f9ff331f1c68c4250351a22b2
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.11.2
|
