Rank: 917 based on 93 downloads (last 30 days) and 1 file submitted
photo

Alec de Zegher

E-mail

Personal Profile:
Professional Interests:

 

Watch this Author's files

 

Files Posted by Alec
Updated   File Tags Downloads
(last 30 days)
Comments Rating
27 Feb 2013 Screenshot xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher apache poi, excel, jexcelapi, java, xlwrite, mac 93 26
  • 4.66667
4.7 | 15 ratings
Comments and Ratings by Alec View all
Updated File Comments Rating
27 Feb 2013 xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher

@Mario: Thanks!

@Thierry: thanks for the recommendations!
1) The Stax library should indeed also be loaded. This will be fixed in next release.

2) Originally we also wanted to add an auto-load function, but we ran into the issue that the POI folder location is unknown. It is allowed to be anywhere on your computer. For example in our matlab-webapplications, the POI libraries are put next to the other java libraries in a central folder. To keep it as generic as possible we decided to throw an error if it is not loaded.

3)xlwrite replacing NaN with the previous number is indeed a bug. This was solved in the update of 25/01/2013.

Best Regards,
Alec

03 Feb 2013 xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher

Hello Jveer,

It should not be a problem to use javaaddpath together with the compiler. We use it for example with de Matlab JA compiler in our company.

To make it work with the compiler:
- Add/drag&drop the POI folder to 'Shared Resource and Helper Files'-window of the compile project
- make sure the javaaddpath point to the right (relative) location.

I hope this helps

25 Jan 2013 xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher

Hello Klaus, the bug is fixed & also the documentation was adapted. I uploaded a new version. It should be online once accepted by the Mathworks.

04 Dec 2012 xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher

Hello Marianna,
When you read the documentation of xl(s)write, you are not allowed to give an empty ([]) sheet. You should use the syntax xlwrite('test.xls',M,'A1:B10') instead of xlwrite('test.xls',M,[],'A1').

Setting the sheet to 1 is also an option, like you said... and the error you are getting is a bug:) I fixed it and uploaded a new version today. It should be online by tomorrow.

27 Nov 2012 xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher

@ Dan & Jason: Thanks for the feedback!

I fixed the bug & uploaded a new version. Should be approved by tha Mathworks soon...

Comments and Ratings on Alec's Files View all
Updated File Comment by Comments Rating
09 May 2013 xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher Jeremy

Update: I tried this on Windows 7 and it worked correctly. On my Mac(10.8) I encountered the problem. Also this was as a .xlsx, it seems the .xls works as stated.
Hi, I've noticed a bug(s) when trying to use xlsread after xlwrite. In my situation it was occurring when the first column of a record was a '1A' instead of a '1a', but solving this next bug may catch that one. I tried to make a sample program to illustrate the bug. The return did not get the second row on the read. Note: If i go into Excel and do something and resave, xlsread then reads the second row:
titles = {'label1', 'label2'};
record = {1, 2};
xlwrite('myXlsx.xlsx', titles, 'A1:B1');
xlwrite('myXlsx.xlsx', record, 'A2:B2');
[~,b,c] = xlsread('myXlsx.xlsx')
b =
'label1'
c =
'label1'

06 May 2013 xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher Tom

great - a little slow - but still great!

10 Apr 2013 xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher Anikiev, Denis

Great submission, thanks.
Why don't you add something like this to beginning:

path = mfilename('fullpath');
name = mfilename;
path = path(1:length(path)-length(name));
javaaddpath([path 'poi_library/poi-3.8-20120326.jar']);
javaaddpath([path 'poi_library/poi-ooxml-3.8-20120326.jar']);
javaaddpath([path 'poi_library/poi-ooxml-schemas-3.8-20120326.jar']);
javaaddpath([path 'poi_library/xmlbeans-2.3.0.jar']);
javaaddpath([path 'poi_library/dom4j-1.6.1.jar']);

05 Mar 2013 xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher Laurin, Alexandre

27 Feb 2013 xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher de Zegher, Alec

@Mario: Thanks!

@Thierry: thanks for the recommendations!
1) The Stax library should indeed also be loaded. This will be fixed in next release.

2) Originally we also wanted to add an auto-load function, but we ran into the issue that the POI folder location is unknown. It is allowed to be anywhere on your computer. For example in our matlab-webapplications, the POI libraries are put next to the other java libraries in a central folder. To keep it as generic as possible we decided to throw an error if it is not loaded.

3)xlwrite replacing NaN with the previous number is indeed a bug. This was solved in the update of 25/01/2013.

Best Regards,
Alec

Top Tags Applied by Alec
excel, xlswrite, apache poi, java, jexcelapi
Files Tagged by Alec View all
Updated   File Tags Downloads
(last 30 days)
Comments Rating
27 Feb 2013 Screenshot xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher apache poi, excel, jexcelapi, java, xlwrite, mac 93 26
  • 4.66667
4.7 | 15 ratings
03 Aug 2012 Screenshot xlwrite : Export Data to Excel from Matlab on Mac/Win xlwrite allows you to export data (2d/3d arrays of double/cell) to Excel from Matlab (Mac/Win) Author: Marin Deresco xlswrite, excel, mac, java, cell2char 95 5

Contact us