Reading the sheet name of a .xls file with Matlab -

-

i have got 30 files named data1.xls data30.xls. in each file, there 2 sheets i'm interested in. first called 'ergebnisse' name of second sheet, important me. sheet changes name. problem here don't know how tell matlab use changing sheet name.

what got far:

liste = dir('*.xls');                  % how many files in folder liste=struct2cell(liste);               liste=liste(1,:)';                        i=1:length(liste)                   % i=number of files     filename=['data' num2str(i) '.xls'];     [num,txt,raw]=xlsread(filename,'ergebnisse');     sheet=txt(3,1);     [num,txt,raw]=xlsread(filename,sheet);   end

the answer sheet 't4_quer_3' write next xlsread doesn't work. help

you dont need cell txt(3,1), content. either go 

sheet=txt{3,1};%notice other brackets

or go 

[num,txt,raw]=xlsread(filename,sheet{:}); %{:}content of cell

Comments

Post a Comment

Popular posts from this blog

sequelize.js - Sequelize group by with association includes id -

-
so when requesting group sequelize follows: return models.workingcalendar .findall({ attributes: [ 'workingcalendar.periodid', 'workingcalendar.date', 'period.name' ], include: [ { model: models.period, attributes: [] } ], where: { getsudoid: currentgetsudo.id, unitplantid: unitplantid }, group: ['workingcalendar.periodid', 'workingcalendar.date', 'period.name'], }); sequelize run query: select [workingcalendar].[id], [workingcalendar].[periodid], [workingcalendar].[date], [period].[name] [workingcalendars] [workingcalendar] left outer join [periods] [period] on [wor...
Read more

delphi - Take screenshot in webcam using VFrames in Console Application -

-
i'm doing program take picture of webcam using delphi xe2 , vframes achieve this, problem have figured out, in graphic application works fine, when use unit in console application, returns me error saying first chance exception @ $76b6b727. exception class eaccessviolation message 'access violation @ address 004a271b in module 'console.exe'. read of address 00000260'. process console.exe (3676) my unit : unit webcam; interface uses sysutils, windows, vcl.imaging.jpeg, vcl.graphics, vsample, vframes, classes; type twebcam = class private procedure newvideoframeevent(sender: tobject; width, height: integer; dataptr: pointer); public constructor create; destructor destroy; override; procedure capture_webcam(take_name: string); end; var web_image: tvideoimage; name_screen: string; implementation constructor twebcam.create; begin inherited create; end; destructor twebcam.destroy; begin inherited destroy; end; ...
Read more

swift - Cannot convert return expression type to return type with closure? -

-
hello have func pagination messages. class func listmessages() -> (int, int, ([chatitemprotocol]) -> void) { let service = messageservice() func list(count: int, offset: int, comp:([chatitemprotocol]) -> void) { let params : [string : anyobject] = ["offset" : offset, "limit" : count] service.listmessagesforroom(params) { (messages) in comp(messages.map({$0})) } } return list } and have error : cannot convert return expression of type '(int, offset: int, comp: ([chatitemprotocol]) -> void) -> ()' return type '(int, int, ([chatitemprotocol]) -> void)' (aka '(int, int, array<chatitemprotocol> -> ())') listmessages(...) expects following tuple return type (int, int, ([chatitemprotocol]) -> void) the function list(...) , on other hand, uses above argument implicitly contain void (/empty tuple type () ) return type. i.e., full signature lis...
Read more