Using MODULE EXCELPY to READ data

asked 2017-07-17 18:11:30 -0500

Mike
1 ●4 ●4 ●4

Hello everyone, I am trying to use this code which I posted in another question on this website. My goal now is this read data but this time using the module EXCELPY. I lloked into the API documentation and I could only find information about writing excel files. What I am trying to do is to read the excel data and using that data, import it into PSSE. Any help would be appreciated.

PSSE_LOCATION = r"C:\Program Files (x86)\PTI\PSSE33\PSSBIN"
sys.path.append(PSSE_LOCATION)
os.environ['PATH'] = os.environ['PATH'] + ';' + PSSE_LOCATION
import psspy
import redirect
import csv
psspy.throwPsseExceptions = True


 STUDY_CASE = 'C:\Users\RoszkowskiM\Documents\Cases\Final\ceii_Case1_SUM_2017_5050_MMWG16PF_FINAL.sav'

LOAD_GEN_DATAFILE = 'C:\Users\RoszkowskiM\Documents\CSV Files\ASTECOR_TLA.csv'

 psspy.psseinit(10000)
 psspy.case(STUDY_CASE)



data = list(csv.reader(open(LOAD_GEN_DATAFILE)))
mydict = {}
for row in data:
year,location,bus,change,isload = row[0:5]
# convert the types from string to Python numbers

change= float(change)
bus = int(bus)

 #If this is a year not seen before, add it to the dictionary
  if year not in mydict:
    mydict[year] = {}
  busses_in_year = mydict[year]
   if location not in busses_in_year:
  busses_in_year[location] = []

  #Add the bus to the list of busses that stop at this location
 busses_in_year[location].append((bus, change,isload))


# assume CSV has columns as described in the doc string
 year = raw_input("Select Year of Study: ")

 location = raw_input(" Select the number associated to the TLA Pocket Location:")

 if year in mydict and location in mydict[year]:  
 busses_in_year = mydict[year]
 print("Here are all the busses at that location for that year: ")
for bus in busses_in_year[location]:
 print(bus)


else:
   print("Invalid Year or Location")

   # I am trying to scale the generation by using these API's. It's based off the loaded information above. I guessed
        # and used bus and change to replace parts of the API with bsys and scal_2
  if isload.isdigit() and int(isload):    
      psspy.bsys(1,0,[0.0,0.0],0,[],1,[bus],0,[],0,[])
      psspy.scal_2(1,0,1,[0,0,0,0,0],[0.0,0.0,0.0,0.0,0.0,0.0,0.0])
      psspy.scal_2(0,1,2,[0,1,0,1,0],[change,0.0,0,-.0,0.0,-.0,0])