how can i Insert row in between the existing data in an excel sheet without overwriting the below data.

xlRange4 = ['B',num2str(nextRow2)];
xlRange5 = ['E',num2str(nextRow2)];
xlswrite('IgnTimgTar_ac_Compliance.xlsx',data,'Result',xlRange4);
 xlswrite('IgnTimgTar_ac_Compliance.xlsx',data,'Result',xlRange5);,

i am using this code but there the below data is getting overwrittened.

Answer 1

[Walter Roberson]

You will need to use activexserver() to connect to Excel, and use the DCOM interface to execute Insert commands

https://www.wallstreetmojo.com/vba-insert-row/

There is no facility inside MATLAB itself for inserting or deleting rows or columns in spreadsheets (without rewriting the rest of the spreadsheet)

[vickey vardwaj]

So we cannot insert any row into a excel using matlab scripting?

[Walter Roberson]

Your options are:

• use activexserver() to send commands to Excel
• use a .NET framework to send commands to Excel
• use an OpenOffice or Office Libré DLL to make the request. This would not talk to Excel: it would use third-party packages that can read and write xlsx files
• find some Java package that will do whatever magic is needed (probably by using activeX internally)
• find some python package that will do whatever magic is needed (probably by using activeX internally)
• find some perl package that will do whatever magic is needed

There is no Mathworks-supplied function that can do the work (except by way of asking another program to do it.)

[vickey vardwaj]

Is it possible to insert a row in cell array without overwritting it?

[Walter Roberson]

If you are talking about MATLAB cell arrays, then the answer is more No than Yes.

MATLAB cell arrays are arrays of pointers to descriptions of data ,with the description most often including a pointer to the storage for the values.

When you assign to an element of a cell array, the pointer to the description of the entry is overwritten with a pointer to the description of the new value. The memory itself is not copied, just the pointer.

In order to insert a new row in a cell array, matlab has to first create a new larger cell array. It then copies the pointers to descriptions from the old cell to the new cell, in the appropriate places. The data enclosed is not moved, just the pointers. But the process does have to create the new cell array (and after dispose of the old list of pointers).

At the moment I cannot think of anything in MATLAB that is known to be implemented as a linked list (there might be internal ones not visible to users)