After writing a numeric matrix in excel using writematrix, the format of each cell in excel is text and not a number.
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
In excel advanced options I have selected not to use the system delimiters. I use "." to delimit decimals and ", " to delimit thousands.
2 Kommentare
Jan
am 7 Mär. 2022
Bearbeitet: Jan
am 7 Mär. 2022
In which format do you write the output file by writematrix? Please provide a small working example, which reproduces the problem and mention, what you want to get instead. Currently your message is a statement and we have to guess, what you are asking for.
Antworten (1)
Harimurali
am 3 Nov. 2023
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 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!