I am running an scheduled agent on server.My agent will copy an excel file from a shared drive to server’s C:\Temp drive using Ftp classes. From there i have to read the file and create the documents from the data in excel. Excel is not installed on server.It is thrwing error when i am trying to create excel object using "CreateObject(“Excel.Application”).
Please suggest an alternative or solution how to read excel data from server.
In order to use CreateObject(“Excel.Application”), Excel needs to be installed on the server. CreateObject tries to bind a Variant to the external dll files of Excel, and if it isn’t installed, there is no reference to any dll files.
Since I don’t recommend installing Excel on a server, can you get the file in any other format?