• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 426
  • Last Modified:

Excel object library without Excel

Hi,

I use VB6 and Excel object library on my application to import xls worksheet.

I would to install on my client this application.

Is it possible to use the excel library object without Excel application?

and how?

Thanks
0
esohier
Asked:
esohier
1 Solution
 
JR2003Commented:
You will need to have Excel installed to have access to the object library.
0
 
Jorge PaulinoIT Pro/DeveloperCommented:
Yes JR2003 but to execute the import i think its not need it!
0
 
JR2003Commented:
jpaulino, I think it is needed.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
SethiCommented:
You would require Excel for sure on a system if you areusing the Excel object liraryin your application. I second JR2003.
0
 
esohierAuthor Commented:
Hi,

Thanks for your answers, but, if Excel is need. Is it possible to detect is this application is installed?

Thanks.
0
 
JR2003Commented:
Public Function ExcelExists() As Boolean

    Dim obj As Object
   
    On Error GoTo ExcelNotPresent
   
    ExcelExists = False 'Initialise
   
    Set obj = CreateObject("Excel.Application")
    ExcelExists = True
   
ExcelNotPresent:
End Function

Private Sub Command1_Click()

    MsgBox ExcelExists()

End Sub
0
 
Jeroen RosinkSoftware testing consultantCommented:
The excel library is part of excel application. To use functionality of it you need excel to be installed. If you don't want this application to be installed due to licences perhaps the excel viewer gives what you need. Im not sure about this, you might give it a try. I can imagine that this also contains the excel library.

to download the viewer (freeware) you might check:
http://www.microsoft.com/downloads/details.aspx?familyid=c8378bf4-996c-4569-b547-75edbd03aaf0&displaylang=en

I hope this works for you.

regards,
Jeroen
0
 
JR2003Commented:
Another possible option is to use an Excel ODBC driver.
You can use this to read a spreadsheet without having excel installed.
I think it comes with some versions of MDAC
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now