Ric, yes, you are right. That actually does not work. An alternative is to create a workbook from scratch with the content of the original book just manipulated a bit by J & Tara. Cheers---Christoph
On 3/14/07, Sherlock, Ric <[EMAIL PROTECTED]> wrote:
Christoph, I think the issue is creating a new worksheet in an Excel workbook that already exists. Tara can create new worksheets as it builds a new workbook, but from my reading of the lab (and as Bill mentions) the only way to add a new worksheet to an existing workbook, using Tara, is to read in the whole existing workbook, recreate the workbook then add the new worksheet(s). The OLE approach that Devon suggests enables you to "edit" the existing workbook and save it. Ric > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Christoph von Basum > Sent: Wednesday, 14 March 2007 20:54 > To: Programming forum > Subject: Re: [Jprogramming] J-to-Excel Question > > Tara can add any number of worksheets; see the lab, chapter > 3, lesson 20 of 25. The magic instructions are: ... Stuff deleted > It works perfectly fine in my J2XLS environment. > > Cheers---Christoph > > On 3/14/07, Devon McCormick <[EMAIL PROTECTED]> wrote: > > > > Oh - I see I've already done that. Look at "addWS" in OLEExcel.ijs > > which is as follows: > > > > > On 3/13/07, bill lam < [EMAIL PROTECTED]> wrote: > > > > > > > > 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. > > > > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
