append new rows in the middle of an excel file's sheet

Question

AMINE EL MOUATAMID 2019-4-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/458687-append-new-rows-in-the-middle-of-an-excel-file-s-sheet

评论： Guillaume 2019-4-28

采纳的回答： Guillaume

I am working on an excel file using actx function

then I want to add some rows in the middle of the sheet

is there a way to solve this ?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

AMINE EL MOUATAMID 2019-4-26

this is how I want it to be

请先登录，再进行评论。

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

Answer 1

Guillaume 2019-4-26

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/458687-append-new-rows-in-the-middle-of-an-excel-file-s-sheet#answer_372403

Probably the easiest way to find out the code you need to use is to record a macro in excel while you do the insertion and fix the formatting (which excel will inevitably mess up). The code you then use in matlab will be more or less identical to the VBA code generated by the macro (with adjustments for the difference in language syntax).

2 个评论
显示无隐藏无

AMINE EL MOUATAMID 2019-4-26

is there something like that in matlab

Guillaume 2019-4-28

在 MATLAB Online 中打开

For some reasons, I never saw your comment until today.

Once you've connected to excel with actxserver you use more or less the same commands in matlab as you would in VBA. So, yes:

excel = actxserver('Excel.Application');  %connect to excel
wb = excel.Workbooks.Open('C:\somewhere\somefolder\somefile.xlsx');
ws = wb.Worksheets.Item('Sheet1');  %One major difference is that you HAVE to use the Item property to access elements of collections
rg = ws.Range('1:4');
rg.Insert(-4121);  %The other difference is that you have to use numeric values for constants. -4121 is the numeric value of XlShiftDown