Excel to HTML?

Doosht · 7 May 2007 at 18:36

Is there an easy way of converting a spreadsheet ive done in excel 2007 to html format please so i can use replicate it as a webpage?

Doosht

Jaffa_Cake · 7 May 2007 at 18:50

Should do the trick

Doosht · 7 May 2007 at 18:59

Thanks again Jaffa

Doosht · 7 May 2007 at 22:16

ok, when i save as "webpage" it comes up fine locally on my machine through internet explorer but doesnt seem to want to display on my webspace.

Any ideas guys and gals?

meghatronic · 7 May 2007 at 22:44

Try either single file webpage or the filtered option.

To be honest, you want to pdf it mate.

Jaffa_Cake · 7 May 2007 at 22:45

To be honost, if you look at the source it outputs its NASTY!

Thats microsoft for you.

Doosht · 7 May 2007 at 22:48

jdickerson said:
Try either single file webpage or the filtered option.

To be honest, you want to pdf it mate.

Trouble with pdf though is that if ive got an image in excel which when pressed gives my email address then this wont do the same if its pdf...i think?

Jaffa_Cake · 7 May 2007 at 22:53

Have a look at this: http://www.flash-utility.com/convert-excel-to-html.html

I've never seen it before but it looks promising.

meghatronic · 7 May 2007 at 22:53

Doosht said:
Trouble with pdf though is that if ive got an image in excel which when pressed gives my email address then this wont do the same if its pdf...i think?

Course it will.

Make sure it's a mailto: href and use this

(FYI XPS is supposed to be a new up and coming format... I don't think it will be [open an xps file in winrar] but it looks cool)

Doosht · 7 May 2007 at 23:44

ok, im getting somewhere now ta. Now next problem is

. . .
The document i want to display is longer than A4 size, it appears that pdf and xps want to display 1 page of a4 then break and then the next page. Is there a way of stiching the pages together so its continuous is there a setting to make it about 2 pages of a4 long?

Sorry for being such a newb

Jaffa_Cake · 7 May 2007 at 23:58

Page Layout -> Size -> A4

You can also change orientation to make it landscape

meghatronic · 8 May 2007 at 00:05

Doosht said:
ok, im getting somewhere now ta. Now next problem is . . .
The document i want to display is longer than A4 size, it appears that pdf and xps want to display 1 page of a4 then break and then the next page. Is there a way of stiching the pages together so its continuous is there a setting to make it about 2 pages of a4 long?

Sorry for being such a newb

Change the page size literally to be a bigger value.

Doosht · 8 May 2007 at 09:11

largest size in excel 2007 seems to be oficio which is just a little bit longer really. Is it possible to make a custom size?

The very last thing from you wonderful people to help me is how do i get the pdf page to just display in the web browser and not come up in acrobat or in my case foxit pdf reader?

Muchos thanks in advance

Doosht