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!

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 (Feb 28 '18)

yes,I want to do data conversion through python

YI-WEI (Mar 1 '18)

add a comment

0

answered Mar 2 '18

perolofl

3537 ●1 ●9 ●21

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.

link

Comments

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

YI-WEI (Mar 2 '18)

See API manual, Chapter 1.

perolofl (Mar 2 '18)

OK THANK !

YI-WEI (Mar 2 '18)

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 (Mar 4 '18)

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 (Mar 4 '18)

see more comments

0

answered Mar 6 '18