xlswrite and the single quote ' character
显示 更早的评论
I want to add a formula to an Excel file using xlswrite but the formula has the ' character. This is giving me an error. Any suggestions to get around this?
For example, if I want to write the word " 'test " in cell A1 of Sheet1 I thought I would use:
xlswrite([foldername ExcelFileName '.xls'], {''test'},'Sheet1', 'A1');
But no, I get an error...
采纳的回答
Oleg Komarov
2011-1-31
Well, post the entire error and I don't get any problem with:
xlswrite(filename, {'test'},'Sheet1','A1')
To have 'test you have to double it when using matlab strings:
xlswrite(filename, {'''test'},'Sheet1','A1')
But then on excel you won't see the ' before test... (but I expect it to be a desired result)
Oleg
更多回答（1 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
2011-1-31
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
