检查可用盘符

  1. def get_disk_list():  
  2.     # This function will return a list which have accessible disks
  3.     disk_list = []
  5.     for c in string.ascii_uppercase:
  6.         disk = c+':'
  7.         if os.path.isdir(disk):  # if the dir is exists, add it to the list
  8.             disk_list.append(disk)
  9.     return disk_list

遍历所有文件

  1. def walk_file(file):
  2.     for root, dirs, files in os.walk(file):
  4.         # root 表示当前正在访问的文件夹路径
  5.         # dirs 表示该文件夹下的子目录名list
  6.         # files 表示该文件夹下的文件list
  8.         # 遍历文件
  9.         for f in files:
  10.             print(os.path.join(root, f))
  12.         # 遍历所有的文件夹
  13.         for d in dirs:
  14.             print(os.path.join(root, d))
  17. def main(path):
  18.     walk_file(path)
  19. # os.getcwd() 获取当前工作路径，可以作为参数传入

xls转换为xlsx

  2. import os  # 导入系统包
  3. import win32com.client as win32  # 将Win32com导入为win32
  6. if __name__ == '__main__':
  7.     fname = os.getcwd() + '\Test.xls'  # 获取绝对地址文件名
  8.     excel = win32.gencache.EnsureDispatch('Excel.Application')  # 调用win32
  9.     wb = excel.Workbooks.Open(fname)  # 存为wb对象
  11.     wb.SaveAs(fname + "x", FileFormat=51)  # FileFormat = 51 is for .xlsx extension
  12.     wb.Close()  # FileFormat = 56 is for .xls extension
  13.     excel.Application.Quit()

互相转换

  1. import win32com.client as win32  # 需安装pywin32
  2. import os.path
  3. import glob
  5. excel = win32.gencache.EnsureDispatch('Excel.Application')
  7. #简易使用方法
  8. #filename = r'E:\xlsx\1.xls'
  9. #wb = excel.Workbooks.Open(filename)
  10. #wb.SaveAs(filename+'x', FileFormat=51)  #FileFormat=51 是 .xlsx 的扩展
  11. #wb.Close()                              #FileFormat=56 是 .xls 的扩展
  12. #excel.Application.Quit()
  14. def xls2xlsx(xls_path, xlsx_path):
  16.     # xls_path参数为待转换的xls文件所在文件夹
  17.     # xlsx_path参数为转换完成的xlsx文件保存文件夹
  18.     # 当xlsx保存文件夹存在同名原xls时，会弹窗提示是否替换，建议保存至空文件夹
  20.     path_list = glob.glob(xls_path + '\\*.xls')  # 获取文件夹下所有xls
  22.     for file in path_list:
  23.         filename = os.path.basename(file).replace('.xls', '.xlsx')  # 获取文件名
  24.         wb = excel.Workbooks.Open(file)
  25.         wb.SaveAs(xlsx_path + '\\' + filename, FileFormat=51)  # xlsx为51
  26.         wb.Close()
  28.     excel.Application.Quit()
  29.     print('xls2xlsx转换完成')
  31. def xlsx2xls(xlsx_path, xls_path):
  33.     # xlsx_path参数为待转换的xlsx文件所在文件夹
  34.     # xls_path参数为转换完成的xls文件保存文件夹
  35.     # 当xls保存文件夹存在同名原xlsx时，会弹窗提示是否替换，建议保存至空文件夹
  37.     path_list = glob.glob(xlsx_path + '\\*.xlsx')  # 获取文件夹下所有xlsx
  39.     for file in path_list:
  40.         filename = os.path.basename(file).replace('.xlsx', '.xls')  # 获取文件名
  41.         wb = excel.Workbooks.Open(file)
  42.         wb.SaveAs(xls_path + '\\' + filename, FileFormat=56)  # xls为56
  43.         wb.Close()
  45.     excel.Application.Quit()
  46.     print('xlsx2xls转换完成')
  49. if __name__ == '__main__':
  50.     xls_path = r'E:\xlsx\xls'
  51.     xlsx_path = r'E:\xlsx\xlsx'
  52.     xls2xlsx(xls_path, xlsx_path)
  53.     #xlsx2xls(xlsx_path, xls_path)

重命名

rename

  1. import os,sys
  2. def add_prefix_subfolders(path):
  3.     mark = 'pre'
  4.     old_names = os.listdir(path)
  5.     for old_name in old_names:
  6.         os.rename( os.path.join(path,old_name) , os.path.join(path,mark+old_name) )
  7.         print(old_name,'has been renamed as ', mark+old_name)
  9. if __name__ == '__main__':
  10.     path = os.getcwd()
  11.     add_prefix_subfolders(path)

传入path 保护脚本模式

  1. import os,sys                       #导入模块
  2. def rename_subfolders():        #定义函数名称
  3.     old_names = os.listdir( path )  #取路径下的文件名，生成列表
  4.     for old_name in old_names:      #遍历列表下的文件名
  5.         if old_name!= sys.argv[0]:     #代码本身文件路径，防止脚本文件放在path路径下时，被一起重命名
  6.             new_name=old_name.replace('test-','test2-')   #将原来名字里的‘test’替换为‘test2’
  7.             os.rename(os.path.join(path,old_name),os.path.join(path,new_name))  #子文件夹重命名
  8.             print (old_name,"has been renamed successfully! New name is: ",new_name)   #输出提示

创建文件夹

  1. import os
  3. def mkdir(path):
  5.     folder = os.path.exists(path)
  7.     if not folder:                   #判断是否存在文件夹如果不存在则创建为文件夹
  8.         os.makedirs(path)            #makedirs 创建文件时如果路径不存在会创建这个路径
  9.         print "---  new folder...  ---"
  10.         print "---  OK  ---"
  12.     else:
  13.         print "---  There is this folder!  ---"
  15. file = "G:\\xxoo\\test"
  16. mkdir(file)             #调用函数

创立工作区

  1. import os
  3. work_space_path = os.getcwd() + '\DMS_WorkSpace'  # Work Space  Name
  5. def make_DMS_dir(path):
  7.     folder = os.path.exists(path)
  9.     if not folder:                   #判断是否存在文件夹如果不存在则创建为文件夹
  10.         os.makedirs(path)            #makedirs 创建文件时如果路径不存在会创建这个路径
  11.         print "Work Space Has Been Created!"
  14.     else:
  15.         print "Work Space  has already exists"
  18. make_DMS_dir(work_space_path)            #调用函数

OS 操作

  1. os.listdir(dirname)：列出dirname下的目录和文件
  2. os.getcwd()：获得当前工作目录
  3. os.curdir:返回当前目录（'.')
  4. os.chdir(dirname):改变工作目录到dirname
  6. os.path.isdir(name):判断name是不是一个目录，name不是目录就返回false
  7. os.path.isfile(name):判断name是不是一个文件，不存在name也返回false
  8. os.path.exists(name):判断是否存在文件或目录name
  9. os.path.getsize(name):获得文件大小，如果name是目录返回0L
  11. os.path.abspath(name):获得绝对路径
  12. os.path.normpath(path):规范path字符串形式
  13. os.path.split(name):分割文件名与目录（事实上，如果你完全使用目录，它也会将最后一个目录作为文件名而分离，同时它不会判断文件或目录是否存在）
  14. os.path.splitext():分离文件名与扩展名
  15. os.path.join(path,name):连接目录与文件名或目录
  16. os.path.basename(path):返回文件名
  17. os.path.dirname(path):返回文件路径
  19. os.remove(dir) #dir为要删除的文件夹或者文件路径
  20. os.rmdir(path) #path要删除的目录的路径。需要说明的是，使用os.rmdir删除的目录必须为空目录，否则函数出错。
  22. os.path.getmtime(name) ＃获取文件的修改时间 
  24. os.stat(path).st_mtime＃获取文件的修改时间
  26. os.stat(path).st_ctime #获取文件创建时间
  28. os.path.getctime(name)#获取文件的创建时间

时间戳操作

  1. #endcoding: utf-8
  3. # 获取文件的时间属性
  4. # 用到的知识
  5. #   os.getcwd() 方法用于返回当前工作目录
  6. #   os.path.getatime(file) 输出文件访问时间
  7. #   os.path.getctime(file) 输出文件的创建时间
  8. #   os.path.getmtime(file) 输出文件最近修改时间
  11. import time 
  12. import os
  14. def fileTime(file):
  15.     return [
  16.         time.ctime(os.path.getatime(file)),
  17.         time.ctime(os.path.getmtime(file)),
  18.         time.ctime(os.path.getctime(file))
  19.     ]
  21. times = fileTime(os.getcwd())
  22. print(times)
  23. print(type(times))

文件操作

  1. #文件、文件夹的移动、复制、删除、重命名
  3. #导入shutil模块和os模块
  4. import shutil,os
  6. #复制单个文件
  7. shutil.copy("C:\\a\\1.txt","C:\\b")
  8. #复制并重命名新文件
  9. shutil.copy("C:\\a\\2.txt","C:\\b\\121.txt")
  10. #复制整个目录(备份)
  11. shutil.copytree("C:\\a","C:\\b\\new_a")
  13. #删除文件
  14. os.unlink("C:\\b\\1.txt")
  15. os.unlink("C:\\b\\121.txt")
  16. #删除空文件夹
  17. try:
  18.     os.rmdir("C:\\b\\new_a")
  19. except Exception as ex:
  20.     print("错误信息："+str(ex))#提示：错误信息，目录不是空的
  21. #删除文件夹及内容
  22. shutil.rmtree("C:\\b\\new_a")
  24. #移动文件
  25. shutil.move("C:\\a\\1.txt","C:\\b")
  26. #移动文件夹
  27. shutil.move("C:\\a\\c","C:\\b")
  29. #重命名文件
  30. shutil.move("C:\\a\\2.txt","C:\\a\\new2.txt")
  31. #重命名文件夹
  32. shutil.move("C:\\a\\d","C:\\a\\new_d")

工作区设计

Original
Logs
版本注释

长春大学课程表

  1. # -*- coding: utf-8 -*-
  2. # Filename:BasicCurriculumInfo
  3. import math
  6. class CourseUnit:
  7.     __defaultWorkbook = 0
  8.     __defaultWorksheet = 0
  9.     __curriculumArea = 0
  10.     __static_to_class_m = 0
  11.     # if your code a tool func and don't want to be static, add this useless statement
  13.     def __init__(self, workbook_obj):
  14.         self.__defaultWorkbook = workbook_obj
  15.         self.__defaultWorksheet = self.__defaultWorkbook.worksheets[0]
  16.         self.__curriculumArea = self.__defaultWorksheet['B4:H9']
  18.     # The ADT of B4:H9 consisted by tuple(tuple()) access by [][]
  20.     def get_curriculums(self):  # this is a test func
  21.         return self.__curriculumArea
  23.     def get_duration(self, week, num):
  24.         week_list_all = []
  25.         curriculum_string = self.__curriculumArea[num - 1][week - 1].value
  26.         if curriculum_string == ' ':
  27.             return -1
  28.         if self.__find_all_subs('[周]', curriculum_string) != -1:
  29.             index_list = self.__find_all_subs('[周]', curriculum_string)
  30.             newline_list = []
  31.             num_of_para = len(index_list)
  32.             for i in index_list:
  33.                 newline_list.append(curriculum_string[0:i].rfind('\n'))
  34.             week_str = []
  35.             for i in range(0, num_of_para):
  36.                 week_str.append(curriculum_string[newline_list[i] + 1:index_list[i]])
  37.             week_string = ""
  38.             for subs in week_str:
  39.                 for chars in subs:
  40.                     week_string += chars
  41.                 week_string += ','
  43.             week_string = week_string.replace(',', '@', 6)
  44.             week_string = week_string.split('@')
  46.             week_list = self.__curriculum_expansion(week_string)
  47.             week_list_all.extend(week_list)
  48.         if self.__find_all_subs('[双周]', curriculum_string) != -1:
  49.             index_list = self.__find_all_subs('[双周]', curriculum_string)
  50.             newline_list = []
  51.             num_of_para = len(index_list)
  52.             for i in index_list:
  53.                 newline_list.append(curriculum_string[0:i].rfind('\n'))
  54.             week_str = []
  55.             for i in range(0, num_of_para):
  56.                 week_str.append(curriculum_string[newline_list[i] + 1:index_list[i]])
  57.             week_string = ""
  58.             for subs in week_str:
  59.                 for chars in subs:
  60.                     week_string += chars
  61.                 week_string += ','
  63.             week_string = week_string.replace(',', '@', 6)
  64.             week_string = week_string.split('@')
  66.             week_list = self.__curriculum_expansion(week_string)
  67.             week_list_all.extend(week_list)
  68.         if self.__find_all_subs('[单周]', curriculum_string) != -1:
  69.             index_list = self.__find_all_subs('[单周]', curriculum_string)
  70.             newline_list = []
  71.             num_of_para = len(index_list)
  72.             for i in index_list:
  73.                 newline_list.append(curriculum_string[0:i].rfind('\n'))
  74.             week_str = []
  75.             for i in range(0, num_of_para):
  76.                 week_str.append(curriculum_string[newline_list[i] + 1:index_list[i]])
  77.             week_string = ""
  78.             for subs in week_str:
  79.                 for chars in subs:
  80.                     week_string += chars
  81.                 week_string += ','
  83.             week_string = week_string.replace(',', '@', 6)
  84.             week_string = week_string.split('@')
  86.             week_list = self.__curriculum_expansion(week_string)
  87.             week_list_all.extend(week_list)
  89.         week_list_all.sort()
  91.         return week_list_all
  93.     def __find_all_subs(self, sub, s):
  94.         self.__static_to_class_m = 0
  95.         index_list = []
  96.         index = s.find(sub)
  97.         while index != -1:
  98.             index_list.append(index)
  99.             index = s.find(sub, index + 1)
  100.         if len(index_list) > 0:
  101.             return index_list
  102.         else:
  103.             return -1
  105.     def __str_to_int(self, o_str):
  106.         self.__static_to_class_m = 0
  107.         char_list = []
  108.         for chars in o_str:
  109.             char_list.append(chars)
  110.         int_list = []
  111.         for ints in char_list:
  112.             int_list.append(int(ints) - int('0'))
  113.         bit = len(int_list)
  114.         local_iter = 0
  115.         integer = 0
  116.         while bit != 0:
  117.             integer += int_list[local_iter] * math.pow(10, bit - 1)
  118.             local_iter += 1
  119.             bit -= 1
  121.         return int(integer)
  123.     def __curriculum_expansion(self, o_str_list):
  124.         self.__static_to_class_m = 0
  125.         u_list = []
  126.         u_start = 0
  127.         u_end = 0
  128.         t_list = []
  130.         for step_len in o_str_list:
  131.             if step_len == '':
  132.                 continue
  133.             if '-' in step_len:
  134.                 u_list = step_len.split('-')
  135.                 u_start = u_list[0]
  136.                 u_end = u_list[1]
  137.                 u_start = self.__str_to_int(u_start)
  138.                 u_end = self.__str_to_int(u_end)
  139.                 for i in range(u_start, u_end + 1):
  140.                     t_list.append(i)
  141.             elif '-' not in step_len:
  142.                 t_list.append(self.__str_to_int(step_len))
  143.         t_list.sort()
  144.         return t_list
  146.     def __reconnect_lists(self, o_list, t_list):
  147.         self.__static_to_class_m = 0
  148.         o_list = o_list.expand(t_list)
  149.         for chapter in o_list:
  150.             if chapter.find('*') > 10:
  151.                 o_list.append('*')
  152.                 chapter.reiter_count()
  153.             elif chapter.thread_max() < 50:
  154.                 t_list.reinsert(chapter.iter.en())
  2. # -*- coding: utf-8 -*-
  3. # Filename:BasicCurriculumInfo
  5. import openpyxl as vpa
  6. import re
  9. class StudentSheetInfo:
  11.     __defaultWorkbook = 0
  12.     __defaultWorksheet = 0
  13.     __basicTitle = 0
  14.     __infoTitle = 0
  16.     def __init__(self, workbook_obj):
  17.         self.__defaultWorkbook = workbook_obj
  18.         self.__defaultWorksheet = self.__defaultWorkbook.worksheets[0]
  19.         self.__basicTitle = self.__defaultWorksheet['A1']
  20.         self.__infoTitle = self.__defaultWorksheet['A2']
  22.     def get_class_sheet_name(self):
  23.         name_position = []
  24.         for i in range(0, len(self.__basicTitle.value)):
  25.             if self.__basicTitle.value[i] == ' ':
  26.                 name_position.append(i)
  27.         return self.__basicTitle.value[name_position[0]+1:name_position[1]]
  28.     # the format of str: "CollegeName Name Title"
  30.     def get_class_sheet_school_year(self):
  31.         school_year_position = re.search('学年学期：', self.__infoTitle.value).span()
  32.         for i in range(school_year_position[1], len(self.__infoTitle.value)):
  33.             if self.__infoTitle.value[i] == ' ':
  34.                 end_mark = i
  35.                 break
  36.         return self.__infoTitle.value[school_year_position[1]:end_mark]
  37.     # the format of str: "学年学期：YYYY-YYYY-I     ..."
  39.     def get_class_sheet_class(self):
  40.         school_year_position = re.search('班级：', self.__infoTitle.value).span()
  41.         for i in range(school_year_position[1], len(self.__infoTitle.value)):
  42.             if self.__infoTitle.value[i] == ' ':
  43.                 end_mark = i
  44.                 break
  45.         return self.__infoTitle.value[school_year_position[1]:end_mark]
  46.     # the format of str: "班级：MajorYYNUM     ..."
  48.     def get_class_sheet_major(self):
  49.         school_year_position = re.search('所属班级：', self.__infoTitle.value).span()
  50.         for i in range(school_year_position[1], len(self.__infoTitle.value)):
  51.             if self.__infoTitle.value[i] == ' ':
  52.                 end_mark = i
  53.                 break
  54.         return self.__infoTitle.value[school_year_position[1]:end_mark]
  55.     # the format of str: "所属班级：MajorYYNUM     ..."
  57.     def get_class_sheet_update_time(self):
  58.         return self.__infoTitle.value[-10:]

新更新

  1. # -*- coding: utf-8 -*-
  2. # Filename:BasicCurriculumInfo
  3. import math
  6. class CourseUnit:
  7.     __defaultWorkbook = 0
  8.     __defaultWorksheet = 0
  9.     __curriculumArea = 0
  10.     __static_to_class_m = 0
  12.     # if your code a tool func and don't want to be static, add this useless statement
  14.     def __init__(self, workbook_obj):
  15.         self.__defaultWorkbook = workbook_obj
  16.         self.__defaultWorksheet = self.__defaultWorkbook.worksheets[0]
  17.         self.__curriculumArea = self.__defaultWorksheet['B4:H9']
  19.     # The ADT of B4:H9 consisted by tuple(tuple()) access by [][]
  21.     def get_curriculums(self):  # this is a test function
  22.         return self.__curriculumArea
  24.     def get_duration(self, week, num):
  25.         week_list_all = []
  26.         curriculum_string = self.__curriculumArea[num - 1][week - 1].value
  27.         if curriculum_string == ' ':
  28.             return -1
  29.         if self.__find_all_subs('[周]', curriculum_string) != -1:
  30.             index_list = self.__find_all_subs('[周]', curriculum_string)
  31.             newline_list = []
  32.             num_of_para = len(index_list)
  33.             for i in index_list:
  34.                 newline_list.append(curriculum_string[0:i].rfind('\n'))
  35.             week_str = []
  36.             for i in range(0, num_of_para):
  37.                 week_str.append(curriculum_string[newline_list[i] + 1:index_list[i]])
  38.             week_string = ""
  39.             for subs in week_str:
  40.                 for chars in subs:
  41.                     week_string += chars
  42.                 week_string += ','
  43.             week_string = week_string.replace(',', '@', 20 + 1)
  44.             week_string = week_string.split('@')
  46.             week_list = self.__curriculum_expansion(week_string)
  47.             week_list_all.extend(week_list)
  48.         if self.__find_all_subs('[双周]', curriculum_string) != -1:
  49.             index_list = self.__find_all_subs('[双周]', curriculum_string)
  50.             newline_list = []
  51.             num_of_para = len(index_list)
  52.             for i in index_list:
  53.                 newline_list.append(curriculum_string[0:i].rfind('\n'))
  54.             week_str = []
  55.             for i in range(0, num_of_para):
  56.                 week_str.append(curriculum_string[newline_list[i] + 1:index_list[i]])
  57.             week_string = ""
  58.             for subs in week_str:
  59.                 for chars in subs:
  60.                     week_string += chars
  61.                 week_string += ','
  63.             week_string = week_string.replace(',', '@', 6)
  64.             week_string = week_string.split('@')
  66.             week_list = self.__curriculum_expansion(week_string)
  67.             week_list_all.extend(week_list)
  68.         if self.__find_all_subs('[单周]', curriculum_string) != -1:
  69.             index_list = self.__find_all_subs('[单周]', curriculum_string)
  70.             newline_list = []
  71.             num_of_para = len(index_list)
  72.             for i in index_list:
  73.                 newline_list.append(curriculum_string[0:i].rfind('\n'))
  74.             week_str = []
  75.             for i in range(0, num_of_para):
  76.                 week_str.append(curriculum_string[newline_list[i] + 1:index_list[i]])
  77.             week_string = ""
  78.             for subs in week_str:
  79.                 for chars in subs:
  80.                     week_string += chars
  81.                 week_string += ','
  83.             week_string = week_string.replace(',', '@', 6)
  84.             week_string = week_string.split('@')
  86.             week_list = self.__curriculum_expansion(week_string)
  87.             week_list_all.extend(week_list)
  89.         week_list_all.sort()
  91.         return week_list_all
  93.     def __find_all_subs(self, sub, s):  # find all substring in string
  94.         self.__static_to_class_m = 0
  95.         index_list = []
  96.         index = s.find(sub)
  97.         while index != -1:
  98.             index_list.append(index)
  99.             index = s.find(sub, index + 1)
  100.         if len(index_list) > 0:
  101.             return index_list  # return location index
  102.         else:
  103.             return -1  # return -1 if nothing have found
  105.     def __str_to_int(self, o_str):  # convert a string type number to int
  106.         self.__static_to_class_m = 0
  107.         char_list = []
  108.         for chars in o_str:
  109.             char_list.append(chars)
  110.         int_list = []
  111.         for ints in char_list:
  112.             int_list.append(int(ints) - int('0'))
  113.         bit = len(int_list)
  114.         local_iter = 0
  115.         integer = 0
  116.         while bit != 0:
  117.             integer += int_list[local_iter] * math.pow(10, bit - 1)
  118.             local_iter += 1
  119.             bit -= 1
  121.         return int(integer)
  123.     def __curriculum_expansion(self, o_str_list):  # get a string with ',' and expand it
  124.         self.__static_to_class_m = 0
  125.         t_list = []
  127.         for step_len in o_str_list:
  128.             if step_len == '':
  129.                 continue
  130.             if '-' in step_len:
  131.                 u_list = step_len.split('-')
  132.                 u_start = u_list[0]
  133.                 u_end = u_list[1]
  134.                 u_start = self.__str_to_int(u_start)
  135.                 u_end = self.__str_to_int(u_end)
  136.                 for i in range(u_start, u_end + 1):
  137.                     t_list.append(i)
  138.             elif '-' not in step_len:
  139.                 t_list.append(self.__str_to_int(step_len))
  140.         t_list.sort()
  141.         return t_list
  143.     def get_curriculum_layout(self):  # convert list to a binary number (int)
  144.         layout = []
  145.         for week in range(1, 7 + 1):  # 7 days a week and a bound
  146.             for chapter in range(1, 6 + 1):  # 6 lesson a day and a bound
  147.                 layout.append(self.list_to_binary(self.get_duration(week, chapter)))
  148.         return layout
  150.     @staticmethod
  151.     def list_to_binary(o_list):
  152.         m_binary = 0
  153.         if o_list == -1:  # runtime datatype double check, (Customized)
  154.             return -1
  155.         for it in o_list:
  156.             m_binary += 2 ** it
  157.         return m_binary
  159.     @staticmethod
  160.     def binary_to_list(o_bin):
  161.         const_bit = 0b1
  162.         m_list = []
  163.         for it in range(0, 20):
  164.             ret = o_bin & const_bit  # get last bit
  165.             if ret == 1:
  166.                 m_list.append(it)
  167.             o_bin = o_bin >> 1
  168.         return m_list
  170.     """
  171.         Excel cannot convert a list data type to a table data type.
  172.         However, the list is not repeated, so I can use binary
  173.         distribution to represent the contents of the list.
  174.         for example i have a list which is [2, 3, 5]
  175.         i cannot put it into excel cells, but i can transfer
  176.         this list into a number which is 0b101100
  177.         0 b 1 0 1 1 0 0
  178.             ^   ^ ^
  179.             5   3 2
  180.         and this number is 44 (int)
  181.     """
  1. # -*- coding: utf-8 -*-
  2. # Filename:BasicCurriculumInfo
  3. """
  4.     class provides basic information of curriculum table
  5.     most of method may not used in actual practice
  6.     the variable 'end_mark' is local variable, ignore
  7.     some warnings below:
  8.     "Local variable 'end_mark' might be referenced before assignment"
  9.     DO NOT ADD GLOBAL STATEMENTS
  10. """
  11. import re
  14. class StudentSheetInfo:
  16.     __defaultWorkbook = 0
  17.     __defaultWorksheet = 0
  18.     __basicTitle = 0
  19.     __infoTitle = 0
  21.     def __init__(self, workbook_obj):
  22.         self.__defaultWorkbook = workbook_obj
  23.         self.__defaultWorksheet = self.__defaultWorkbook.worksheets[0]
  24.         self.__basicTitle = self.__defaultWorksheet['A1']
  25.         self.__infoTitle = self.__defaultWorksheet['A2']
  27.     def get_class_sheet_name(self):
  28.         name_position = []
  29.         for i in range(0, len(self.__basicTitle.value)):
  30.             if self.__basicTitle.value[i] == ' ':
  31.                 name_position.append(i)
  32.         return self.__basicTitle.value[name_position[0]+1:name_position[1]]
  33.     # the format of str: "CollegeName Name Title"
  35.     def get_class_sheet_school_year(self):
  36.         school_year_position = re.search('学年学期：', self.__infoTitle.value).span()
  37.         for i in range(school_year_position[1], len(self.__infoTitle.value)):
  38.             if self.__infoTitle.value[i] == ' ':
  39.                 end_mark = i
  40.                 break
  41.         return self.__infoTitle.value[school_year_position[1]:end_mark]
  42.     # the format of str: "学年学期：YYYY-YYYY-I     ..."
  44.     def get_class_sheet_class(self):
  45.         school_year_position = re.search('班级：', self.__infoTitle.value).span()
  46.         for i in range(school_year_position[1], len(self.__infoTitle.value)):
  47.             if self.__infoTitle.value[i] == ' ':
  48.                 end_mark = i
  49.                 break
  50.         return self.__infoTitle.value[school_year_position[1]:end_mark]
  51.     # the format of str: "班级：MajorYYNUM     ..."
  53.     def get_class_sheet_major(self):
  54.         school_year_position = re.search('所属班级：', self.__infoTitle.value).span()
  55.         for i in range(school_year_position[1], len(self.__infoTitle.value)):
  56.             if self.__infoTitle.value[i] == ' ':
  57.                 end_mark = i
  58.                 break
  59.         return self.__infoTitle.value[school_year_position[1]:end_mark]
  60.     # the format of str: "所属班级：MajorYYNUM     ..."
  62.     def get_class_sheet_update_time(self):
  63.         return self.__infoTitle.value[-10:]