DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

« previous next »
Pages: 1 [2] • bottom • last

Last post Author Topic: DONE: HTML Mail Merge  (Read 69,318 times)

Ath

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,649
    • Participated in NANY Challenge Eleven Times
    • Coding Snacks
    • Linux User
    • Hardware Hacker
Re: DONE: HTML Mail Merge
« Reply #25 on: July 25, 2011, 09:56 PM »
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.
/Ton
Ath's software collection, Quote: "A problem well stated is a problem half-solved." (Charles Kettering)

bootz15

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 17
Re: DONE: HTML Mail Merge
« Reply #26 on: July 26, 2011, 01:18 PM »
Eureka! Great job! :Thmbsup:

bootz15

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 17
Re: DONE: HTML Mail Merge
« Reply #27 on: July 26, 2011, 01:19 PM »
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.  8)

Ath

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,649
    • Participated in NANY Challenge Eleven Times
    • Coding Snacks
    • Linux User
    • Hardware Hacker
Re: DONE: HTML Mail Merge
« Reply #28 on: July 26, 2011, 04:49 PM »
Quote from: bootz15 on July 26, 2011, 01:19 PM
cell formulas aren't calculated in the the html output (only the formula definition is displayed).
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 :o
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).
/Ton
Ath's software collection, Quote: "A problem well stated is a problem half-solved." (Charles Kettering)

Ath

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,649
    • Participated in NANY Challenge Eleven Times
    • Coding Snacks
    • Linux User
    • Hardware Hacker
RELEASE: HTML Mail Merge: Excel2Html v2.0.1.0
« Reply #29 on: July 26, 2011, 06:33 PM »
Now that I've solved the formula evaluation issue, as reported by bootz15 I can announce the update:


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 :o

Comments, requests, remarks, etc. are all welcome :-*
/Ton
Ath's software collection, Quote: "A problem well stated is a problem half-solved." (Charles Kettering)

bootz15

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 17
Re: DONE: HTML Mail Merge
« Reply #30 on: July 26, 2011, 08:24 PM »
I can confirm that basic formula calculation is now working! :Thmbsup:

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

Ath

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,649
    • Participated in NANY Challenge Eleven Times
    • Coding Snacks
    • Linux User
    • Hardware Hacker
RELEASE: HTML Mail Merge: Excel2Html v2.0.1.1
« Reply #31 on: July 27, 2011, 09:15 AM »
Quote from: bootz15 on July 26, 2011, 08:24 PM
+10MB is chump-change these days
It's a bit annoying to me that to deliver a < 19 kB application .jar file, a download of 15+ MB is needed :tellme:

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


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

Comments, requests, remarks, etc. are all welcome :-*
/Ton
Ath's software collection, Quote: "A problem well stated is a problem half-solved." (Charles Kettering)
« Last Edit: July 27, 2011, 09:19 AM by Ath »

Ath

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,649
    • Participated in NANY Challenge Eleven Times
    • Coding Snacks
    • Linux User
    • Hardware Hacker
RELEASE: HTML Mail Merge: Excel2Html v2.0.1.2
« Reply #32 on: July 27, 2011, 03:19 PM »
I added a Linux .sh script after some testing on Ubuntu linux, so here it is, a new release:


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

Comments, requests, remarks, etc. are all welcome :-*
/Ton
Ath's software collection, Quote: "A problem well stated is a problem half-solved." (Charles Kettering)

DeVamp

  • Let the coding begin :-)
  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 127
    • Furry Fandom Badge - Furry Fandom
Re: DONE: HTML Mail Merge
« Reply #33 on: March 02, 2012, 12:48 PM »
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

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,649
    • Participated in NANY Challenge Eleven Times
    • Coding Snacks
    • Linux User
    • Hardware Hacker
Re: DONE: HTML Mail Merge
« Reply #34 on: March 02, 2012, 10:08 PM »
Quote from: DeVamp on March 02, 2012, 12:48 PM
How to use <!-- EXCEL2HTML - COLUMN1 --> in single file mode.

When I place that in my template, I only get 1 line as result.
Added 2 new tags for looping over the selected rows producing repeatedly the same template-section with different data. Example (xml) included.


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 :-*
/Ton
Ath's software collection, Quote: "A problem well stated is a problem half-solved." (Charles Kettering)

DeVamp

  • Let the coding begin :-)
  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 127
    • Furry Fandom Badge - Furry Fandom
Re: DONE: HTML Mail Merge
« Reply #35 on: March 03, 2012, 08:14 AM »
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

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 593
Re: DONE: HTML Mail Merge
« Reply #36 on: March 15, 2012, 01:10 PM »
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

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,649
    • Participated in NANY Challenge Eleven Times
    • Coding Snacks
    • Linux User
    • Hardware Hacker
Re: DONE: HTML Mail Merge
« Reply #37 on: March 15, 2012, 02:31 PM »
Thanks for these interesting links and site!

But those articles weren't written when I wrote Excel2Html :D, and they require Excel to be used, so it won't run unattended on a server or on Linux, if that is a requirement.
/Ton
Ath's software collection, Quote: "A problem well stated is a problem half-solved." (Charles Kettering)
« previous next »
Pages: 1 [2] • top

Original address: https://www.donationcoder.com/forum/index.php?topic=25114.0