Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Opening an Excel File in Unix

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Opening an Excel File in Unix
# 1  
Old 08-03-2006
MySQL 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
# 2  
Old 08-03-2006
the easy way is to convert your .xls to .csv on windows and use sed/awk/whatever to extract just one column from the .csv on UNIX.
# 3  
Old 08-03-2006
MySQL
hi Moderator,
in that case is it possible to automate the whole process through a script or something.
Thanks,
bubesh
# 4  
Old 08-03-2006
Quote:
Originally Posted by bubeshj
hi Moderator,
in that case is it possible to automate the whole process through a script or something.
Thanks,
bubesh
not that I'm aware of - you'll have to do it manually. btw... Google is your friend.
# 5  
Old 08-03-2006
MySQL
Hi,
If you are aware why not share so it is of help to everyone. Xpecting your co-operation.
Thanks,
Subsahini.
# 6  
Old 08-03-2006
vgersh99 indicated that he is not aware of any automated process. All he did was provide you a google search URL to show you [b]a tool[b] that may perhaps help you. I don't believe he is endorsing it at all.

You issue is automating the transformation from Excel to CSV, everything else is easy. Excel files are propietary, binary formats so plucking out a piece of data is no trvial.

vgersh99 was really prompting you so use google to search out a solution.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Opening a Unix File with Mac OS X

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

2. UNIX for Advanced & Expert Users

Problem in converting password protected excel file to csv file in unix

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

3. Shell Programming and Scripting

Read Ms-excel file in unix

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

4. UNIX for Dummies Questions & Answers

Problem in opening UNIX file in Windows

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

5. Linux

Opening a TXT file in LINUX / UNIX

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

6. UNIX for Dummies Questions & Answers

Urgent help needed to delete some text without opening the file in unix

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

7. UNIX for Dummies Questions & Answers

Opening a Unix File in Windows.

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

8. OS X (Apple)

How do I choose the application when opening a file in UNIX?

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

9. Shell Programming and Scripting

Spilt excel file in unix

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

10. Programming

File Opening in C++ in Unix Env

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
Login or Register to Ask a Question