Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 07-08-2008, 03:21 AM   #1
Registered: Feb 2006
Distribution: debian squeeze
Posts: 199

Rep: Reputation: 31
spreadsheet comparison

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, 03:51 AM   #2
Mr. C.
Senior Member
Registered: Jun 2008
Posts: 2,529

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

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

Rep: Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983
man diff explains it all, e.g. do simply
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, 08:59 AM   #5
Senior Member
Registered: Oct 2003
Location: UK
Distribution: Kubuntu 12.10 (using awesome wm though)
Posts: 3,530

Rep: Reputation: 65
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.


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 08:23 PM
Spreadsheet application deanmeyer Linux - Newbie 2 11-22-2007 03:30 PM
gnumeric, any spreadsheet klee12 Linux - Software 2 09-04-2007 11:35 AM
Spreadsheet iqbala Linux - Software 1 02-29-2004 01:25 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 05:04 PM.

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
Open Source Consulting | Domain Registration