[libreoffice-users] Re: Batch for extracting lines into new files in CALC

Am 18.01.2012 14:56, Calvin Kim wrote:
> I usually convert it to .csv and extract data with PHP, but I love to
> see how to do it with Calc.
> cK

Manually without any coding:
Connect a registered Base document to the spreadsheet. A connection to 
an indexed dBase copy might be more performant.
Create a parameter query: SELECT * FROM "Table" WHERE "Column"= :p
Create a Calc template with an import range bound to that param query.
Bind some shorcut to command "refresh data range", say Ctrl+R
Declare the template as default template.
Switch to xls as default file format.

Ctrl+N gets a new document.
Ctrl+R prompts for parameter :p. Enter 1 and wait for the import to 
complete.
Ctrl+W closes this document prompting for the xls file name. Enter 001.

Repeat these 3 steps until you are finished.


--
For unsubscribe instructions e-mail to: users+help@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