Re: Data-Bars in POI

On Tue, Jul 9, 2019 at 10:09 AM Robert Jacobs <robertjacobsit@xxxxxxxxx> wrote:

I have been hunting around for a way to implement data-bars in an Excel
file using POI. We are currently using Scott's HSSF utility, but the
getDataBarFormatting, and other required methods, are not defined.

How invested are you in HSSF already?

If the answer is "not much" then I highly recommend going some other
route. The least radical step would be to just use POI directly from
Java. If you don't already know Java, then I would recommend switching
to any of the newer open-source options available for PASE (Node.js,
Python, .NET, PHP, or Ruby).

All of those have very good and very easy-to-use libraries for working
with Excel files. I am only personally familiar with Python; I can't
vouch for the data bar support in the others, though I would imagine
that they all have something that can handle it.

Please understand I am not trying to talk you (or anyone) into
abandoning HSSF. The "if" statements I used above were purposeful and
should not be taken as lip service.

John Y.