Use matlab to search and replace in an excel sheet

10 次查看（过去 30 天）

mael thevenot 2018-11-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/427627-use-matlab-to-search-and-replace-in-an-excel-sheet

评论： mael thevenot 2018-11-8

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 个评论
显示 20更早的评论隐藏 20更早的评论

Guillaume 2018-11-5

编辑：Guillaume 2018-11-5

@Calgar,

"Both excel and Matlab has a setting for the decimal separator. Both of them can be set to work with comma or dot"

As far as I know this is not true for either. Excel uses Windows regional settings, it doesn't have its own. Matlab has very little support for , as a decimal separator. The only place it is aware of it is when exporting to the clipboard. It does not support it for import.

"xlswrite cannot write strings"

xlswrite can write strings just fine.

@mael thevenot,

As I said above, Excel uses Windows regional settings. So you can always change your regional settings to use a . instead of , as a decimal separator. Note that it will affect other programs. On my machine (Win10 + Excel 365), as soon as I change the decimal symbol in the regional settings, Excel automatically reflects the change.

However, it is really not clear what problem you are having. If the number are really stored as numbers in Excel, then whichever separator Excel uses does not matter for matlab. Matlab, using xlsread or readtable (or even through actxserver) will read the numbers with a . separator. That's because matlab doesn't read the textual representation of the numbers but their binary representation.

Of course, if the numbers are stored as text, then matlab will read the text as it is. But then they're not numbers in excel as well.

So, the whole "search through the excel sheet for points and replace it with commas" seems pointless. If it's for matlab, it's a non-issue and if it's for excel, you can't do that without changing the numbers to text and preventing you use them in calculation.

Guillaume 2018-11-7

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 2018-11-8

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.

请先登录，再进行评论。

请先登录，再回答此问题。