MATLAB Answers

Reading txt file from VBA for Matlab

21 views (last 30 days)
sko on 1 Dec 2020
Answered: Rishik Ramena on 4 Dec 2020
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:
VBBV on 1 Dec 2020
You can delete those if you want after importing to matlab workspace

Sign in to comment.

Answers (1)

Rishik Ramena
Rishik Ramena on 4 Dec 2020
You can process the NaNs after importing them to MATLAB. This link might be helpful.




Community Treasure Hunt

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

Start Hunting!

Translated by