Re-reading your initial statement, I now think that my comment was not informative nor useful.
"File not found" can mean any of a variety of problems. Rebooting windows fixes some of them. If I were having this problem (and I avoid using excel because I have had to deal with this kind of problem too often in the past -- back in the windows 3.1.1 / windows 4.0 days), I would try to see if the problem can be isolated to a specific file, or if there's any kind of timing issue (sometimes windows is slower than you might think, about propagating changes to the file system so that programs can see them. Meanwhile, "file not found" without knowing which specifically file is not found is not a helpful message. I would be tempted to rewrite that bit of code so that it reports on the file which was not found. That said, you said that you last ran successfully on July 25 and that Tara was updated on July 25. So my initial suspicion would be that the July 25 change to Tara is the root cause of this issue. -- Raul On Tue, Aug 14, 2012 at 5:58 PM, Raul Miller <[email protected]> wrote: > 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
