Formatting Data from readmatrix
7 ビュー (過去 30 日間)
古いコメントを表示
Rounak Saha Niloy
2022 年 4 月 19 日
回答済み: Rounak Saha Niloy
2022 年 4 月 19 日
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 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!