Sep 14, 2004 #1 dsm666 IS-IT--Management Joined Mar 9, 2004 Messages 40 Location US Is there an easier way to convert an excel file to an ascii file using korn shell. Thanks much
Sep 15, 2004 #2 tdatgod Programmer Joined Jul 21, 2001 Messages 601 Location US Easier? you mean there is a way to do it at all? The easiest way is to take it back to WINDOWS load it into EXCEL and have it save it as a Comma Separated Variables (.csv) file which will be in ASCII. I found a WEB site that does the conversion for you. http://www.iconv.com/xls2csv.htm I guess this assumes you can run a WEB browser on your UNIX box. Upvote 0 Downvote
Easier? you mean there is a way to do it at all? The easiest way is to take it back to WINDOWS load it into EXCEL and have it save it as a Comma Separated Variables (.csv) file which will be in ASCII. I found a WEB site that does the conversion for you. http://www.iconv.com/xls2csv.htm I guess this assumes you can run a WEB browser on your UNIX box.
Sep 16, 2004 Thread starter #3 dsm666 IS-IT--Management Joined Mar 9, 2004 Messages 40 Location US Thanks for taking the time to answer me. Much appreciated. Upvote 0 Downvote
Sep 17, 2004 #4 KenCunningham Technical User Joined Mar 20, 2001 Messages 8,475 Location GB I agree with tdatgod, but http://www-106.ibm.com/developerworks/linux/library/l-pexcel is interesting. Upvote 0 Downvote
I agree with tdatgod, but http://www-106.ibm.com/developerworks/linux/library/l-pexcel is interesting.