Clear Filters
Clear Filters

Use matlab to search and replace in an excel sheet

7 views (last 30 days)
Hello,
I load an excel file with matlab R2015b using "xlsread". I would like to use matlab to search through the excel sheet for points and replace it with commas. Any ideas how do do that?
Thanks
  22 Comments
Guillaume
Guillaume on 7 Nov 2018
I assume the tdms files are converted to xlsx using National Instrument excel add-in (that is automatically installed with LabView). Note that there is a tdms reader in the file exchange which allows you to read the tdms file directly into matlab.
A sample of a generated xlsx file would be useful.
"start matlab, tried xlsread with an excel file with dot : NaN matrix" Then it doesn't look like your problem has anything to do with dot vs comma.
mael thevenot
mael thevenot on 8 Nov 2018
I said something wrong sorry, the xlsx that are not working are from another soft, where there is a button "copy data" and then I can copy those data in an excel (and it have a dot as decimal separator). The default format of the cell is "standard" in my excel 2016. I tried to change the format of cells (text, number, ...) but xlsread do not work until I search&replace dots to commas.
If there is no way to do this change in matlab, I'll just go on by doing it manually, thanks for your time.

Sign in to comment.

Answers (0)

Categories

Find more on Data Import from MATLAB 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!