After writing a numeric matrix in excel using writematrix, the format of each cell in excel is text and not a number.
3 次查看(过去 30 天)
显示 更早的评论
In excel advanced options I have selected not to use the system delimiters. I use "." to delimit decimals and ", " to delimit thousands.
2 个评论
回答(1 个)
Harimurali
2023-11-3
Hi Fernando,
I understand that you want to write the data in the number matrix “DATA” to an Excel sheet, but the data is written to Excel as text instead of being recorded as Excel numbers.
I tried reproducing the issue at my end, but it was not reproducible. An alternate to this is using Spreadsheet Link software, which enables access to the MATLAB environment from an Excel spreadsheet.
Please follow these steps to install Spreadsheet Link and import data from MATLAB in Excel:
- Spreadsheet Link can be installed using the add-ons manager in MATLAB in the following way:
HOME -> Add-Ons -> Get Add-Ons -> Search for “Spreadsheet Link” and click install.
- Refer to the following documentation for setting up the Spreadsheet Link Add-In in Microsoft Excel:
- Open a new spreadsheet and enter the following command:
=MLGetMatrix(DATA, "SheetName!Cell"), where “SheetName” is the name of the sheet where the data needs to be imported to beginning at the “Cell” specified.
For example: =MLGetMatrix(DATA, "Sheet1!A5")
Please refer the following links for more information on Spreadsheet Link:
Hope this helps.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!