[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice
Subject:    Re: How to get data from my app to kspread
From:       Nicolas Goutte <nicog () snafu ! de>
Date:       2002-12-16 22:06:49
[Download RAW message or body]

I suppose that your problem is not to import the ASCII files one by one into 
KSpread, but that you find it too complex/long/boring... (Otheriwise, I have 
misunderstood your question.)

One way would be that your application generates KSpread files directly. They 
do not need to be zipped, as the KOffice library allows raw XML files to be 
loaded instead of zipped douments. However be careful that the file name ends 
in .ksp or the file would not be recognized as KSpread file. (The DTD is in 
koffice/kspread/dtd/kspread.dtd but be careful that the DTD might not 
represent the effectively used KSP file format. So you better look at an 
actual KSpread file to learn the file format.)

Another possibility, but a more complex one, is to generate any XML file and 
to use the XSL facility of KOffice. However, you have to write the XSL 
template yourself, so normally it is easier to chose another way to load.

Of course, perhaps you could also use any of the other file format known by 
KSpread's import filters, like: Gnumeric, Excel, DBase, Opencalc or Applix 
Spreadsheet.

In theory, you have also another posibility: to generate a file in your 
private file format and to import it in KSpread by a private import filter 
that you would have written.

I hope that at least one of the suggestion may suit you.

Have a nice day/evening/night!

On Monday 16 December 2002 21:31, Kevin E. Fogarty wrote:
> I would like to use kspread(?) to tabulate data originating interactively
> in another application - one I wrote myself (not a KDE-based application,
> but OpenGL - actually Ygl which is an IRIX-GL library clone).  For reasons
> I won't go into here, I can/will not rewrite this to use KDE.  However I
> would like to somehow get columns of numbers that are produced, as easily
> as possible into kspread so that the use can save/chart/edit them. 
> Currently I just create a series of text files (each with many rows of 2
> columns, i.e. (x,y) pairs).  These ascii files have to then be imported,
> one by one, into a spread sheet (actually it is easier in gnumeric than
> kspread as gnumeric has a more flexible text-import dialog requiring only
> "whitespace" between columns).  Anyone have a suggestion how I might think
> about approaching this?
>
> -- Kevin Fogarty
> ______________________________________________________________________
>
>  Kevin E. Fogarty                            Biomedical Imaging Group
>  Professor                                       Program in Molecular
> Medicine Department of Physiology                University of MA Medical
> Center Office:   (508) 856-3785                         Suite 114,
> Biotech-2 FAX:      (508) 856-1840                        373 Plantation
> Street Email:    Kevin.Fogarty@umassmed.edu    Worcester, MA, USA 01605
> ______________________________________________________________________
>
> ____________________________________
> koffice mailing list
> koffice@mail.kde.org
> To unsubscribe please visit:
> http://mail.kde.org/mailman/listinfo/koffice

____________________________________
koffice mailing list
koffice@mail.kde.org
To unsubscribe please visit:
http://mail.kde.org/mailman/listinfo/koffice
[prev in list] [next in list] [prev in thread] [next in thread]