html table py,GitHub - martsberger/tablepyxl: A bridge between html tables and openpyxl

tablepyxl - A python library to convert html tables to Excel

Introduction

Tablepyxl is a bridge between html tables and openpyxl.

If you can make an html table, you can make an Excel workbook.

Usage

If your html table is in a string, you can write an Excel file with the document_to_xl function:

from tablepyxl import tablepyxl

table = "

" "

"

"

"

"

"

"

"

"

"

"

"

tablepyxl.document_to_xl(table, "/path/to/file")

If your html table is in a file, read it into a string first:

from tablepyxl import tablepyxl

doc = open("/file/with/html/table", "r")

table = doc.read()

tablepyxl.document_to_xl(table, "/path/to/output")

Convert your html to an openpyxl workbook object instead of a file so that you can do further work:

from tablepyxl import tablepyxl

doc = open("/file/with/html/table", "r")

table = doc.read()

wb = tablepyxl.document_to_wb(table)

# For example, you can add another document to the same workbook

# in a new sheet:

doc2 = open("/file/with/html/table2", "r")

table2 = doc2.read()

wb = tablepyxl.document_to_wb(table, wb=wb)

Notes:

A document with more than one table will write each table to a separate sheet

Sheet names match the name attribute of the table element

Multiple tables can be added to the same sheet using the insert_table method.

Styling and Formatting

Tablepyxl intends to support all of the style and formatting options supported by Openpyxl. Here are the

currently supported styles:

Font

bold via the font-weight style, e.g.

color via the color style, e.g.

Alignment

horizontal via the text-align style

vertical via the vertical-align style

wrap_text via the white-space style

Fill

Solid background color via the background-color style

Border

style and color for the top border via border-top-style and border-top-color styles

Cell types

Cell types can be set by adding any of the following classes to the td element:

TYPE_STRING

TYPE_FORMULA

TYPE_NUMERIC

TYPE_BOOL

TYPE_CURRENCY

TYPE_NULL

TYPE_INLINE

TYPE_ERROR

TYPE_FORMULA_CACHE_STRING

TYPE_INTEGER

Number formatting

Currency is formatted using FORMAT_CURRENCY_USD_SIMPLE

Dates are formatted using 'mm/dd/yyyy'

Numeric values are formatted with commas every 3 digits if the commas are present in the html

Merging

Cells can be merged using the colspan and rowspan attributes of td elements

License

Contributors