This page is presented by www.haserodt.de  Impressum Download Register - Buy now   Help
Excel Jeanie Html Help
How to
Activating till E 2003
Activating E 2007

The buttons
Left side
HP + Extras
comments
FTP
Mini Html Editor
VBA
Actual Version: 4.2.0

How to ...

A fast intro for using Excel Jeanie Html with the Forum Standard button.
For using in Forums / Messageboards

For general understanding:
To desplay your table nicely in a forum / messageboard, it has to be translated into a language the board will understand.
This is html - and the board must support html - which good boards will do.
Excel Jeanie Html will do that for you and with to clicks you have the html in the clipboard, ready to paste it anywhere you like.

Create something like this in Excel:

 ABC
1123
24Super6


Now select the range A1:C2

Choose EJH4e -> Excel Jeanie Html or the icon from the iconbar.:



A dialog opens and on it's left side you see your selected range and the button:



Depending on the options - here it's the default- you will get a message that the html-code is copied to the clipboard and a preview will appear.

After the click on the button Forum Standard the hml-code is in the clipboard!
Now you just go to the forum/messageboard and paste it to your message (With CTRL+V or with the context menue)

Thats it!

For information about displaying formulas etc... see: Formulas
Here again the example a little bit more detailled:

Create something like this in Excel:
Sheet1
 ABC
1123
24Super6

Select range A1:C2
Choose EJH4e -> Excel Jeanie Html or the icon from the iconbar.
In Excel Jeanie Html it should look like this:
Now click button:
The dialog disappears and after a short moment  - and perhaps an other message box - the following message appears:
Copied to clipboard
Click OK and a preview will appear
The created html-code is in the clipboard!
Excel Jeanie Html has transferred your selection to html-code and put it into the clipboard.
It will stay in the clipboard, until you copy something else.
Now go to your application, where you want to have your html code.
Let's say, you want to have it in a forum.
You can go for a test to my german testforum:
http://www.jeanie-programme.de/forum/forum_nav.php?f=1
Click to Neues Thema (New entry) and this window shows up:
Geman-English:Betreff - topic, Vorschau-preview, Senden - send, Abbrechen-escape
Now you can first write a text or/and paste from the clipboard the created html-code.
Use CTRL+V or the context menu.
Something like that will be inserted:
<div>Tabelle1</br><table border=1 cellspacing=0 cellpadding=0 style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt;  padding-right:2pt; "> <colgroup><col width=30 style="font-weight:bold; "><col width=79.999998 ><col width=79.999998 ><col width=79.999998 ></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td>&nbsp;</td><td>A</td><td>B</td><td>C</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">2</td><td style="text-align:right; ">3</td></tr><tr height=17 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">4</td><td style="font-weight:bold; ">Super</td><td style="background-color:#ccffcc; text-align:right; ">6</td></tr></table> <br>
</div>
That looks strange, but's ok. It's the produced html-code to show your table.
You can add text below or above, but don't change the code itself (if you don't know about how html works)

Now just click Vorschau (preview) and have a look.
If you are satisfied, you can click Senden (send).
Now just experiment yourself a little bit.

Top   Home