Server.CreateObject ("Excel.Application")

Results 1 to 2 of 2

Thread: Server.CreateObject ("Excel.Application")

  1. #1
    Join Date
    Dec 1969

    Default Server.CreateObject ("Excel.Application")

    When I run this command on the IIS server I get error Cannot Launch out of process component. Can I launch excel on the <BR>server or must it be on the client. What I want to do is manipulate the cells of an xls file that resides on the server.<BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default Use the Jet provider and regular

    old ADO to manipulate your Excel data.<BR><BR>Here is a sample connection string:<BR><BR>strConn = "Microsoft.Jet.OLEDB.4.0;Data Source=c:yourpath/yourspreadsheet.xls;Extended Properties=Excel 8.0;HDR=No;"<BR><BR>You can remove &#039;HDR=No;&#039; if you have column headers.<BR><BR>Then you can execute normal SQL SELECT statements except you use the sheet name like:<BR><BR>SELECT * FROM [Sheet1$]<BR><BR>You can even select from a specific range.<BR><BR>Good luck<BR>Pete<BR><BR>

Posting Permissions

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