Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Embedding excel sheet in html

Apr 19, 2007 7:20AM PDT

I have a loan calculator on an excel sheet that I would like to be displayed in a web page on my site. Is that possible?

Thanks,

Awais

Discussion is locked

- Collapse -
Or in JAVA?
Apr 19, 2007 10:27AM PDT
- Collapse -
Have you tried...
Apr 19, 2007 11:50PM PDT

...puting a link to the Excel file on your web page...Viewers would need to have Excel or the "Open Office" equivalent to view and work on the "loan calculator" : (<a href=.....> tag)

- Collapse -
Yes
Apr 20, 2007 2:32AM PDT

Thats how it is right now but some users do not have excel and I personally want it to be shown as an html page not as a sheet.

Thanks for your help in advance.

- Collapse -
Can't be done.
Apr 20, 2007 3:28AM PDT

Excel isn't html, so can't be shown as such and work as a calculator. Like Bob said already.
Definitely the wrong tool for what you want.

Kees

- Collapse -
thanks but...
Apr 20, 2007 4:12AM PDT
- Collapse -
Re: excel to html
Apr 20, 2007 4:24AM PDT

This link shows a way to save an Excel-worksheet as html in Excel 97.
The way to do it in Excel 2000 is File>Save as webpage. I don't know about higher versions. But I do know it's not what you want.

Kees

- Collapse -
silly question
Apr 20, 2007 4:36AM PDT

when i save it as a web page should its ext not be changed? It opens the same way as before too.

- Collapse -
Re: save as html
Apr 20, 2007 5:02AM PDT

The default extension for Save as Webpage in Excel 2000 is htm. And if I don't change that, Windows Explorer shows it to be htm also, so there's nothing wrong with me here.
Did you check the extension? Can you open it in IE? How does it look there? Does it work? Then you've got your answer.

Kees

- Collapse -
Saving as html
Apr 20, 2007 8:14PM PDT

The problem as I see it is that saving a spreadsheet as html only saves the values of the cells into web page format.

When you look at the sheet in a web browser, you can't use it like an Excel spreadsheet. You can't add/amend formulas or add/amend values in cells for the formulas to work out and display results. So a calculator spreadsheet will not be a calculator web page, it will just be a web page that shows cells with values in them. Any form buttons with macros or VBA module code assigned to them will not work, because the VBA code does not get converted to html when the spreadsheet is.

To make sure I am right I have just tested it. I have a workbook full of formulas and vba code which I re-saved as a web page. Using IE7, (Internet Explorer would have been more likely to work as it is part of the Microsoft family), I opened the workbook htm file.

All I got was a web page displaying my spreadsheet values. The sheet tabs were there and I could navigate to other sheets, but none of the cells were active, and so I couldn't change anything. None of my macros worked.

So it seems to me you are going to have to use another method, eg Java or one of the more sophisticated web page design methods.

Mark