MATLAB: Loading a excel file in which I want to take only A, C not B and D, how can I improve

image processingmatrix

filename = 'myExample.xlsx';
sheet = 1;
header_xlRange = 'A:D';
[headers_nums, header_text] = xlsread(filename, sheet, header_xlRange);

loading a excel file in which I want to take only A, C not B and D, how can I improve?

Best Answer

headers_nums=headers_nums(:,[1 3])

Related Solutions

MATLAB: Multiple import/edit of xls files

This should work! You might need to tweak it slightly!

hExcel = actxserver('Excel.Application');
hExcel.visible = 1; % If you want Excel visible.
hExcel.DisplayAlerts = false; % Avoid excel warning popups
for i:length(filenames) % Assuming filenames contains the 1400 xls files
   Wkbk = hExcel.Workbooks.Open(fullfile(pathToFile, filenames{i})); % Opens Excel file
   Sheets = Wkbk.Sheets; % Get the Sheets
   Sheets.Item(1).Delete; % Deletes the first sheet
   Wkbk.ActiveSheet.Cells.Item(1).EntireRow.Insert; Assuming you want to insert a row and not a column
   Wkbk.ActiveSheet.Cells.Range('A1').Value = filenames{i}; % Insert Filename
   Wkbk.Save; Save xls file
   Wkbk.SaveAs('C:\MatlabWork\Answers\Test.csv', 6); Save as .csv (file format for csv enum is 6)
   Wkbk.Close;

end

hExcel.Quit;
hExcel.delete;

MATLAB: I nead help, xlsread(file,-1).

I'll rephrase the question to make it clear.

How can I return the address of the data which I selected interactively with:

xlsread(filename,-1)

After a bit of reverse engineering I found a semi-undocumented feature. It is possible to play with the COM object through the 5th input. The syntax I am gonna use is:

[num,txt,raw,custom] = xlsread(filename,sheet,range,'',functionHandle)

Step 1 Create the following function which will query the Address property

function [DataRange, range] = customOut(DataRange)
    range = DataRange.Address;
end

Step 2 Now simply import the data with:

[num,txt,raw,address] = xlsread('test.xlsx',-1,[],[],@customOut)
address =
$B$7:$D$12

Best Answer

Related Solutions

MATLAB: Multiple import/edit of xls files

MATLAB: I nead help, xlsread(file,-1).

Related Question