Hi Mike, I can only comment on the writexlsheets/writeshtdat. You are correct that writexlsheets writes a whole file. The tables/tara addon only allows you to write a new .xls file. You can't open a file, edit/change it and then save it again. writeshtdat won't help you with what you are trying to do. It is just abstracts out the code for writing to a new sheet. Hopefully Bill will have better news with regards to wdoowrite. Regards, Ric
On Fri, Jul 5, 2013 at 9:16 PM, Mike Day <mike_liz....@tiscali.co.uk> wrote: > (copied to Bill & Ric) > > I suspect Bill Lam and/or Ric Sherlock are the people are the people to > ask here, and but I'll ask the forum as a whole anyway: > > I've just acquired a new laptop and am enjoying learning 64-bit Windows 8. > I'm loth to pay big pounds for Office 2010 or whatever. My 32-bit Windows > 7 still supported my old Office 2003 but that doesn't run in Win 8. I've > downloaded Open Office which seems to be well thought of as an alternative > to M/S Office. > > I wonder how to continue do the following, which worked under Windows 7 > > I have a multi-worksheet xls file. > My J application successfully reads one small named worksheet, not the > first, using readexcel . > It uses that information and wished to modify the contents of that > worksheet ONLY. > Under Windows 7 it successfully called wdoowrite to do this. > However, I find the workbook is not updated on the new machine. > > I had used wdoowrite rather than writexlsheets as it appears that the > latter overwrites the whole file, but I might have misunderstood it. > It looks as if writeshtdat might do the job, but I'm not sure what locale > info to offer as the x argument. > > Advice would be welcome! > > Thanks > > Mike > > > > ------------------------------**------------------------------**---------- > For information about J forums see > http://www.jsoftware.com/**forums.htm<http://www.jsoftware.com/forums.htm> > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
