Author Topic: Posting Excel to Website Discussion (Read 94841 times)

Bundy · « 2008-Dec-11, 02:57 PM **Reply #1** »

Date Contestant $Return Points Return Daily Score $Return c/f Points Return c/f Total Score c/f

Bundy · « 2008-Dec-11, 03:00 PM **Reply #2** »

Magic..is it possible to copy and post from an Excel Worksheet with columns?....just tried it with the above post...columns mia.

MagiC~* · « 2008-Dec-11, 03:05 PM **Reply #3** »

I think Stormy found a program that converts the Excel into HTML that you can post on here, I will find out what the program is Bundy, unless of course Stormy is reading this and he may tll us

BT may know of a good program, will ask him

Bundy · « 2008-Dec-11, 03:18 PM **Reply #4** »

Cheers Digger!

gratlog · « 2008-Dec-11, 03:43 PM **Reply #5** »

Good on ya mate. Sounds good.

Stormy · « 2008-Dec-11, 05:59 PM **Reply #6** »

Quote from: Bundy on 2008-Dec-11, 03:18 PM

Cheers Digger!

G'day Bundy,
Is this what you are after ?

Cheers Stormy

MagiC~* · « 2008-Dec-11, 06:12 PM **Reply #7** »

Does excel have an Export to HTML function Bundy ??

Stormy · « 2008-Dec-11, 06:16 PM **Reply #8** »

If it is, converting to HTML will not display the grid.
The display that I posted is an jpg image, uploaded to photobucket
then post into the HTML tags that are supplied by RHT.

I am running a MAC so I use a program called GRAB which just grabs exactly what you want,
Example; open the program then select the section that you want to grab, or grab the whole window
save it as a JPG upload to photobucket then post it.
It seems alot to do, but real easy. It is the only way you will get the grid to display, HTML does not understand the grid lines
or columns.
If you do decide to go this way I suggest you just save the the same spreadsheet as you edit then overwrite your upload.

Cheers Stormy

Stormy · « 2008-Dec-11, 06:17 PM **Reply #9** »

Quote from: MagiC~* on 2008-Dec-11, 06:12 PM

Does excel have an Export to HTML function Bundy ??

Magic you can save an Excel spreadsheet as a HTML file, then copy and paste into your HTML converter
then paste in between the HTML tags

MagiC~* · « 2008-Dec-11, 06:19 PM **Reply #10** »

Thats what I was thinking Stormy, never really played with excel and spreadsheets, so wasn't sure if you could export to html.

I think that is what Bundy is looking to do

Stormy · « 2008-Dec-11, 06:34 PM **Reply #11** »

Quote from: MagiC~* on 2008-Dec-11, 06:19 PM

Thats what I was thinking Stormy, never really played with excel and spreadsheets, so wasn't sure if you could export to html.

I think that is what Bundy is looking to do

On the flip side of that, you can still format into columns just without gridlines.
When finished work is done in the spreadsheet do a Webpage preview then you can see if you columns do not run into each other,
if they do run, then go back to the spreadsheet adjust the columns wider then preview again, once satisfied, cut and paste into MAGIC converter then post in between the HTML tags in the forum. DONE DEAL will be formatted just without the grid.

MagiC~* · « 2008-Dec-11, 06:36 PM **Reply #12** »

to add grid lines Stormy all you have to do is add style="border:solid 1px #000;" to your table

Stormy · « 2008-Dec-11, 06:40 PM **Reply #13** »

Quote from: MagiC~* on 2008-Dec-11, 06:36 PM

to add grid lines Stormy all you have to do is add style="border:solid 1px #000;" to your table

Nice One, I like that keep that in mind. Is that all the code I need?

westie · « 2008-Dec-11, 06:45 PM **Reply #14** »


SYD - R1	XXXX	XXXX
AM	JUST	TESTING
AM	JUST	TESTING
AM	JUST	TESTING
AM	JUST	TESTING
AM	JUST	TESTING
AM	JUST	TESTING

MagiC~* · « 2008-Dec-11, 06:48 PM **Reply #15** »

How did you mange that Westie ?

Stormy · « 2008-Dec-11, 06:56 PM **Reply #16** »

Quote from: westie on 2008-Dec-11, 06:45 PM

SYD - R1

XXXX

XXXX

AM

JUST

TESTING

AM

JUST

TESTING

AM

JUST

TESTING

AM

JUST

TESTING

AM

JUST

TESTING

AM

JUST

TESTING

I like that

Stormy · « 2008-Dec-11, 06:57 PM **Reply #17** »

Westie whats he secret

westie · « 2008-Dec-11, 06:58 PM **Reply #18** »

I use 2007 excel (although any should work) copy and close down the file before before pasting so make sure it has already been saved, if a new file. The cheating part and this is where I will come unstuck after MSN closes down is to paste into MSN, click box at bottom 'use html to create your page' and click box at top right 'use plain text editor'. You taught me that little trick and I think you also found a program that would do the same thing after MSN closes remember we trialed it.

The trick is to close the excel document before pasting, think it was saintly who taught me that.

MagiC~* · « 2008-Dec-11, 07:00 PM **Reply #19** »

Does your excel export to xhtml Westie ?

Stormy · « 2008-Dec-11, 07:05 PM **Reply #20** »

Quote from: westie on 2008-Dec-11, 06:58 PM

I use 2007 excel (although any should work) copy and close down the file before before pasting so make sure it has already been saved, if a new file. The cheating part and this is where I will come unstuck after MSN closes down is to paste into MSN, click box at bottom 'use html to create your page' and click box at top right 'use plain text editor'. You taught me that little trick and I think you also found a program that would do the same thing after MSN closes remember we trialed it.

The trick is to close the excel document before pasting, think it was saintly who taught me that.

Do I paste the data into the converter.

westie · « 2008-Dec-11, 07:07 PM **Reply #21** »

which converter are you using stormy.

Stormy · « 2008-Dec-11, 07:08 PM **Reply #22** »

Racehorse Talk converter

westie · « 2008-Dec-11, 07:08 PM **Reply #23** »

Quote from: MagiC~* on 2008-Dec-11, 07:00 PM

Does your excel export to xhtml Westie ?

magic
I just highlight what I want to copy (click copy) close down file and paste to MSN.

Stormy · « 2008-Dec-11, 07:12 PM **Reply #24** »

Where in MSN do you do that, it's all new to me