Inserting an Excel spreadsheet into a webpage

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Inserting an Excel spreadsheet into a webpage

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> General Web Development >> Inserting an Excel spreadsheet into a webpage

Page: [1]


_gail Posts: 2876 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


bobby Posts: 11399 Joined: 8/15/1969 From: Seattle WA USA Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 14:03:32 Any reason why you can' t put it into a table? You can paste an .xls file into a page, but it carries with it the same bloated code that comes with other MS Office files... An html table will give you the size control, and not overload your page with XML translators and MS cheeze whiz _____________________________ In order to remove a wall you must first remove the Windows® (in reply to _gail)


_gail Posts: 2876 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 (in reply to bobby)


Mike54 Posts: 4796 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. (in reply to _gail)


bobby Posts: 11399 Joined: 8/15/1969 From: Seattle WA USA Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 16:05:41 Oops, sorry _gail, guess I better start reading closer [:p] quote: ...except that some of the tables don' t show between data. Is there something I need to do to fix that? Do you mean table cells aren' t showing up? Try putting <p>& nbsp ;</p> into the empty cells... or a clear 1x1 GIF does that help? < Message edited by bobby -- 4/30/2003 1:06 PM > _____________________________ In order to remove a wall you must first remove the Windows® (in reply to _gail)


_gail Posts: 2876 From: So FL Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 16:16:39 Mike, I tried every format available to me. quote: Try putting <p>& nbsp ;</p> into the empty cells... or a clear 1x1 GIF In ALL of them?! No way![:' (] I think if the empty columns were removed it would be okay. Can they be removed? gail _____________________________ Digicamhelp - Easiest place on the web to learn about Digit@l Cameras & Photography (in reply to bobby)


abbeyvet Posts: 5095 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 (in reply to _gail)


bobby Posts: 11399 Joined: 8/15/1969 From: Seattle WA USA Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 17:16:19 quote: I think if the empty columns were removed it would be okay. Can they be removed? Yeah, if they' re empty I don' t see why not... Kathrine makes a good point tho... if everyone who sees it has Excel, why not just upload the file and link to it? Or maybe THIS could be useful? _____________________________ In order to remove a wall you must first remove the Windows® (in reply to _gail)


Mike54 Posts: 4796 Joined: 3/26/2001 From: Way Up Over Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 17:19:39 quote: Is there no way they would accept you just uploading it and linking to it? As usual Katherine you point out the painfully obvious (and possibly overlooked?) solution. My Auntie Ethel would have liked you. Of course there may be people who don' t have Excel... _____________________________ 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. (in reply to _gail)


_gail Posts: 2876 From: So FL Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 17:31:30 quote: Or maybe THIS could be useful? " ExcelWriter - enables .xls spreadsheets on a web page without needing Excel installed on the server to view it... " Oh, pooh! You mean people who don' t have Excel can' t see the schedule?! Yes, Katherine has offered a simple solution, except that they want it to look pretty and have their logo and a few other things appear on top of the page. Well, unless there is hope out there for a fairly simple fix, ugly it' s going to look! thanks, all, for your always valuable advice and generous time helping to solve problems like this. gail _____________________________ Digicamhelp - Easiest place on the web to learn about Digit@l Cameras & Photography (in reply to bobby)


bobby Posts: 11399 Joined: 8/15/1969 From: Seattle WA USA Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 17:36:14 One could always set up a web form posting to a database so they could maintain it themselves... DRW could probably handle that even... if not it wouldn' t be that complicated of a script... They could even archive old versions right on the web. Just an idea... _____________________________ In order to remove a wall you must first remove the Windows® (in reply to _gail)


_gail Posts: 2876 From: So FL Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 17:38:24 Just made an executive decision in high places. It' s going to be ugly! gail _____________________________ Digicamhelp - Easiest place on the web to learn about Digit@l Cameras & Photography (in reply to bobby)


bobby Posts: 11399 Joined: 8/15/1969 From: Seattle WA USA Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 17:39:05 quote: Yes, Katherine has offered a simple solution, except that they want it to look pretty and have their logo and a few other things appear on top of the page. FRAME it! Put the logo and prettiness in a header framel, and load the schedule into the body frame right below that... in .xls format... If they don' t have Excel, send them to www.openoffice.org Just another idea... that takes a lot less effort than my last one... _____________________________ In order to remove a wall you must first remove the Windows® (in reply to _gail)


bobby Posts: 11399 Joined: 8/15/1969 From: Seattle WA USA Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 17:40:07 quote: Just made an executive decision in high places. Sometimes exec' s aren' t such bad people... _____________________________ In order to remove a wall you must first remove the Windows® (in reply to _gail)


wattle Posts: 254 Joined: 3/31/2003 From: Australia Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 4/30/2003 21:30:39 Hi Gail, hope it' s worked out We place Excel spreadsheets on the Intranet. I usually open the document in Excel, go to > File > Save As Web Page and then save it in the location on the web it is required as per Mike' s suggestion. You do get bloated coding but it' s workable. Once it' s a webpage you can do whatever...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? I' m sure that whatever is occurring when you use this option will happen here one day and I' d like to be prepared If you want to get rid of the extra columns highlight the data on the actual spreadsheet then paste into frontpage. For instance if the data goes across to column M and down to row 180, go to the cell M 180 and highlight up and across to cell A 1, then select copy, and paste. This too brings the bloated coding with it as Bobby stated. If the cells contain formulas then the ' paste special' option can be used. Apologies if this is not what you mean by the extra columns coming across Hmmm....another thought re the blank columns / cells. Sometimes people using Excel will format an entire row or column rather than just the cells in use. This can cause problems. Out of curiosity I converted a large spreadsheet to htm after formatting a font for an entire column. The web page was extremely long (all blank under the end of the actual data) as it ' thinks' there is data in the entire column down to the end row Instead of having a spreadsheet 1000 rows long it becomes 65536 rows long as Excel assumes that the formatted cells are in use. If the above is the case, you could select only the cells on the spread sheet that contain data, paste it into a new spreadsheet and then convert to a web page, or paste into frontpage. This will get rid of all the excess formatting. Wattle (in reply to _gail)

_gail

Posts: 2876
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

(in reply to wattle)


cecilc Posts: 133 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 (in reply to _gail)


ou812 Posts: 1612 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 (in reply to _gail)


bobby Posts: 11399 Joined: 8/15/1969 From: Seattle WA USA Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 5/1/2003 14:43:09 Cecil, that rocks! (yep, I said " rocks" ) I do the same thing for my father-in-laws race site (in process of slowly converting over to database and ASP) I get an email from the track with weekly results and standings... used to take hours converting the .xls file to html tables... I gave up after half of last season, just started waiting until they posted it on their website and then copied it from there... they usually take three to four days to do that. Now I can get points up before they do [:p] Excellent tip... thanks much! B _____________________________ In order to remove a wall you must first remove the Windows® (in reply to _gail)


wattle Posts: 254 Joined: 3/31/2003 From: Australia Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 5/1/2003 18:24:28 quote: Highlight everything you want placed into a table and pull down the Table menu and choose Convert>Text to table. What a great tip! I did not even know that Frontpage had that option Just played around with it and it worked extremely well. I came unstuck with one spreadsheet but got a workaround by saving the Excel file as a CSV document. I went to Notepad and opened the .csv file and then pasted that into Frontpage and did the convert to table using comma' s - worked a treat. Thanks for posting this Wattle (in reply to cecilc)


cecilc Posts: 133 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 (in reply to _gail)


wattle Posts: 254 Joined: 3/31/2003 From: Australia Status: offline	RE: Inserting an Excel spreadsheet into a webpage - 5/1/2003 18:58:16 quote: 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. Hi Gail, it sounds like the problem is coming from the formatting of the spreadsheet. Without actually seeing it I can only guess that the entire thing is formatted, and maybe reformatted when updates are made. This does cause ' weird stuff' to happen (I' m very technical [:p] ) It could be worth trying to save as web page by ' selection' . That is, select only the cells in use on the spreadsheet to save. This site might help http://www.fadinap.org/manuals/msexcel_convert.html Hopefully Cecilc' s tip will be workable for you Wattle (in reply to _gail)