/dports/textproc/p5-Spreadsheet-Read/Spreadsheet-Read-0.84/t/ |
H A D | 36_xls.t | 35 binmode $xls; 36 $content = <$xls>; 37 close $xls; 40 my $xls; 52 is (scalar keys %{$xls->[0]{sheet}}, 84 is ($xls->[1]{maxrow}, 25, "MaxRow"); 85 is ($xls->[1]{maxcol}, 3, "MaxCol"); 91 is ($#{$xls->[1]{cell}[3]}, $xls->[1]{maxrow}, "cell structure"); 92 ok (defined $xls->[1]{cell}[$xls->[1]{maxcol}][$xls->[1]{maxrow}], "last cell"); 135 ok (my $ss = $xls->[1], "first sheet"); [all …]
|
H A D | 30_xls.t | 30 binmode $xls; 31 $content = <$xls>; 32 close $xls; 35 my $xls; 40 ok ($xls = ReadData ($txt), $msg); 47 is (scalar keys %{$xls->[0]{sheet}}, 79 is ($xls->[1]{maxrow}, 25, "MaxRow"); 80 is ($xls->[1]{maxcol}, 3, "MaxCol"); 86 is ($#{$xls->[1]{cell}[3]}, $xls->[1]{maxrow}, "cell structure"); 87 ok (defined $xls->[1]{cell}[$xls->[1]{maxcol}][$xls->[1]{maxrow}], "last cell"); [all …]
|
H A D | 611_clr.t | 16 my $xls; 17 ok ($xls = ReadData ("files/attr.xlsx", attr => 1), "Excel Attributes testcase"); 20 ok (my $clr = $xls->[$xls->[0]{sheet}{Colours}], "colors"); 23 skip "$xls->[0]{parser} $xls->[0]{version} does not reliably support colors yet", 255; 52 ok ($xls = Spreadsheet::Read->new ("files/attr.xlsx", attr => 1), "Attributes OO"); 53 is ($xls->[1]{attr}[3][3]{fgcolor}, "#008000", "C3 Forground color direct"); 54 is ($xls->sheet (1)->attr (3, 3)->{fgcolor}, "#008000", "C3 Forground color OO rc hash"); 55 is ($xls->sheet (1)->attr ("C3")->{fgcolor}, "#008000", "C3 Forground color OO cell hash"); 59 is ($xls->[1]{attr}[3][3]{bogus_attribute}, undef, "C3 bogus attribute direct"); 60 is ($xls->sheet (1)->attr ("C3")->{bogus_attr}, undef, "C3 bogus attribute OO hash"); [all …]
|
H A D | 610_xlsx.t | 29 binmode $xls; 30 $content = <$xls>; 31 close $xls; 34 my $xls; 39 ok ($xls = ReadData ($txt), $msg); 42 is (ref $xls, "ARRAY", "Return type"); 44 is ($xls->[0]{sheets}, 2, "Sheet count"); 46 is (scalar keys %{$xls->[0]{sheet}}, 48 my $xvsn = $xls->[0]{version}; 74 ok (my $ss = $xls->[1], "first sheet"); [all …]
|
H A D | 33_misc.t | 14 my $xls; 18 $xls = ReadData ("files/misc.xls", 27 ok ($xls, "Open with options"); 28 is ($xls->[0]{sheets}, 3, "Sheet Count"); 32 $xls = ReadData ("files/misc.xls", 41 ok ($xls, "Open with options"); 42 is ($xls->[1]{cell}[1], undef, "undef works as option value for 'rc'"); 43 ok (!exists $xls->[1]{A1}, "undef works as option value for 'cells'"); 47 $xls = ReadData ("files/misc_ws.xls", 54 ok ($xls, "Open with options, let's see if we get any warnings");
|
/dports/textproc/R-cran-readxl/readxl/tests/testthat/ |
H A D | test-geometry.R | 53 expect_identical(xls, xlsx) 54 expect_identical(xls, ref) 69 expect_identical(xls, xlsx) 70 expect_identical(xls, ref) 80 expect_identical(xls, xlsx) 81 expect_identical(xls, ref) 88 expect_identical(xls, xlsx) 94 expect_identical(xls, xlsx) 100 expect_identical(xls, xlsx) 106 expect_identical(xls, xlsx) [all …]
|
H A D | test-trim-ws.R | 10 expect_identical(xls[[1]], trimws(xls[[1]])) 15 expect_identical(xls[[1]], xlsx[[1]]) 20 expect_identical(names(xls), trimws(names(xls))) 30 xls <- read_excel( globalVar 38 expect_false(identical(xls[[1]], trimws(xls[[1]]))) 42 ws_only <- grepl("^\\s*$", xls[[1]]) 48 expect_false(identical(names(xls), trimws(names(xls)))) 54 xls <- read_excel( globalVar 62 expect_is(xls$numeric, "numeric") 64 expect_true(is.na(xls[[2, 1]])) [all …]
|
/dports/textproc/p5-Spreadsheet-ParseExcel/Spreadsheet-ParseExcel-0.65/ |
H A D | MANIFEST | 43 t/excel_files/Dates.xls 46 t/excel_files/Test95.xls 47 t/excel_files/Test95J.xls 48 t/excel_files/Test97J.xls 50 t/excel_files/chart1.xls 51 t/excel_files/chart2.xls 52 t/excel_files/chart3.xls 53 t/excel_files/chart4.xls 91 sample/Excel/Rich.xls 94 sample/Excel/Test95.xls [all …]
|
/dports/textproc/py-pyexcel/pyexcel-0.6.7/docs/source/ |
H A D | cookbook.rst | 15 example.xls 46 >>> update_columns("example.xls", custom_column, "output.xls") 70 example.xls 96 >>> update_rows("example.xls", custom_row, "output.xls") 128 example.xls 160 >>> merge_two_files("example.csv", "example.xls", "output.xls") 194 example.xls 264 example.xls 292 >>> merge_all_to_a_book(["example.csv", "example.xls"], "output.xls") 378 >>> split_a_book("megabook.xls", "output.xls") [all …]
|
H A D | tutorial_file.rst | 87 ---pyexcel:example.xls--- 118 >>> sheet.save_as("new_example.xls") 148 >>> sheet.save_as("new_example1.xls") 245 ---pyexcel:row_example.xls--- 288 >>> os.unlink("new_example.xls") 289 >>> os.unlink("new_example1.xls") 290 >>> os.unlink("new_example2.xls") 291 >>> os.unlink("new_example3.xls") 292 >>> os.unlink("new_example4.xls") 293 >>> os.unlink("new_example5.xls") [all …]
|
/dports/math/octave-forge-io/io-2.6.4/inst/ |
H A D | xlsclose.m | 65 function [ xls ] = xlsclose (xls, varargin) 86 if (xls.changed == 0 || xls.changed > 2) 118 xls = __COM_spsh_close__ (xls); variable 121 xls = __JOD_spsh_close__ (xls); variable 124 xls = __JXL_spsh_close__ (xls); variable 127 xls = __OTK_spsh_close__ (xls, force); variable 130 xls = __OXS_spsh_close__ (xls); variable 133 xls = __POI_spsh_close__ (xls); variable 136 xls = __UNO_spsh_close__ (xls, force); variable 139 xls = __OCT_spsh_close__ (xls, "xlsclose"); variable [all …]
|
H A D | xls2oct.m | 128 if (! isstruct (xls)) 153 [datrange, wsh, xls] = chknmrange (xls, datrange, wsh); 183 [rawarr, xls, rstatus] = __COM_spsh2oct__ (xls, wsh, datrange, spsh_opts); 192 [rawarr, xls, rstatus] = __JOD_spsh2oct__ (xls, wsh, datrange, spsh_opts); 195 [rawarr, xls, rstatus] = __JXL_spsh2oct__ (xls, wsh, datrange, spsh_opts); 198 switch xls.odfvsn 206 [rawarr, xls, rstatus] = __OTK_spsh2oct__ (xls, wsh, datrange, spsh_opts); 209 [rawarr, xls, rstatus] = __OXS_spsh2oct__ (xls, wsh, datrange, spsh_opts); 221 [rawarr, xls, rstatus] = __OCT_gnm2oct__ (xls, wsh, datrange); 243 xls.limits = []; [all …]
|
H A D | oct2xls.m | 23 ## @var{xls}. 25 ## Return argument @var{xls} equals supplied argument @var{xls} and is 161 [crange, wsh, xls] = chknmrange (xls, crange, wsh); 164 if (strcmpi (xls.filename(end-4:end-1), ".xls")) 201 [xls, rstatus] = __COM_oct2spsh__ (obj, xls, wsh, crange, spsh_opts); 204 [ xls, rstatus ] = __JOD_oct2spsh__ (obj, xls, wsh, crange); 207 [xls, rstatus] = __JXL_oct2spsh__ (obj, xls, wsh, crange, spsh_opts); 210 [xls, rstatus] = __OXS_oct2spsh__ (obj, xls, wsh, crange, spsh_opts); 223 [xls, rstatus] = __POI_oct2spsh__ (obj, xls, wsh, crange, spsh_opts); 226 [xls, rstatus] = __UNO_oct2spsh__ (obj, xls, wsh, crange, spsh_opts); [all …]
|
/dports/textproc/freexl/freexl-1.0.6/tests/ |
H A D | Makefile.am | 29 testdata/oocalc_empty97.xls \ 30 testdata/oocalc_simple95.xls \ 32 testdata/empty2003.xls \ 33 testdata/simple2003.xls \ 34 testdata/simple2003_21.xls \ 35 testdata/simple2003_3.xls \ 36 testdata/simple2003_4.xls \ 39 testdata/simple2003_5WB.xls \ 40 testdata/datetime2003.xls \ 41 testdata/testcase1.xls \ [all …]
|
/dports/devel/R-cran-gdata/gdata/R/ |
H A D | xls2sep.R | 5 xls2sep(xls=xls, sheet=sheet, verbose=verbose, 11 xls2sep(xls=xls, sheet=sheet, verbose=verbose, 17 xls2sep(xls=xls, sheet=sheet, verbose=verbose, 21 xls2sep <- function(xls, argument 46 if ( substring(xls, 1, 7) == "http://" || 47 substring(xls, 1, 6) == "ftp://" ) 52 dQuote(xls), " to ", 54 download.file(xls, tf, mode = "wb") 56 xls <- tf 95 shQuote(xls), [all …]
|
H A D | sheetCount.R | 1 sheetCount <- function(xls, verbose = FALSE, perl = "perl") { argument 4 sheetCmd(xls, cmd="sheetCount.pl", verbose=verbose, perl=perl) 7 sheetNames <- function(xls, verbose = FALSE, perl = "perl") { argument 10 sheetCmd(xls, cmd="sheetNames.pl", verbose=verbose, perl=perl) 26 if ( substring(xls, 1, 7) == "http://" || 27 substring(xls, 1, 6) == "ftp://" ) 32 dQuote(xls), " to ", 36 download.file(xls, tf, mode = "wb") 38 xls <- tf 50 cmd <- paste(shQuote(perl), shQuote(sc), shQuote(xls), sep=" ") [all …]
|
/dports/devel/R-cran-gdata/gdata/man/ |
H A D | read.xls.Rd | 1 \name{read.xls} 2 \alias{read.xls} 10 read.xls(xls, sheet=1, verbose=FALSE, pattern, na.strings=c("NA","#DIV/0!"), 38 \code{"read.xls"} returns a data frame. 70 xlsfile <- file.path(path.package('gdata'),'xls','iris.xls') 97 iris <- read.xls(xlsfile, perl="/usr/bin/perl") 102 iris <- read.xls(xlsfile, perl=perl) 106 ## read xls file from net 108 nba <- read.xls(nba.url) 114 crime <- read.xls(crime.url, pattern = "State") [all …]
|
/dports/textproc/R-cran-readxl/readxl/ |
H A D | MD5 | 76 30a624f1c6e25ecf38169ba5db7478e3 *src/xls.c 83 bc3e1e9692f94b0d144309c01a4c2f28 *tests/testthat/sheets/65536-rows-xls.xls 86 1761922bdaae72328538d663d0a5c8c4 *tests/testthat/sheets/big-texty-numbers-xls.xls 93 be135d229f0b590f4aeb0eaa704dbc78 *tests/testthat/sheets/dates-leap-year-1900-xls.xls 106 e33da78d404624fe45c75bb9835bcbb0 *tests/testthat/sheets/iris-excel-xls.xls 115 dc2e78db47889ed44188dda631ef6f9b *tests/testthat/sheets/missing-values-xls.xls 117 21804fc504d15926b10c2d80ac2d4e8a *tests/testthat/sheets/more-than-256-unique-strings-xls.xls 119 dfb3ab964bcdca0c607299ad75cfca49 *tests/testthat/sheets/names-need-repair-xls.xls 126 e9cd3a21b26b47b07b8e9ed467761add *tests/testthat/sheets/numbers-as-na-and-shared-strings-xls.xls 134 dcbf8a23bb36b795728cc8ba40a289a9 *tests/testthat/sheets/texty-dates-xls.xls [all …]
|
/dports/math/octave-forge-io/io-2.6.4/inst/private/ |
H A D | __OCT_spsh_close__.m | 18 ## @deftypefn {Function File} {@var{xls} =} __OCT_spsh_close__ (@var{xls}) 27 function [xls] = __OCT_spsh_close__ (xls, fcn) 29 if (isfield (xls, "nfilename")) 30 xls.filename = xls.nfilename; 44 if (xls.changed && xls.changed < 3) 46 cd (xls.workbook); 68 xls.changed = 0; 88 unlink (xls.workbook); 89 xls.changed = 0; 105 if (! xls.changed) [all …]
|
/dports/textproc/py-pyexcel-xls/pyexcel-xls-0.7.0/ |
H A D | README.rst | 2 pyexcel-xls - Let you focus on data, instead of xls format 107 $ pip install pyexcel-xls 115 $ cd pyexcel-xls 140 Write to an xls file 156 Read from an xls file 170 Write an xls to memory 190 Read from an xls from memory 256 >>> os.unlink("huge_file.xls") 267 Reading from an xls file 289 Writing to an xls file [all …]
|
H A D | PKG-INFO | 2 Name: pyexcel-xls 10 Keywords: python,xls,xlsx,xlsm 24 pyexcel-xls - Let you focus on data, instead of xls format 137 $ cd pyexcel-xls 146 Write to an xls file 162 Read from an xls file 176 Write an xls to memory 267 Reading from an xls file 289 Writing to an xls file 357 #. cd pyexcel-xls [all …]
|
/dports/textproc/p5-Spreadsheet-Read/Spreadsheet-Read-0.84/scripts/ |
H A D | xlsx2csv | 45 "i|s|in=s" => \ my $xls, 88 unless ($xls) { 91 $xls = splice @ARGV, $i, 1; 96 $xls or usage 1, "No input file"; 98 -s $xls or usage 1, "Input file empty"; 113 my $ss = ReadData ($xls) or die "Cannot read/parse $xls\n"; 115 $csv and $xls = $csv; 116 $xls =~ s/$valid_ext $//ix; 142 my $fn = "$xls.zip"; 156 warn "Converting $xls to $csv ...\n"; [all …]
|
/dports/math/scilab/scilab-6.1.1/scilab/modules/spreadsheet/demos/xls/ |
H A D | README | 1 The files t1.xls Test1.xls and Testbig.xls have been built by Microsoft Excel 2000 3 The files o1.xls Testo1.xls and Testobig.xls have been built by OpenOffice 1.0.2 7 - t1.xls and o1.xls 10 - Test1.xls and Testo1.xls 14 - Testbig.xls and Testobig.xls
|
/dports/textproc/py-pyexcel-xls/pyexcel-xls-0.7.0/pyexcel_xls.egg-info/ |
H A D | PKG-INFO | 2 Name: pyexcel-xls 10 Keywords: python,xls,xlsx,xlsm 24 pyexcel-xls - Let you focus on data, instead of xls format 137 $ cd pyexcel-xls 146 Write to an xls file 162 Read from an xls file 176 Write an xls to memory 267 Reading from an xls file 289 Writing to an xls file 357 #. cd pyexcel-xls [all …]
|
/dports/math/gnumeric/gnumeric-1.12.50/test/ |
H A D | t9010-ssgrep.pl | 125 $samples/excel/mathfuns.xls:SUM 126 $samples/excel/mathfuns.xls:SUMIF 128 $samples/excel/mathfuns.xls:SUMSQ 129 $samples/excel/mathfuns.xls:SUMX2MY2 130 $samples/excel/mathfuns.xls:SUMX2PY2 131 $samples/excel/mathfuns.xls:SUMXMY2 132 $samples/excel/engfuns.xls:IMSUM 150 $samples/excel/mathfuns.xls:SUM 151 $samples/excel/mathfuns.xls:SUMIF 153 $samples/excel/mathfuns.xls:SUMSQ [all …]
|