The message "readxlsheets: file not found' might be a mis-information, and the actual error not related to file not found. The latest changes were some minor update in Tara for working with xls2cvs.
There is a try/catch structure in the top level cover verb. Remove the try keyword and commenting the catch block, truning on debugger and run to let it suspend at the point of failure, and see what has gone wrong. Втр, 14 Авг 2012, Bill Harris писал(а): > 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 -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
