MATLAB: Append new rows in the middle of an excel file’s sheet

addappendexcelMATLABsheet

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 ?

Best Answer

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).

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: Editing/Changing a text file’s content based on input variable

The idea is that you run the regexpr N times using the 'once' parameter. And you don't need so save the file intermediately after you have converted all the numbers to 0.

function changeTC_SYS(filename, N)
% Sets <num> to 1 in the first N lines of format "set TC_SYS_10 <num>". 
content = fileread(filename);
content = regexprep(content, '(?<=set TC_SYS_\d*\s+)[01]','0');
% the above line is just to make sure all of them are 0,if any of them are 1;
for i = 1:N
  content = regexprep(content, '(?<=set TC_SYS_\d*\s+)0', '1', 'once');
end
fid = fopen(filename,'w');
fwrite(fid,content);
fclose(fid);

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: Editing/Changing a text file’s content based on input variable

Related Question