Python ExcelXlsxTableWriter.headers示例

示例#1

文件： excel_table_multi.py 项目： thombashi/pytablewriter

def main():
    writer = ExcelXlsxTableWriter()
    filepath = "multi_sheet_example.xlsx"

    # write the first worksheet
    writer.table_name = "example"
    writer.headers = ["int", "float", "str", "bool", "mix", "time"]
    writer.value_matrix = [
        [0, 0.1, "hoge", True, 0, "2017-01-01 03:04:05+0900"],
        [2, "-2.23", "foo", False, None, "2017-12-23 12:34:51+0900"],
        [3, 0, "bar", "true", "inf", "2017-03-03 22:44:55+0900"],
        [-10, -9.9, "", "FALSE", "nan", "2017-01-01 00:00:00+0900"],
    ]
    writer.dump(filepath, close_after_write=False)

    # write the second worksheet
    writer.table_name = "Timezone"
    writer.headers = [
        "zone_id",
        "abbreviation",
        "time_start",
        "gmt_offset",
        "dst",
    ]
    writer.value_matrix = [
        ["1", "CEST", "1017536400", "7200", "1"],
        ["1", "CEST", "1048986000", "7200", "1"],
        ["1", "CEST", "1080435600", "7200", "1"],
        ["1", "CEST", "1111885200", "7200", "1"],
        ["1", "CEST", "1143334800", "7200", "1"],
    ]
    writer.dump(filepath)

示例#2

文件： excel_table_single.py 项目： thombashi/pytablewriter

def main():
    writer = ExcelXlsxTableWriter()

    writer.table_name = "example"
    writer.headers = ["int", "float", "str", "bool", "mix", "time"]
    writer.value_matrix = [
        [0, 0.1, "hoge", True, 0, "2017-01-01 03:04:05+0900"],
        [2, "-2.23", "foo", False, None, "2017-12-23 12:34:51+0900"],
        [3, 0, "bar", "true", "inf", "2017-03-03 22:44:55+0900"],
        [-10, -9.9, "", "FALSE", "nan", "2017-01-01 00:00:00+0900"],
    ]
    writer.dump("sample.xlsx")

示例#3

#!/usr/bin/env python
# encoding: utf-8
"""
.. codeauthor:: Tsuyoshi Hombashi <*****@*****.**>
"""

from pytablewriter import ExcelXlsxTableWriter

writer = ExcelXlsxTableWriter()
filepath = "multi_sheet_example.xlsx"

# write the first worksheet
writer.table_name = "example"
writer.headers = ["int", "float", "str", "bool", "mix", "time"]
writer.value_matrix = [
    [0, 0.1, "hoge", True, 0, "2017-01-01 03:04:05+0900"],
    [2, "-2.23", "foo", False, None, "2017-12-23 12:34:51+0900"],
    [3, 0, "bar", "true", "inf", "2017-03-03 22:44:55+0900"],
    [-10, -9.9, "", "FALSE", "nan", "2017-01-01 00:00:00+0900"],
]
writer.dump(filepath, close_after_write=False)

# write the second worksheet
writer.table_name = "Timezone"
writer.headers = [
    "zone_id",
    "abbreviation",
    "time_start",
    "gmt_offset",
    "dst",
]

示例#4

文件： excel_table_single.py 项目： thombashi/pytablewriter

#!/usr/bin/env python
# encoding: utf-8

"""
.. codeauthor:: Tsuyoshi Hombashi <*****@*****.**>
"""

from pytablewriter import ExcelXlsxTableWriter


writer = ExcelXlsxTableWriter()

writer.table_name = "example"
writer.headers = ["int", "float", "str", "bool", "mix", "time"]
writer.value_matrix = [
    [0,   0.1,      "hoge", True,   0,      "2017-01-01 03:04:05+0900"],
    [2,   "-2.23",  "foo",  False,  None,   "2017-12-23 12:34:51+0900"],
    [3,   0,        "bar",  "true",  "inf", "2017-03-03 22:44:55+0900"],
    [-10, -9.9,     "",     "FALSE", "nan", "2017-01-01 00:00:00+0900"],
]
writer.dump("sample.xlsx")

示例#5

文件： excel_table_multi.py 项目： thombashi/pytablewriter

#!/usr/bin/env python
# encoding: utf-8

"""
.. codeauthor:: Tsuyoshi Hombashi <*****@*****.**>
"""

from pytablewriter import ExcelXlsxTableWriter


writer = ExcelXlsxTableWriter()
filepath = "multi_sheet_example.xlsx"

# write the first worksheet
writer.table_name = "example"
writer.headers = ["int", "float", "str", "bool", "mix", "time"]
writer.value_matrix = [
    [0,   0.1,      "hoge", True,   0,      "2017-01-01 03:04:05+0900"],
    [2,   "-2.23",  "foo",  False,  None,   "2017-12-23 12:34:51+0900"],
    [3,   0,        "bar",  "true",  "inf", "2017-03-03 22:44:55+0900"],
    [-10, -9.9,     "",     "FALSE", "nan", "2017-01-01 00:00:00+0900"],
]
writer.dump(filepath, close_after_write=False)

# write the second worksheet
writer.table_name = "Timezone"
writer.headers = [
    "zone_id", "abbreviation", "time_start", "gmt_offset", "dst",
]
writer.value_matrix = [
    ["1", "CEST", "1017536400", "7200", "1"],

示例#6

def args_to_excel(model, header, value_matrix):
    writer = ExcelXlsxTableWriter()
    writer.table_name = model
    writer.headers = header
    writer.value_matrix = value_matrix
    writer.dump("results.xlsx")

示例#7

#!/usr/bin/env python
# encoding: utf-8
"""
.. codeauthor:: Tsuyoshi Hombashi <*****@*****.**>
"""

from pytablewriter import ExcelXlsxTableWriter

writer = ExcelXlsxTableWriter()

writer.table_name = "example"
writer.headers = ["int", "float", "str", "bool", "mix", "time"]
writer.value_matrix = [
    [0, 0.1, "hoge", True, 0, "2017-01-01 03:04:05+0900"],
    [2, "-2.23", "foo", False, None, "2017-12-23 12:34:51+0900"],
    [3, 0, "bar", "true", "inf", "2017-03-03 22:44:55+0900"],
    [-10, -9.9, "", "FALSE", "nan", "2017-01-01 00:00:00+0900"],
]
writer.dump("sample.xlsx")