[Jprogramming] J-to-Excel Question

[bill lam]

No, you can't. AFAIK Excel only provides oleautomation for programming 
interface.  You may read the entire workbook and recreate it together with new 
worksheets yourself.

Leigh J. Halliwell wrote:
> Dear J Forum:
> I'm designing a J application that reads data from an Excel workbook and an
> produces several array results.  I would like to return each array as a new
> worksheet in that workbook, and save the augmented workbook.  The "Tara and
> Excel" lab shows only how to create new workbooks, not how to add sheets to
> existing ones.  How can I do the latter?  Or should I use something other
> than the Tara package?  My knowledge of OOP is rudimentary (I learn as I
> go), so please try to keep things simple.  Thanks.
> Sincerely,
> Leigh
> Leigh Joseph Halliwell, FCAS, MAAA
> Chief Manager
> L. J. Halliwell, LLC
> 406 Gibson Pond Rd
> Chattanooga, TN  37421-5368
> 423-296-2739
> 423-605-5789 cell
> 423-954-2772 fax
>  <mailto:lhalliwell at epicactuaries.com> leigh at lhalliwell.com
>  <http://www.lhalliwell.com/> www.lhalliwell.com
> This communication is intended solely for the use of the individual to whom
> or the entity to which it is addressed. It may contain information that is
> privileged, confidential, and exempt from disclosure under applicable law.
> If you are neither the intended recipient, nor the employee, nor the agent
> responsible for delivering the communication to the intended recipient, you
> are hereby notified that any dissemination, distribution, or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by telephone or email,
> delete the communication from any computer or other electronic storage
> media, and destroy all other copies in your possession.
>  
> 
> 
> ------------------------------------------------------------------------
> 
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm


-- 
regards,
bill