OpenSesame: @DbColumn on a spreadsheet
Thu 22 Mar 2007, 11:58 PMTweet
by Ben Langhinrichs
Copyright © 2007 Genii Software Ltd.
What has been said:
572.1. Tim Tripcony (03/22/2007 10:43 PM)
Whoa. Now that's cool. Just curious, are you anticipating that UNC paths will be supported for the file location?
572.2. Ben Langhinrichs (03/23/2007 03:31 AM)
Certainly. They work now. I just tried
@DbColumn("OpenS"; "\\\\hamster\\cdrive\\share\\trial.ods"; "Sheet1"; "F4-F999");
and it works fine (\\hamster being a shared network drive here where I copied the file). Watch for the parameters possible for @DbLookup, as I think they are very cool (Rocky Oliver helped me think them up).
572.3. Ben Langhinrichs (03/23/2007 04:41 AM)
I should also point out that when this ships, it should also work with an attached ODS file, probably with the syntax:
@DbColumn("OpenS"; @DbName; @DocumentUniqueID; "MyInvoice.ods"; "Sheet1"; "F4-F999");
and there may be other variations. It is just likely people would want to act on an attached spreadsheet.