Add styling support for Excel (binary) format

[jimkohl]

I really like the patterns setup here. Looks like the various styling options for tables are not supported for Excel. The default font is WAY too small and I want also to BOLD headers.
I tried using the patterns laid out (and it is even stated they aren't supported).
Is there a plan for adding this?

Any suggestions as to how I can force this to a bigger font?
I'll dig into the code more but I think this would be a huge value.
Thanks
jim

[jimkohl]

Also have tried using panda but that's not working either :(.

[jimkohl]

I just decided to mess w the objects hanging off of pytablewriter instead to get rid of the difficult to read choice of font / size:
self.writer.open(file_path)
self.writer = self.tableWriterClass()
self.writer.MAX_CELL_WIDTH = 15
self.format_table['header']['font_name'] = "Arial"
self.format_table['header']['font_size'] = 14
self.default_format['font_size'] = 14
self.default_format['font_name'] = "Arial"

I'm sure there's more brute force stuff to discover ahead, but it would really be good if the various cell styling things followed patterns of Markdown, etc. such as column centering.

[thombashi]

Thank you for your feedback.

Unfortunately, Excel writer classes have not supported style settings for now.
However I have plan to support that feature.

[jimkohl]

If there is anything I can do to help would love to make this a reality!

…

Sent from my iPhone

On Jan 1, 2020, at 1:07 AM, Tsuyoshi Hombashi ***@***.***> wrote:  Unfortunately, Excel writer classes have not supported style settings for now. However I have plan to support that feature. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.

[stezz]

Lovely project @thombashi ! I have the same issue as @jimkohl and ended up solving it the same way. However I believe that a quick and dirty fix would be just to set
Default.FONT_NAME = 'Arial'
Then the style would be just fine and the whole need would disappear. Frankly I believe that 'MS Gothic' is not the best default font for an Excel ;)
Thanks again for your efforts and giving us this great lib!