xlprocesstoolbox

Find a way to process excel esaily,base on openpyxl,xlrd,xlwt.support .xls.xlsx

Install

pip3 install xlprocess

Format change

Change into python list

• tolist.tolist(filename='', sheetnum=-1)

sheetnum=-1 meaning all sheets in file change to list.The data structure like this:

[[sheetname,[value in A1,value in A2,value in A3],[value in B1,value in B2,value in B3], ......value in N3],[sheetname2,[...]]

Change format to csv

• formatchange.tocsv(filename,sheetnum=-1)

• -1 mean include every sheet.

Change format to xlsx

• formatchange.toxlsx(filename,sheetnum=-1)

• -1 mean include every sheet.

Combine and split

Combination

• fileprocess.combination(xlsx=True,file1,file2,file3...)

If all file in same folder,you can use:

• fileprocess.fcombination(xlsx=Ture,dir='yourdir')

Default return a new file named 'comfile.xlsx',but when the character in cell is too long openpylx might throw IllegalCharacterError exception.In this condition,you can change xlsx parameter to False.But in this case,you should make sure every sheet's name is different.

Split accroding sheet's name

• fileprocess.filesplit(xlsx=True,'filename')

Content processing

Generate row title

• sheeetprocess.rowtltie(xlsx=True,'filename',sheetnum=-1,title=1)

Groupby

• sheetprocess.groupby(xlsx=True,filename,sheetnum=-1,*col)

• Last of *col meaning quantity.For example,groupby(True,'data/test1.xls',0,1,2,3),meaning accounting the third column

Classify by columns

• sheetprocess.classify(xlsx=True,'filename',*col)

License

The MIT License