[scribus] Importing tables

[Jean-Paul Gendner]

Hello,

	I posted the two last messages 4 week ago as I was not recognized on
the list. So they are out of interest.

	Regards,
	Jean-Paul

****************
Jean-Paul Gendner
Site : f5bu.fr
03.88.27.03.44

-----Message d'origine-----
De : Jean-Paul Gendner [mailto:jean-paul.gendner at orange.fr] 
Envoyé : mardi 17 juin 2014 13:25
À : 'Scribus User Mailing List'
Objet : [scribus] Importing tables

Hi,

 

As I mentioned in my preceding message, I had difficulties to import a table
with the Importcsv2Table script.

            First, I do a mistake, because I used an old version of Excel to
create the csv file. So the file was not coded in utf-8 with the
consequences for the French accentuated characters! Doing the same with Open
Office works well.

            The table I had to import had 11 columns and 6 rows. So after
importing with the script, I had to attribute a style to each cell (I do not
found to do that globally) and to define a top margin which is easy to
duplicate with the copy tool.

            So, I made a script based on the Importcsv2Table with more
possibilities. Here the description of use:

 

ABOUT THIS SCRIPT (modified by J.-P. Gendner June15 2014):

Import CSV data files as tables into Scribus

1. You may create a style to be aplied to all cells of the table

2. Create a frame at the position (upper left corner) 

and of the size (height and width) you want for your table

3. Make sure it is selected

4. Execute this script:

  You will first be prompted for the csv data filename.

  ->  The number of columns and row will be displayed.

  You will then be prompted for the width of each column in mm.

  ->  The default value given is calculated to respect the width of the
table.

  Then you will be prompted for the height of each row.

  ->  The default value is calculated to respect the height of the table.

  Then you may enter the style name you want to be applied to each cell.

  Finally, you may enter the Top distance for all text.

5. The data from the csv file will be imported and a table of

textboxes will be drawn on the page.

 

LIMITATIONS:

   In Scribus versions 1.3.5svn, when the script ends, you cannot

adjust text, colors, and line features for a group, whereas in 1.3.3.x,

all of these can be done without ungrouping.

 

            Of course, I am ready to share this script; however, I do not
know how to do that?

 

            Regards,

            Jean-Paul

 

****************

Jean-Paul Gendner

Site : f5bu.fr <http://www.f5bu.fr/> 

Tél: 03.88.27.03.44

 

P  Afin de préserver notre environnement, n'imprimer ce courriel que si
nécessaire

 

-------------- section suivante --------------
Une pi?ce jointe HTML a ?t? nettoy?e...
URL:
<http://lists.scribus.net/pipermail/scribus/attachments/20140617/a23ae987/at
tachment.html>
___
Scribus Mailing List: scribus at lists.scribus.net
Edit your options or unsubscribe:
http://lists.scribus.net/mailman/listinfo/scribus
See also:
http://wiki.scribus.net
http://forums.scribus.net