Help answer threads with 0 replies.
Go Back > Forums > Non-*NIX Forums > Programming
User Name
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.


  Search this Thread
Old 01-31-2008, 07:16 AM   #1
LQ Newbie
Registered: Jun 2007
Posts: 9

Rep: Reputation: 0
Want to import an excel sheet data from from a remote linux server


I want to import a Microsoft excel sheet to the linux and then read that file. I want to replace few colums from that sheet according to the date mentioned in one of the coloumn of that sheet itself.

Can any one guide me with the logic to do so with a bash script...

Old 01-31-2008, 01:08 PM   #2
LQ 5k Club
Registered: Aug 2005
Distribution: OpenSuse, Fedora, Redhat, Debian
Posts: 5,397
Blog Entries: 2

Rep: Reputation: 908Reputation: 908Reputation: 908Reputation: 908Reputation: 908Reputation: 908Reputation: 908Reputation: 908
You haven't given enough information to give a complete answer, but I think bash is going to need quite a bit of help along the way.
Firstly, you need to specify where the Excel spreadsheet is. It might be in one of these situations:
1. On a SMB/CIFS/NFS shared directory on a running Windows host.
2. On a directory of a Windows host running a FTP/SFTP server.
3. On a Windows partition of the local host filesystem (ie. dual boot).
4. On a portable media such as CD, floppy, flash drive, etc.
5. Simply as a file already stored on the Linux filesystem.

Once this issue has been resolved, one can address how the importation might be done.

Having 'imported' the spreadsheet, one can then manipulate it with any of a number of perl modules, starting with 'Spreadsheet::ParseExcel', manpiulating the resulting data structures as necessary, and finally writing out a new version with 'Spreadsheet::WriteExcel'.

These things can be done using other tools, with bash as the wrapper script, but unlikely using strictly bash.

--- rod.

Last edited by theNbomr; 01-31-2008 at 01:09 PM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
filter a data sheet for blank spaces tjgadu Linux - Newbie 2 04-20-2006 11:39 AM
Live data replicaton to remote server roballen Linux - Software 0 01-17-2006 09:23 AM
import data to mysql server alaios Linux - Software 1 05-25-2005 12:37 AM
Import Opera Mail data from Windows to Linux d2h78q9rf Linux - Software 2 02-28-2005 12:50 AM
how to import MS-Excel sheet data using PHP dileepkk Programming 1 07-28-2004 02:23 PM > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 06:57 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration