コード例 #1
0
    def export_excel(self):
        try:
            # create excel
            office = modOffice.modOffice()
            office.create_excel_app()
            office.create_excel_workbook()
            office.create_excel_sheets()

            # set row and col
            row = 1
            col = 1

            for i in range(self.maxd):  # day number
                # set excel title
                if i + 1 == self.maxd and self.flag == True:
                    office.sheet.Cells(row, col).Value = "********"
                    office.sheet.Cells(row, col + 1).Value = "********"
                else:
                    v = re.sub(r"\d", "", str(self.userinfo.field[0].date[i]))
                    if v.strip() != "":
                        office.sheet.Cells(row, col).Value = self.userinfo.field[0].date[i]
                        office.sheet.Cells(row, col + 1).Value = self.userinfo.field[0].name
                row += 1

                # set excel value
                for k in range(self.userinfo.count + 1):  # round number
                    v = re.sub(r"\d", "", str(self.userinfo.field[0].teamA[i][k]))
                    if v != "":
                        if k < 3:
                            office.sheet.Cells(row, col).Value = "0" + str(k + 7) + ":30"
                        else:
                            office.sheet.Cells(row, col).Value = str(k + 7) + ":30"
                        office.sheet.Cells(row, col + 1).Value = self.userinfo.field[0].teamA[i][k]
                        office.sheet.Cells(row, col + 2).Value = self.userinfo.field[0].teamB[i][k]
                        row += 1
        except:
            raise
コード例 #2
0
import modOffice
import modPublic
import modString


#load string handle module
string=modString.modString()
string.Number2ABC(26)

#load template and base data
userinfo=modUserInfo.modUserInfo()
userinfo.loadbaseinfo(5)
userinfo.loadtemplate()

#create excel
office=modOffice.modOffice()
office.create_excel_app()
office.create_excel_workbook()
office.create_excel_sheets()

#set contest title
for i in range(userinfo.team_count):
	office.sheet.Cells(i+2, 1).Value=userinfo.team[i].name
	office.sheet.Cells(1, i+2).Value=userinfo.team[i].name
	office.sheet.Cells(i+2, i+2).Value="X"
	
	office.sheet.Cells(userinfo.team_count+3, i+2).Value=userinfo.team[i].name

#set record title
office.sheet.Cells(userinfo.team_count+4, 1).Value="應賽".encode("big5")
office.sheet.Cells(userinfo.team_count+5, 1).Value="已賽".encode("big5")