Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    2

    Exclamation Unanswered: Excel / ASP / OWC (was Hi !)

    Hello.. Glad to be amongst you all.

    I'll post an issue rightaway...

    We're a small group working on ASP/JSP/DHTML,,, occasionally using VB and MS Office... The quest that brought me here is:

    One of our late colleagues used Office Web Components to dispaly an Excel Spreadsheet within a DIV. This was a couple of years back and all our machines had Office 2000 running on Windows 2000. Now our machines have Office XP or 2003 running on the same OS (well, a handful have XP Prof.).
    I'm pasting the code below from the HTML page (between the 'div' tags).

    The spreadsheet does not show up on some machines whereas it does on some... Is it a problem with the version of Office present ... or something else ..?? ... I have no experience with such a thing but have been asked to dig for a solution ... please help.

    ========================

    <div id="RevalueInventory" align="center" style="Z-INDEX: 10; LEFT: 465px; WIDTH: 380px; POSITION: absolute; TOP: 232px; HEIGHT: 184px; background-color: #FFFFFF; layer-background-color: #FFFFFF; border:1px solid #000000;visibility: hidden;" xublishsource="Excel">
    <OBJECT id=excel_obj codeBase=file:msowc.cab#version=9,0,0,2710
    classid=CLSID:0002E510-0000-0000-C000-000000000046><PARAM NAME="HTMLURL" VALUE=""><PARAM NAME="HTMLData" VALUE="<html xmlns:x=&quot;urn:schemas-microsoft-comffice:excel&quot;
    xmlns=&quot;http://www.w3.org/TR/REC-html40&quot;>

    <head>
    <style type=&quot;text/css&quot;>
    <!--tr
    {mso-height-source:auto;}
    td
    {white-space:nowrap;}
    .wc0AB33E1
    {white-space:nowrap;
    font-family:Verdana;
    mso-number-format:General;
    font-size:7pt;
    font-weight:400;
    font-style:normal;
    text-decoration:auto;
    mso-background-source:auto;
    mso-pattern:auto;
    color:black;
    text-align:general;
    vertical-align:bottom;
    border-top:none;
    border-left:none;
    border-right:none;
    border-bottom:none;
    mso-protection:locked;}

    -->
    </style>
    </head>

    <body>
    <!--[if gte mso 9]><xml>
    <x:ExcelWorkbook>
    <x:ExcelWorksheets>
    <x:ExcelWorksheet>
    <x:OWCVersion>9.0.0.6430</x:OWCVersion>
    <x:Label Style='border-top:solid .5pt silver;border-left:solid .5pt silver;
    border-right:solid .5pt silver;border-bottom:solid .5pt silver'>
    <x:Caption>Microsoft Office Spreadsheet</x:Caption>
    </x:Label>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
    <xelected/>
    <x:Height>7620</x:Height>
    <x:Width>15240</x:Width>
    <x:TopRowVisible>0</x:TopRowVisible>
    <x:LeftColumnVisible>0</x:LeftColumnVisible>
    <x:ProtectContents>True</x:ProtectContents>
    <xefaultRowHeight>180</xefaultRowHeight>
    <xtandardWidth>2340</xtandardWidth>
    </x:WorksheetOptions>
    </x:ExcelWorksheet>
    </x:ExcelWorksheets>
    <xpreadsheetAutoFit/>
    <x:MaxHeight>80%</x:MaxHeight>
    <x:MaxWidth>80%</x:MaxWidth>
    </x:ExcelWorkbook>
    </xml><![endif]-->

    <table class=wc0AB33E1 x:str>
    <col class=wc0AB33E1 width=&quot;95&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;82&quot; style='mso-width-source:userset'>
    <col class=wc43E33E1 width=&quot;51&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;31&quot; style='mso-width-source:userset'>
    <col class=wc07F33E1 width=&quot;48&quot; style='mso-width-source:userset'>
    <col class=wc02143E1 width=&quot;77&quot; style='mso-width-source:userset'>
    <col class=wc43E33E1 width=&quot;78&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;64&quot;>
    <col class=wc0AB33E1 width=&quot;139&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;84&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;80&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;82&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;77&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;57&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;106&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;133&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;118&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;105&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;64&quot;>
    <col class=wc0AB33E1 width=&quot;95&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;85&quot; style='mso-width-source:userset'>
    <col class=wc43E33E1 width=&quot;55&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;35&quot; style='mso-width-source:userset'>
    <col class=wc8C343E1 width=&quot;52&quot; style='mso-width-source:userset'>
    <col class=wc02143E1 width=&quot;79&quot; style='mso-width-source:userset'>
    <col class=wc02143E1 width=&quot;61&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;40&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;114&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;106&quot; style='mso-width-source:userset'>
    <col class=wc43E33E1 width=&quot;46&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;32&quot; style='mso-width-source:userset'>
    <col class=wc07F33E1 width=&quot;54&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;110&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;64&quot;>
    <col class=wc0AB33E1 width=&quot;108&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;0&quot; style='display:none;mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;117&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;0&quot; style='display:none;mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;126&quot; style='mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;0&quot; style='display:none;mso-width-source:userset'>
    <col class=wc0AB33E1 width=&quot;111&quot; style='mso-width-source:userset'>
    <tr height=&quot;13&quot; style='mso-height-alt:195'>
    <td class=wc8BE43E1 colspan=&quot;7&quot;></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc43E33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc8C343E1></td>
    <td class=wc02143E1></td>
    <td class=wc02143E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc43E33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc07F33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    <td class=wc0AB33E1></td>
    </tr>
    </table>

    </body>

    </html>
    "><PARAM NAME="DataType" VALUE="HTMLDATA"><PARAM NAME="AutoFit" VALUE="-1"><PARAM NAME="DisplayColHeaders" VALUE="0"><PARAM NAME="DisplayGridlines" VALUE="0"><PARAM NAME="DisplayHorizontalScrollBar" VALUE="-1"><PARAM NAME="DisplayRowHeaders" VALUE="0"><PARAM NAME="DisplayTitleBar" VALUE="0"><PARAM NAME="DisplayToolbar" VALUE="0"><PARAM NAME="DisplayVerticalScrollBar" VALUE="-1"><PARAM NAME="EnableAutoCalculate" VALUE="-1"><PARAM NAME="EnableEvents" VALUE="-1"><PARAM NAME="MoveAfterReturn" VALUE="-1"><PARAM NAME="MoveAfterReturnDirection" VALUE="0"><PARAM NAME="RightToLeft" VALUE="0"><PARAM NAME="ViewableRange" VALUE="1:65536">
    <p style='margin-top:100;font-family:Arial;font-size:8.0pt'>To use this Web page
    interactively, you must have Microsoft® Internet Explorer 4.01 or later and the
    Microsoft Office Web Components.<span style="mso-spacerun: yes"></span>See the
    <a
    HRef="http://officeupdate.microsoft.com/office/redirect/fromOffice9/MSOWCPub.htm?&amp;HelpLCID=1033">Microsoft
    Office Web site</a> for more information.</p></OBJECT></div>

    ================================================== =

    Thanks for your patience. Looking forward to an enriching experience on this forum. - Terro

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    As this thread is a lot more tech than it is "Hello, world", I'm going to move it to a forum where it will attract more technical attention for you.

    -PatP

  3. #3
    Join Date
    May 2006
    Posts
    2
    Thanks PatP !

  4. #4
    Join Date
    Mar 2006
    Location
    south jersey, usa
    Posts
    53
    i found a script that dumped a recordset into an excel file. when i first tried to use it inhouse, it didn't work. Come to find out that with different versions of owc comes different class or object names

    Set objSpreadsheet = Server.CreateObject("OWC11.Spreadsheet") ' i think this was owc9 before
    "They say Moses split the Red Sea
    I split the blunt and rolled the fat one, I'm deadly"
    -- Tupac 'Blasphemy'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •