LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 07-08-2008, 02:21 AM   #1
binary_dreamer
Member
 
Registered: Feb 2006
Distribution: debian squeeze
Posts: 185

Rep: Reputation: 31
spreadsheet comparison


Hi.
I got an open office spreadsheet that has two columns. One column (A) has some elements and the column B has the name of the elements.
that spreadsheet gets updated every day.
I need to go once per week and find out which lines have been updated and post them out. Is there an easy way to compare two spreadsheets and find out which lines have been added?
 
Old 07-08-2008, 02:51 AM   #2
Mr. C.
Senior Member
 
Registered: Jun 2008
Posts: 2,529

Rep: Reputation: 59
Export as CSV or text, and use the command line program diff to show you the differences.
 
Old 07-08-2008, 05:32 AM   #3
binary_dreamer
Member
 
Registered: Feb 2006
Distribution: debian squeeze
Posts: 185

Original Poster
Rep: Reputation: 31
hi thanks a lot for your quick reply. let's say that i got both files in home/binary
fileA.csv
fileB.csv
Will you be able to tell me how the synatx works for the diff in the csv?
 
Old 07-08-2008, 07:08 AM   #4
colucix
Moderator
 
Registered: Sep 2003
Location: Bologna
Distribution: CentOS 6.5 OpenSuSE 12.3
Posts: 10,503

Rep: Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957Reputation: 1957
man diff explains it all, e.g. do simply
Code:
diff fileA.csv fileB.csv
If you want to perform your task automatically, you may consider python and the xlrd module, an excellent piece of software to manage excel files.
 
Old 07-08-2008, 07:59 AM   #5
matthewg42
Senior Member
 
Registered: Oct 2003
Location: UK
Distribution: Kubuntu 12.10 (using awesome wm though)
Posts: 3,530

Rep: Reputation: 63
diff output is a little weird until you learn what it means. sdiff (side-by-side diff) is often easier to visualise, and there are some very nice graphical diff programs like kompare which might help.

Diff tools aisde, and depending on the sort of changes you get in the data, it might be easier to do a little magic within oocalc, or at worst case with a macro.

If you can post some example data - a before, after and when you expect the sheet to tell you - I might be able to help knock up something for you.
 
  


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
Database or Spreadsheet? johnsfine Linux - Software 9 01-22-2008 07:23 PM
Spreadsheet application deanmeyer Linux - Newbie 2 11-22-2007 02:30 PM
gnumeric, any spreadsheet klee12 Linux - Software 2 09-04-2007 10:35 AM
Spreadsheet iqbala Linux - Software 1 02-29-2004 12:25 PM


All times are GMT -5. The time now is 01:36 PM.

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