export excel files to psse v33
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!
First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!
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!
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.
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.
Asked: 2018-02-28 05:36:39 -0500
Seen: 1,258 times
Last updated: Mar 06 '18
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