Pretty formatting of output .xls file

[epogrebnyak]

Input:

• _kep.xls, to be generated by pandas
• _kep-format.xls - containing sample of formatting

Output:

• kep.xls that has data from '_kep.xls' and formats from '_kep-format.xls'

Interface function:

reformat_xls(datasource_file = '_kep.xls', format_file = '_kep-format.xls', 
                                                           output_file = 'kep.xls') 

Behaviour:

From first sheet of format file '_kep-format.xls' read format of first n (n=3) rows. Apply formatting to n rows in new file. Apply n-th row format to all other rows. Intent: apply formatting of headers to headers and formatting of rows to row.

Links:

• https://secure.simplistix.co.uk/svn/xlrd/trunk/xlrd/doc/xlrd.html?p=4966#formatting.Format-class
• https://github.com/python-excel/xlwt/blob/master/examples/num_formats.py

[epogrebnyak]

Less sophisticated approach, just change cell fornmatting in column A

[epogrebnyak]

TODO: may change formatting of the columns http://xlsxwriter.readthedocs.org/en/latest/example_pandas_column_formats.html#ex-pandas-column-formats http://stackoverflow.com/questions/17069694/writing-xlwt-dates-with-excel-date-format http://stackoverflow.com/questions/9920935/easily-write-formatted-excel-from-python-start-with-excel-formatted-use-it-in

do not write second row - inherited from pivot.

[epogrebnyak]

column in 'variables' sheet in kep.xls(x) need more width

[epogrebnyak]

See https://github.com/epogrebnyak/rosstat-806-regional/issues/21

[epogrebnyak]

Use code from here in here for better xls(x) file formatting.

Changes above work for just one file type (xls or xlsx) - do not remember, other one will be the same default styles.

[Fak3]

Task copied from commit comments:

• Font color must be black everywhere, comment out existing font colors and put black.

[epogrebnyak]

in kep.xlsx the first row has new formatting, but first column in formatted wrong:

[epogrebnyak]

@Fak3 - please move this work to a new branch, and revert commits related to this problem in master

[Fak3]

moved to pretty_xlsx branch

[Fak3]

in kep.xlsx the first row has new formatting, but first column in formatted wrong

First column on your screenshot is formatted exactly as written in the code. What is wrong?

            'bold': True,
            'font_name': 'Arial',
            'font_size': 10,
            'align': 'center',
            'border': 1

[epogrebnyak]

First column must be "YYYY-MM-DD", in date format