08-03-2006
Opening an Excel File in Unix
Hi all,
I want to open an Excel file in Unix(ABC.xls) and copy one column of the file onto another text file (xyz.txt) .Please let me know if there is a way of going about to perform this operation.
Thanks in Advance,
bubeshj
10 More Discussions You Might Find Interesting
1. Programming
Pls someone help me. This piece of code is giving me weird results.
ofstream outfile;
ofstream out;
char filename1;
char filename2;
memset(filename1,'\0',sizeof(filename1));
memset(filename2,'\0',sizeof(filename2));
strcpy(filename1,"Testing1.out");... (0 Replies)
Discussion started by: skannan
0 Replies
2. Shell Programming and Scripting
Hi friends...
I am sending a file say xyz.xls to a mail through unix.
The .xls file is more than 65 thousand in size so I want to spilt the file size into 40 thousand and 25 thousand.
So can anyone provide any inputs.... (1 Reply)
Discussion started by: Soumya Dash
1 Replies
3. OS X (Apple)
If I have a file in OSX (e.g. a pdf), I can choose how to open it i.e. with the "open with..." command from the 'right click menu'.
Sometimes a pdf is garbled in OSX Preview so I need to open it in Adobe Acrobat.
How do I choose the application when opening a file in UNIX? (2 Replies)
Discussion started by: Mpeter
2 Replies
4. UNIX for Dummies Questions & Answers
Hi folks,
I have a file in unix box as abc.xls and i have a file in windows box as abc_win.xls. Now if i open the file abc_win.xls which is in windows, i have to get the datas of the file abc.xls which is in unix. Everytime i opens the abc_win.xls file, the updated datas of file abc.xls... (6 Replies)
Discussion started by: a439511
6 Replies
5. UNIX for Dummies Questions & Answers
Hi
To delete some text in 2 files in line1 ( not complete line) in unix without opening the files.
For example: source file is like this
<?xml version="1.0"... (5 Replies)
Discussion started by: pyaranoid
5 Replies
6. Linux
Hey Friends,
When I open (More <filename>) a big txt file in UNIX /LINUX it asks me to press any key to see remaining file. Can I see it in a stretch? I mean I jst want to let the contains of file scroll up completely. Is there any way out?
Plz help.
Thanx in advance
Anushree. (2 Replies)
Discussion started by: anushree.a
2 Replies
7. UNIX for Dummies Questions & Answers
Hi ,
I am having file in unix with size (386796649) , below is the output of ls command in UNIX.
I have ftp'ed the file to my windows machine . When i tried to open the file it is not
opening . Why it is so . Is there is size limit.
-rw-rw-rw- 1 p10 pQQ 98473 Sep 17 17:20... (4 Replies)
Discussion started by: arunkumar_mca
4 Replies
8. Shell Programming and Scripting
Hi,
I have the Ms Excel file(test.xls) in my UNIX box. I would like to read the excel file and create files for each column.
Please find an example.
My excel file like this data:
Num Data
1 a1
2 b2
3 c3
4 d4
5 e5
6 f6
7 h7
My output:
I want create 2 files(num.log and... (3 Replies)
Discussion started by: koti_rama
3 Replies
9. UNIX for Advanced & Expert Users
I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner.
I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies
10. UNIX for Dummies Questions & Answers
Hi. I'm new to Unix and recently received Unix files via email. I downloaded those files but am unable to open them on my computer which uses Mac OS X. How do I open the files? (11 Replies)
Discussion started by: michellemc
11 Replies
LEARN ABOUT DEBIAN
py_xls2txt
py_xls2txt(1) General Commands Manual py_xls2txt(1)
NAME
py_xls2txt - convert an Excel xls file to a plain text file
SYNOPSIS
py_xls2txt input-file
DESCRIPTION
This manual page was written for the Debian distribution because the original program does not have a manual page.
py_xls2txt takes an Excel xls file as an argument and converts it to a plain text file. Output is sent to stdout.
Additional utility scripts can be found in the tools/ directory.
OPTIONS
This program does not take any command line options.
AUTHOR
pyexcelerator and py_xls2txt were written by Roman V. Kiseliov <roman@kiseliov.ru>.
This manual page was written by Kevin Coyner <kcoyner@debian.org> for the Debian system (but may be used by others). Permission is granted
to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later version published
by the Free Software Foundation.
On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.
SEE-ALSO
pyexcelerator(1), py_xls2csv(1), py_xls2html(1)
October 12, 2006 py_xls2txt(1)