[ome-devel] Spreadsheet Importer

[Ilya Goldberg]

On Aug 15, 2005, at 4:31 AM, Josh Moore wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Ilya Goldberg wrote:
>> Oh, VBA is here and now.
>> Attached is a preliminary version of an OME client built in Excel.  It
>> was built mainly for using with Find Spots but has some generality as 
>> well.
>> I'm still not completely sure what to do with it beyond Find Spots.
>> Enjoy!
>
> Rock on! Looks like I'll actully have to reboot under Windows now.

This was developed on Office X (for OS X).  Hopefully it will run on 
Windows, but I haven't tested it.  Any reports about how this works on 
Windows would be greatly appreciated.

> Could
> at least see the features in Gnumeric, but it's not the real deal.
>
> Two questions/comments (all of which may be completely obvious when
> running under Excel):
>
> - - "Query String" is generated or cut-and-pasted?

Sometimes generated, but can be cut-and pasted.
The result of a query has to end up on a worksheet somewhere, so some 
code uses it as scratch space.

> - - SampleQueries looks very sensible, especially for anyone who's also
> worked with OME-Java. Same kind of query building. Perhaps a button to
> get a list of all "Types" or all valid names for a given type, etc. (I
> assume you used psql or the web to get the values to enter here. This
> way it'd be a pure Excel environment. I'm sure you could also get
> pop-ups of the available values.)

That should be an example query - to get all STs.
No query to get all DBObjects, unfortunately.

>
> For anything else I need to be able to click buttons. But still quite 
> neat.

The FindSpots thing is all done by clicking buttons.
Hopefully there are some VBA-heads out there that can expand this 
further.

-I


>
>  ~josh.
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.5 (GNU/Linux)
> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
>
> iD8DBQFDAHz6IwpkR5bKmAsRAttJAJ4sKY2mU1uxNxXFz4J/6t6YpV2VgQCglQd0
> AXTsI6mO3jUSI+HBXJcOqU8=
> =09yl
> -----END PGP SIGNATURE-----
>