summaryrefslogtreecommitdiff
path: root/modules/spreadsheet/demos
diff options
context:
space:
mode:
Diffstat (limited to 'modules/spreadsheet/demos')
-rwxr-xr-xmodules/spreadsheet/demos/spreadsheet.dem.gateway.sce18
-rwxr-xr-xmodules/spreadsheet/demos/spreadsheet.dem.sce36
-rwxr-xr-xmodules/spreadsheet/demos/xls/README18
-rwxr-xr-xmodules/spreadsheet/demos/xls/Test1.xlsbin0 -> 9216 bytes
-rwxr-xr-xmodules/spreadsheet/demos/xls/Testbig.xlsbin0 -> 143872 bytes
-rwxr-xr-xmodules/spreadsheet/demos/xls/Testo1.xlsbin0 -> 9728 bytes
-rwxr-xr-xmodules/spreadsheet/demos/xls/Testobig.xlsbin0 -> 179712 bytes
-rwxr-xr-xmodules/spreadsheet/demos/xls/o1.xlsbin0 -> 7168 bytes
-rwxr-xr-xmodules/spreadsheet/demos/xls/t1.xlsbin0 -> 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
new file mode 100755
index 000000000..3296c3c2c
--- /dev/null
+++ b/modules/spreadsheet/demos/xls/Test1.xls
Binary files differ
diff --git a/modules/spreadsheet/demos/xls/Testbig.xls b/modules/spreadsheet/demos/xls/Testbig.xls
new file mode 100755
index 000000000..aa2a7153f
--- /dev/null
+++ b/modules/spreadsheet/demos/xls/Testbig.xls
Binary files differ
diff --git a/modules/spreadsheet/demos/xls/Testo1.xls b/modules/spreadsheet/demos/xls/Testo1.xls
new file mode 100755
index 000000000..1ee6c3952
--- /dev/null
+++ b/modules/spreadsheet/demos/xls/Testo1.xls
Binary files differ
diff --git a/modules/spreadsheet/demos/xls/Testobig.xls b/modules/spreadsheet/demos/xls/Testobig.xls
new file mode 100755
index 000000000..478f106f8
--- /dev/null
+++ b/modules/spreadsheet/demos/xls/Testobig.xls
Binary files differ
diff --git a/modules/spreadsheet/demos/xls/o1.xls b/modules/spreadsheet/demos/xls/o1.xls
new file mode 100755
index 000000000..b91ea7ff7
--- /dev/null
+++ b/modules/spreadsheet/demos/xls/o1.xls
Binary files differ
diff --git a/modules/spreadsheet/demos/xls/t1.xls b/modules/spreadsheet/demos/xls/t1.xls
new file mode 100755
index 000000000..012a8ebec
--- /dev/null
+++ b/modules/spreadsheet/demos/xls/t1.xls
Binary files differ