MATLAB: Extracting Names from Excel

excelexport

Hello, i have created a list of .txt files in excel (myData.xlsx) that look something like this:

ABC_123.txt

DEF_345.txt

GHI_678.txt

I would like to access this excel sheet and pull out cell A1 and open the file ABC_123.txt. I have tried this using xlsread and winopen but to no avail.

Below is what i have tried:

filename='myData.xlsx';

sheet=1;

xlRange='A1:A1';

subsetA=xlsread(filename,sheet,xlRange)

winopen(subsetA)

Any help is greatly appreciated!

Best Answer

filename='myData.xlsx';

sheet=1;

xlRange='A1:A1';

% Text fields are stored in cell array txt

[num,txt,raw] =xlsread(filename,sheet,xlRange)

% cell array content indexing to get the string value

winopen(txt{1,1})

Related Solutions

MATLAB: Exporting simulation data in Multiple sheets in excel file.

hello

see example below :

for k=1:10
     xlswrite('Result.xlsx',rand(k),k);
    writematrix(rand(k),'myData.xlsx','Sheet',k);
end

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;

Best Answer

Related Solutions

MATLAB: Exporting simulation data in Multiple sheets in excel file.

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

Related Question