hi all,
please tell me how to access the values in the excel sheet.
i am in the network system. cannot access local disk files. All that i need to access from server.
please help me with this.
Thanks in advance
Integration Server is usually running on a server and has only access to the files available in shares mounted on this server. So if it shall parse Excel files you have to bring them on the server first (E.g. by ftp, sftp etc.). There are also some posts in this forum about how to upload a file using an IS DSP, is this is a way to go.
For parsing Excel, there is no out of the box solution. There are some API’s available like [URL=“http://poi.apache.org/”][COLOR=#22229c]http://poi.apache.org/[/color][/URL] , which you can use in Java services inside IS.