|
| |
|
|
_gail
Posts: 2878
From: So FL
Status: offline
 |
Inserting an Excel spreadsheet into a webpage - 4/30/2003 13:15:49
I know nothing, absolutely nothing, about spreadsheets.
What I do have to learn is how to insert one properly into a web page page so I can control the width of it when it is inserted into a table. I just can' t get the spreadsheet under control. I don' t even know enough about it to explain to the client, who will be sending me one a month, how to format it better if that' s the problem.
Part of the problem may be all those empty rows and columns to the right of the last column that contains data. I' ve tried deleting the empty columns but they don' t go away. I' ve tried Saving As in every format available and inserting it into the table; no go.
It' s worse when she gives me the data in a Word document.
Any suggestions?
thanks, gail
_____________________________
Digicamhelp - Easiest place on the web to learn about Digit@l Cameras & Photography
|
|
|
|
_gail
Posts: 2878
From: So FL
Status: offline
|
RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 15:19:46
quote:
Any reason why you can' t put it into a table?
As mentioned, that' s what I had been doing.
The excel doc gives me problems because of the extraneous, empty columns.
I took a look again at the Word doc and decided to check out the properties dialog box for tables, about which I at least know something.
I discovered that the speadsheet had a fixed Preferred Width so I unchecked it. It' s working fine now...
...except that some of the tables don' t show between data. Is there something I need to do to fix that?
I can' t put a link to it here because it' s in a pw protected area.
I' m trying to get the gal to get it to me in the proper format; only a handful of people look at the schedule every month and I ain' t spending an hour or more on this each time, particularly when I' d doing it as a freebie.
Still, I' d like to know how to get it right.
thanks bobby,
gail
< Message edited by _gail -- 4/30/2003 3:21 PM >
_____________________________
Digicamhelp - Easiest place on the web to learn about Digit@l Cameras & Photography
| |
|
|
|
Mike54
Posts: 4870
Joined: 3/26/2001
From: Way Up Over
Status: offline
|
RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 15:27:07
Hi _gail,
Have you tried saving the excel spreadsheet as a " webpage" as opposed to one of the other formats? I' ve only done it once for an intranet but the results seemed pretty good. The only drawback I saw was that it created a whole folder of stuff that had to go with it. (That' s with Office 2K Pro, I don' t remember if you could do that in ' 97)
_____________________________
Who was the first guy that looked at a cow and said, "I think that I'll drink whatever comes out of those things when I squeeze them"?
New photogalleries, stop by sometime.
Or you could just view the old stuff.
Old photogalleries
| |
|
|
|
abbeyvet
Posts: 5094
From: Kilkenny Ireland
Status: offline
|
RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 17:01:21
Is there no way they would accept you just uploading it and linking to it? It really would save an awful lot of hassle.
_____________________________
Katherine
:: InKK Design :: InKK Domains
| |
|
|
|
_gail
Posts: 2878
From: So FL
Status: offline
|
RE: Inserting an Excel spreadsheet into a webpage - 5/1/2003 9:06:35
quote:
best thing is there is no blank cells. I' m not sure why the document is not appearing in tables when you try saving as a web page. What happens exactly?
This is exactly the problem. The gal sends me a spreadsheet with a lot of blank cells/columns to the right of the last column holding data. What do I tell her about how to get rid of those extra, empty columns and cells? If they could be eliminated, the problem would be solved.
The tables and cells are appearing, it' s that after the spreadsheet is inserted into a web page, several of them no longer have shading or lines separating one from the other. No big deal, but it' s mystifying why some do and some don' t.
quote:
Sometimes people using Excel will format an entire row or column rather than just the cells in
You' re probably on to something here. I' ll ask if this is the case.
Much thanks, wattle, for all the info and suggestions.
gail
_____________________________
Digicamhelp - Easiest place on the web to learn about Digit@l Cameras & Photography
| |
|
|
|
cecilc
Posts: 139
From: Atlanta, Ga, USA
Status: offline
|
RE: Inserting an Excel spreadsheet into a webpage - 5/1/2003 11:25:41
I' m responsible for posting race results on our running website, and I always get the results in an Excel file. Here' s what I do with them:
Highllight everything from the Excel file and " copy" it.
Paste that into Notepad (that should remove all the table formatting from it). Then copy that.
Paste that non-formatted text into Frontpage.
Highlight everything you want placed into a table and pull down the Table menu and choose Convert>Text to table.
You may have to play around with the next dialog box, which asks how you want to separate the text. (With racing results, I usually check " other" and just enter a " space" ).
When you click " OK" , that information will now be in a table.
When that' s done, I just format the table to whatever specs I feel it needs to be and post it. It' s definitely a " back-door" approach to it, but it seems to work, and it cuts down (actually, it pretty much eliminates) the html-bloating that you get if you just import the Excel file itself.
_____________________________
Cecil
| |
|
|
|
ou812
Posts: 1742
Joined: 1/5/2002
From: San Diego
Status: offline
|
RE: Inserting an Excel spreadsheet into a webpage - 5/1/2003 12:56:21
Wow, that was pretty cool. I' ve not needed to do this, yet, but wanted to give it a try. So walked through your steps and it came out great. Thanks Cecil!
-brian
| |
|
|
|
cecilc
Posts: 139
From: Atlanta, Ga, USA
Status: offline
|
RE: Inserting an Excel spreadsheet into a webpage - 5/1/2003 18:39:51
I am happy to be of service....
And I' m also glad to know that other people can duplicate the process without blowing up their machine .....[:p]
_____________________________
Cecil
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
Of course there may be people who don' t have Excel...
