Formatting Data from readmatrix
古いコメントを表示
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 件のコメント
Stephen23
2022 年 4 月 19 日
Numeric data do not contain formatting information.
You can change how numeric data are displayed by using the FORMAT function.
採用された回答
その他の回答 (0 件)
カテゴリ
ヘルプ センター および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!