How to insert new column to existing excel sheet?

20 次查看（过去 30 天）
azizullah khan
azizullah khan 2014-10-8
编辑： Guillaume 2014-10-8
My aim is to insert new column/Cells (for specific range e.g B2:B8 ) with out interrupting other cells or data.More specific i want to insert New cells without disturbing remaining pattern and data. If it is possible using actxserver kindly share your experience with me thanks.

请先登录，再回答此问题。

采纳的回答

Guillaume
Guillaume 2014-10-8
编辑：Guillaume 2014-10-8
Not tested:
excel = actxsever('Excel.Application');
wb = excel.Workbooks.Open('somefile.xlsx');
ws = wb.Worksheets.Item('sheetname');
ws.Range('B2:B8').Insert;
%other code
wb.Save;
excel.Quit;
delete(excel);
See insert method of the range object
edited for numerous errors!
  9 个评论
显示 7更早的评论
Iain
Iain 2014-10-8
The easiest way is probably to use the matlab supplied xlsread and xlswrite functions:
[n t data] = xlsread(...)
data(:,3:end+1) = data(:,2:end);
data(2:8,2) = %your new stuff...
xlswrite(..., data);
But if you want to do it all yourself (and there are reasons you might), then the code in xlswrite probably tells you how to add stuff in a way you want.
Guillaume
Guillaume 2014-10-8
To write values to a range:
ws.Range('B2:B8').Value = [1 2 3 4 5 6 7]'; %array must be same shape as range

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by