Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > Excel / ASP / OWC (was Hi !)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-03-06, 11:30
Terro Terro is offline
Registered User
  
Join Date: May 2006
Posts: 2
Exclamation 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
Reply With Quote
  #2 (permalink)  
Old 05-03-06, 12:19
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
  
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
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
Reply With Quote
  #3 (permalink)  
Old 05-03-06, 13:55
Terro Terro is offline
Registered User
  
Join Date: May 2006
Posts: 2
Thanks PatP !
Reply With Quote
  #4 (permalink)  
Old 05-04-06, 17:33
csamuels csamuels is offline
Registered User
  
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'
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.