Book: Sheet operations¶
Merge excel books¶
Suppose you have two excel books and each had three sheets. You can merge them and get a new book:
>>> import pyexcel
You also can merge indivdual sheets:
>>> book1 = pyexcel.get_book(file_name="book1.xls")
>>> book2 = pyexcel.get_book(file_name="book2.xlsx")
>>> merged_book = book1 + book2
>>> merged_book = book1["Sheet 1"] + book2["Sheet 2"]
>>> merged_book = book1["Sheet 1"] + book2
>>> merged_book = book1 + book2["Sheet 2"]
Manipulate individual sheets¶
merge sheets into a single sheet¶
Suppose you want to merge many csv files row by row into a new sheet.
>>> import pyexcel as pe
>>> import glob
>>> merged = pyexcel.Sheet()
>>> for file in glob.glob("*.csv"):
... merged.row += pe.get_sheet(file_name=file)
>>> writer = pe.Writer("merged.csv")
>>> writer.write_reader(merged)
>>> writer.close()