To get the max value in row with excelpy

asked 2023-08-08 09:16:26 -0500

Jimmy
13 ●5 ●7 ●9

updated 2023-08-08 09:19:32 -0500

My goal ：To get the max value in row with excelpy

My thought : Is it possible to read the results in excel then I can do the max(row 3) 、max(row 4) ?

Is there any solution?

Thank you so much for reading my question.

My Code：

                   .
                   .

ierr,buses = psspy.abusint(1,1,string='NUMBER')

ierr,volts = psspy.abusreal(1,1,string='PU')

x1.set_range(2,'b',zip(*buses),True)

x1.set_range(3,'b',zip(*volts),True)
                   .
                   .
                   .
for  x in range(len( bus number))

z=x+4
                   .
                   .
                   .

ierr,volts_1 = psspy.abusreal(1,1,string='PU') 

x1.set_range(z,'b',zip(*volts_1),True)

del z

Result in Excel：

       a    b    c    d    e    f    g    h       i   
1

2     1     2    3    4    5    6    7    8              (buses number)

3    10     5   30   85    50   60   75   80     (85)    (volts)  (max value in row 3 is 85)

4    90    60   20   10    5    6    8    12     (90)    (volts)  (max value in row 4 is 90)

5    6     10  ..............................            (volts)

6   .........................................            (volts)