[jopendocument] Re: Support in-memory sheets (and documents read from an URL)

[Sylvain Cuaz]

Cafebabe a écrit :

The SpreadSheet-API is very File-oriented. I would like to see a way
of reading SpreadSheets from an URL or from an in memory byte array:

SpreadSheet createFromFile = SpreadSheet.createFromUrl( new URL
(url) );

and

byte[] bytes = ...
SpreadSheet createFromFile = SpreadSheet.createFromBytes( bytes );

Or in general an InputStream. This is much more flexible than a File.

SpreadSheet.create( inputStream );

Instead of saveAs() to a File I would like to see an OutputStream

OutputStream  baos = new ByteArrayOutputStream();
sheet.getSpreadSheet().saveAs( baos );

Hi,

        For both you need to use ODPackage :
- SpreadSheet.create(new ODPackage(InputStream))
- SpreadSheet.getPackage().save(OutputStream)

HTH,
Sylvain