Write Data to txt file from Excel

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 Comments

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?
  1. Yes, numeric data.
  2. Read data into MATLAB and then MATLAB writes data - this should be the case.

Sign in to comment.

 Accepted Answer

Arif Hoq
Arif Hoq on 17 Mar 2022
Edited: Arif Hoq on 17 Mar 2022
try this:
A=readtable('data.xlsx','ReadvariableName',false);
writetable(A,'myfile.txt')
or
B=readmatrix('data.xlsx');
writematrix(B,'myfile2.txt')

2 Comments

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.
jsut use this:
A=readtable('data.xlsx','ReadvariableName',false,'Range','D3:D10');
or
B=readmatrix('data.xlsx','Range','D3:D10');

Sign in to comment.

More Answers (0)

Products

Release

R2021b

Tags

Asked:

on 17 Mar 2022

Edited:

on 17 Mar 2022

Community Treasure Hunt

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

Start Hunting!