Charts support in XlsxWriter

198 views
Skip to first unread message

John McNamara

unread,
Apr 16, 2013, 8:42:19 AM4/16/13
to python...@googlegroups.com
Hi,

Work has started on adding chart support to XlsxWriter and there is already some limited functionality.

If you would like to get early access and give some feedback you can subscribe to the following issue on Github:

    https://github.com/jmcnamara/XlsxWriter/issues/9

Currently only Bar charts are supported. Column, scatter, line and pie charts will follow quickly and chart formatting options will be added after that. There is a working example at the above link if you wish to try it.

Have a look at the Excel::Writer::XLSX::Chart docs for an idea of what features will be supported:

    http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX/lib/Excel/Writer/XLSX/Chart.pm

John

Ash Krishan

unread,
Apr 16, 2013, 9:12:52 AM4/16/13
to python...@googlegroups.com

Fantastic work John. Many thanks I soon going to implement your lib in my django project.

--
You received this message because you are subscribed to the Google Groups "python-excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to python-excel...@googlegroups.com.
To post to this group, send an email to python...@googlegroups.com.
Visit this group at http://groups.google.com/group/python-excel?hl=en-GB.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

John Yeung

unread,
Apr 16, 2013, 9:29:32 AM4/16/13
to python-excel
Tiny docbug: The features list (comparison with Excel::Writer::XLSX)
still lists sparklines as unimplemented, and the blurb at the top
mentions both sparklines and charts as remaining.

To me, this is of only slightly higher priority than spelling mistakes
in the prose. (Spelling mistakes in code examples would be higher.)
Let me take this opportunity to mention that not only does XlsxWriter
provide a lot of features in quite a programmer-friendly manner, it
also has nice docs.

John Y.

John McNamara

unread,
Apr 16, 2013, 10:38:51 AM4/16/13
to python...@googlegroups.com

On Tuesday, 16 April 2013 14:29:32 UTC+1, John Yeung wrote:
Tiny docbug: 

Hi John,

Thanks for that and your comments. I already have that sparkline fix on my internal TODO list for the next doc update. :-)

John

John McNamara

unread,
Apr 26, 2013, 9:25:22 PM4/26/13
to python...@googlegroups.com
Hi,

Chart support has been added in version 0.3.1 of XlsxWriter.

See the documentation links in the Changelog:


Enjoy.

John

John Yeung

unread,
Apr 27, 2013, 1:47:11 AM4/27/13
to python-excel
On Fri, Apr 26, 2013 at 9:25 PM, John McNamara <jmcn...@cpan.org> wrote:
> Chart support has been added in version 0.3.1 of XlsxWriter.

Of course, this is introduced the day that I decide to stop waiting
and just install 0.3.0. ;)

(Not that I have even exercised, or really know how to exercise yet,
the features beyond 0.2.6.)

But nice work! I'm sure it will be fun once I get around to it.

John Y.
Reply all
Reply to author
Forward
0 new messages