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.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 39cc40a11bc97e8d97e5bfe8fb4052991b4b5a2958cdb184aaa98bd241e0f348 |
|
MD5 | 88207eea5d7a49137752f5d36db21036 |
|
BLAKE2b-256 | 3ba9b09b45e917e1e29642dbeb702e022f411ec9e47aa1d4629effe0e33c05dd |