why xlswrite has @ character?

1 次查看（过去 30 天）

galaxy 2021-11-17

评论： galaxy 2021-11-18

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.

How to fix it?

Thank you

Monika Jaskolka 2021-11-17

编辑：Monika Jaskolka 2021-11-17

This is something that happens automatically in Excel. Please see:

galaxy 2021-11-18

Thank you so much

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

R2021b

Find the treasures in MATLAB Central and discover how the community can help you!

Translated by