froggy77
asked on
Error while creating Excel application in ASP
I get the following error at this perticular line
set e=server.CreateObject("Exc el.Applica tion")
error message
Error Type:
Server object, ASP 0177 (0x80080005)
Server execution failed
Is there any file or dll or library to be registered to create an excel application?
Or is there any requirement which is missing on the server?
set e=server.CreateObject("Exc
error message
Error Type:
Server object, ASP 0177 (0x80080005)
Server execution failed
Is there any file or dll or library to be registered to create an excel application?
Or is there any requirement which is missing on the server?
It could be a permission issue
You can try this
1) Run DCOMCNFG.EXE
2) In the Application tab select Microsoft Excel Application and then click
the Properties button to configure the application.
3) In the Properties dialog you can configure your permissions for the
Microsoft Excel Application via the Security tab.
You can try this
1) Run DCOMCNFG.EXE
2) In the Application tab select Microsoft Excel Application and then click
the Properties button to configure the application.
3) In the Properties dialog you can configure your permissions for the
Microsoft Excel Application via the Security tab.
ASKER
I cannot use
<%@ Language=VBScript %>
<%
'Change HTML header to specify Excel's MIME content type
Response.Buffer = TRUE
Response.ContentType = "application/vnd.ms-excel"
%>
because at the end of the asp page I have to save the excel file and I cannot do it using the above code.
And regarding DCOMCNFG.EXE
I changed the permission but it still gives the error message. Should I reboot the system after changing the security options?
<%@ Language=VBScript %>
<%
'Change HTML header to specify Excel's MIME content type
Response.Buffer = TRUE
Response.ContentType = "application/vnd.ms-excel"
%>
because at the end of the asp page I have to save the excel file and I cannot do it using the above code.
And regarding DCOMCNFG.EXE
I changed the permission but it still gives the error message. Should I reboot the system after changing the security options?
yes u can try that. If it is a permission issue it should be solved this way
If you're using Excel 2002 you can use this object instead.
Hope it helps. I can provide more info on how to populate the fields if needed.
<object classid="clsid:0002E551-00 00-0000-C0 00-0000000 00046" id="Spreadsheet1">
<param name="DataType" value="XMLDATA">
<param name="AllowPropertyToolbox " value="-1">
<param name="AutoFit" value="0">
<param name="Calculation" value="-4105">
<param name="Caption" value="Microsoft Office Spreadsheet">
<param name="DisplayColumnHeading s" value="-1">
<param name="DisplayGridlines" value="-1">
<param name="DisplayHorizontalScr ollBar" value="-1">
<param name="DisplayOfficeLogo" value="-1">
<param name="DisplayPropertyToolb ox" value="0">
<param name="DisplayRowHeadings" value="-1">
<param name="DisplayTitleBar" value="0">
<param name="DisplayToolbar" value="-1">
<param name="DisplayVerticalScrol lBar" value="-1">
<param name="DisplayWorkbookTabs" value="-1">
<param name="EnableEvents" value="-1">
<param name="MaxHeight" value="80%">
<param name="MaxWidth" value="80%">
<param name="MoveAfterReturn" value="-1">
<param name="MoveAfterReturnDirec tion" value="-4121">
<param name="RightToLeft" value="0">
<param name="ScreenUpdating" value="-1">
<param name="EnableUndo" value="-1">
<param name="XMLData" value="<?xml version="1.0"?&g t;
<ss:Workbook xmlns:x="urn:schemas- microsoft- com:office :excel&quo t;
xmlns:ss="urn:schemas -microsoft -com:offic e:spreadsh eet"
xmlns:c="urn:schemas- microsoft- com:office :component :spreadshe et"&g t;
<x:ExcelWorkbook>
<x:ProtectStructure> False</ x:ProtectS tructure&g t;
<x:ActiveSheet>0< /x:ActiveS heet>
</x:ExcelWorkbook>
<ss:Styles>
<ss:Style ss:ID="Default"& gt;
<ss:Alignment ss:Horizontal="Automa tic" ss:Rotate="0.0" ss:Vertical="Bottom&q uot;
ss:ReadingOrder="Cont ext"/ >
<ss:Borders>
</ss:Borders>
<ss:Font ss:FontName="Arial&qu ot; ss:Size="10" ss:Color="Automatic&q uot; ss:Bold="0"
ss:Italic="0" ss:Underline="None&qu ot;/>
<ss:Interior ss:Color="Automatic&q uot; ss:Pattern="None" ;/>
<ss:NumberFormat ss:Format="General&qu ot;/>
<ss:Protection ss:Protected="1" />
</ss:Style>
</ss:Styles>
<c:ComponentOptions>
<c:Label>
<c:Caption>Microsoft Office Spreadsheet</c:Caption& gt;
</c:Label>
<c:MaxHeight>80%< /c:MaxHeig ht>
<c:MaxWidth>80%</ c:MaxWidth >
<c:NextSheetNumber>4 </c:Nex tSheetNumb er>
</c:ComponentOptions> ;
<x:WorkbookOptions>
<c:OWCVersion>10.0.0 .2621 </c:OWCVersion>
<x:Height>7620</x :Height> ;
<x:Width>15240</x :Width>
</x:WorkbookOptions>
<ss:Worksheet ss:Name="Sheet1" >
<x:WorksheetOptions>
<x:Selected/>
<x:ViewableRange>R1: R262144< ;/x:Viewab leRange> ;
<x:Selection>R1C1< ;/x:Select ion>
<x:TopRowVisible>0&l t;/x:TopRo wVisible&g t;
<x:LeftColumnVisible> ;0</x:L eftColumnV isible>
<x:ProtectContents>F alse</x :ProtectCo ntents>
</x:WorksheetOptions> ;
<c:WorksheetOptions>
</c:WorksheetOptions> ;
</ss:Worksheet>
<ss:Worksheet ss:Name="Sheet2" >
<x:WorksheetOptions>
<x:ViewableRange>R1: R262144< ;/x:Viewab leRange> ;
<x:Selection>R1C1< ;/x:Select ion>
<x:TopRowVisible>0&l t;/x:TopRo wVisible&g t;
<x:LeftColumnVisible> ;0</x:L eftColumnV isible>
<x:ProtectContents>F alse</x :ProtectCo ntents>
</x:WorksheetOptions> ;
<c:WorksheetOptions>
</c:WorksheetOptions> ;
</ss:Worksheet>
<ss:Worksheet ss:Name="Sheet3" >
<x:WorksheetOptions>
<x:ViewableRange>R1: R262144< ;/x:Viewab leRange> ;
<x:Selection>R1C1< ;/x:Select ion>
<x:TopRowVisible>0&l t;/x:TopRo wVisible&g t;
<x:LeftColumnVisible> ;0</x:L eftColumnV isible>
<x:ProtectContents>F alse</x :ProtectCo ntents>
</x:WorksheetOptions> ;
<c:WorksheetOptions>
</c:WorksheetOptions> ;
</ss:Worksheet>
</ss:Workbook>
">
Hope it helps. I can provide more info on how to populate the fields if needed.
<object classid="clsid:0002E551-00
<param name="DataType" value="XMLDATA">
<param name="AllowPropertyToolbox
<param name="AutoFit" value="0">
<param name="Calculation" value="-4105">
<param name="Caption" value="Microsoft Office Spreadsheet">
<param name="DisplayColumnHeading
<param name="DisplayGridlines" value="-1">
<param name="DisplayHorizontalScr
<param name="DisplayOfficeLogo" value="-1">
<param name="DisplayPropertyToolb
<param name="DisplayRowHeadings" value="-1">
<param name="DisplayTitleBar" value="0">
<param name="DisplayToolbar" value="-1">
<param name="DisplayVerticalScrol
<param name="DisplayWorkbookTabs"
<param name="EnableEvents" value="-1">
<param name="MaxHeight" value="80%">
<param name="MaxWidth" value="80%">
<param name="MoveAfterReturn" value="-1">
<param name="MoveAfterReturnDirec
<param name="RightToLeft" value="0">
<param name="ScreenUpdating" value="-1">
<param name="EnableUndo" value="-1">
<param name="XMLData" value="<?xml version="1.0"?&g
<ss:Workbook xmlns:x="urn:schemas-
xmlns:ss="urn:schemas
xmlns:c="urn:schemas-
<x:ExcelWorkbook>
<x:ProtectStructure>
<x:ActiveSheet>0<
</x:ExcelWorkbook>
<ss:Styles>
<ss:Style ss:ID="Default"&
<ss:Alignment ss:Horizontal="Automa
ss:ReadingOrder="Cont
<ss:Borders>
</ss:Borders>
<ss:Font ss:FontName="Arial&qu
ss:Italic="0" ss:Underline="None&qu
<ss:Interior ss:Color="Automatic&q
<ss:NumberFormat ss:Format="General&qu
<ss:Protection ss:Protected="1"
</ss:Style>
</ss:Styles>
<c:ComponentOptions>
<c:Label>
<c:Caption>Microsoft
</c:Label>
<c:MaxHeight>80%<
<c:MaxWidth>80%</
<c:NextSheetNumber>4
</c:ComponentOptions>
<x:WorkbookOptions>
<c:OWCVersion>10.0.0
<x:Height>7620</x
<x:Width>15240</x
</x:WorkbookOptions>
<ss:Worksheet ss:Name="Sheet1"
<x:WorksheetOptions>
<x:Selected/>
<x:ViewableRange>R1:
<x:Selection>R1C1<
<x:TopRowVisible>0&l
<x:LeftColumnVisible>
<x:ProtectContents>F
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
</ss:Worksheet>
<ss:Worksheet ss:Name="Sheet2"
<x:WorksheetOptions>
<x:ViewableRange>R1:
<x:Selection>R1C1<
<x:TopRowVisible>0&l
<x:LeftColumnVisible>
<x:ProtectContents>F
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
</ss:Worksheet>
<ss:Worksheet ss:Name="Sheet3"
<x:WorksheetOptions>
<x:ViewableRange>R1:
<x:Selection>R1C1<
<x:TopRowVisible>0&l
<x:LeftColumnVisible>
<x:ProtectContents>F
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
</ss:Worksheet>
</ss:Workbook>
">
Do you have to display the page in Regular web format and then save the same page as excel
or you want to create an excel file along with some other things on the page and open it on click of button!!
Explain how do u want it!!
or you want to create an excel file along with some other things on the page and open it on click of button!!
Explain how do u want it!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified abandoned. I will make a recommendation to the
moderators on its resolution in a week or two. I appreciate any comments
that would help me to make a recommendation.
<note>
Unless it is clear to me that the question has been answered I will recommend delete. It is possible that a Grade less than A will be given if no expert makes a case for an A grade. It is assumed that any participant not responding to this request is no longer interested in its final disposition.
</note>
If the user does not know how to close the question, the options are here:
https://www.experts-exchange.com/help/closing.jsp
Cd&
moderators on its resolution in a week or two. I appreciate any comments
that would help me to make a recommendation.
<note>
Unless it is clear to me that the question has been answered I will recommend delete. It is possible that a Grade less than A will be given if no expert makes a case for an A grade. It is assumed that any participant not responding to this request is no longer interested in its final disposition.
</note>
If the user does not know how to close the question, the options are here:
https://www.experts-exchange.com/help/closing.jsp
Cd&
It is time to clean this abandoned question up.
I am putting it on a clean up list for CS.
<recommendation>
PAQ
</recommendation>
If anyone participating in the Q disagrees with the recommendation,
please leave a comment for the mods.
Cd&
I am putting it on a clean up list for CS.
<recommendation>
PAQ
</recommendation>
If anyone participating in the Q disagrees with the recommendation,
please leave a comment for the mods.
Cd&
<%@ Language=VBScript %>
<%
'Change HTML header to specify Excel's MIME content type
Response.Buffer = TRUE
Response.ContentType = "application/vnd.ms-excel"
%>