At 19:43 10/11/2007 +0200, RafaÅ Maj wrote:
in OOCalc spreadsheet, I want to insert external
data from foo.csv into Sheet1; (and refresh it automatically)
But OOCalc can not find any data range to import
from that file. How to use it?
The foo.csv is a plain text file, containing 2
columns and changeable number of rows (around
100), I want column one to be in D10 to D110 and second to be in E10 to E110.
This text file is generated by external program.
I do: insert -> link to external data, select
the file, Text Import box appears showing my
data, I select both columns (or just one) and
click OK; but in the External Data, the
Available tables/ranges list is empty and OK button there is not active.
In OpenOffice 2.0.4 (linux debian)
I don't think you can do this. CSV is not a real
spreadsheet format, of course, just a way of
listing tabulated data in plain text. So there
is no way to include a data range name in the CSV
file itself. The help text for "Link to External
Data" says: 'To import data from a *.csv or *.txt
file, choose File - Open and then select the
Files of type "Text CSV".' This seems to confirm
that you cannot do what you want. You can import
the data, of course, but you cannot do so with a
link so that the values are automatically updated.
Here is a workaround:
o Open your CSV file in a text editor and select and copy all the text.
o Paste into an empty sheet of your spreadsheet.
o Construct the rest of the spreadsheet to
incorporate the values from this sheet appropriately.
o Each time your CSV file changes, just copy and
paste it into the original sheet, replacing the previous values.
If you particularly didn't want the CSV sheet
itself to appear in the spreadsheet, you could do
this indirectly, pasting the text from the CSV
file into another spreadsheet in which the data
range is already defined and which file is
already linked from your real spreadsheet.
Unless anyone knows better ...
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
