LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
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 10-24-2012, 01:39 AM   #1
monsteriname
LQ Newbie
 
Registered: Sep 2009
Distribution: mandy 2010 spring, maggie 3 and 4
Posts: 24

Rep: Reputation: 0
Can I use XLSperl, xlsgrep.pl, perl-spreadsheet-read, someting else? Calc spreadsheet


To do an automated daily search of our Calc spreadsheet I have been doing this;

Exploding the Calc spreadsheet with ark, then grepping through the "content.xml" for
full strings (with small amounts of regexp thrown in to the greps) to return the equivalent
of the full row of info.

I don't normally have to change parameters often, but when I do it kinda sucks. We recently
changed that Calc spreadsheet by adding a few columns and changing the cell formatting
of a couple of existing cells. This change is going to call for a larger reworking of
my grep script.

I want to take the opportunity to find and use a utility that would do the pre-parsing for
me, i.e. return the full row, if it finds a partial match from predefined list. I can
then finish working with the row of data.

I am getting lost just trying to find (if there is) a utility and how to
use it. I see things like XLSperl, xlsgrep.pl, perl-spreadsheet-read, that I had hoped
were utilities I could use similar to sed and grep.

If there is one, what utility might do what I'm after and should be the most likley to
run without lots of configuration to do, or programming knowledge (perl or otherwise)?

I am asking instead of "just trying them to see for myself" because;
I have yet to get any of the above to even pretend they were going to run, much less
start playing with them, and so, because I am most likley going to have to ask for help and
spend time just getting a utility to run, I want to choose it ahead of time.

Thanks for any help,

UPDATE;
First, thanks chrism01.
I went and looked around PerlMonks, it looks like a fun (and helpful) community, makes me wish I had time to learn some perl.
Anyhow,
I'm not an office type person, that is to say I've never worked with any office applications or documents myself (other than this one Calc spreadsheet). I didn't realize what a .csv was until just now. Its so easy to just use libreoffice from the command line with the --invisibile switch and convert the .ods to a .csv, then grep and sed to my hearts content. I wish I would have realized that two years ago.

Last edited by monsteriname; 11-02-2012 at 09:39 AM. Reason: found a solution but don't want to drag up an old thread
 
Old 10-24-2012, 06:32 AM   #2
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.5, Centos 5.10
Posts: 16,280

Rep: Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032
Definitely sounds like something I'd use Perl for.

You could search over at search.cpan.org, which is where you'll find all the Perl modules, but to save time and get expert advice I'd also post this qn over at www.perlmonks.org;, its where the Perl gurus hang out (inc the ones that do Perl internals).

I'd also consider asking the Mods here at LQ to move this to the Programming forum (use the Report button).

Good Luck
 
  


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
system froze when I clicked Save for Calc spreadsheet, now the spreadsheet is gone Stringdude Linux - Newbie 2 11-24-2010 01:05 AM
I got switched from a word process doc. into spreadsheet form. now ALL is spreadsheet 293 manzanita Linux - Newbie 1 08-04-2010 01:14 PM
Linux (Ubuntu) OpenOffice Calc Spreadsheet ... rktompsett Linux - Software 1 07-11-2009 09:45 AM
load exel spreadsheet into ooo calc? Matthew O'Brien Linux - Newbie 1 04-25-2008 04:21 PM
Calc Spreadsheet VLOOKUP Question win32sux Linux - Software 4 12-08-2007 08:29 PM


All times are GMT -5. The time now is 07:32 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