Formatting Data from readmatrix
14 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Rounak Saha Niloy
am 19 Apr. 2022
Beantwortet: Rounak Saha Niloy
am 19 Apr. 2022
I have an excel file with name MyExcel.xlsm. The data in "A1:C1" are-
A1 = 236381.358; B1 = 338746.896; C1 = 13.239
I am using the following to formula to read these data from Excel-
Result = readmatrix("MyExcel.xlsm","Range","A1:C1")
The output I am getting is-
Result =
1.0e+05 *
2.3638 3.3875 0.0001
How do I get the result in the format as it is in the excel file? I mean, how do I get it in the following way?
Result =
236381.358 338746.896 13.239
1 Kommentar
Stephen23
am 19 Apr. 2022
Numeric data do not contain formatting information.
You can change how numeric data are displayed by using the FORMAT function.
Akzeptierte Antwort
Weitere Antworten (0)
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!