Hi All,
I'm encountering a problem on an object done like this:
<object id="excel"
classid="CLSID:00024500-0000-0000-C000-000000000046"
width=90%
height=90%>
<param name="DisplayTitleBar" value=false>
<param name="DataType" VALUE="HTMLDATA">
<param name="DisplayColHeaders" VALUE="1">
<param name="DisplayGridlines" VALUE="1">
<param name="DisplayHorizontalScrollBar" VALUE="1">
<param name="DisplayRowHeaders" VALUE="1">
<param name="DisplayToolbar" VALUE="0">
<param name="AllowPropertyToolBox" VALUE="0">
<param name="DisplayVerticalScrollBar" VALUE="1">
<param name="EnableAutoCalculate" VALUE="1">
<param name="EnableEvents" VALUE="0">
<param name="MoveAfterReturn" VALUE="1">
<param name="MoveAfterReturnDirection" VALUE="0">
<param name="RightToLeft" VALUE="0">
<param name="ViewableRange" VALUE="1:65536">
<param name="DisplayWorkbookTabs" value="0">
inside a JSPpage.
The management of the object is done using VBscript.
My web application runs with Tomcat 5.5.26.
It uses the Excel object in order to load some db data in a spreadsheet and then allows to save it as CSV file.
Using the object with clsid=0002E559-0000-0000-C000-000000000046 (should be valid for XLS 2003), it works properly, but if I try to save the file with Excel 2007 I have a huge file because it is filled with unuseful "comma empty rows', this do not happen if I save it with Excel 2003.
So I've tried to substitute the clsid with this: 00024500-0000-0000-C000-000000000046 that should be valid for Excel 2007, but I have the following error:
"object doesn't support this property or method 'excel.ActiveSheet'".
Anyone can help?

Thanks a lot

Zilvia