Re: Java Error xlsread

[Tatsuro MATSUOKA]

----- Original Message -----
> From: adrianc852 
> To: help-octave@
> Cc: 
> Date: 2015/3/31, Tue 13:54
> Subject: Re: Java Error xlsread
> 
>T hanks for the reply.  I received this error message when I tried to install
> the io  package.
> 
> 
> pkg install -forge io
> warning: rmpath:
> C:\Octave\Octave-3.8.2\lib\octave\packages\io-2.2.7\i686-w64-mingw32-api-v49+:
> not found
> 
> warning: (Automatic loading of spreadsheet I/O Java classlibs failed)



I have downloaded the latest 3.8.2-5 from mxeoctave.osuv.de
and
>> cd C:\octave\Octave-3.8.2\src
>> build_packages
>> pkg load windows
>> pkg install -forge io



+ ## PKG_ADD
+ ## add paths of io pkg java jars.

+ ## First check if Java support was built in anyway
+ if (octave_config_info ("features").JAVA)
+   ## OK, Java built-in / supported. Check environment var
+   userdir = getenv ("OCTAVE_IO_JAVALIBS");
+   if (ispc)
+     homedir = getenv ("USERPROFILE");
+     ## (MinGW) assume jar files are in /lib/java
+     libdir = octave_config_info ("libdir");
+     ## elseif (ismac)
+     ##   ## Who knows where OSX keeps e.g., Apache POI stuff? if it does at al
l...
+   elseif (isunix)
+     homedir = tilde_expand ("~");
+     ## On linux spreadsheet .jars are often found somewhere in /usr/share/java

+     libdir = "/usr/share";
+   else
+     ## Set libdir to "." to avoid searching in a root dir
+     libdir = ".";
+   endif;
+   ## Find LibreOffice or OpenOffice.org
+   ooopath = '';
+   ii = 0;
+   ## Possible locations for  OOo or LO.
+   bnam = {"C:/Program Files (X86)", "C:/Program Files", "C:/Programs", "/opt",
 "/usr/lib"};
+   if (strcmpi (octave_config_info ("USE_64_BIT_IDX_T"), "yes"))
+     ## 64-bit Octave won't work with 32-bit LibreOffice/OpenOffice.org
+     bnam (1) = [];
+   endif;
+   while (isempty (ooopath) && ii < numel (bnam))
+     ooopath = glob ([bnam{++ii}, filesep, "[Ll]ibre[Oo]ffice*"]);
+   endwhile;
+   while (isempty (ooopath) && ii < numel (bnam))
+     ooopath = glob ([bnam{++ii}, filesep, "[Oo]pen[Oo]ffice.org*"]);
+   endwhile;
+   while (isempty (ooopath) && ii < numel (bnam))
+     ooopath = glob ([bnam{++ii}, filesep, "ooo*"]);
+   endwhile;
+   if (!isempty (ooopath))
+     ooopath = ooopath {:};
+   else
+     ooopath = '';
+   endif;
+   ## One big try-catch to circumvent possible problems on Linux
+   try
+     if (!isempty (userdir))
+       if (strcmpi (userdir, "no") || strcmpi (userdir, "false") || strcmpi (us
erdir, "0"))
+         ## Do not load Java class libs .jar files). First clean up, then retur
n
+         clear ('libdir', 'spr_status', 'userdir', 'homedir', 'bnam', 'ooopath'
, 'ii');
+         return;
+       endif;
+       ## First allow some time for io package to be fully loaded
+       pause (0.25);
+       ## Check first for user-, then system supplied jars
+       if (exist (userdir) == 7)
+         ## Userdir is a subdir
+         spr_status = chk_spreadsheet_support (userdir, 0, ooopath);
+       endif;
+       ## Also try user's home directory
+     elseif (isunix && !(strcmpi (userdir, "no") || strcmpi (userdir, "false")
|| strcmpi (userdir, "0")))
+       ## On non-Windows systems, automatic loading of Java classes is opt-in d
ue to
+       ## excessive search time (see bug #42044). Most of the delay is due to s
earching
+       ## for the Libre/OpenOffice.org jars
+       clear ('libdir', 'spr_status', 'userdir', 'homedir', 'bnam', 'ooopath',
'ii');
+       return;
+     else
+       ## Allow some time for io package to be fully loaded
+       pause (0.25);
+     endif;
+     ## Try <HOME>/java
+     spr_status = chk_spreadsheet_support ([homedir, filesep, "java"], 0, ooopa
th);
+     ## Only then search for system-supplied jars. ooopath has been searched
+     spr_status = chk_spreadsheet_support ([libdir, filesep, "java"], 0);
+   catch
+     warning ("(Automatic loading of spreadsheet I/O Java classlibs failed)\n")
;
+   end_try_catch;
+ endif;
+ ## OK, Java built-in / supported. Check environment var
+ userdir = getenv ("OCTAVE_IO_JAVALIBS");
+ if (ispc)
+   homedir = getenv ("USERPROFILE");
+   ## (MinGW) assume jar files are in /lib/java
+   libdir = octave_config_info ("libdir");
+   ## elseif (ismac)
+   ##   ## Who knows where OSX keeps e.g., Apache POI stuff? if it does at all.
..
+ elseif (isunix)
+   homedir = tilde_expand ("~");
+   ## On linux spreadsheet .jars are often found somewhere in /usr/share/java
+   libdir = "/usr/share";
+ else
+   ## Set libdir to "." to avoid searching in a root dir
+   libdir = ".";
+ endif;
+ homedir = getenv ("USERPROFILE");
+ ## (MinGW) assume jar files are in /lib/java
+ libdir = octave_config_info ("libdir");
+ ## Find LibreOffice or OpenOffice.org
+ ooopath = '';
+ ii = 0;
+ ## Possible locations for  OOo or LO.
+ bnam = {"C:/Program Files (X86)", "C:/Program Files", "C:/Programs", "/opt", "
/usr/lib"};
+ if (strcmpi (octave_config_info ("USE_64_BIT_IDX_T"), "yes"))
+   ## 64-bit Octave won't work with 32-bit LibreOffice/OpenOffice.org
+   bnam (1) = [];
+ endif;
+ while (isempty (ooopath) && ii < numel (bnam))
+   ooopath = glob ([bnam{++ii}, filesep, "[Ll]ibre[Oo]ffice*"]);
+ endwhile;
+ ooopath = glob ([bnam{++ii}, filesep, "[Ll]ibre[Oo]ffice*"]);
+ while (isempty (ooopath) && ii < numel (bnam))
+   ooopath = glob ([bnam{++ii}, filesep, "[Oo]pen[Oo]ffice.org*"]);
+ endwhile;
+ while (isempty (ooopath) && ii < numel (bnam))
+   ooopath = glob ([bnam{++ii}, filesep, "ooo*"]);
+ endwhile;
+ if (!isempty (ooopath))
+   ooopath = ooopath {:};
+ else
+   ooopath = '';
+ endif;
+ ooopath = ooopath {:};
+ ## One big try-catch to circumvent possible problems on Linux
+ try
+   if (!isempty (userdir))
+     if (strcmpi (userdir, "no") || strcmpi (userdir, "false") || strcmpi (user
dir, "0"))
+       ## Do not load Java class libs .jar files). First clean up, then return
+       clear ('libdir', 'spr_status', 'userdir', 'homedir', 'bnam', 'ooopath',
'ii');
+       return;
+     endif;
+     ## First allow some time for io package to be fully loaded
+     pause (0.25);
+     ## Check first for user-, then system supplied jars
+     if (exist (userdir) == 7)
+       ## Userdir is a subdir
+       spr_status = chk_spreadsheet_support (userdir, 0, ooopath);
+     endif;
+     ## Also try user's home directory
+   elseif (isunix && !(strcmpi (userdir, "no") || strcmpi (userdir, "false") ||
 strcmpi (userdir, "0")))
+     ## On non-Windows systems, automatic loading of Java classes is opt-in due
 to
+     ## excessive search time (see bug #42044). Most of the delay is due to sea
rching
+     ## for the Libre/OpenOffice.org jars
+     clear ('libdir', 'spr_status', 'userdir', 'homedir', 'bnam', 'ooopath', 'i
i');
+     return;
+   else
+     ## Allow some time for io package to be fully loaded
+     pause (0.25);
+   endif;
+   ## Try <HOME>/java
+   spr_status = chk_spreadsheet_support ([homedir, filesep, "java"], 0, ooopath
);
+   ## Only then search for system-supplied jars. ooopath has been searched
+   spr_status = chk_spreadsheet_support ([libdir, filesep, "java"], 0);
+ catch
+   warning ("(Automatic loading of spreadsheet I/O Java classlibs failed)\n");
+ end_try_catch;
+ if (!isempty (userdir))
+   if (strcmpi (userdir, "no") || strcmpi (userdir, "false") || strcmpi (userdi
r, "0"))
+     ## Do not load Java class libs .jar files). First clean up, then return
+     clear ('libdir', 'spr_status', 'userdir', 'homedir', 'bnam', 'ooopath', 'i
i');
+     return;
+   endif;
+   ## First allow some time for io package to be fully loaded
+   pause (0.25);
+   ## Check first for user-, then system supplied jars
+   if (exist (userdir) == 7)
+     ## Userdir is a subdir
+     spr_status = chk_spreadsheet_support (userdir, 0, ooopath);
+   endif;
+   ## Also try user's home directory
+ elseif (isunix && !(strcmpi (userdir, "no") || strcmpi (userdir, "false") || s
trcmpi (userdir, "0")))
+   ## On non-Windows systems, automatic loading of Java classes is opt-in due t
o
+   ## excessive search time (see bug #42044). Most of the delay is due to searc
hing
+   ## for the Libre/OpenOffice.org jars
+   clear ('libdir', 'spr_status', 'userdir', 'homedir', 'bnam', 'ooopath', 'ii'
);
+   return;
+ else
+   ## Allow some time for io package to be fully loaded
+   pause (0.25);
+ endif;
+ ## Allow some time for io package to be fully loaded
+ pause (0.25);
+ ## Try <HOME>/java
+ spr_status = chk_spreadsheet_support ([homedir, filesep, "java"], 0, ooopath);

+ ## Only then search for system-supplied jars. ooopath has been searched
+ spr_status = chk_spreadsheet_support ([libdir, filesep, "java"], 0);
+ ## Clean up
+ clear ('libdir', 'spr_status', 'userdir', 'homedir', 'bnam', 'ooopath', 'ii');

+ endscript;
+ ## PKG_DEL
+ ##
+ ## All we need to do is try to remove all Java spreadsheet class libs loaded
+ ## by chk_spreadsheet_support.m from the javaclasspath
+ try
+   chk_spreadsheet_support ("", -1);
+ catch
+   warning ("Couldn't remove spreadsheet I/O javaclasspath entries while unload
ing io pkg");
+ end_try_catch;
+ chk_spreadsheet_support ("", -1);
+ endscript;
For information about changes from previous versions of the io package, run 'new
s io'.


Regards

Tatsuro