[libreoffice-users] Re: What's needed for reading and writing an excel o spreedsheet file from Java

Le 06/08/13 16:08, Edwin F. López A. a écrit :

Hi,

> I saw the examples of libre office for openning an Excel file, and was
> wondering what is required to create a java application that uses
> LibreOffice UNO runtime for such a task. That is, use LibreOffice for

You need a running instance of LO (which can be invisible to the user)
that accepts connections.


> openning and manipulate Excel files from within a Java application (like in
> the examples: http://api.libreoffice.org/examples/java/ToDo/ToDo.java).

LO converts an XLSX file (via a filter) to data structures that the ODF
parser understands and stores the data structures in memory. The larger
the Excel file, the longer it takes to parse those structures and
manipulate them in RAM. You may find that this solution doesn't scale
well for you either on large files such as the ones you are envisaging.
I don't use LO enough with large files in this way to say.

Your best chance of getting a more comprehensive answer would be to ask
your question on the libreoffice developer list, or look out for Markus
Mohrhard, Eike Rathke or Kohei on the libreoffice developer IRC, they're
the main LO Calc experts.


Alex



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted