1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
## Copyright (C) 2012,2013 Philip Nienhuis
##
## This program is free software; you can redistribute it and/or modify
## it under the terms of the GNU General Public License as published by
## the Free Software Foundation; either version 3 of the License, or
## (at your option) any later version.
##
## This program is distributed in the hope that it will be useful,
## but WITHOUT ANY WARRANTY; without even the implied warranty of
## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
## GNU General Public License for more details.
##
## You should have received a copy of the GNU General Public License
## along with Octave; see the file COPYING. If not, see
## <http://www.gnu.org/licenses/>.
## __JXL_spsh_info__
## Author: Philip Nienhuis <prnienhuis@users.sf.net>
## Created: 2012-10-12
## Updates:
## 2012-10-12 Moved into ./private
## 2012-10-24 Style fixes
## 2013-12-01 Style fixes, copyright string updates
function [sh_names, fformat] = __JXL_spsh_info__ (xls)
sh_cnt = xls.workbook.getNumberOfSheets ();
sh_names = cell (sh_cnt, 2); nsrows = zeros (sh_cnt, 1);
sh_names(:,1) = char (xls.workbook.getSheetNames ());
for ii=1:sh_cnt
[tr, lr, lc, rc] = getusedrange (xls, ii);
if (tr)
sh_names(ii, 2) = ...
sprintf ("%s:%s", calccelladdress (tr, lc), calccelladdress (lr, rc));
else
sh_names(ii, 2) = "Empty";
endif
endfor
if (sh_cnt > 0)
fformat = "xlWorkbookNormal";
else
fformat = '';
endif
endfunction
|
