Hi folks,

I have a KIX script running on a server using some automation in Excel. What I've read recently is that server-side automation is not a good idea for MS Office products (see the below article):


One of the suggestions is to use the System.IO.Package.IO namespace in .NET Framework.

Could anyone please help on how to replace the below code with the above suggestion without initializing Excel application itself?

 $Excel = CreateObject("Excel.Application")
 $WorkBook = $Excel.WorkBooks.Open("\\server\folder\EUR.xls")
 $WorkSheet = $WorkBook.Sheets.Item("EUR")
    $xlsValueEUR01 = $WorkSheet.Range("E3").Value