Problems with actxserver function for xlswrite?
3 views (last 30 days)
Show older comments
I have error: Undefined function 'actxserver' for input arguments of type 'char'. I use iMac (late 2009) and OSX 10.9.4. Matlab is 2014a (student) and I try write Excel-files using xlswrite. So, how I can write to Excel-files?
0 Comments
Answers (2)
Iain
on 11 Aug 2014
I am guessing that since you're using an iMac, that you don't have windows installed, and that may explain why you do not have the option of using an activex server.
Do you have excel on that machine? If so, you might be able to use DDE methods (ddepoke, ddeinit, ddeexec) to send commands (and data) to an open excel application. You may need to understand VBA to do it though.
Another answer to your question is to use CSV files.
fopen, fwrite/fprintf and fclose will be what you need to use to do that, e.g.
fid = fopen('blah.csv','w');
fwrite(fid,uint8(['Hello, duckies, are you feeling well?' 10 13 '45, 23, 76, 235, 12345' 10 13]),'uint8');
fwrite(fid,uint8(['Goodbye, No I am dead., I told you i was sick.' 10 13 '454, 234, 476, 45, 1235']),'uint8');
fclose(fid);
3 Comments
Image Analyst
on 11 Aug 2014
Use the 'dir' option in your call to exist().
Use csvwrite() or dlmwrite() instead of xlswrite().
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!