Reading txt file from VBA for Matlab
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I am working parallel with Excel and VBA in order to create txt files I wish to use for MATLAB. However, I experience some format issues I can't resolve.
For instance, the following VBA
Open "example.txt" For Output As #1
For i = 1 To 5
Print #1, Sheets("Example").Cells(i + 3, 3)
Next i
Indeed prints numbers (reals) it is supposed to however MATLAB struggles with reading this example .txt file.
There are some characters VBA is printing. I don't know how to delete those within a VBA code or tell somehow Matlab how to read this file
Example.txt opened in matlab. Note the NaN read by MATLAB from a text file:
2 commentaires
VBBV
le 1 Déc 2020
It occurs when the file has special characters or space. Matlab converts them as NaN which means Not a Number if the file has numeric data and text.
Réponses (1)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!