CRAN Package Check Results for Package gdata

Last updated on 2022-01-20 22:54:03 CET.

Flavor Version Tinstall Tcheck Ttotal Status Flags
r-devel-linux-x86_64-debian-clang 2.18.0 OK
r-devel-linux-x86_64-debian-gcc 2.18.0 4.32 73.05 77.37 OK
r-devel-linux-x86_64-fedora-clang 2.18.0 137.65 NOTE
r-devel-linux-x86_64-fedora-gcc 2.18.0 123.68 OK
r-devel-windows-x86_64-new-UL 2.18.0 204.00 123.00 327.00 ERROR
r-devel-windows-x86_64-new-TK 2.18.0 ERROR
r-patched-linux-x86_64 2.18.0 6.91 98.26 105.17 OK
r-release-linux-x86_64 2.18.0 5.11 97.89 103.00 OK
r-release-macos-arm64 2.18.0 OK
r-release-macos-x86_64 2.18.0 OK
r-release-windows-ix86+x86_64 2.18.0 10.00 236.00 246.00 OK
r-oldrel-macos-x86_64 2.18.0 OK
r-oldrel-windows-ix86+x86_64 2.18.0 10.00 238.00 248.00 OK

Check Details

Version: 2.18.0
Check: Rd cross-references
Result: NOTE
    Undeclared package ‘reshape’ in Rd xrefs
Flavor: r-devel-linux-x86_64-fedora-clang

Version: 2.18.0
Check: examples
Result: ERROR
    Running examples in 'gdata-Ex.R' failed
    The error most likely occurred in:
    
    > ### Name: read.xls
    > ### Title: Read Excel files
    > ### Aliases: read.xls xls2csv xls2tab xls2tsv xls2sep
    > ### Keywords: file
    >
    > ### ** Examples
    >
    >
    > # iris.xls is included in the gregmisc package for use as an example
    > xlsfile <- file.path(path.package('gdata'),'xls','iris.xls')
    > xlsfile
    [1] "D:/RCompile/CRANpkg/lib/4.2/gdata/xls/iris.xls"
    >
    > iris <- read.xls(xlsfile) # defaults to csv format
    Error in findPerl(perl, verbose = verbose) :
     perl executable not found. Use perl= argument to specify the correct path.
    Calls: read.xls -> xls2sep -> findPerl
    Error in file.exists(tfn) : invalid 'file' argument
    Calls: read.xls -> file.exists
    Execution halted
Flavor: r-devel-windows-x86_64-new-UL

Version: 2.18.0
Check: tests
Result: ERROR
     Running 'runRUnitTests.R' [1s]
     Running 'test.humanReadable.R' [1s]
     Comparing 'test.humanReadable.Rout' to 'test.humanReadable.Rout.save' ...4,5c4
    < gdata: Unable to load perl libaries needed by read.xls()
    < gdata: to support 'XLX' (Excel 97-2004) files.
    ---
    > gdata: read.xls support for 'XLS' (Excel 97-2004) files ENABLED.
    7,12c6
    < gdata: Unable to load perl libaries needed by read.xls()
    < gdata: to support 'XLSX' (Excel 2007+) files.
    <
    < gdata: Run the function 'installXLSXsupport()'
    < gdata: to automatically download and install the perl
    < gdata: libaries needed to support Excel XLS and XLSX formats.
    ---
    > gdata: read.xls support for 'XLSX' (Excel 2007+) files ENABLED.
     Running 'test.read.xls.R' [1s]
     Running 'test.reorder.factor.R' [1s]
     Comparing 'test.reorder.factor.Rout' to 'test.reorder.factor.Rout.save' ...15,16c15
    < gdata: Unable to load perl libaries needed by read.xls()
    < gdata: to support 'XLX' (Excel 97-2004) files.
    ---
    > gdata: read.xls support for 'XLS' (Excel 97-2004) files ENABLED.
    18,23c17
    < gdata: Unable to load perl libaries needed by read.xls()
    < gdata: to support 'XLSX' (Excel 2007+) files.
    <
    < gdata: Run the function 'installXLSXsupport()'
    < gdata: to automatically download and install the perl
    < gdata: libaries needed to support Excel XLS and XLSX formats.
    ---
    > gdata: read.xls support for 'XLSX' (Excel 2007+) files ENABLED.
     Running 'test.write.fwf.eol.R' [1s]
     Running 'tests.write.fwf.R' [1s]
     Comparing 'tests.write.fwf.Rout' to 'tests.write.fwf.Rout.save' ...11,12c11
    < gdata: Unable to load perl libaries needed by read.xls()
    < gdata: to support 'XLX' (Excel 97-2004) files.
    ---
    > gdata: read.xls support for 'XLS' (Excel 97-2004) files ENABLED.
    14,19c13
    < gdata: Unable to load perl libaries needed by read.xls()
    < gdata: to support 'XLSX' (Excel 2007+) files.
    <
    < gdata: Run the function 'installXLSXsupport()'
    < gdata: to automatically download and install the perl
    < gdata: libaries needed to support Excel XLS and XLSX formats.
    ---
    > gdata: read.xls support for 'XLSX' (Excel 2007+) files ENABLED.
    Running the tests in 'tests/test.read.xls.R' failed.
    Complete output:
     > library(gdata)
     gdata: Unable to load perl libaries needed by read.xls()
     gdata: to support 'XLX' (Excel 97-2004) files.
    
     gdata: Unable to load perl libaries needed by read.xls()
     gdata: to support 'XLSX' (Excel 2007+) files.
    
     gdata: Run the function 'installXLSXsupport()'
     gdata: to automatically download and install the perl
     gdata: libaries needed to support Excel XLS and XLSX formats.
    
     Attaching package: 'gdata'
    
     The following object is masked from 'package:stats':
    
     nobs
    
     The following object is masked from 'package:utils':
    
     object.size
    
     The following object is masked from 'package:base':
    
     startsWith
    
     >
     > if ( ! 'XLSX' %in% xlsFormats() )
     + {
     + try( installXLSXsupport() )
     + }
     Error in system(cmd, intern = TRUE) :
     Calls: %in% -> xlsFormats -> system
     Execution halted
Flavor: r-devel-windows-x86_64-new-UL

Version: 2.18.0
Check: tests
Result: ERROR
     Running 'runRUnitTests.R'
     Running 'test.humanReadable.R'
     Comparing 'test.humanReadable.Rout' to 'test.humanReadable.Rout.save' ...6,11c6
    < gdata: Unable to load perl libaries needed by read.xls()
    < gdata: to support 'XLSX' (Excel 2007+) files.
    <
    < gdata: Run the function 'installXLSXsupport()'
    < gdata: to automatically download and install the perl
    < gdata: libaries needed to support Excel XLS and XLSX formats.
    ---
    > gdata: read.xls support for 'XLSX' (Excel 2007+) files ENABLED.
     Running 'test.read.xls.R'
    Running the tests in 'tests/test.read.xls.R' failed.
    Complete output:
     > library(gdata)
     gdata: read.xls support for 'XLS' (Excel 97-2004) files ENABLED.
    
     gdata: Unable to load perl libaries needed by read.xls()
     gdata: to support 'XLSX' (Excel 2007+) files.
    
     gdata: Run the function 'installXLSXsupport()'
     gdata: to automatically download and install the perl
     gdata: libaries needed to support Excel XLS and XLSX formats.
    
     Attaching package: 'gdata'
    
     The following object is masked from 'package:stats':
    
     nobs
    
     The following object is masked from 'package:utils':
    
     object.size
    
     The following object is masked from 'package:base':
    
     startsWith
    
     >
     > if ( ! 'XLSX' %in% xlsFormats() )
     + {
     + try( installXLSXsupport() )
     + }
     Error in installXLSXsupport() :
     Unable to install Perl XLSX support libraries.
    
    
     >
     > # iris.xls is included in the gregmisc package for use as an example
     > xlsfile <- file.path(path.package('gdata'),'xls','iris.xls')
     >
     > iris.1 <- read.xls(xlsfile) # defaults to csv format
     WARNING: Perl module Spreadsheet::ParseXLSX cannot be loaded.
     WARNING: Microsoft Excel 2007 'XLSX' formatted files will not be processed.
     > iris.1
     Sepal.Length Sepal.Width Petal.Length Petal.Width Species
     1 5.1 3.5 1.4 0.2 setosa
     2 4.9 3.0 1.4 0.2 setosa
     3 4.7 3.2 1.3 0.2 setosa
     4 4.6 3.1 1.5 0.2 setosa
     5 5.0 3.6 1.4 0.2 setosa
     6 5.4 3.9 1.7 0.4 setosa
     7 4.6 3.4 1.4 0.3 setosa
     8 5.0 3.4 1.5 0.2 setosa
     9 4.4 2.9 1.4 0.2 setosa
     10 4.9 3.1 1.5 0.1 setosa
     11 5.4 3.7 1.5 0.2 setosa
     12 4.8 3.4 1.6 0.2 setosa
     13 4.8 3.0 1.4 0.1 setosa
     14 4.3 3.0 1.1 0.1 setosa
     15 5.8 4.0 1.2 0.2 setosa
     16 5.7 4.4 1.5 0.4 setosa
     17 5.4 3.9 1.3 0.4 setosa
     18 5.1 3.5 1.4 0.3 setosa
     19 5.7 3.8 1.7 0.3 setosa
     20 5.1 3.8 1.5 0.3 setosa
     21 5.4 3.4 1.7 0.2 setosa
     22 5.1 3.7 1.5 0.4 setosa
     23 4.6 3.6 1.0 0.2 setosa
     24 5.1 3.3 1.7 0.5 setosa
     25 4.8 3.4 1.9 0.2 setosa
     26 5.0 3.0 1.6 0.2 setosa
     27 5.0 3.4 1.6 0.4 setosa
     28 5.2 3.5 1.5 0.2 setosa
     29 5.2 3.4 1.4 0.2 setosa
     30 4.7 3.2 1.6 0.2 setosa
     31 4.8 3.1 1.6 0.2 setosa
     32 5.4 3.4 1.5 0.4 setosa
     33 5.2 4.1 1.5 0.1 setosa
     34 5.5 4.2 1.4 0.2 setosa
     35 4.9 3.1 1.5 0.2 setosa
     36 5.0 3.2 1.2 0.2 setosa
     37 5.5 3.5 1.3 0.2 setosa
     38 4.9 3.6 1.4 0.1 setosa
     39 4.4 3.0 1.3 0.2 setosa
     40 5.1 3.4 1.5 0.2 setosa
     41 5.0 3.5 1.3 0.3 setosa
     42 4.5 2.3 1.3 0.3 setosa
     43 4.4 3.2 1.3 0.2 setosa
     44 5.0 3.5 1.6 0.6 setosa
     45 5.1 3.8 1.9 0.4 setosa
     46 4.8 3.0 1.4 0.3 setosa
     47 5.1 3.8 1.6 0.2 setosa
     48 4.6 3.2 1.4 0.2 setosa
     49 5.3 3.7 1.5 0.2 setosa
     50 5.0 3.3 1.4 0.2 setosa
     51 7.0 3.2 4.7 1.4 versicolor
     52 6.4 3.2 4.5 1.5 versicolor
     53 6.9 3.1 4.9 1.5 versicolor
     54 5.5 2.3 4.0 1.3 versicolor
     55 6.5 2.8 4.6 1.5 versicolor
     56 5.7 2.8 4.5 1.3 versicolor
     57 6.3 3.3 4.7 1.6 versicolor
     58 4.9 2.4 3.3 1.0 versicolor
     59 6.6 2.9 4.6 1.3 versicolor
     60 5.2 2.7 3.9 1.4 versicolor
     61 5.0 2.0 3.5 1.0 versicolor
     62 5.9 3.0 4.2 1.5 versicolor
     63 6.0 2.2 4.0 1.0 versicolor
     64 6.1 2.9 4.7 1.4 versicolor
     65 5.6 2.9 3.6 1.3 versicolor
     66 6.7 3.1 4.4 1.4 versicolor
     67 5.6 3.0 4.5 1.5 versicolor
     68 5.8 2.7 4.1 1.0 versicolor
     69 6.2 2.2 4.5 1.5 versicolor
     70 5.6 2.5 3.9 1.1 versicolor
     71 5.9 3.2 4.8 1.8 versicolor
     72 6.1 2.8 4.0 1.3 versicolor
     73 6.3 2.5 4.9 1.5 versicolor
     74 6.1 2.8 4.7 1.2 versicolor
     75 6.4 2.9 4.3 1.3 versicolor
     76 6.6 3.0 4.4 1.4 versicolor
     77 6.8 2.8 4.8 1.4 versicolor
     78 6.7 3.0 5.0 1.7 versicolor
     79 6.0 2.9 4.5 1.5 versicolor
     80 5.7 2.6 3.5 1.0 versicolor
     81 5.5 2.4 3.8 1.1 versicolor
     82 5.5 2.4 3.7 1.0 versicolor
     83 5.8 2.7 3.9 1.2 versicolor
     84 6.0 2.7 5.1 1.6 versicolor
     85 5.4 3.0 4.5 1.5 versicolor
     86 6.0 3.4 4.5 1.6 versicolor
     87 6.7 3.1 4.7 1.5 versicolor
     88 6.3 2.3 4.4 1.3 versicolor
     89 5.6 3.0 4.1 1.3 versicolor
     90 5.5 2.5 4.0 1.3 versicolor
     91 5.5 2.6 4.4 1.2 versicolor
     92 6.1 3.0 4.6 1.4 versicolor
     93 5.8 2.6 4.0 1.2 versicolor
     94 5.0 2.3 3.3 1.0 versicolor
     95 5.6 2.7 4.2 1.3 versicolor
     96 5.7 3.0 4.2 1.2 versicolor
     97 5.7 2.9 4.2 1.3 versicolor
     98 6.2 2.9 4.3 1.3 versicolor
     99 5.1 2.5 3.0 1.1 versicolor
     100 5.7 2.8 4.1 1.3 versicolor
     101 6.3 3.3 6.0 2.5 virginica
     102 5.8 2.7 5.1 1.9 virginica
     103 7.1 3.0 5.9 2.1 virginica
     104 6.3 2.9 5.6 1.8 virginica
     105 6.5 3.0 5.8 2.2 virginica
     106 7.6 3.0 6.6 2.1 virginica
     107 4.9 2.5 4.5 1.7 virginica
     108 7.3 2.9 6.3 1.8 virginica
     109 6.7 2.5 5.8 1.8 virginica
     110 7.2 3.6 6.1 2.5 virginica
     111 6.5 3.2 5.1 2.0 virginica
     112 6.4 2.7 5.3 1.9 virginica
     113 6.8 3.0 5.5 2.1 virginica
     114 5.7 2.5 5.0 2.0 virginica
     115 5.8 2.8 5.1 2.4 virginica
     116 6.4 3.2 5.3 2.3 virginica
     117 6.5 3.0 5.5 1.8 virginica
     118 7.7 3.8 6.7 2.2 virginica
     119 7.7 2.6 6.9 2.3 virginica
     120 6.0 2.2 5.0 1.5 virginica
     121 6.9 3.2 5.7 2.3 virginica
     122 5.6 2.8 4.9 2.0 virginica
     123 7.7 2.8 6.7 2.0 virginica
     124 6.3 2.7 4.9 1.8 virginica
     125 6.7 3.3 5.7 2.1 virginica
     126 7.2 3.2 6.0 1.8 virginica
     127 6.2 2.8 4.8 1.8 virginica
     128 6.1 3.0 4.9 1.8 virginica
     129 6.4 2.8 5.6 2.1 virginica
     130 7.2 3.0 5.8 1.6 virginica
     131 7.4 2.8 6.1 1.9 virginica
     132 7.9 3.8 6.4 2.0 virginica
     133 6.4 2.8 5.6 2.2 virginica
     134 6.3 2.8 5.1 1.5 virginica
     135 6.1 2.6 5.6 1.4 virginica
     136 7.7 3.0 6.1 2.3 virginica
     137 6.3 3.4 5.6 2.4 virginica
     138 6.4 3.1 5.5 1.8 virginica
     139 6.0 3.0 4.8 1.8 virginica
     140 6.9 3.1 5.4 2.1 virginica
     141 6.7 3.1 5.6 2.4 virginica
     142 6.9 3.1 5.1 2.3 virginica
     143 5.8 2.7 5.1 1.9 virginica
     144 6.8 3.2 5.9 2.3 virginica
     145 6.7 3.3 5.7 2.5 virginica
     146 6.7 3.0 5.2 2.3 virginica
     147 6.3 2.5 5.0 1.9 virginica
     148 6.5 3.0 5.2 2.0 virginica
     149 6.2 3.4 5.4 2.3 virginica
     150 5.9 3.0 5.1 1.8 virginica
     >
     > iris.2 <- read.xls(xlsfile,method="csv") # specify csv format
     WARNING: Perl module Spreadsheet::ParseXLSX cannot be loaded.
     WARNING: Microsoft Excel 2007 'XLSX' formatted files will not be processed.
     > iris.2
     Sepal.Length Sepal.Width Petal.Length Petal.Width Species
     1 5.1 3.5 1.4 0.2 setosa
     2 4.9 3.0 1.4 0.2 setosa
     3 4.7 3.2 1.3 0.2 setosa
     4 4.6 3.1 1.5 0.2 setosa
     5 5.0 3.6 1.4 0.2 setosa
     6 5.4 3.9 1.7 0.4 setosa
     7 4.6 3.4 1.4 0.3 setosa
     8 5.0 3.4 1.5 0.2 setosa
     9 4.4 2.9 1.4 0.2 setosa
     10 4.9 3.1 1.5 0.1 setosa
     11 5.4 3.7 1.5 0.2 setosa
     12 4.8 3.4 1.6 0.2 setosa
     13 4.8 3.0 1.4 0.1 setosa
     14 4.3 3.0 1.1 0.1 setosa
     15 5.8 4.0 1.2 0.2 setosa
     16 5.7 4.4 1.5 0.4 setosa
     17 5.4 3.9 1.3 0.4 setosa
     18 5.1 3.5 1.4 0.3 setosa
     19 5.7 3.8 1.7 0.3 setosa
     20 5.1 3.8 1.5 0.3 setosa
     21 5.4 3.4 1.7 0.2 setosa
     22 5.1 3.7 1.5 0.4 setosa
     23 4.6 3.6 1.0 0.2 setosa
     24 5.1 3.3 1.7 0.5 setosa
     25 4.8 3.4 1.9 0.2 setosa
     26 5.0 3.0 1.6 0.2 setosa
     27 5.0 3.4 1.6 0.4 setosa
     28 5.2 3.5 1.5 0.2 setosa
     29 5.2 3.4 1.4 0.2 setosa
     30 4.7 3.2 1.6 0.2 setosa
     31 4.8 3.1 1.6 0.2 setosa
     32 5.4 3.4 1.5 0.4 setosa
     33 5.2 4.1 1.5 0.1 setosa
     34 5.5 4.2 1.4 0.2 setosa
     35 4.9 3.1 1.5 0.2 setosa
     36 5.0 3.2 1.2 0.2 setosa
     37 5.5 3.5 1.3 0.2 setosa
     38 4.9 3.6 1.4 0.1 setosa
     39 4.4 3.0 1.3 0.2 setosa
     40 5.1 3.4 1.5 0.2 setosa
     41 5.0 3.5 1.3 0.3 setosa
     42 4.5 2.3 1.3 0.3 setosa
     43 4.4 3.2 1.3 0.2 setosa
     44 5.0 3.5 1.6 0.6 setosa
     45 5.1 3.8 1.9 0.4 setosa
     46 4.8 3.0 1.4 0.3 setosa
     47 5.1 3.8 1.6 0.2 setosa
     48 4.6 3.2 1.4 0.2 setosa
     49 5.3 3.7 1.5 0.2 setosa
     50 5.0 3.3 1.4 0.2 setosa
     51 7.0 3.2 4.7 1.4 versicolor
     52 6.4 3.2 4.5 1.5 versicolor
     53 6.9 3.1 4.9 1.5 versicolor
     54 5.5 2.3 4.0 1.3 versicolor
     55 6.5 2.8 4.6 1.5 versicolor
     56 5.7 2.8 4.5 1.3 versicolor
     57 6.3 3.3 4.7 1.6 versicolor
     58 4.9 2.4 3.3 1.0 versicolor
     59 6.6 2.9 4.6 1.3 versicolor
     60 5.2 2.7 3.9 1.4 versicolor
     61 5.0 2.0 3.5 1.0 versicolor
     62 5.9 3.0 4.2 1.5 versicolor
     63 6.0 2.2 4.0 1.0 versicolor
     64 6.1 2.9 4.7 1.4 versicolor
     65 5.6 2.9 3.6 1.3 versicolor
     66 6.7 3.1 4.4 1.4 versicolor
     67 5.6 3.0 4.5 1.5 versicolor
     68 5.8 2.7 4.1 1.0 versicolor
     69 6.2 2.2 4.5 1.5 versicolor
     70 5.6 2.5 3.9 1.1 versicolor
     71 5.9 3.2 4.8 1.8 versicolor
     72 6.1 2.8 4.0 1.3 versicolor
     73 6.3 2.5 4.9 1.5 versicolor
     74 6.1 2.8 4.7 1.2 versicolor
     75 6.4 2.9 4.3 1.3 versicolor
     76 6.6 3.0 4.4 1.4 versicolor
     77 6.8 2.8 4.8 1.4 versicolor
     78 6.7 3.0 5.0 1.7 versicolor
     79 6.0 2.9 4.5 1.5 versicolor
     80 5.7 2.6 3.5 1.0 versicolor
     81 5.5 2.4 3.8 1.1 versicolor
     82 5.5 2.4 3.7 1.0 versicolor
     83 5.8 2.7 3.9 1.2 versicolor
     84 6.0 2.7 5.1 1.6 versicolor
     85 5.4 3.0 4.5 1.5 versicolor
     86 6.0 3.4 4.5 1.6 versicolor
     87 6.7 3.1 4.7 1.5 versicolor
     88 6.3 2.3 4.4 1.3 versicolor
     89 5.6 3.0 4.1 1.3 versicolor
     90 5.5 2.5 4.0 1.3 versicolor
     91 5.5 2.6 4.4 1.2 versicolor
     92 6.1 3.0 4.6 1.4 versicolor
     93 5.8 2.6 4.0 1.2 versicolor
     94 5.0 2.3 3.3 1.0 versicolor
     95 5.6 2.7 4.2 1.3 versicolor
     96 5.7 3.0 4.2 1.2 versicolor
     97 5.7 2.9 4.2 1.3 versicolor
     98 6.2 2.9 4.3 1.3 versicolor
     99 5.1 2.5 3.0 1.1 versicolor
     100 5.7 2.8 4.1 1.3 versicolor
     101 6.3 3.3 6.0 2.5 virginica
     102 5.8 2.7 5.1 1.9 virginica
     103 7.1 3.0 5.9 2.1 virginica
     104 6.3 2.9 5.6 1.8 virginica
     105 6.5 3.0 5.8 2.2 virginica
     106 7.6 3.0 6.6 2.1 virginica
     107 4.9 2.5 4.5 1.7 virginica
     108 7.3 2.9 6.3 1.8 virginica
     109 6.7 2.5 5.8 1.8 virginica
     110 7.2 3.6 6.1 2.5 virginica
     111 6.5 3.2 5.1 2.0 virginica
     112 6.4 2.7 5.3 1.9 virginica
     113 6.8 3.0 5.5 2.1 virginica
     114 5.7 2.5 5.0 2.0 virginica
     115 5.8 2.8 5.1 2.4 virginica
     116 6.4 3.2 5.3 2.3 virginica
     117 6.5 3.0 5.5 1.8 virginica
     118 7.7 3.8 6.7 2.2 virginica
     119 7.7 2.6 6.9 2.3 virginica
     120 6.0 2.2 5.0 1.5 virginica
     121 6.9 3.2 5.7 2.3 virginica
     122 5.6 2.8 4.9 2.0 virginica
     123 7.7 2.8 6.7 2.0 virginica
     124 6.3 2.7 4.9 1.8 virginica
     125 6.7 3.3 5.7 2.1 virginica
     126 7.2 3.2 6.0 1.8 virginica
     127 6.2 2.8 4.8 1.8 virginica
     128 6.1 3.0 4.9 1.8 virginica
     129 6.4 2.8 5.6 2.1 virginica
     130 7.2 3.0 5.8 1.6 virginica
     131 7.4 2.8 6.1 1.9 virginica
     132 7.9 3.8 6.4 2.0 virginica
     133 6.4 2.8 5.6 2.2 virginica
     134 6.3 2.8 5.1 1.5 virginica
     135 6.1 2.6 5.6 1.4 virginica
     136 7.7 3.0 6.1 2.3 virginica
     137 6.3 3.4 5.6 2.4 virginica
     138 6.4 3.1 5.5 1.8 virginica
     139 6.0 3.0 4.8 1.8 virginica
     140 6.9 3.1 5.4 2.1 virginica
     141 6.7 3.1 5.6 2.4 virginica
     142 6.9 3.1 5.1 2.3 virginica
     143 5.8 2.7 5.1 1.9 virginica
     144 6.8 3.2 5.9 2.3 virginica
     145 6.7 3.3 5.7 2.5 virginica
     146 6.7 3.0 5.2 2.3 virginica
     147 6.3 2.5 5.0 1.9 virginica
     148 6.5 3.0 5.2 2.0 virginica
     149 6.2 3.4 5.4 2.3 virginica
     150 5.9 3.0 5.1 1.8 virginica
     >
     > iris.3 <- read.xls(xlsfile,method="tab") # specify tab format
     WARNING: Perl module Spreadsheet::ParseXLSX cannot be loaded.
     WARNING: Microsoft Excel 2007 'XLSX' formatted files will not be processed.
     > iris.3
     Sepal.Length Sepal.Width Petal.Length Petal.Width Species
     1 5.1 3.5 1.4 0.2 setosa
     2 4.9 3.0 1.4 0.2 setosa
     3 4.7 3.2 1.3 0.2 setosa
     4 4.6 3.1 1.5 0.2 setosa
     5 5.0 3.6 1.4 0.2 setosa
     6 5.4 3.9 1.7 0.4 setosa
     7 4.6 3.4 1.4 0.3 setosa
     8 5.0 3.4 1.5 0.2 setosa
     9 4.4 2.9 1.4 0.2 setosa
     10 4.9 3.1 1.5 0.1 setosa
     11 5.4 3.7 1.5 0.2 setosa
     12 4.8 3.4 1.6 0.2 setosa
     13 4.8 3.0 1.4 0.1 setosa
     14 4.3 3.0 1.1 0.1 setosa
     15 5.8 4.0 1.2 0.2 setosa
     16 5.7 4.4 1.5 0.4 setosa
     17 5.4 3.9 1.3 0.4 setosa
     18 5.1 3.5 1.4 0.3 setosa
     19 5.7 3.8 1.7 0.3 setosa
     20 5.1 3.8 1.5 0.3 setosa
     21 5.4 3.4 1.7 0.2 setosa
     22 5.1 3.7 1.5 0.4 setosa
     23 4.6 3.6 1.0 0.2 setosa
     24 5.1 3.3 1.7 0.5 setosa
     25 4.8 3.4 1.9 0.2 setosa
     26 5.0 3.0 1.6 0.2 setosa
     27 5.0 3.4 1.6 0.4 setosa
     28 5.2 3.5 1.5 0.2 setosa
     29 5.2 3.4 1.4 0.2 setosa
     30 4.7 3.2 1.6 0.2 setosa
     31 4.8 3.1 1.6 0.2 setosa
     32 5.4 3.4 1.5 0.4 setosa
     33 5.2 4.1 1.5 0.1 setosa
     34 5.5 4.2 1.4 0.2 setosa
     35 4.9 3.1 1.5 0.2 setosa
     36 5.0 3.2 1.2 0.2 setosa
     37 5.5 3.5 1.3 0.2 setosa
     38 4.9 3.6 1.4 0.1 setosa
     39 4.4 3.0 1.3 0.2 setosa
     40 5.1 3.4 1.5 0.2 setosa
     41 5.0 3.5 1.3 0.3 setosa
     42 4.5 2.3 1.3 0.3 setosa
     43 4.4 3.2 1.3 0.2 setosa
     44 5.0 3.5 1.6 0.6 setosa
     45 5.1 3.8 1.9 0.4 setosa
     46 4.8 3.0 1.4 0.3 setosa
     47 5.1 3.8 1.6 0.2 setosa
     48 4.6 3.2 1.4 0.2 setosa
     49 5.3 3.7 1.5 0.2 setosa
     50 5.0 3.3 1.4 0.2 setosa
     51 7.0 3.2 4.7 1.4 versicolor
     52 6.4 3.2 4.5 1.5 versicolor
     53 6.9 3.1 4.9 1.5 versicolor
     54 5.5 2.3 4.0 1.3 versicolor
     55 6.5 2.8 4.6 1.5 versicolor
     56 5.7 2.8 4.5 1.3 versicolor
     57 6.3 3.3 4.7 1.6 versicolor
     58 4.9 2.4 3.3 1.0 versicolor
     59 6.6 2.9 4.6 1.3 versicolor
     60 5.2 2.7 3.9 1.4 versicolor
     61 5.0 2.0 3.5 1.0 versicolor
     62 5.9 3.0 4.2 1.5 versicolor
     63 6.0 2.2 4.0 1.0 versicolor
     64 6.1 2.9 4.7 1.4 versicolor
     65 5.6 2.9 3.6 1.3 versicolor
     66 6.7 3.1 4.4 1.4 versicolor
     67 5.6 3.0 4.5 1.5 versicolor
     68 5.8 2.7 4.1 1.0 versicolor
     69 6.2 2.2 4.5 1.5 versicolor
     70 5.6 2.5 3.9 1.1 versicolor
     71 5.9 3.2 4.8 1.8 versicolor
     72 6.1 2.8 4.0 1.3 versicolor
     73 6.3 2.5 4.9 1.5 versicolor
     74 6.1 2.8 4.7 1.2 versicolor
     75 6.4 2.9 4.3 1.3 versicolor
     76 6.6 3.0 4.4 1.4 versicolor
     77 6.8 2.8 4.8 1.4 versicolor
     78 6.7 3.0 5.0 1.7 versicolor
     79 6.0 2.9 4.5 1.5 versicolor
     80 5.7 2.6 3.5 1.0 versicolor
     81 5.5 2.4 3.8 1.1 versicolor
     82 5.5 2.4 3.7 1.0 versicolor
     83 5.8 2.7 3.9 1.2 versicolor
     84 6.0 2.7 5.1 1.6 versicolor
     85 5.4 3.0 4.5 1.5 versicolor
     86 6.0 3.4 4.5 1.6 versicolor
     87 6.7 3.1 4.7 1.5 versicolor
     88 6.3 2.3 4.4 1.3 versicolor
     89 5.6 3.0 4.1 1.3 versicolor
     90 5.5 2.5 4.0 1.3 versicolor
     91 5.5 2.6 4.4 1.2 versicolor
     92 6.1 3.0 4.6 1.4 versicolor
     93 5.8 2.6 4.0 1.2 versicolor
     94 5.0 2.3 3.3 1.0 versicolor
     95 5.6 2.7 4.2 1.3 versicolor
     96 5.7 3.0 4.2 1.2 versicolor
     97 5.7 2.9 4.2 1.3 versicolor
     98 6.2 2.9 4.3 1.3 versicolor
     99 5.1 2.5 3.0 1.1 versicolor
     100 5.7 2.8 4.1 1.3 versicolor
     101 6.3 3.3 6.0 2.5 virginica
     102 5.8 2.7 5.1 1.9 virginica
     103 7.1 3.0 5.9 2.1 virginica
     104 6.3 2.9 5.6 1.8 virginica
     105 6.5 3.0 5.8 2.2 virginica
     106 7.6 3.0 6.6 2.1 virginica
     107 4.9 2.5 4.5 1.7 virginica
     108 7.3 2.9 6.3 1.8 virginica
     109 6.7 2.5 5.8 1.8 virginica
     110 7.2 3.6 6.1 2.5 virginica
     111 6.5 3.2 5.1 2.0 virginica
     112 6.4 2.7 5.3 1.9 virginica
     113 6.8 3.0 5.5 2.1 virginica
     114 5.7 2.5 5.0 2.0 virginica
     115 5.8 2.8 5.1 2.4 virginica
     116 6.4 3.2 5.3 2.3 virginica
     117 6.5 3.0 5.5 1.8 virginica
     118 7.7 3.8 6.7 2.2 virginica
     119 7.7 2.6 6.9 2.3 virginica
     120 6.0 2.2 5.0 1.5 virginica
     121 6.9 3.2 5.7 2.3 virginica
     122 5.6 2.8 4.9 2.0 virginica
     123 7.7 2.8 6.7 2.0 virginica
     124 6.3 2.7 4.9 1.8 virginica
     125 6.7 3.3 5.7 2.1 virginica
     126 7.2 3.2 6.0 1.8 virginica
     127 6.2 2.8 4.8 1.8 virginica
     128 6.1 3.0 4.9 1.8 virginica
     129 6.4 2.8 5.6 2.1 virginica
     130 7.2 3.0 5.8 1.6 virginica
     131 7.4 2.8 6.1 1.9 virginica
     132 7.9 3.8 6.4 2.0 virginica
     133 6.4 2.8 5.6 2.2 virginica
     134 6.3 2.8 5.1 1.5 virginica
     135 6.1 2.6 5.6 1.4 virginica
     136 7.7 3.0 6.1 2.3 virginica
     137 6.3 3.4 5.6 2.4 virginica
     138 6.4 3.1 5.5 1.8 virginica
     139 6.0 3.0 4.8 1.8 virginica
     140 6.9 3.1 5.4 2.1 virginica
     141 6.7 3.1 5.6 2.4 virginica
     142 6.9 3.1 5.1 2.3 virginica
     143 5.8 2.7 5.1 1.9 virginica
     144 6.8 3.2 5.9 2.3 virginica
     145 6.7 3.3 5.7 2.5 virginica
     146 6.7 3.0 5.2 2.3 virginica
     147 6.3 2.5 5.0 1.9 virginica
     148 6.5 3.0 5.2 2.0 virginica
     149 6.2 3.4 5.4 2.3 virginica
     150 5.9 3.0 5.1 1.8 virginica
     >
     > stopifnot(all.equal(iris.1, iris.2))
     > stopifnot(all.equal(iris.1, iris.3))
     >
     > exampleFile <- file.path(path.package('gdata'),'xls',
     + 'ExampleExcelFile.xls')
     >
     > exampleFileX <- file.path(path.package('gdata'),'xls',
     + 'ExampleExcelFile.xlsx')
     >
     > # see the number and names of sheets:
     > sheetCount(exampleFile)
     [1] 4
     >
     > if(! 'XLSX' %in% xlsFormats() )
     + {
     + cat("************************************************************\n")
     + cat("** DIFF IN THIS SECTION IS EXPECTED BECAUSE PERL PACKAGES **\n")
     + cat("** FOR SUPPORTING XLSX ARE NOT INSTALLED **\n")
     + cat("************************************************************\n")
     + } else {
     + sheetCount(exampleFileX)
     + }
     ************************************************************
     ** DIFF IN THIS SECTION IS EXPECTED BECAUSE PERL PACKAGES **
     ** FOR SUPPORTING XLSX ARE NOT INSTALLED **
     ************************************************************
     >
     >
     > sheetNames(exampleFile)
     [1] "Sheet First" "Sheet Second"
     [3] "Sheet with a very long name!" "Sheet with initial text"
     >
     > if(! 'XLSX' %in% xlsFormats() )
     + {
     + cat("************************************************************\n")
     + cat("** DIFF IN THIS SECTION IS EXPECTED BECAUSE PERL PACKAGES **\n")
     + cat("** FOR SUPPORTING XLSX ARE NOT INSTALLED **\n")
     + cat("************************************************************\n")
     + } else {
     + sheetNames(exampleFileX)
     + }
     ************************************************************
     ** DIFF IN THIS SECTION IS EXPECTED BECAUSE PERL PACKAGES **
     ** FOR SUPPORTING XLSX ARE NOT INSTALLED **
     ************************************************************
     >
     >
     > example.1 <- read.xls(exampleFile, sheet=1) # default is first worksheet
     WARNING: Perl module Spreadsheet::ParseXLSX cannot be loaded.
     WARNING: Microsoft Excel 2007 'XLSX' formatted files will not be processed.
     > example.1
     A B C
     1 1 1 1
     2 2 4 8
     3 3 9 27
     4 4 16 64
     5 5 25 125
     6 6 36 216
     7 7 49 343
     >
     > example.2 <- read.xls(exampleFile, sheet=2) # second worksheet by number
     WARNING: Perl module Spreadsheet::ParseXLSX cannot be loaded.
     WARNING: Microsoft Excel 2007 'XLSX' formatted files will not be processed.
     > example.2
     X D E. F G Factor
     1 FirstRow 1 NA NA NA Red
     2 SecondRow 2 1 NA NA Green
     3 ThirdRow 3 2 1 NA Red
     4 FourthRow 4 3 2 1 Black
     >
     > example.3 <- read.xls(exampleFile, sheet=3, header=FALSE) # third worksheet by number
     WARNING: Perl module Spreadsheet::ParseXLSX cannot be loaded.
     WARNING: Microsoft Excel 2007 'XLSX' formatted files will not be processed.
     > example.3
     V1 V2 V3 V4 V5 V6 V7
     1 1 2001-01-01 01:01:00.00 0.2058182 NA A 2001-01-01 01:01:01.01
     2 2 2002-02-02 02:02:00.00 0.2910708 NA B 2002-02-02 02:02:02.02
     3 3 2003-03-03 03:03:00.00 0.3564875 -0.84147098 C 2003-03-03 03:03:03.03
     4 4 2004-04-04 04:04:00.00 0.4116363 0.70807342 2004-04-04 04:04:04.04
     5 5 2005-05-05 05:05:00.00 0.4602234 0.50136797 A 2005-05-05 05:05:05.05
     6 6 2006-06-06 06:06:00.00 NA 0.25136984 B 2006-06-06 06:06:06.06
     7 7 2007-07-07 07:07:00.00 0.5445436 0.06318679 B 2007-07-07 07:07:07.07
     8 8 2008-08-08 08:08:00.00 0.5821416 NA C 2008-08-08 08:08:08.08
     9 9 2009-09-09 09:09:00.00 0.6174545 0.00000000 A 2009-09-09 09:09:09.09
     10 10 2010-10-10 10:10:00.00 0.6508541 0.00000000 A 2010-10-10 10:10:10.10
     V8
     1 36892.04
     2 37289.08
     3 37683.13
     4 38081.17
     5 38477.21
     6 38874.25
     7 39270.30
     8 39668.34
     9 40065.38
     10 40461.42
     >
     > example.4 <- read.xls(exampleFile, sheet=4, header=FALSE) # fourth worksheet by number
     WARNING: Perl module Spreadsheet::ParseXLSX cannot be loaded.
     WARNING: Microsoft Excel 2007 'XLSX' formatted files will not be processed.
     > example.4
     V1
     1 This line contains text that would need to be skipped to get to the data
     2
     3
     4
     5
     6
     7
     V2 V3 V4 V5 V6 V7
     1
     2 This line too!
     3 D E F G Factor
     4 FirstRow 1 <NA> <NA> <NA> Red
     5 SecondRow 2 1 <NA> <NA> Green
     6 ThirdRow 3 2 1 <NA> Red
     7 FourthRow 4 3 2 1 Black
     >
     > if(! 'XLSX' %in% xlsFormats() )
     + {
     + cat("************************************************************\n")
     + cat("** DIFF IN THIS SECTION IS EXPECTED BECAUSE PERL PACKAGES **\n")
     + cat("** FOR SUPPORTING XLSX ARE NOT INSTALLED **\n")
     + cat("************************************************************\n")
     + } else {
     + example.x.1 <- read.xls(exampleFileX, sheet=1) # default is first worksheet
     + print(example.x.1)
     +
     + example.x.2 <- read.xls(exampleFileX, sheet=2) # second worksheet by number
     + print(example.x.2)
     +
     + example.x.3 <- read.xls(exampleFileX, sheet=3, header=FALSE) # third worksheet by number
     + print(example.x.3)
     +
     + example.x.4 <- read.xls(exampleFileX, sheet=4, header=FALSE) # fourth worksheet by number
     + print(example.x.4)
     +
     + data <- read.xls(exampleFileX, sheet="Sheet Second") # and by name
     + print(data)
     +
     + # load the third worksheet, skipping the first two non-data lines...
     + data <- read.xls(exampleFileX, sheet="Sheet with initial text", skip=2)
     + print(data)
     + }
     ************************************************************
     ** DIFF IN THIS SECTION IS EXPECTED BECAUSE PERL PACKAGES **
     ** FOR SUPPORTING XLSX ARE NOT INSTALLED **
     ************************************************************
     >
     > ## Check handling of skip.blank.lines=FALSE
     >
     > example.skip <- read.xls(exampleFile, sheet=2, blank.lines.skip=FALSE)
     WARNING: Perl module Spreadsheet::ParseXLSX cannot be loaded.
     WARNING: Microsoft Excel 2007 'XLSX' formatted files will not be processed.
     > example.skip
     X D E. F G Factor
     1 FirstRow 1 NA NA NA Red
     2 SecondRow 2 1 NA NA Green
     3 NA NA NA NA
     4 ThirdRow 3 2 1 NA Red
     5 FourthRow 4 3 2 1 Black
     >
     > if(! 'XLSX' %in% xlsFormats() )
     + {
     + cat("************************************************************\n")
     + cat("** DIFF IN THIS SECTION IS EXPECTED BECAUSE PERL PACKAGES **\n")
     + cat("** FOR SUPPORTING XLSX ARE NOT INSTALLED **\n")
     + cat("************************************************************\n")
     + } else {
     + example.x.skip <- read.xls(exampleFileX, sheet=2, blank.lines.skip=FALSE)
     + example.x.skip
     + }
     ************************************************************
     ** DIFF IN THIS SECTION IS EXPECTED BECAUSE PERL PACKAGES **
     ** FOR SUPPORTING XLSX ARE NOT INSTALLED **
     ************************************************************
     >
     >
     >
     > ## Check handing of fileEncoding for latin-1 characters
     >
     > latin1File <- file.path(path.package('gdata'),'xls', 'latin-1.xls' )
     > latin1FileX <- file.path(path.package('gdata'),'xls', 'latin-1.xlsx')
     >
     > if(.Platform$OS.type=="unix")
     + {
     + example.latin1 <- read.xls(latin1File,
     + fileEncoding='latin1',
     + encoding='latin1',
     + stringsAsFactors=FALSE)
     + } else {
     + example.latin1 <- read.xls(latin1File,
     + #fileEncoding='latin1',
     + encoding='latin1',
     + stringsAsFactors=FALSE)
     + }
     WARNING: Perl module Spreadsheet::ParseXLSX cannot be loaded.
     WARNING: Microsoft Excel 2007 'XLSX' formatted files will not be processed.
     Error in type.convert.default(data[[i]], as.is = as.is[i], dec = dec, :
     invalid multibyte string at '<e1> '
     Calls: read.xls ... read.csv -> read.table -> type.convert -> type.convert.default
     Execution halted
Flavor: r-devel-windows-x86_64-new-TK