answered Apr 30 '15

tiagosantos
1 ●1

updated Apr 30 '15

To extract data from .out files to excel datasheet I use this script in python: (simply copy the code between the lines made of '#' to a .py extension file and run it, you should change the path to pss/e bin path and should run it from the same folder of your .out file, alse change the variable "name" to the name of your .out (in this case the file was "x.out" ))

# # # # # # # # # # # # # # # # # # # # # # # # # # # # # #

import os,sys

sys.path.insert(0,'C:\Program Files (x86)\PTI\PSSEXplore33\PSSBIN')

os.environ['PATH'] = 'C:\Program Files (x86)\PTI\PSSEXplore33\PSSBIN'+';'+os.environ['PATH']

import excelpy

import dyntools

import time

name='x';

data=str(time.localtime().tmmday)+" do "+str(time.localtime().tmmon);

outfile = dyntools.CHNF(name+'.out')

shorttitle, chaniddict, chandatadict = outfile.getdata()

xlsfile=name+'.xlsx';

xl = excelpy.workbook(xlsfile, mode='w');

outfile.xlsout(sheet=name,overwritesheet=True);

xl.close();

xl.save();

xl.close();

# # # # # # # # # # # # # # # # # # # # # # # # # #