Utility for read/write of Excel or csv files
Project description
-- Prerequisite modules -pandas@0.25.3 -openpyxl3.0.1 -xlrd@1.2.0
-- Install xlsfile pip install xlsfile --user
-- How to use xlsfile?
from xlsfile import xlsfile
Csv file testing
print("Test csv file") contents = xlsfile.readcsv("test2.csv") xlsfile.writecsv("test3.csv", contents)
input = {} input["name"] = ["Test1", "Test2", "Test3"] input["email"] = ["test1@gmail.com", "test2@yahoo.com", "test3@gmail.com"] input["name"].append("Test4") input["email"].append("test@yahoo.com")
filename = "testfamily.xlsx"
Excel file test
print("\nExcel file test") xlsfile.write(filename, input) contents = xlsfile.read(filename) print(contents)
Excel to csv
print("\nExcel to csv") xlsfile.xls2csv(filename, filename.replace(".xlsx", ".csv"))
csv to Excel
print("\ncsv to Excel") xlsfile.csv2xls(filename.replace(".xlsx", ".csv"), "testfamily2.xlsx") contents = xlsfile.read("testfamily2.xlsx") print(contents)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for xlsfile_shaw1236-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 589544c6d754ea2f1ad57822a08f375f9c6d23e388842db2926594dcc0fcbd37 |
|
MD5 | 2cd3d8c36bae3d6df4a5d229d5c58fc6 |
|
BLAKE2b-256 | 19a0de94a9276d029ea682edf1605b1b3a4c78fe575fc2f2f197bb37c95bea54 |