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!
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.
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.
thanks to tell me this way . How to use RDCH?
See API manual, Chapter 1.
OK THANK !
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
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!
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.
yes,I want to do data conversion through python