writer Package

writer Package

class txt2xls.writer.Writer(conf)

Bases: object

write(collection, filename=None, fail_silently=False)

utils Module

txt2xls.writer.utils.ensure_iterable(axis)

Ensure the axis is iterable (XY array)

>>> axis1 = [
...     [0, 1, 2],
...     [3, 4, 5],
...     [6, 7, 8],
... ]
>>> assert axis1 == ensure_iterable(axis1)
>>> axis21 = [0, 1, 2]
>>> axis22 = [[0], [1], [2]]
>>> assert axis22 == ensure_iterable(axis21)

txt2xls.writer.utils.get_sheet_name(filename)

Return extension and parent directory stripped filename which is used as a sheet name

Parameters:filename (string) – A file path Returns:A extension and parent directory stripped filename Return type:filename

Examples

>>> get_sheet_name('./foo/bar/hogehoge.piyo')
'hogehoge'
>>> len(get_sheet_name("*"*100))
31

txt2xls.writer.utils.prefer_alphabet(i)

Convert an integer to an alphabet if it is within 0 to 51.

>>> prefer_alphabet(0)
'A'
>>> prefer_alphabet(25)
'Z'
>>> prefer_alphabet(26)
'a'
>>> prefer_alphabet(51)
'z'
>>> prefer_alphabet(100)
'100'