Effacer les filtres
Effacer les filtres

Info

Cette question est clôturée. Rouvrir pour modifier ou répondre.

How to expand matrice with zeroes?

1 vue (au cours des 30 derniers jours)
andrew_cup
andrew_cup le 22 Nov 2012
Clôturé : MATLAB Answer Bot le 20 Août 2021
I have a xls file with 3 columns and 212 rows of data. Is there any way to insert 3 columns of zeroes with x number of rows in the middle, so there is a total of 365 rows?

Cette question est clôturée.

Réponses (1)

Image Analyst
Image Analyst le 22 Nov 2012
Read it in with xlsread(). Insert the columns and rows. Then write back out with xlswrite().
  2 commentaires
andrew_cup
andrew_cup le 22 Nov 2012
Modifié(e) : andrew_cup le 22 Nov 2012
like this?
filename = 'testdata.xls';
A = zeros(153,3);
sheet = 1;
x1Range = 'A122';
xlswrite(filename,A,sheet,x1Range);
snodybde = xlsread('testdata.xls');
Image Analyst
Image Analyst le 22 Nov 2012
No. All you attempted was writing the stuff back out. Where is your call to xlsread, and your insertion code??????
[numbers txt raw] = xlsread('testdata.xls');
insertionRow = 10;
output = [numbers(1:insertionRow, :); newXRows; numbers((insertionRow+1):end,:)];
xlswrite(output, 'testdata.xls', 'D1'); % Write into columns 4-6.
or something like that.

Cette question est clôturée.

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by