Am 17.01.2012 17:23, tk5ep wrote:
Hi All,
I have a 130000 lines CALC file.
I need to :
- filter the lines according a criterion
- export these lines to a new XLS file named after this criterion
- email the file
this has to be done about 500 times (criterions)
Has anybody a solution ??
Thanks for any help,
--
View this message in context:
http://nabble.documentfoundation.org/Batch-for-extracting-lines-into-new-files-in-CALC-tp3666623p3666623.html
Sent from the Users mailing list archive at Nabble.com.
Leave behind all spreadsheets. There is no technical reason nor
convenience factor in favour of using spreadsheets with a database dump
of raw data.
The dBase driver of the Base component supports indexing for fast
lookups within millions of rows.
Save as dBase in a *dedicated directory*. dBase is a database in a
directory.
Connect a Base document to the *directory*.
Open the table for editing and add some indices on relevant fields.
Create a set of simple queries. Parameter queries are supported.
Video tutorial on something similar with a small amount of data in a
sheet:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=40403&p=186845&hilit=+parameter#p186158
--
For unsubscribe instructions e-mail to: [email protected]
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
