do anybody knows why this is not working after exporting it and opening it on a browser? the xls file is just numbers and names. it works well on processing.


import de.bezier.data.*;
XlsReader reader;
PFont v22;
PFont v48;

String names[][] = new String [12][118];


void setup() {
smooth();
size(500,500);
v22 = loadFont("verdana_24.vlw");
v48 = loadFont("verdana_48.vlw");
reader = new XlsReader( this, "a.xls" );
background(0);
readall();
}



void draw() {
     


}

void readall(){
 
for(int i = 1;i<=11;i++){
  fill(random(0,255),random(0,255),random(0,255));
    for(int j = 1;j<=117;j++){
      fp(i,j,-150+i*150,j*10);
    }
}  
 
 
}

void fp(int x, int y, float px, float py){ //thesh keliou: x/y // pou na emfanistei: px/py
 reader.firstRow();
 reader.firstCell();
 for(int j = 1;j<y;j++){
   reader.nextRow();
 }
 for(int i = 1;i<x;i++){
   reader.nextCell();
 }
 textFont(v48,15);  
 
 String[] list = split(reader.getString(), "."); // kratame mono to 1o meros an xorizetai me . (teleia)
 
 text(list[0], px, py,140,15);
 
 names[x][y] = list[0];
 
}

i get this:
ERR, getString(): you are reading a numeric cell as string.

but, even without it it will not run
the xls is included in the data folder of the sketch but do i have to put it manualy in the applet folder after i have exported it?

XlsReader will not work in (normal) applets. The underlying framework (poi.apache.org) tries to gain read-write access which is not allowed for unsigned applets.

I'm looking for a fix and will report back ...