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()