[Jprogramming] Reading Excel Files

[bill lam]

Leigh J. Halliwell wrote:
> Dear J Forum:
> I'm studing the Tara lab, and learning how to use the readexcel function.
> The y argument is the filename and the x argument is the worksheet tab.  But
> instead of a whole worksheet, I'd like to read just a named range.  Can I do
> that in the Tara package?

I think that it can be done but you have to do more work. There is a dumpexcel
verb in tara to dump all records in an excel file, search for the record
containing the named range, and from that the position of cells of the range can
be determined.

I seems much easier to do it with oleautomation.

-- 
regards,
bill