Is it possible to feed Open Office via STDIN?

Question

I have an Open Office Spreadsheet document stored inside a bash variable. I want to do something like the following to feed Open Office via STDIN:

echo "$openOfficeDoc" | ooffice

But it doesn't work.

Note: The content of the bash variable must not be written to disk.

I'll emphasize that I'm trying to pass to Open Office the actual data of the file.

I'm trying to store passwords in an Open Office Spreadsheet file. The passwords are encrypted using GPG. I don't want the passwords to be written to disk for security reasons.

The bash variable value is a binary blob of an Open Office Spreadsheet document. It is not ASCII.

The bash code I used to create the blob is:

data=$(cat "Encrypted.gpg" | gpg -u "Dor" -d)

While Encrypted.gpg is an encrypted file of an Open Office Spreadsheet.

Is it possible to feed Open Office via STDIN?

Answer 1

I don't think OpenOffice can be convinced to read from its standard input. But that doesn't matter. Just write the data to a temporary file.

You don't want the passwords to be written to disk. That's fine. Write them to a file that isn't stored on disk.

Many systems use an in-memory filesystem (tmpfs) for /tmp. Solaris has been doing that for ages; Linux distributions have been slow to come to the mix (Fedora 18 adopted it, Debian and Ubuntu still haven't budged) so it usually requires the system administrator to set it up manually. However, modern Linux distributions mount a tmpfs filesystem somewhere; recent versions of the standard library require it. The standard location for tmpfs is /run, with /run/shm being world-writable (same permissions as /tmp), but some distributions may not have it yet; look at /dev/shm and perhaps other locations.

Answer 2

Importing textual data

Your questions isn't entirely clear to me but it almost reads as if you have data that you want to import into OpenOffice. If that is the case then I would use one of these approaches below.

CSV file

I'd write that data out to a CSV file (.csv) and then open that file in OpenOffice.

csv2odf

Another idea would be to use the command line tool csv2odf to write your CSV formatted data into an ODF file.

• http://sourceforge.net/apps/mediawiki/csv2odf/index.php?title=Main_Page

Real file

Just opening a file

However if you're simply just trying to open a ODF document from the command line then you should be able to do it like so:

$ openoffice "$openOfficeDoc"

Importing binary data

Piping contents to OpenOffice

In looking at this several ways I do not believe there is a method that will allow you to do the following:

$ echo "$data" | openoffice

The limiting factor is not Linux though. You can echo data stored in variables just fine, and pipe it to tools that know how to open incoming file data on their STDIN.

Example

$ echo $data|strings| head -10
[Content_Types].xml 
E`2+
)+Bp_9
no+yV
2q^QF
M xv
C1lA
d:NA
_rels/.rels 
b"gi

The limiting factor here is OpenOffice. In looking through it's options I saw no method for coaxing it to open data via STDIN. It only knows how to open files.

Answer 3

Use an anonymous pipe as the file:

ooffice <(echo "$openOfficeDoc")

See also https://stackoverflow.com/questions/345505/how-can-you-diff-two-pipelines-in-bash

Answer 4

There is a zsh-only solution:

oofice =(echo $openOfficeDoc)

I use it a lot with a cli tool of mine that outputs some csv (with libreoffice, but it's the same idea).

If you want to stick with bash, you can still install zsh and invoke it just for this command:

TMP=$openOfficeDoc zsh -c 'oofice =(echo $TMP)'

NOTE: The zsh/bash <() notation does not work with ooffice/libreoffice according to my test, see a possible explanation why.

Answer 5

This is not really an answer to your question, but a complete alternative to what you're currently trying to do: just use either a password manager like Revelation, or store your passwords as GPG-encrypted plain text.

Answer 6

Both Apache Open Office and Libre Office have the ability to save a file with a password - encrypting it with, e.g., blowfish or AES.

Look for the "Save With Password" checkbox on the "Save As" dialog box. You will then be prompted for the password and to confirm the password.

Answer 7

Open/Star/Libreoffice can receive data from STDIN via the Python-UNO bridge. The Input can then go into any Libreoffice document, here it is a Writer document.

This was tested on Ubuntu 16.04 with Libreoffice5. You need a python interpreter which has the uno libs included ! Libreoffice needs to be started as a service:

# soffice "--accept=socket,host=localhost,port=2002;urp;" --writer

# echo "test" | ./reader_uno.py

#!/usr/bin/python3
import sys
import uno
localContext = uno.getComponentContext()
resolver = localContext.ServiceManager.createInstanceWithContext(
                "com.sun.star.bridge.UnoUrlResolver", localContext )
# connect to the running office
ctx = resolver.resolve( "uno:socket,host=localhost,port=2002;urp;StarOffice.ComponentContext" )
smgr = ctx.ServiceManager
# get the central desktop object
desktop = smgr.createInstanceWithContext( "com.sun.star.frame.Desktop",ctx)
# access the current writer document
model = desktop.getCurrentComponent()
# access the document's text property
text = model.Text
# create a cursor
cursor = text.createTextCursor()
# read from STDIN and insert the text into the document
for line in sys.stdin:
  sys.stdout.write(line)
  text.insertString(cursor,line, 0 )
ctx.ServiceManager

More details can be found on my blog "bitkistl".
http://www.bitkistl.com/2016/02/libreopenstaroffice-hints-and-tips.html