Hello,
Is there any way that i can view or read Excel file on AIX server using any commands or script. Is it possible?
Thanks
Deep
Reading Excel on AIX server
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 58
- Joined: Mon Dec 14, 2015 3:16 pm
- Location: Arizona
Reading Excel on AIX server
anudpETL
-
- Participant
- Posts: 58
- Joined: Mon Dec 14, 2015 3:16 pm
- Location: Arizona
not sure if you can do it easily. There are a bunch of ways to work around it..
- you can run a windows virtual machine
- you can run a compatible program like openoffice that can read most excel files
- you can make a networked drive setup so you can open the file on windows directly via a mapped folder path
-you can open it in datastage 11 and maybe view the contents there or drop it to a csv file
- you can maybe open it via a web page (?) excel program. I am not sure about this one.
- you can write code in some language to extract the data from the file, possibly borrowing from open-office code base. This would not be simple, but it probably is more or less straightforward assuming you can borrow from existing code.
There are probably other ways as well.
- you can run a windows virtual machine
- you can run a compatible program like openoffice that can read most excel files
- you can make a networked drive setup so you can open the file on windows directly via a mapped folder path
-you can open it in datastage 11 and maybe view the contents there or drop it to a csv file
- you can maybe open it via a web page (?) excel program. I am not sure about this one.
- you can write code in some language to extract the data from the file, possibly borrowing from open-office code base. This would not be simple, but it probably is more or less straightforward assuming you can borrow from existing code.
There are probably other ways as well.