http://bugzilla.scilab.org/show_bug.cgi?id=7063
--------- Bug Summary -----------
xls_read fails to read big excel files
---------- Changed by ------------
sgougeon at free.fr
---------- What changed ----------
bug_file_loc, component
Samuel GOUGEON <sgougeon at free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
URL|-->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,Sheet |
|pos] = |
|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 |
Component|Scilab |Data import/export
--
You are receiving this mail because:
You are watching all bug changes.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.scilab.org/pipermail/bugzilla/attachments/20180322/7cfa7039/attachment.htm>