xlswrite and apache poi

I built a method using ApachePOI but it is too slow. I noticed that xlswrite() of Matlab is most clever and I would like to use it in java. Is it possible to do that? I would like to build a .jar file and to import it with java. Can you help me please? Thanks M. Peruzzo

Answer 1

[Image Analyst]

xlswrite is pretty slow if you will be doing multiple writes to the same workbook. Why don't you just use ActiveX directly from your java programming environment to control Excel directly?

That said, MATLAB does have a java product: http://www.mathworks.com/products/javabuilder/

[Mario]

Thanks very much, I don't know what is ActiveX then I would like to use xlswrite() and xlsread(). Can you write for me the code that I must have before to compile with Matlab builder? I saw video but my English is not good so I can only understand writing not listening. Apache POI are not good because they are a big limit. When I finish the available ram of my pc the java program crashes. xlswrite () instead doesn't have limits, I can write very large files and I found it not so slow like you tell to me.

[Image Analyst]

Sorry - I have not used Apache ROI, nor have I used the Java builder tool. Call them on the phone and explain your problem. They will send you a trial version that you can use and then you can ask them questions on how to use it.

[Mario]

I don’t understand the subject about your last sentence, my English is not good. I don't have Matlab R2012b full version but I can use it when I go to university and Apache POI is free.

[Image Analyst]

Buy MATLAB Java Builder, or get a free trial. Call the Mathworks and ask them how to use it to do what you want to do. Click here to get to Google Translate