Write Data to txt file from Excel

6 visualizaciones (últimos 30 días)
Rounak Saha Niloy
Rounak Saha Niloy el 17 de Mzo. de 2022
Editada: Arif Hoq el 17 de Mzo. de 2022
I have some data in cell D3:D10 in an excel file. I want to write these particular data in a txt file. How do I do that?
  2 comentarios
Walter Roberson
Walter Roberson el 17 de Mzo. de 2022
Editada: Walter Roberson el 17 de Mzo. de 2022
Is it numeric data?
Is it required that the MATLAB program instruct Excel to write the data, or would it instead be acceptable to read the data into MATLAB and have MATLAB write the data?
Rounak Saha Niloy
Rounak Saha Niloy el 17 de Mzo. de 2022
  1. Yes, numeric data.
  2. Read data into MATLAB and then MATLAB writes data - this should be the case.

Iniciar sesión para comentar.

Respuesta aceptada

Arif Hoq
Arif Hoq el 17 de Mzo. de 2022
Editada: Arif Hoq el 17 de Mzo. de 2022
try this:
A=readtable('data.xlsx','ReadvariableName',false);
writetable(A,'myfile.txt')
or
B=readmatrix('data.xlsx');
writematrix(B,'myfile2.txt')
  2 comentarios
Rounak Saha Niloy
Rounak Saha Niloy el 17 de Mzo. de 2022
I have data in various other cells of that excel file. I want to write data of only the mentioned cells i.e. D3:D10.
Arif Hoq
Arif Hoq el 17 de Mzo. de 2022
Editada: Arif Hoq el 17 de Mzo. de 2022
jsut use this:
A=readtable('data.xlsx','ReadvariableName',false,'Range','D3:D10');
or
B=readmatrix('data.xlsx','Range','D3:D10');

Iniciar sesión para comentar.

Más respuestas (0)

Etiquetas

Productos


Versión

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by