diff options
Diffstat (limited to 'modules/spreadsheet/demos')
-rwxr-xr-x | modules/spreadsheet/demos/spreadsheet.dem.gateway.sce | 18 | ||||
-rwxr-xr-x | modules/spreadsheet/demos/spreadsheet.dem.sce | 36 | ||||
-rwxr-xr-x | modules/spreadsheet/demos/xls/README | 18 | ||||
-rwxr-xr-x | modules/spreadsheet/demos/xls/Test1.xls | bin | 0 -> 9216 bytes | |||
-rwxr-xr-x | modules/spreadsheet/demos/xls/Testbig.xls | bin | 0 -> 143872 bytes | |||
-rwxr-xr-x | modules/spreadsheet/demos/xls/Testo1.xls | bin | 0 -> 9728 bytes | |||
-rwxr-xr-x | modules/spreadsheet/demos/xls/Testobig.xls | bin | 0 -> 179712 bytes | |||
-rwxr-xr-x | modules/spreadsheet/demos/xls/o1.xls | bin | 0 -> 7168 bytes | |||
-rwxr-xr-x | modules/spreadsheet/demos/xls/t1.xls | bin | 0 -> 13824 bytes |
9 files changed, 72 insertions, 0 deletions
diff --git a/modules/spreadsheet/demos/spreadsheet.dem.gateway.sce b/modules/spreadsheet/demos/spreadsheet.dem.gateway.sce new file mode 100755 index 000000000..2d727fc10 --- /dev/null +++ b/modules/spreadsheet/demos/spreadsheet.dem.gateway.sce @@ -0,0 +1,18 @@ +// Scilab ( http://www.scilab.org/ ) - This file is part of Scilab +// Copyright (C) 2011 - DIGITEO - Allan CORNET +// +// This file is released under the 3-clause BSD license. See COPYING-BSD. + +function subdemolist = demo_gateway() + + demopath = get_absolute_file_path("spreadsheet.dem.gateway.sce"); + add_demo(_("Spreadsheet"), demopath + "spreadsheet.dem.gateway.sce"); + + subdemolist = [_("Read a xls file") ,"spreadsheet.dem.sce"]; + + subdemolist(:,2) = demopath + subdemolist(:,2); + +endfunction + +subdemolist = demo_gateway(); +clear demo_gateway;
\ No newline at end of file diff --git a/modules/spreadsheet/demos/spreadsheet.dem.sce b/modules/spreadsheet/demos/spreadsheet.dem.sce new file mode 100755 index 000000000..1bfa54def --- /dev/null +++ b/modules/spreadsheet/demos/spreadsheet.dem.sce @@ -0,0 +1,36 @@ +// Scilab ( http://www.scilab.org/ ) - This file is part of Scilab +// Copyright (C) ????-2008 - INRIA - Allan CORNET +// Copyright (C) 2010 - DIGITEO - Allan CORNET +// +// This file is released under the 3-clause BSD license. See COPYING-BSD. + +function demo_spreadsheet() + + l = lines(); + lines(0); + + m = mode(); + mode(1); + + mprintf("\n// Decode ole file, extract and open Excel stream\n"); + mprintf("[fd, SST, Sheetnames, Sheetpos] = xls_open(''SCI/modules/spreadsheet/demos/xls/Test1.xls'')\n"); + + [fd, SST, Sheetnames, Sheetpos] = xls_open("SCI/modules/spreadsheet/demos/xls/Test1.xls") + + mprintf("\n// Read first data sheet\n"); + mprintf("[Value, TextInd] = xls_read(fd, Sheetpos(1))\n"); + + [Value, TextInd] = xls_read(fd, Sheetpos(1)) + + //close the spreadsheet stream + mclose(fd); + + mprintf("\n"); + + mode(m); + lines(l(2), l(1)); + +endfunction + +demo_spreadsheet() +clear demo_spreadsheet; diff --git a/modules/spreadsheet/demos/xls/README b/modules/spreadsheet/demos/xls/README new file mode 100755 index 000000000..e292a9b20 --- /dev/null +++ b/modules/spreadsheet/demos/xls/README @@ -0,0 +1,18 @@ +The files t1.xls Test1.xls and Testbig.xls have been built by Microsoft Excel 2000 + +The files o1.xls Testo1.xls and Testobig.xls have been built by OpenOffice 1.0.2 +Currently the OpenOffice can be read but the results are not ok. It seems that +OpenOffice does not set the formula value + +- t1.xls and o1.xls + contain 3 Excel sheets the first 2 sheets contain 2x2 arrays the last one is empty + +- Test1.xls and Testo1.xls + contain 1 Excel sheet (20x4). First 2 rows contain text, + for the other rows, Columns 2:4 data are defined by formulas. + +- Testbig.xls and Testobig.xls + contain 1 Excel sheet (1000x4). First 2 rows contain text, + for the other rows, Columns 2:4 data are defined by formulas. + + diff --git a/modules/spreadsheet/demos/xls/Test1.xls b/modules/spreadsheet/demos/xls/Test1.xls Binary files differnew file mode 100755 index 000000000..3296c3c2c --- /dev/null +++ b/modules/spreadsheet/demos/xls/Test1.xls diff --git a/modules/spreadsheet/demos/xls/Testbig.xls b/modules/spreadsheet/demos/xls/Testbig.xls Binary files differnew file mode 100755 index 000000000..aa2a7153f --- /dev/null +++ b/modules/spreadsheet/demos/xls/Testbig.xls diff --git a/modules/spreadsheet/demos/xls/Testo1.xls b/modules/spreadsheet/demos/xls/Testo1.xls Binary files differnew file mode 100755 index 000000000..1ee6c3952 --- /dev/null +++ b/modules/spreadsheet/demos/xls/Testo1.xls diff --git a/modules/spreadsheet/demos/xls/Testobig.xls b/modules/spreadsheet/demos/xls/Testobig.xls Binary files differnew file mode 100755 index 000000000..478f106f8 --- /dev/null +++ b/modules/spreadsheet/demos/xls/Testobig.xls diff --git a/modules/spreadsheet/demos/xls/o1.xls b/modules/spreadsheet/demos/xls/o1.xls Binary files differnew file mode 100755 index 000000000..b91ea7ff7 --- /dev/null +++ b/modules/spreadsheet/demos/xls/o1.xls diff --git a/modules/spreadsheet/demos/xls/t1.xls b/modules/spreadsheet/demos/xls/t1.xls Binary files differnew file mode 100755 index 000000000..012a8ebec --- /dev/null +++ b/modules/spreadsheet/demos/xls/t1.xls |