Linux Format forums Forum Index Linux Format forums
Help, discussion, magazine feedback and more
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Scripted spreadsheet update

 
Post new topic   Reply to topic    Linux Format forums Forum Index -> Programming
View previous topic :: View next topic  
Author Message
Nox



Joined: Wed Jul 03, 2013 6:29 am
Posts: 14
Location: Ohio, U.S.A.

PostPosted: Tue Sep 10, 2013 1:37 pm    Post subject: Scripted spreadsheet update Reply with quote

Any known way to append to a spreadsheet from a shell script?

Even if I have to use the script to run something else to do this, I just need it to happen on its own.

Ideally I'd like to take a comma deliminated file and tack it onto a shiny Libre Office Calc file.
Back to top
View user's profile Send private message
johnhudson
LXF regular


Joined: Wed Aug 03, 2005 2:37 pm
Posts: 871

PostPosted: Tue Sep 10, 2013 10:26 pm    Post subject: Reply with quote

If you mean add it to an existing file, possibly

loffice -o [filename] [script]

I guess the [script] bit because that is how I routinely opened Supercalc files in order to add data in the 80s.

If you mean a new file

loffice -o [filename] --infilter="CSV"

I guess "CSV" by analogy with other examples because I cannot find a list of all the command line filters.
Back to top
View user's profile Send private message
Nox



Joined: Wed Jul 03, 2013 6:29 am
Posts: 14
Location: Ohio, U.S.A.

PostPosted: Wed Sep 11, 2013 6:30 am    Post subject: Reply with quote

Thank you!

Your info got me around to this:
https://help.libreoffice.org/Common/Starting_the_Software_With_Parameters

Which looks like it should get me where I want to be if its possible. It's currently tossing a Fontconfig warning, but it doesnt seem to be a fatal error.

If I get the whole thing to play nice I'll post it here.
Back to top
View user's profile Send private message
View previous topic :: View next topic  
Display posts from previous:   
Post new topic   Reply to topic    Linux Format forums Forum Index -> Programming All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Linux Format forums topic RSS feed 


Powered by phpBB © 2001, 2005 phpBB Group


Copyright 2011 Future Publishing, all rights reserved.


Web hosting by UKFast