Ric Sherlock tikkanz at gmail.com Wed Oct 26 06:45:38 HKT 2011
The following will read all the sheets in a workbook: readxlsheets 'myfile.xls' NB. reads first sheet in workbook 0 readxlsheets 'myfile.xls' NB. reads first sheet in workbook '' readxlsheets 'myfile.xls' NB. read all sheets in workbook check out the lab for Tara. ----- Yes, I did that, and what I need is then t1=: 0 readxlsheets 'myfile.xls' to be able to do writestring__t1 0 0 ; 'my text' |rank error: t1 | writestring__t1 0 0;'my text' No wonder, t1 is array when bi in the example bi=: '' conew 'biffbook' is a locale (at least not an array). How can a get the structure, like associated with bi above, with content of existing file - not the empty workbook created with '' conew 'biffbook'? I'd like to be able to modify that and then save in another file. Thanks, Alex ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
