[libreoffice-users] Re: database2spreadsheet

Am 17.03.2015 um 13:22 schrieb hw:
> Am 16.03.2015 um 18:00 schrieb Andreas Säger:
> > Am 16.03.2015 um 16:21 schrieb hw:
> > > > Without any coding it is be possible to create a field of hyperlinks.
> > > > Just add a HYPERLINK formula next to the import range. The adjacent
> > > > field expands to the size of the import range.
> > >
> > > You mean to the size of the image?  It doesn't scale the images to
> > > achieve a reasonable overall layout?
> > >
> > > In this case, I could make the images all the same size; in other cases,
> > > I might have images in all different sizes ...
> >
> > Nope. I mean you can add a hyperlink to the spreadsheet which opens the
> > picture in your pic viewing program.
>
> Ok, so I want to import data from a CSV file and would like to have some
> formatting applied automatically, like specifying a particular width and
> conditional formatting for some of the columns when I open the file
> which is sent to me by email.
>
> It would be possible to write some extra data into the CSV to achieve this.
>
> How could I do this?

Simply use the database engine of your choice. The one you are already
connected with. It should provide all the capabilities to export, import
and link csv table. In this case you would not need any Office suite at
all. Office users can import csv files in the office GUI. Copying table
icons from a text connected database into a regular database or copying
spreadsheet cells onto the icon of a database table.

For the built-in HSQLDB this is described here:
[Tutorial] Using csv/text files as editable data source.
> https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=23260
And it works in the same way with later versions of HSQL.

Since you do not mention your database engine, Google is your friend.
There are thousands of hits about csv and MySQL. All this works without
any office suite and your Perl script can simply issue some SQL command
via the dbi module (I think). I'm 100& sure that an office suite can not
add anything to your project. Operate your database any way you want.
Finally you may or may not load the results into document templates.

[Example] Loading CSV into preformatted spreadsheets
> https://forum.openoffice.org/en/forum/viewtopic.php?f=100&t=23727

how to maintain prepared Calc templates to be filled with raw data from
csv (or any other kind of data source provided by the Base component).


-- 
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