?
Solved

Displaying excel range on webpage

Posted on 2006-04-11
9
Medium Priority
?
423 Views
Last Modified: 2010-04-06
I am wanting to display an excel range on my web page. Im already using php and odbc to link to an access databse. All i want is to display say range("B3:K31") of a specific sheet on a web page, i dont want to have any interaction. The sheet will only be updated once week? Is this possible and if so how do i go about doing it?
0
Comment
Question by:generali
  • 5
  • 4
9 Comments
 
LVL 30

Expert Comment

by:Irwin Santos
ID: 16430898
http://support.microsoft.com/kb/311765/en-us

There is some reading for you.
0
 
LVL 2

Author Comment

by:generali
ID: 16432190
Ive had a look at that but to be honest it seems a little advanced for me. ive downlaoded the Dso framer and loaded my sheet but i dont know how to embed it in my web page.

All im really after is an embedded view of my sheet on my webpage that will be updated weekly, soley for viewing.
0
 
LVL 30

Expert Comment

by:Irwin Santos
ID: 16432849
Ok.. so how about something a little less complex
http://support.microsoft.com/kb/190195/
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Author Comment

by:generali
ID: 16443692
Still not really what im after, its using VB which i dont know how to use. Ive saved my spreadsheet as html, which is more or less what i want except i want to input it within my own template, not sure if thats possible though.
0
 
LVL 30

Expert Comment

by:Irwin Santos
ID: 16443711
It's either going to be my 1st or 2nd comment that you wil lhave to apply

OR

Copy & paste the results from Excel.
0
 
LVL 2

Author Comment

by:generali
ID: 16443989
definately not copy and paste. im sure ive used some vbscript before to load the excel inteface and fuctionality (which im not interested) but not an actual sheet with data, but i cant for the life of me find where i used it.

with regards to your second comment, on the link it says:

'1. Create a new standard EXE project called "DAO_EXCEL."  
2. From the Project menu, click References, and then select the Microsoft DAO 3.5 Library check box.  
3. Place a CommandButton on the form.  
4. Paste the following code in the form code window:'

Im assuming that the EXE project is a VB project? do you need specific software for this, ive done quite a lot of VBA but no VB?

thanks
0
 
LVL 30

Accepted Solution

by:
Irwin Santos earned 1000 total points
ID: 16444149
Below is code that I generated via EXCEL... "Save as Web Page".  Build your page around your data.
----------------------------------------------

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=FrontPage.Editor.Document>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="Page_files/filelist.xml">
</head>

<body>
<!--[if !excel]>&nbsp;&nbsp;<![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_17090" align=center x:publishsource="Excel">

<h1 style='color:black;font-family:Arial;font-size:14.0pt;font-weight:800;
font-style:normal'>Test sample</h1>

<object id="Book1_17090_Spreadsheet"
 classid="CLSID:0002E559-0000-0000-C000-000000000046">
 <param name=DisplayTitleBar value=false>
 <param name=ViewableRange value="$A$1:$A$6">
 <param name=Autofit value=true>
 <param name=DataType value=XMLData>
 <param name=XMLData
 value="&lt;?xml version=&quot;1.0&quot;?&gt;&#13;&#10;&lt;?mso-application progid=&quot;Excel.Sheet&quot;?&gt;&#13;&#10;&lt;Workbook xmlns=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;&#13;&#10; xmlns:o=&quot;urn:schemas-microsoft-com:office:office&quot;&#13;&#10; xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;&#13;&#10; xmlns:ss=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;&#13;&#10; xmlns:html=&quot;http://www.w3.org/TR/REC-html40"> ; &lt;DocumentProperties xmlns=&quot;urn:schemas-microsoft-com:office:office&quot;&gt;&#13;&#10;  &lt;Author&gt;Administrator&lt;/Author&gt;&#13;&#10;  &lt;Created&gt;2006-04-13T10:20:10Z&lt;/Created&gt;&#13;&#10;  &lt;Company&gt;.&lt;/Company&gt;&#13;&#10;  &lt;Version&gt;11.6568&lt;/Version&gt;&#13;&#10; &lt;/DocumentProperties&gt;&#13;&#10; &lt;ExcelWorkbook xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;  &lt;WindowHeight&gt;13035&lt;/WindowHeight&gt;&#13;&#10;  &lt;WindowWidth&gt;21915&lt;/WindowWidth&gt;&#13;&#10;  &lt;WindowTopX&gt;120&lt;/WindowTopX&gt;&#13;&#10;  &lt;WindowTopY&gt;60&lt;/WindowTopY&gt;&#13;&#10;  &lt;ProtectStructure&gt;False&lt;/ProtectStructure&gt;&#13;&#10;  &lt;ProtectWindows&gt;False&lt;/ProtectWindows&gt;&#13;&#10; &lt;/ExcelWorkbook&gt;&#13;&#10; &lt;Styles&gt;&#13;&#10;  &lt;Style ss:ID=&quot;Default&quot; ss:Name=&quot;Normal&quot;&gt;&#13;&#10;   &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;&#13;&#10;   &lt;Borders/&gt;&#13;&#10;   &lt;Font/&gt;&#13;&#10;   &lt;Interior/&gt;&#13;&#10;   &lt;NumberFormat/&gt;&#13;&#10;   &lt;Protection/&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10; &lt;/Styles&gt;&#13;&#10; &lt;Worksheet ss:Name=&quot;Sheet1&quot;&gt;&#13;&#10;  &lt;Table ss:ExpandedColumnCount=&quot;1&quot; ss:ExpandedRowCount=&quot;6&quot;&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell&gt;&lt;Data ss:Type=&quot;String&quot;&gt;data1&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell&gt;&lt;Data ss:Type=&quot;String&quot;&gt;data2&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell&gt;&lt;Data ss:Type=&quot;String&quot;&gt;data3&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell&gt;&lt;Data ss:Type=&quot;String&quot;&gt;data4&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell&gt;&lt;Data ss:Type=&quot;String&quot;&gt;data5&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell&gt;&lt;Data ss:Type=&quot;String&quot;&gt;data6&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;  &lt;/Table&gt;&#13;&#10;  &lt;WorksheetOptions xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;   &lt;ProtectObjects&gt;False&lt;/ProtectObjects&gt;&#13;&#10;   &lt;ProtectScenarios&gt;False&lt;/ProtectScenarios&gt;&#13;&#10;  &lt;/WorksheetOptions&gt;&#13;&#10;  &lt;PublishObjects xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;   &lt;PublishObject&gt;&#13;&#10;    &lt;Id&gt;17090&lt;/Id&gt;&#13;&#10;    &lt;DivID&gt;Book1_17090&lt;/DivID&gt;&#13;&#10;    &lt;SourceType&gt;SourceRange&lt;/SourceType&gt;&#13;&#10;    &lt;Source&gt;R1C1:R6C1&lt;/Source&gt;&#13;&#10;    &lt;HtmlType&gt;HtmlCalc&lt;/HtmlType&gt;&#13;&#10;    &lt;Location&#13;&#10;     x:HRef=&quot;C:\Documents and Settings\Administrator.GETAROBOG\My Documents\Page.htm&quot;/&gt;&#13;&#10;    &lt;Title&gt;Test sample&lt;/Title&gt;&#13;&#10;   &lt;/PublishObject&gt;&#13;&#10;   &lt;AutoRepublish&gt;&#13;&#10;    &lt;DivID&gt;Book1_17090&lt;/DivID&gt;&#13;&#10;   &lt;/AutoRepublish&gt;&#13;&#10;  &lt;/PublishObjects&gt;&#13;&#10; &lt;/Worksheet&gt;&#13;&#10;&lt;/Workbook&gt;&#13;&#10;">
 <p style='margin-top:100;font-family:Arial;font-size:8.0pt'>To use this Web
 page interactively, you must have Microsoft® Internet Explorer 5.01 Service
 Pack 2 (SP2) or later and the Microsoft Office 2003 Web Components.</p>
 <p style='margin-top:100;font-family:Arial;font-size:8.0pt'>See the <a
 href="http://r.office.microsoft.com/r/rlidmsowcpub?clid=1033&p1=Excel">Microsoft
 Office Web site</a> for more information.</p>
</object></div>


<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>

</html>
0
 
LVL 2

Author Comment

by:generali
ID: 16453143
Id already done that but was a little overwhelemed by all the html it produces so didnt know what to do with the headers etc within my own template, ive maged to emded it now although its not alligned very well, ill have to play aroud with it or make do with the blank htm file.

Cheers for the suggestions
0
 
LVL 30

Expert Comment

by:Irwin Santos
ID: 16454048
Cool. thank you!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most of the sites are being standardized with W3C Web Standards. W3C provides lot of web standard services to the web. They have the web specification, process and documentation for all the web standards. You can apply HTML, CSS and Accessibility st…
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question