I want to read a csv file and show it in handsontable.
var container = document.getElementById('grid');
hot = new Handsontable(container, {
data: seri,
rowHeaders: true,
colHeaders: true,
width: 700,
height: 650,
colWidths: 70,
rowHeights: 35,
type: 'numeric',
columns: [
{type: 'numeric'}
]
});
this is the seri on console:
> seri
> Array[388][0 … 99]0: 41231: 0.0107682: -49.4367373: 650.6457164: 7.0857265: -54.7165716: -2.9605137: 0.0840968: 0.010899: -49.29449210: 650.57193511: 7.18785712: -54.68423513: -2.94445414: 0.08405615: 0.01104916: -49.15137517: 650.49585718: 7.28964819: -54.65077320: -2.92422421: 0.08401422: 0.01120623: -49.00843624: 650.3760225: 7.36796826: -54.62385127: -2.89985428: 0.08398829: 0.01132930: -48.88853431: 650.21520132: 7.45489733: -54.59044834: -2.88326635: 0.08395836: 0.01146537: -48.76858738: 650.09494739: 7.54962340: -54.55155541: -2.86671742: 0.08391343: 0.01161344: -48.67299945: 649.9780146: 7.64585547: -54.51272648: -2.84655549: 0.08386950: 0.01176351: -48.55416152: 649.86386853: 7.7258954: -54.48481255: -2.82282356: 0.0838457: 0.01188858: -48.4584559: 649.74611560: 7.80665661: -54.44597662: -2.8028163: 0.08379664: 0.01201565: -48.3624966: 649.59086267: 7.89536168: -54.40073269: -2.7869970: 0.08374671: 0.01215472: -48.26595973: 649.39036974: 7.97572175: -54.36090876: -2.76270877: 0.08371178: 0.01228279: -48.14594280: 649.18885681: 8.05491482: -54.32214683: -2.74621284: 0.08367785: 0.01240886: -48.02662587: 648.95582788: 8.12741589: -54.27710490: -2.72685391: 0.08363892: 0.01252493: -47.90747994: 648.71995295: 8.21516996: -54.2330697: -2.7033598: 0.083699: 0.012664[100 … 199][200 … 299][300 … 387]300: -2.085983301: 0.08266302: 0.015978303: -44.760909304: 642.725975305: 10.330791306: -53.09709307: -2.065827308: 0.082612309: 0.016073310: -44.644074311: 642.450181312: 10.380146313: -53.052175314: -2.042044315: 0.082578316: 0.016157317: -44.551554318: 642.218269319: 10.438804320: -53.001834321: -2.014685322: 0.082529323: 0.016254324: -44.457921325: 641.938524326: 10.504291327: -52.956786328: -1.994598329: 0.082495330: 0.016363331: -44.341151332: 641.579312333: 10.568892334: -52.902158335: -1.966701336: 0.082456337: 0.016473338: -44.248068339: 641.262282340: 10.626936341: -52.851887342: -1.930823343: 0.082419344: 0.016572345: -44.153732346: 640.94049347: 10.699754348: -52.81121349: -1.906376350: 0.082396351: 0.016694352: -44.060307353: 640.662029354: 10.765246355: -52.76623356: -1.886032357: 0.082362358: 0.016803359: -43.965705360: 640.382492361: 10.830543362: -52.729848363: -1.865895364: 0.082341365: 0.016913366: -43.848074367: 640.104061368: 10.89496369: -52.694595370: -1.837917371: 0.082322372: 0.017021373: -43.753693374: 639.822834375: 10.975575376: -52.648428377: -1.813508378: 0.082286379: 0.017154380: -43.65902381: 639.462039382: 11.025339383: -52.612177384: -1.793423385: 0.082276386: 0.017242387: -43length: 388__proto__: Array[0]
and the result is just bunch of blank cells. why? can handsontable handle floating points ( not just for currency)?