pyexcel.writers module

pyexcel.writers

Uniform interface for writing different excel file formats

copyright:

3. 2014 by C. W.

license:

GPL v3

class pyexcel.writers.CSVWriter(file)

csv file writer

close()

This call close the file handle

write_row(array)

write a row into the file

class pyexcel.writers.ODSWriter(file)

open document spreadsheet writer

close()

This call writes file

write_row(array)

write a row into the file

class pyexcel.writers.Writer(file)

Uniform excel writer

It provides one interface for writing ods, csv, xls, xlsx and xlsm

close()

Close the writer

Please remember to call close function

write_array(table)

Write a table

table can be two dimensional array or a row iterator

write_dict(the_dict)

Write a whole dictionary

series and data will be write into one file

write_reader(reader)

Write a pyexcel reader

In this case, you may use FiterableReader or SeriesReader to do filtering first. Then pass it onto this function

write_row(array)

Write a row

write a row into the file in memory

class pyexcel.writers.XLSWriter(file)

xls, xlsx and xlsm writer

close()

This call actually save the file

write_row(array)

write a row into the file