Formatting Data from readmatrix

7 次查看（过去 30 天）
Rounak Saha Niloy
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
Stephen23 2022-4-19
Numeric data do not contain formatting information.
You can change how numeric data are displayed by using the FORMAT function.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Rounak Saha Niloy
Rounak Saha Niloy 2022-4-19
Used the following code and it solved my problem.
format longg;
Result = readmatrix("MyExcel.xlsm","Range","A1:C1")

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by