import sys
import xlrd
import xlwt

# define var
# state_max -Antenna State max Up+Down Antenna
# C1 -Used for cell value transfer
# ca_label  -Ca state mark
# nrows,ncols = number of row and col
# GPIO_Input_Value - Input of CrossMipi GPIO_Value


data = xlrd.open_workbook("Crossmipi_Gpio.xlsx")
inputtable = data.sheet_by_name("GPIO_Input_LTE")

wdata=xlwt.Workbook()
woutputtable=wdata.add_sheet(‘GPIO_Output‘)

nrows=inputtable.nrows
ncols=inputtable.ncols

state_max=nrows-2
band_config=[]


i=0
j=0
k=0
m=0

c1=0

gpio_input_value=[0,0,0,0]


# Find differrent band config in the cell
for i in range(state_max):
    for j in range(7):
        if inputtable.cell_value(i+2,j+3)!=0:
            band_config.append([])
            band_config[m]=inputtable.cell_value(i+2,j+3)
            m=m+1


band_config=list(set(band_config))


for k in range(len(band_config)):
    for i in range(state_max):
        for j in range(7):
            # band_config[k] GPIO_Input value
            if inputtable.cell_value(i+2,j+3)==band_config[k]:
                for m in range(4):
                    gpio_input_value[m]=(gpio_input_value[m] or inputtable.cell_value(i+2,m+10))
    c1=gpio_input_value[0]*8+gpio_input_value[1]*4+gpio_input_value[2]*2+gpio_input_value[3]
    
    woutputtable.write(k+2,2,band_config[k])
    woutputtable.write(k+2,3,c1)
    c1=0
    gpio_input_value=[0.0,0.0,0.0,0.0]

wdata.save(‘Crossmipi_Output_GPIO.xlsx‘)