Franco Fornari schrieb:
Hi Andreas,
yes, I certainly agree with all your suggestions, but the data I was
referring to come from the web in Excel format. Then, each time I'd have
to delete the old tables in my database and import the new ones from the
spreadsheet ,again. This is doable, sure, but I'd prefer, each time,
overwrite the spreadsheet, only. That's all. ;-)
Ciao,
Franco
I see. The sender is the problem.
Assuming you have got some document from the web, saved at URL
file://path/spreadsheet.ods, having a sheet named "Data" with some list
("database-table") in range A1:Mxxxx
Open your working document.
Hit Ctrl+F3
Name: Import
Assigned to: 'file://path/spreadsheet.ods'#$Data.$A$1:$M65536
Now call Edit>Links ...
The dialog shows a spreadsheet-link and offers some commands:
- You can update the link (details below)
- You may change the source-file (which unfortunatly needs to have an
equally named sheet "Data"!)
- You may break the link, which won't be successfull as long as anything
references the external data.
Call Format>Sheet>Show...
You've got a data-copy (no formulas) of the "Data" sheet. The copied
sheet is named 'file://path/spreadsheet.ods'#$Data
When you refer to either one of 'file://path/spreadsheet.ods'#$Data or
named range "Import" in some formula, then you actually refer to this
sheet. You do not access the source file. It works even when the source
file has been moved.
When you get a new file://path/spreadsheet.ods, having a sheet named
"Data" with some list ("database-table") in range A1:Mxxxx, then you
just have to call Edit>Links>Update in order to replace the data on
hidden sheet 'file://path/spreadsheet.ods'#$Data.
There is another kind of links. See help on function DDE(). This wil not
create a hidden sheet. The file will be loaded invisible instead. So it
needs to be accessible. This kind of link can be set to automatic update
on recalculation.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
