I try it on win7,found another question:
if I use (i.3 4) writexlsheets jpath '~temp/temp.xls' to create a temp excel file,than readxlsheets jpath '~temp/temp.xls' readxlsheets: file not found but, fexist jpath '~temp/temp.xls' 1 **** if I create a temp1.xls file by right click -> creat new excel... readxlsheets jpath '~temp/temp.xls' works well At 2012-05-20 18:32:30,"Piet de Jong" <piet.dej...@mq.edu.au> wrote: >Thanks for your help and suggestions. > >I can get it to work now using "jpath". > >But I don't understand why jpath is needed. For example if I define > >xlwrite=:writexlsheets jpath > >The using xlwrite allows me to point to any folder/file for writing eg > > (i.2 2) xlwrite '~/Documents/junk3.xls' > >writes the file "junk3.xls" to the Documments folder etc. > >But what is the point of "jpath"? > > >On Sun, May 20, 2012 at 10:17 AM, bill lam <bbill....@gmail.com> wrote: >> I tested it ok on linux jconsole and gtkide but no Mac available for testing. >> >> Will it be related to file permission? Try if if will work for your >> home directly. >> >> (i.5 7) writexlsheets jpath '~/junk.xls' >> >> Вск, 20 Май 2012, Piet de Jong писал(а): >>> I run Jgtk701 on a mac. >>> >>> Tara works fine except that I cannot specify/control where >>> spreadsheets are written or read - ie the directory information. >>> >>> For example >>> >>> (i.5 7) writexlsheets 'junk.xls' >>> >>> writes the spreasheet into the 'j701' foloder. When I try and >>> change things to eg >>> >>> (i.5 7) writexlsheets '/Mactinosh HD/junk.xls' >>> writexlsheets: error creating/writing later sheets >>> 0 >>> >>> This no matter whatever folder/directory information I give it. >>> Any attempt to modify the folder/directory information gives an error as >>> above. >>> >>> Please help. >>> ---------------------------------------------------------------------- >>> 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 > > > >-- >Piet de Jong >-------------------------------------------------- >View my current research at >http://ssrn.com/author=619154 >-------------------------------------------------- >---------------------------------------------------------------------- >For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm