I don't think that the verb readxlsheets that is defined by
tables/tara supports reading more than one file at a time and I'm not
sure that it calls readexcel_biffread_ either. Is it possible that
there is a name collision here between a verb you have written and one
from the addon both called readxlsheets ?
Here are the docs for the built in readxlsheets:
namedoc 'readxlsheets'
readxlsheets (v) Reads one or more sheets from an Excel file
returns: 2-column matrix with a row for each sheet
0{"1 boxed list of sheet names
1{"1 boxed list of boxed matrices of sheet contents
y is: 1 or 2-item boxed list:
0{ filename of Excel workbook
1{ [default 0] optional switch to return all cells contents as strings
x is: one of [default is 0]:
* numeric list of indicies of sheets to return
* boxed list of sheet names to return
* '' - return all sheets
EG: 0 readxlsheets 'test.xls'
reads Excel Versions 5, 95, 97, 2000, XP, 2003
biff5 excel 5 biff7 excel 97 biff8 excel 97, xp, 2003
On Wed, Aug 15, 2012 at 10:52 AM, bill lam <[email protected]> wrote:
> 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
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
