Hey guys
I have been using excel to manage my .out files but I want to import the data into matlab now since the datasets are getting bigger and bigger.
Is there a function that would do this for me similar as dyntools exports to excel.
Best Regards Johannnes
Hello,
I do you read the .out file in Excel? Mine is just a bunch of garbage.
Best Regards,
Madjê
Hey Madje Yes I use dyntools to export the .out files and the channels I want to excel. Best Regards Johannes
*Copying of all channels into matlab workspace (as possibility for matlab users)*
Download matlab function and example of using:
https://drive.google.com/drive/folder...
function [numberchannels,nameschannels,tomatlab]=pssout2matlab(inputfile)
nameschannels=[];
channelsdata=[];
numberchannels=[];
tekst=[];
if nargin==0
[filename]=uigetfile('*.out','PSSE .out files'); % select file from disk (without inputfile in function call)
fid=fopen(filename);
else
fid=fopen(inputfile');
end
setstr(fread(fid,4,'char')');
setstr(fread(fid,4,'char')');
setstr(fread(fid,4,'char')');
numberchannels=fread(fid,1,'float32');
fread(fid,1,'float32');
nameschannels=setstr(fread(fid,[32, numberchannels] ,'char'))';
nameschannels=strvcat(strcat('Time',blanks(28)),nameschannels);
tekst=setstr(fread(fid,[60, 2] ,'char'))';
channelsdata=fread(fid,Inf,'float32');
kolona=(size(channelsdata,1)-2)/(numberchannels+2);
rezultat=reshape(channelsdata(1:kolona*(numberchannels+2)),numberchannels+2,kolona)';
tomatlab=rezultat(:,2:size(rezultat,2));
fclose(fid);
numberchannels=numberchannels+1;
nameschannels=strcat(num2str([1:numberchannels]','%06.f'),'-',nameschannels);
end
Asked: 2013-01-29 07:45:06 -0500
Seen: 1,733 times
Last updated: Jul 12 '17
whit loves you. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
There isn't a ready-made function. But you could write something that exports to CSV. Then import that to matlab. Does it take a long time to write to excel?
Hey man, I am currently exporting all the out files and the channels I want to excel and then I should be able to open it in matlab but that is a alot of mouseclicks :)
I actually noticed an interesting problem. When I run many dynamic simulations the size of the .out files seem to grow althoguh I change the name and reopen the channels so I can run limited amount of dynamic simulations.
Yeah, sorry I wasn't much help on that one. My suggestion had more to do with writing directly to a flat CSV file and then in Matlab reading that CSV file in. This way you skip Excel entirely.