As near as I can tell, readxlsheets should be defined in tara's jbiffread.ijs
-- Raul On Tue, Aug 14, 2012 at 5:51 PM, Bill Harris <[email protected]> wrote: > I'm buffaloed by a seemingly related problem I just encountered. > > I have a program I wrote about 3 years ago (and have updated since > then) that pulls in some number of Excel XLS files, parses out > variable-sized rectangles of cells, pulls those into a J array for > further processing, and eventually writes an SQLite file. I've > packaged all that up as a standalone program, so it doesn't change > easily without my rerunning Inno Setup. > > It's worked up to as recently as 2012-07-25, judging by the timestamp > on the current sqlite file. I'm running > > 9!:14 '' > j602/2008-03-03/16:45 > > and tables/tara 1.2.17. Pacman shows no packages in need of updating. > > When I try to run it today, I get an error. Running it from a command > in an ijx shell gives me "readxlsheets: file not found' plus a > wdhandler dialog box that includes > > index error: readexcel_biffread_ > variable =: 'SHEET' readexcel"1 (_1&}.) DDIRold,"1 FNAME > > where FNAME is an unboxed 12 by 14 array of FQFNs (and, yes, I do > intend to drop one of the names). > > The files all exist: > > fexist"1 (_1&}.)DDIRold,"1 FNAME > 1 1 1 1 1 1 1 1 1 1 1 > > I saw the jpath issue between tara and other verbs, but I don't think > that's the problem, as each file name starts with b:, ends with .xls, > and has all the intervening directories, file names, and slashes in > between. > > According to Windows Explorer, nothing has changed in those XLS files > since June 26, 2012 for one file and since 2011 or before for the > others. I repeated the test just on one file that hasn't changed > since 2008 and get the same result. According to Emacs Dired, the J > scripts haven't changed since November 4, 2011. > > The only things I can think of that are left as possible changes are J > packages or Windows XP. If I understand > http://www.jsoftware.com/jwiki/JAL/Build%20Log, there have been no > updates to tara since July 25. > > So I suspect I'm over-thinking this. Has anyone seen anything related > to this? Has anyone made a change that might account for this > behavior? Should I just jump into debug and see what I can suss out? > Is there something better than biffread to check out? > > Thanks, > > Bill > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
