Ask Your Question
0

export excel files to psse v33

asked 2018-02-28 05:36:39 -0500

YI-WEI gravatar image

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 gravatar imageperolofl ( 2018-02-28 15:53:31 -0500 )edit

yes,I want to do data conversion through python

YI-WEI gravatar imageYI-WEI ( 2018-02-28 19:39:11 -0500 )edit

2 answers

Sort by ยป oldest newest most voted
0

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

perolofl gravatar image

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 more

Comments

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

YI-WEI gravatar imageYI-WEI ( 2018-03-02 08:29:12 -0500 )edit

See API manual, Chapter 1.

perolofl gravatar imageperolofl ( 2018-03-02 08:57:47 -0500 )edit

OK THANK !

YI-WEI gravatar imageYI-WEI ( 2018-03-02 09:20:40 -0500 )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 gravatar imageYI-WEI ( 2018-03-04 03:31:07 -0500 )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 gravatar imageperolofl ( 2018-03-04 05:18:00 -0500 )edit
0

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

jfconroy gravatar image

The excelpy module provided with PSSE does not have the ability to import data from Excel, merely to export to Excel.

Personally, I use openpyxl for reading and writing to Excel. I suggest that you give openpyxl a go.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

[hide preview]

Question Tools

1 follower

Stats

Asked: 2018-02-28 05:36:39 -0500

Seen: 309 times

Last updated: Mar 06 '18