how to import excel data to PSS/E using python

edit

The first step is reading the Excel sheet. If you have Pandas package installed within your PSSE Python environment, you can use:

pandas.read_excel(...)

If not, and you have stored the data as a csv-file, you can use:

with open('filename.csv', 'r') as f:
    data = f.read()
    print(data)   # Prints the data to see the format that is read, but should not be part of final code

Then you would have to parse each line and create a data structure to keep track of the different parameters.

To get the data from Python into PSS/E, it depends on what type of data you want to update PSSE with. Load flow (buses, branches, etc), dynamics, or other type of data. Please provide more context.