YI-WEI
11 ●11 ●12 ●14

I want to write a python code to export excel data to psse .sav file. EXCEL data and PSSE NETWORK DATA the same format, how to use the API to write the program, please give me some examples. THANK!

edit retag flag offensive close merge delete

Comments

Do you mean that the excel data is structured in PSSE RAW data format? I.e. bus data, followed by load data, followed by shunt data, etc.

perolofl ( 2018-02-28 15:53:31 -0600 )edit

yes,I want to do data conversion through python

YI-WEI ( 2018-02-28 19:39:11 -0600 )edit

add a comment

0

answered 2018-03-02 02:11:49 -0600

perolofl

3692 ●1 ●9 ●22

PSSE raw data in an Excel file may be exported into PSSE in the following way:

1: Export data from excel to csv-file with proper modules, e.g. xlrd and csv.

2: Remove lines in the beginning of the csv-file so first line is the first bus data record. After last data group, add Q on a separate line.

3: Read the file into PSSE with API RDCH to update existing PSSE network data.

To read a complete network from excel use API READ instead and include the "Case Identification Data record" and the two case title lines in the beginning of the csv-file.

edit flag offensive delete link

Comments

thanks to tell me this way . How to use RDCH?

YI-WEI ( 2018-03-02 08:29:12 -0600 )edit

See API manual, Chapter 1.

perolofl ( 2018-03-02 08:57:47 -0600 )edit

OK THANK !

YI-WEI ( 2018-03-02 09:20:40 -0600 )edit

hi Can you help me look at the code in below? it show some error : Reading IC, SBASE, REV, XFRRAT, NXFRAT, BASFRQ... Input error detected at ! 101,NUC-A,21.6,1,FLAPCO,77,PLANT,11,GEN 1,2,1.02,16.55,1.1,0.9,1.1,0.9

YI-WEI ( 2018-03-04 03:31:07 -0600 )edit

You are using READ to read a RDCH-file. Your bus data rekord is also wrong. It is not in raw data format. Please read the manual!

perolofl ( 2018-03-04 05:18:00 -0600 )edit

see more comments

0

answered 2018-03-06 01:38:39 -0600