Formatting Data from readmatrix
    7 visualizaciones (últimos 30 días)
  
       Mostrar comentarios más antiguos
    
    Rounak Saha Niloy
 el 19 de Abr. de 2022
  
    
    
    
    
    Respondida: Rounak Saha Niloy
 el 19 de Abr. de 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 comentario
  Stephen23
      
      
 el 19 de Abr. de 2022
				Numeric data do not contain formatting information.
You can change how numeric data are displayed by using the FORMAT function.
Respuesta aceptada
Más respuestas (0)
Ver también
Categorías
				Más información sobre Spreadsheets en Help Center y File Exchange.
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!

