DONE: HTML Mail Merge

[Ath]

I fixed the download links in the release message, thanks for reporting that. As a workaround you could have gone to the DCMembers page, and grabbed the download from there.

[bootz15]

Eureka! Great job!

[bootz15]

I just noticed that cell formulas aren't calculated in the the html output (only the formula definition is displayed). Not sure if it's possible to do this, but it would be a cool feature. 

[Ath]

cell formulas aren't calculated in the the html output (only the formula definition is displayed).

-bootz15 (July 26, 2011, 08:19 AM)

It is supposed to display the result of the calculation, not the formula, with some exceptions (imposed by the POI project...) : It can not process custom/user formulas, as it doesn't know how to handle the VBA involved. And it won't until someone implements a VBA interpreter in Java
There are more restrictions on formula's as described in this Apache POI page
I tested with quite simple '=J2+J3' etc. formula's (that didn't get into the demo data, but will be in the next update) and that works just fine.

Can you give an example of a formula (and an expected result, if possible) that doesn't compute?

I did some investigation, and it seems I need to re-evaluate all formulas when reading them. That requires another library jar (ooxml-schemas instead of the much smaller poi-ooxml-schemas) so the download will increase quite a bit. I'll release v2.0.1.0 shortly after this message (v2.0.0.1 is already available with just minor changes, but I didn't have time to write the announcement).

[Ath]

Now that I've solved the formula evaluation issue, as reported by bootz15 I can announce the update:

Excel2Html v2.0.1.0

The what's new is added to the original release thread.

A full re-download is required as I had to replace one of the .jar libraries with a more extensive version ('ooxml-schemas' replacing 'poi-ooxml-schemas') but that's also ~10 MB larger

Comments, requests, remarks, etc. are all welcome

[bootz15]

I can confirm that basic formula calculation is now working!

(Don't worry -- +10MB is chump-change these days )

[Ath]

+10MB is chump-change these days

-bootz15 (July 26, 2011, 03:24 PM)

It's a bit annoying to me that to deliver a < 19 kB application .jar file, a download of 15+ MB is needed

I added 2 new command-line parameters to Excel2Html, so here it is, a new release:

Excel2Html v2.0.1.1

The what's new is added to the original release thread.

Comments, requests, remarks, etc. are all welcome

[Ath]

I added a Linux .sh script after some testing on Ubuntu linux, so here it is, a new release:

Excel2Html v2.0.1.2

The what's new is added to the original release thread.

Comments, requests, remarks, etc. are all welcome

[DeVamp]

Hi,

I've played a bit with your program and have the following question:

How to use <!-- EXCEL2HTML - COLUMN1 --> in single file mode.

When I place that in my template, I only get 1 line as result.

[Ath]

How to use <!-- EXCEL2HTML - COLUMN1 --> in single file mode.

When I place that in my template, I only get 1 line as result.

-DeVamp (March 02, 2012, 06:48 AM)

Added 2 new tags for looping over the selected rows producing repeatedly the same template-section with different data. Example (xml) included.

Excel2Html v2.1.0.0

The what's new is added to the original release thread.

I'm now officially planning some kind of filtering support.

Comments, requests, remarks, etc. are all welcome

[DeVamp]

Great.
This update will save me a lot of copy/paste. :-)

Thats why I like this site so much.
Developers who listen to their audience.

Thank you very much.

[kfitting]

Just noticed this thread... dont know how useful the information will be, but here are some articles about html output from excel.  Very related to formatting, but still might be interesting.

http://www.dailydoseofexcel.com/archives/2012/02/08/turning-an-excel-table-into-css/
http://www.dailydoseofexcel.com/archives/2012/02/15/making-a-wiki-table/

[Ath]

Thanks for these interesting links and site!

But those articles weren't written when I wrote Excel2Html , and they require Excel to be used, so it won't run unattended on a server or on Linux, if that is a requirement.