--> atomsInstall("xlreadwrite")
This toolbox allows to read and write Excel BIFF8 .xls files and .xslx files in a transparent way, with the same syntax as the Matlab functions xlsread and xlswrite. It is based on the Apache POI Java library.
Fixed the startup problem under Windows.
Upload date : 2020-10-20 09:01:41 MD5 : 7bd0db14071facc829a75d34c707b587 SHA1 : bde23aae807f48e3eb96858f49d703f55aeb5d39 Downloads : 2868
Upload date : 2020-09-01 12:46:33 MD5 : 6bd9e009d60b97abc08e6dd68fd24400 SHA1 : 14512dbbba24d2452278d9adc2cd43de96eaf19d Downloads : 52
Hi Stephane, the current version of the package does not work, see error message below: Start xlreadwrite Load macros atomsLoad: An error occurred while loading 'xlreadwrite-1.2': exec: error on line #64: "javaclasspath: Could not add URL to system classloader : C:/Program%20Files/scilab-6.1.0/modules/jvm/jar/org.scilab.modules.jvm.jar." We have modified xlreadwrite.start as follows to make the package work: ### Original, does not work Win 10 Prof xlwriteClassPath=['poi_library/poi-4.1.2/'+jars]; classPath=javaclasspath(); javaclasspath([classPath;path+xlwriteClassPath]); ### Modified, work Win 10 Prof xlwriteClassPath=['poi_library/poi-4.1.2/'+jars]; classPath=javaclasspath(); javaclasspath([path+xlwriteClassPath]); The demos are not loaded. Thanks for the package! Best regards Rudi
> Hi Stephane, > the current version of the package does not work, see error message below: > > Start xlreadwrite > Load macros > atomsLoad: An error occurred while loading 'xlreadwrite-1.2': > exec: error on line #64: "javaclasspath: Could not add URL to system classloader : > > C:/Program%20Files/scilab-6.1.0/modules/jvm/jar/org.scilab.modules.jvm.jar." > > We have modified xlreadwrite.start as follows to make the package work: > > ### Original, does not work Win 10 Prof > xlwriteClassPath=['poi_library/poi-4.1.2/'+jars]; > classPath=javaclasspath(); > javaclasspath([classPath;path+xlwriteClassPath]); > > ### Modified, work Win 10 Prof > xlwriteClassPath=['poi_library/poi-4.1.2/'+jars]; > classPath=javaclasspath(); > javaclasspath([path+xlwriteClassPath]); > > The demos are not loaded. > > Thanks for the package! > > Best regards > Rudi Hi, Thanks for the report. I have fixed this in 1.2.1 binary. Please uninstall the previous version, refresh the list of packages then reinstall. S.
Hi Stephane, thank you for this nice tool to access directly .xlsx file content. Yet I noticed an issue with timeseries data while trying to get "time" formatted cells from .xlsx as below: Date Time datatest 20/11/2018 00:00:00 0 20/11/2018 01:00:00 0.64 20/11/2018 02:00:00 8.03 20/11/2018 03:00:00 8.6 there's no error message while calling --> [value,text,data]=xlread("xldatefail.xlsx"); but I didn't get the expected characters string "00:00:00" neither in data{2,2} nor text(2,2) : --> data{2,2} ans = "31/12/1899" --> text(2,2) ans = "31/12/1899" and value(1,2) is Nan while Data formatted cells works fine, text(2,1) returns "20/11/2018" as expected It would be nice if you see what's going wrong with 'time' format ! thank you David
> Hi Stephane, > thank you for this nice tool to access directly .xlsx file content. Yet I noticed an > issue with timeseries data while trying to get "time" formatted cells from > .xlsx as > below: > > Date Time datatest > 20/11/2018 00:00:00 0 > 20/11/2018 01:00:00 0.64 > 20/11/2018 02:00:00 8.03 > 20/11/2018 03:00:00 8.6 > > there's no error message while calling > --> [value,text,data]=xlread("xldatefail.xlsx"); > > but I didn't get the expected characters string "00:00:00" neither in > data{2,2} nor > text(2,2) : > --> data{2,2} > ans = > > "31/12/1899" > --> text(2,2) > ans = > > "31/12/1899" > > > and value(1,2) is Nan > > while Data formatted cells works fine, text(2,1) returns "20/11/2018" as > expected > > It would be nice if you see what's going wrong with 'time' format ! > > thank you > > David > > > > > Hi David, I have improved the date/time handling in new version 1.2.2. Now the value contains the Excel serial date number (add 693960 to obtain a Scilab serial date number) and the text is the original formated date string. S.
Sorry this is now 1.2.3 version (after a small technical problem...).
