Rank: 648 based on 170 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 xlswrite, excel, xlwrite, java, jexcelapi, mac 170 72
  • 4.84375
4.8 | 37 ratings
Comments and Ratings by Alec View all
Updated File Comments Rating
04 Aug 2014 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

@Azizullah Khan
These should be in the zip file. Just extract the whole zip folder to your matlab workspace to make the demo work.
Alec

18 Jun 2014 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

@Gaurav:

It seems like a bug in Matlab itself.
Best would to file a bug submission at the Mathworks.

If it is urgent, you can edit the xlsread.m file directly to remove the bug. I don't have 2014a, so I cannot correct it myself.

Alec

05 Jun 2014 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

@Shaun:
It seems the "poi_library" folder is not in the same folder as your Text.xlWrite.m file....

05 Jun 2014 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

@Volker Schardt
Sorry for the late reply. I will be more than happy to add your code to the zip file. Can you please contact me by Private Message?

Thanks!
Alec

30 Jan 2014 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: I just got a reply back from Mathworks support:
"This bug should be fixed with R2014a. The PreRelease for R2014a is available already and it should also contain the bug fix."

Comments and Ratings on Alec's Files View all
Updated File Comment by Comments Rating
03 Sep 2014 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 Nikos

Hello again,
Problem solved, I had multiple copies of Text.xlWrite.m in different folders.
xlwrite works perfectly as long as Text.xlWrite.m and the folder poi_library are both in the current directory.
Sorry for the bother.
Thanks again, excellent work!

03 Sep 2014 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 Nikos

Hi Alec,
This project was much needed, thanks.
I seem to have the same proble as @azizulh khan and @Shawn - I get the error:
"The POI library is not loaded in Matlab.
Check that POI jar files are in Matlab Java path!"
I am certain poi_library is in my workspace and in the matlab path as is Text.xlWrite.m
Please help!
Kind regards, Nikos

04 Aug 2014 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

@Azizullah Khan
These should be in the zip file. Just extract the whole zip folder to your matlab workspace to make the demo work.
Alec

01 Aug 2014 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 khan, azizullah

sir,make me clear about poi library
how can i insert it and from where can i get these files.The jar files?
thanks

03 Jul 2014 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

Nice job but I believe there is a small problem.
xlwrite is able to create an xlsx file with multiple worksheets which I can open with Excel but I cannot read this file with xlsread. However, if I open the xlsx file with excel and then simply hit save (ostensibly making no changes), I can then open with xlsread.

Any ideas?

Thanks,

Dan

Contact us