DataDealTool
the package to deal data between csv and excel This package implements the conversion between CSV files and Excel files. dictorder provide ordered Dictionaries and return a Dictionaries too.
e.g1:
from DDT.CSV_EXCEL import DataToCsv
dtc = DataToCsv("test")
headers = ["姓名", "年龄", "爱好"]
data = [u"xiaoming", "12", "basketball"]
dtc.write("test.csv", data, headers=headers, mode="ab+")
dtc.write("test.csv", data, headers=headers)
dtc.nullline("test.csv", nulldata=[""])
dtc.write("test.csv", data, headers=headers)
e.g2:
from DDT.CSV_EXCEL import CsvToExcel
cte = CsvToExcel(dir_path="excel_test")
cte.convertToExcel("test", "test/test.csv", merge_cells=False, drop_colume=[u"爱好"])
e.g3:
from DDT.CSV_EXCEL import CsvMergeSheet
cms = CsvMergeSheet("csv_sheet")
cms.merge_sheet("test/test.csv", "1")
e.g4:
from DDT.CSV_EXCEL import ExcelToCsv
etc = ExcelToCsv("etc")
etc.convertToCsv("csv_sheet/test.xlsx", sheet_name="11", csvfile="test.csv")
e.g5:
from DDT.dictorder import sorted_dict
data = {"a":"11", "c":"123", "b": "321"}
new_data = sorted_dict(data)