I am using CoffeeCup HTML Editor Version 2008 and Microsoft Excel 2007. I have a spreadsheet with data that I would like to add to my web site, so that viewers can see the information, but not be allowed to make any changes.

Is this possible?

Larry,

You don't need to request a separate email. I think you are automatically subscribed to any topic that you start. If not, look at the bottom of the messages, and you will find a button to subscribe to this topic.

Open your excel file. Click on the "Office Button" (top left). Place your cursor of the "Save As" icon and in the window that opens, select "Other Formats" at the bottom of the list. You should now have a standard "Save As" window open. At the bottom of the file listing, just below the file name box, you should see a box labeled "Save as type" and one of the options is "Web Page" which should be what you want.

You will get a warning window letting you know that you will loose several of the MS Excel features, but that is to be expected when you are saving to a web page.

I did this with a file named "budget" and a budget.htm file was created as well as a budget_files folder that contains the sheet1.htm through sheet#.htm files.

Understand that MS Office programs do not produce valid HTML code, and the files are bloated, but you will have a page that looks like an excel sheet including the tabs at the bottom.

Hope this is what you need.

Bill R.

Thank you for your prompt reply.

I followed the steps that ou outlines and I would like to ask a few additional questions:

What you suggested created several files -
Family_Tree.html
Then in a separate folder that was named Family_Tree.files:
filelist.xml with a size of 1 KB
sheet001.htm with a size of 15 KB
stylesheet.css with a size of 2 KB
tabstrip.htm with a size of 1 KB

My first question is - Which of these files should be uploaded to the server?

My second question is - What do I have to do in order to have the column and row grid lines show on the web page?

Thanks again

I would guess that you need to do a page setup, but other than that, I am not sure how to turn on the guide lines.

As for what to upload, that depends what you want to have on the web. If you want the entire spreadsheet, then be sure to upload the folder and all the files that are in the folder. The Family_Tree.html is the main file, but it needs the folder and files in it to display the various work sheets.

Based on the file name, I wonder if you are uploading a family tree? If so, you may want to check out Legacy, a program that will produce a family tree html page, and I suspect it will do a better job.

I thought it was a bit frustrating how many files Excel now uses to generate a web version of the spreadsheets. I had been playing with OpenOffice recently, which is an open source (free) alternative to Office. While I wouldn't recommend replacing MS Office if you already have it, it makes a much simpler/cleaner conversion of the Excel spreadsheets into .html files.
Larry, if you'd rather not go through the hassle of installing a suite for that sole purpose, I could try converting the file for you if you're comfortable in sharing the .xls. Just let me know.

The .htm file that is created will have a tag that starts with this:

or something similar, starting with the word "table". There will be part of that that says <table..... border="0" ..... If the border is =0, then there will be no border lines. Anywhere you have border=0, change the 0 to 1 or 2 and you will have lines. Office may have created leftborder, rightborder, topborder and such, and they would all need to be changed to ="1" for the lines to show up.

Thanks billr and Adam R.
Reading this post and your replies I learned a little bit. I used the Open Office Calc and made a realy fast html file, only to adapt to my needs.
Now I have a new tool fom my websites
Thanks a lot.
Ooops... Larry thanks also for your question.
Jimmy

You may want to click on profile and change your forum name to something other than your email address. Spammers are looking for valid email addresses.

What program are you using to write your web page?

Have you created the html code using Excel? If so, what version of Excel are you using? It may be that different versions of Excel will create different html code.

I am using VSD to create my page. I am using 2007 version of excel.

I didn't think excel could write html. All I need is to a give a link to the file so person can download my spreadsheet. I do have a couple of them.

Thank you for taking the time to help.

I do not use Excel, I use Open Office. But I'm sure Microsoft will "export" to a PDF file. You'll find it under the "Files / Export" menu.
If not a great little program, and it's free, PrimoPDF can be downloaded and used. You treat it like a printer. It will print, to file, anything you would normally print to paper. Turns the file into a PDF. I've never had it fail me.

Hope this helps