清空筛选条件
清空筛选条件

Info

此问题已关闭。 请重新打开它进行编辑或回答。

How to expand matrice with zeroes?

2 次查看（过去 30 天）
andrew_cup
andrew_cup 2012-11-22
关闭： MATLAB Answer Bot 2021-8-20
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?

此问题已关闭。

回答（1 个）

Image Analyst
Image Analyst 2012-11-22
Read it in with xlsread(). Insert the columns and rows. Then write back out with xlswrite().
  2 个评论
andrew_cup
andrew_cup 2012-11-22
编辑：andrew_cup 2012-11-22
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 2012-11-22
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.

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by