Updating a csv file held on a unix box with excel running on windows


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Updating a csv file held on a unix box with excel running on windows
# 1  
Old 09-30-2003
Updating a csv file held on a unix box with excel running on windows

Hi, my question is quite simple: Can I update a csv file which is held on a unix box (and which a script on the same box uses) with Microsoft Excel running in a windows environment? Or, is there a free spreadsheet package available to run in unix that will update my csv file. I know it's easy to create a csv file using Excel, but how do I access it on a UNIX box if the file is saved in Windows?

Any help appreciated!
# 2  
Old 09-30-2003
I don't see any problem with editing the file using Excel even if the file is stored on your unix box if the two are networked together... you could even edit the file manually on the unix box since it's just a text file with all the fields separated by commas.
# 3  
Old 10-01-2003
I'm trying to move away from editing the file manually, that's what I'm doing at the minute. I'm setting up a system for somebody else, and I want them to be able to edit the csv file held in my ~/scripts/ directory from Excel running on windows. Basically, I don't want this person to have to use UNIX at all...
# 4  
Old 10-02-2003
http://www.openoffice.org/
What UNIX are you using?
# 5  
Old 10-02-2003
sorry, meant to say 'Linux' - Red HAT 9.
# 6  
Old 10-02-2003
RHL 9 comes with Openoffice as part of the OS bundle, if the system is a standard install you could use a tool called "redhat-config-packages", you can check if the OO package is installed. I would use the Calc program to edit the file, I have found that editing some unix files with microsoft applications is useless eg I had to reconfigure a system recently, an inexperienced administrator prepared a service initialization script on a MS Windows machine, the file format was not recognised by svinit and skipped during the boot process.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to extract UNIX output to excel CSV file?

Hi guys - I have a file and output like this below: File: myfile.dat File has content like this: ABCD, 34, 456, 2324 I would like excel to have this: Name (ABCD) Quantity (34), Type (456), Status (2324) (Name, Quantity, Type and Status are columns) I would like to export... (4 Replies)
Discussion started by: DallasT
4 Replies

2. Shell Programming and Scripting

ftp an excel file from windows to unix

Hi all.. Please help me on below requirement. I have an excel file ftped from windows to unix location. I am not able to open the file. if i am opening it in vi editor, i am getting only junk characters. I have to make the excel file as .csv file and read the data to put some business... (3 Replies)
Discussion started by: gani_85
3 Replies

3. Shell Programming and Scripting

How to convert a excel file to a .csv file from unix script

Hi I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this? Thanks Abhinav (3 Replies)
Discussion started by: akashtcs
3 Replies

4. Shell Programming and Scripting

ftp file starting with particular name on Windows box to Unix box using shell script

Hello all ! I'm trying to write a shell script (bash) to ftp a file starting with particular name like "Latest_" that is present on a Windows box to UNIX server. Basically I want to set this script in the cron so that daily the new build that is posted on the Windows box can be downloaded to the... (2 Replies)
Discussion started by: vijayb4u83
2 Replies

5. 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

6. Shell Programming and Scripting

Add multiple .csv files as sheets to an excel file in unix.

Hi, I am using Solaris 8. My script outputs 4 .csv files. Currently I am SFTPing the files and creating a new excel file with the 4 files as sheets. Can anyone suggest ways to do this in UNIX ? Thanks, David. (2 Replies)
Discussion started by: libin4u2000
2 Replies

7. UNIX for Dummies Questions & Answers

I need an scp command from a unix box to a windows box.

scp file="myfile.txt" todir="user@somehost:(M:drive:/somepath/)"/ Not sure I need it to go to a specific drive on the windows box (1 Reply)
Discussion started by: xgringo
1 Replies

8. Shell Programming and Scripting

Moving files from Unix box to a windows box

Hi All, I need a little help .I want to transfer a file from unix box to a windows box,but the problem i'm facing is that in windows box FTP is not enabled and currently it is nearly impssible to change setting on windows box,i can not use the ftp method ,in my shell script to transfer the file.... (2 Replies)
Discussion started by: Preet
2 Replies

9. UNIX for Dummies Questions & Answers

Running UNIX commands remotely in Windows box from Unix box – avoid entering password

I am able to run the UNIX commands in a Windows box from a UNIX box through "SSH" functionality. But whenever the SSH connection is established between UNIX and Windows, password for windows box is being asked. Is there a way to avoid asking password whenever the SSH connection is made? Can I... (1 Reply)
Discussion started by: D.kalpana
1 Replies

10. UNIX for Advanced & Expert Users

VPN client (windows Box),and Server (Unix Box)

If I want to access unix box via VPN tunnel,from windows box. What sould I configure on the windows client PC, and what should I enable on the Unix Server box ? I am using Solaris V10 intel platform, and I am using windows XP, and 2003 for client (0 Replies)
Discussion started by: zillah
0 Replies
Login or Register to Ask a Question