basic website question

Xalten

New Member
Joined
Oct 10, 2002
Messages
6
Hi, sorry for asking such a easy question, I tried to search for the answer on the boards but all I could find were a ton of questions alot more in depth than mine. Anyhow, I have a excel sheet and basically all I want to do is put it on a web page. I use the "Save as Web Page" but that dosnt keep my frozen cells i have. If I add interactivity it puts it in a small box and allows other people to edit it.. thats not what I want, I just want people to be able to view it and I want the frozen columns and rows to remain frozen. Can anyone help please? thanks.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Make a image of your screen by using the print screen key and pasting it in paint, you can now crop the image to suit. Save as jpg or gif.

On your webpage use the image tag as such:

<img src=myfile.jpg>

Hope this helps

Chris
 
Upvote 0
i cant do that.. thats basically what the Save as Web Page does.. it is to big to do that and they have to scroll over.. when they scroll over i want their names to stay in one place so its easier to determine what line they are on I can post the basic web page sheet if you want to see what i mean?
 
Upvote 0
Actually, what Chris proposed was simply making a picture of your screen. Nothing like what "save as web page" does. As it is just a picture, nothing would move.
 
Upvote 0
yea i understand that, but the reason i cant is because it is to big to fit on one page hence i have a frozen A column so when you scroll over you can still keep in line the peoples names with the information in the rest of the excel sheet.
 
Upvote 0
Well, how many columns do you have? If it's not too big, maybe if you set the zoom so that all of the columns show but are still legible and then do the print screen?

Just a thought
shrug.gif
 
Upvote 0
It will wind up having multiple columns for each day of the month, I have already determined that it will not be possible to take still shots. Does anyone know how to put it on a web page and maintain the Freeze Pains? there must be a way somehow
 
Upvote 0
There is another way round this, you could add an excel object and load your sheet into it. This would mean your host would need to support ASP and there would be some tricky programming behind it.

OR

I don't know if you could take a large image of the screen data and a small image of the names, put them together into two HTML frames and let these handle the scrolling - very messy.

The first method is the best but it's very complex I think, take a look at some ASP sites (www.asp101.co or http://www.aspin.com)

Chris
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top