why xlswrite has @ character?
3 views (last 30 days)
Show older comments
Hi all,
I used xlswrite to write string function to excel cell.
Such as:
xlswrite('resultFile.xlsx', {['=FREQUENCY(A1:A1000,C1:C30)']},'Sheet1', 'D1')
But result in excel file contains '@' character like this.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/803014/image.png)
How to fix it?
Thank you
0 Comments
Accepted Answer
Monika Jaskolka
on 17 Nov 2021
Edited: Monika Jaskolka
on 17 Nov 2021
This is something that happens automatically in Excel. Please see:
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!