At 20:11 18/12/2010 +0000, Mark Knecht wrote:
Is it possible to link two Sheets in a Calc spreadsheet to two external CSV files?
Yes.
I have two programs which generate (hopefully) identical data in CSV format. I need to check for differences on maybe a daily basis. Doing the compare is easy once I've loaded the data into Calc but I'd rather make it a link so that all I have to do is open the Calc spreadsheet, have it read the contents of the existing files and then have it do the compare. I tried inserting a Link to External Data and putting the file name in but at that point it doesn't seem to allow me to do anything. OK never becomes active.
That's because - referenced this way - the external data must be located in a table or named range. In the External Data dialogue, available names in the linked file are listed in the lower panel; if any exist, the OK button becomes active. CSV doesn't support names, I think.
Is there a way to do this?
Yes. Use Insert | Sheet from File..., browse to the .csv file, and tick the Link box in the Insert Sheet dialogue. You'll want two sheets linked to your two data files and a third sheet (probably in front) in which to perform the comparison.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
