converting excel file to text file in unix
I am currently using an unix environment. i need to convert excel file into text file as i don't think pl/sql can read excel file. Is it possible to convert it into. txt format? as my job are mainly for batch processing thus i hope it to be with little or no manual work done.
I am currently using an unix environment. i need to convert excel file into text file as i don't think pl/sql can read excel file. Is it possible to convert it into .txt format? as my job are mainly for batch processing thus i hope it to be with little or no manual work done..
How can this be done? if possible please give more detail as i am quite new to the tools i am using.
thanks..
How can this be done? if possible please give more detail as i am quite new to the tools i am using.
thanks..
Participate on our website and join the conversation
This topic is archived. New comments cannot be posted and votes cannot be cast.
Responses to this topic
What is the file extension of the file you wish to convert? .xls?
There is a command line tool called xls2csv. it will convert excel spreadsheets to a comma separtated text file.
just install the pkg for your distro if it's not already installed and check out the man page. IF you have alot of files in one directory you could just do something like
for i in *.xls
do
xls2csv $1
done
just install the pkg for your distro if it's not already installed and check out the man page. IF you have alot of files in one directory you could just do something like
for i in *.xls
do
xls2csv $1
done
gnumeric will open .xls files, and I'm fairly certain you can then save it as a text file.
