LinkBack URL
About LinkBacks
Reply With QuoteYou want the table data , or actually open excel ? what if people don't have excel on the computer ?
Excel sheet to webpage
Sorry if this is has come up before (I'm sure it has), but I tried searching and did not find an answer.
I'm just trying to get an excel sheet onto my site. I save as a web page but I am then unsure what to do. I want to have the excel sheet inside a div tag on one of my web pages.
What I've tried so far is to "View as a web page" and then "View source" and try to put this source into my div tags. Is this the correct approach to be taking as the page does not look right when added to my webpage.
Thanks
You want the table data , or actually open excel ? what if people don't have excel on the computer ?
sorry if not clear, yes it's the table data displayed, not to open the excel sheet
why don't you use normal HTML for this
HTML Code:<table> <tr> <th>col 1</th><th>col2</th> </tr> <tr> <td>row 1</td><td>row 2</td> </tr> </table>
Well the excel sheet is quite large and it would be nice to be able to import it. Also on occasion the sheet is likely to change, and it would then save creating the table again with html
check out this : Tryit Editor v1.4
but you have to view it in IE i think
but this is probably what you are looking for XML Application
Thanks for the help, but it's not too appealing if it only works in IE. I will investigate further, any other taughts?
One solution is zohosheets where you keep the functionality of excel:
Online Spreadsheets - Zoho Sheet
(not sure if it is free or not)
If you just want the data table you could do as you have done, save as web page, strip down the code and paste it into your webpage.
Your code MAY look something like this:
..etc etcCode:<!--[if !excel]> <![endif]--> <!--The following information was generated by Microsoft Office Excel's Publish as Web Page wizard.--> <!--If the same item is republished from Excel, all information between the DIV tags will be replaced.--> <!-----------------------------> <!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD --> <!-----------------------------> <div id="Book1_23242" align=center x:publishsource="Excel"> <table x:str border=0 cellpadding=0 cellspacing=0 width=224 style='border-collapse: collapse;table-layout:fixed;width:168pt'> <col width=56 span=4 style='width:42pt'> <tr height=15 style='height:11.25pt'> <td height=15 class=xl1523242 width=56 style='height:11.25pt;width:42pt'>qwe</td> <td class=xl1523242 width=56 style='width:42pt'>qwe</td> <td class=xl1523242 width=56 style='width:42pt'>qwe</td> <td class=xl1523242 width=56 style='width:42pt'>qew</td> </tr>
All that crap can be stripped down to:
... etc etc and then you can add your own styles to pretty-ify it.Code:<table cellpadding=0 cellspacing=0> <tr> <td>qwe</td> <td>qwe</td> <td>qwe</td> <td>qew</td> </tr>
Last edited by enzo; 04-09-2007 at 09:15 AM.
Posting Permissions
