<html>
<head>
<base href="http://bugzilla.scilab.org/" />
</head>
<body><span class="vcard"><a class="email" href="mailto:sgougeon@free.fr" title="Samuel GOUGEON <sgougeon@free.fr>"> <span class="fn">Samuel GOUGEON</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - xls_read fails to read big excel files"
href="http://bugzilla.scilab.org/show_bug.cgi?id=7063">bug 7063</a>
<br><br>
---------- Bug Summary ----------- <br>xls_read fails to read big excel files <br><br>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">URL</td>
<td>-->stacksize max
//willitbug.xls has one sheet named 'freud'. In the first column there are numbers (let say zipcodes). In the second column there are strings (let say city names)
//there are 36681 rows (each row is a french city)
-->[fd,SST,Sheetnames,Sheetpos] = xls_open("willitbug.xls");
-->[donnees txt]=xls_read(fd, Sheetpos(find(Sheetnames=='freud')));
//number of cities (rows)
-->nb_comunes = size(donnees,1);
//zipcodes : no problem, they are read as numbers
-->codgeo = donnees(:,1);
-->//indexes corresponding to the second row in the xls file
-->txtind = txt(:,2);
//that should give all the city names. HERE IS THE BUG
-->nam = SST(txtind);
!--error 21
Index invalide.
//xls_read has fail to read the whole column:
//this shows where the first problem occurs
-->find(txtind==0,1)
ans =
32769.
//after the line (row) number 32769, xlr_read was unable to get the text
-->sum(txtind(32769:$))
ans =
0.
//and the next result is strange too:
-->size(SST)
ans =
1. 34491. //where are the 2190 other cities?
-->nb_comunes
nb_comunes =
36681
</td>
<td>
</td>
</tr>
<tr>
<td style="text-align:right;">Component</td>
<td>Scilab
</td>
<td>Data import/export
</td>
</tr></table>
<p>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are watching all bug changes.</li>
</ul>
</body>
</html>