Home
last modified time | relevance | path

Searched refs:xls (Results 1 – 25 of 1936) sorted by relevance

12345678910>>...78

/dports/textproc/p5-Spreadsheet-Read/Spreadsheet-Read-0.84/t/
H A D36_xls.t35 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 D30_xls.t30 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 D611_clr.t16 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 D610_xlsx.t29 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 D33_misc.t14 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 Dtest-geometry.R53 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 Dtest-trim-ws.R10 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 DMANIFEST43 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 Dcookbook.rst15 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 Dtutorial_file.rst87 ---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 Dxlsclose.m65 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 Dxls2oct.m128 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 Doct2xls.m23 ## @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 DMakefile.am29 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 Dxls2sep.R5 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 DsheetCount.R1 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 Dread.xls.Rd1 \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 DMD576 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__.m18 ## @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 DREADME.rst2 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 DPKG-INFO2 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 Dxlsx2csv45 "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 DREADME1 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 DPKG-INFO2 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 Dt9010-ssgrep.pl125 $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 …]

12345678910>>...78