excelkit.core package

Submodules

excelkit.core.build module

build an excel file from data

class excelkit.core.build.ExcelBuilder

Bases: object

add_comment(coordinate, *args, **kwargs)

add_hyperlink(coordinate, hyperlink)

# method1: >>> value = ‘=HYPERLINK(“http://www.baidu.com”, “baidu”)’ >>> sheet.cell(row, colum, value=value)

# method2: >>> _ = sheet.cell(row, column, value=’baidu’) >>> _.hyperlink = ‘http://www.baidu.com’

# method3: >>> sheet[‘B3’].hyperlink = Hyperlink(ref=’‘, target=’http://www.baidu.com’, tooltip=’baidu’)

add_rows(rows, color_list=None, **style)

add_title(titles, **style)

auto_filter()

automatical filter for first row

create_sheet(title=None)

require: len(title) <= 31

freeze_panes(first_column=None, first_row=True, first_column_and_row=None, coordinate=None)

logger = <SimpleLogger ExcelBuilder (DEBUG)>

merge_cells(*args, **kwargs)

range_string=None start_row=None start_column=None end_row=None end_column=None

save(outfile)

set_dimensions_style(height=None, width=None, **style)

set_row_style(**style)

excelkit.core.concat module

concat multiple excel files to one

class excelkit.core.concat.ExcelConcat

Bases: object

concat(infiles, keep_fmt=False, keep_size=True, merge_cells=True, keep_other=True)

copy_format(origin_cell, target_cell)

copy style for each cell

copy_image(origin_sheet, target_sheet)

copy_other(origin_sheet, target_sheet)

copy_size(origin_sheet, target_sheet)

copy width for columns and height for rows

logger = <SimpleLogger ExcelConcat (DEBUG)>

merge_cells(origin_sheet, target_sheet)

copy merged cells

save(outfile)

excelkit.core.merge module

excelkit.core.parse module

parse excel file

class excelkit.core.parse.ExcelParser

Bases: object

choose_sheet(workbook)

export(data, outfile=None, fmt='table', indent=None, sep='\t', header=True, index=True, color=None, pager=False)

“export data

parameters

data: data return by get_data method outfile: output file, default stdout fmt: ‘table’, ‘html’, ‘tsv’ or ‘json’ indent: for json fmt export sep: for tsv fmt export

get_data(worksheets, skip=None, limit=None, fillna='')

logger = <SimpleLogger ExcelParser (DEBUG)>

parse(filename, data_only=False, read_only=False, sheet_idx=None, choose_one=False, skip=None, limit=None, **kwargs)

data_only=True: get the value instead of formula when data_type is ‘f’ read_only=True: to deal with large file, some attributes might lost

excelkit.core.parse.parse_text(file_hdl, sep='\t', comment=None)

Module contents