why xlswrite has @ character?

2 visualizzazioni (ultimi 30 giorni)

galaxy il 17 Nov 2021

Commentato: galaxy il 18 Nov 2021

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 il 17 Nov 2021

Modificato: Monika Jaskolka il 17 Nov 2021

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

galaxy il 18 Nov 2021

Thank you so much

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

Scopri di più su Spreadsheets in Help Center e File Exchange

R2021b

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

Translated by