LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
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.

Notices

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

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


Hi,

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

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

Rep: Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903
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 02:09 PM.
 
  


Reply


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 12:39 PM
Live data replicaton to remote server roballen Linux - Software 0 01-17-2006 10:23 AM
import data to mysql server alaios Linux - Software 1 05-25-2005 01:37 AM
Import Opera Mail data from Windows to Linux d2h78q9rf Linux - Software 2 02-28-2005 01:50 AM
how to import MS-Excel sheet data using PHP dileepkk Programming 1 07-28-2004 03:23 PM


All times are GMT -5. The time now is 01:47 AM.

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