python(49)-Excel-读-xlrd-写xlwt

1.创建一个EXCEL 文件
2.指定行列写入
3.读取一个EXCEL文件

---

1.创建一个EXCEL 文件
 

    excelname = "D://test.xls"
    writebook = xlwt.Workbook()  # 打开一个excel
    sheet     = writebook.add_sheet('Test1')
    writebook.save(excelname)

2.指定行列写入
    特别注意：
      readsheet=readbook.sheet_by_index(sheetid)   #sheetid为index  xlrd
      readsheet=readbook.sheet_by_name(sheetstr) #sheetstr为字符串

                      writesheet=writebook.get_sheet(sheetid)  #  xlwt
   以下代码是在文件test.xls的第一个sheet，[1,1]单元格里写入“我的测试”
   

 

    excelname = "D:/test.xls"
    readbook = xlrd.open_workbook(excelname)
    writebook = copy(readbook)
    writesheet = writebook.get_sheet(0)
    valuetext="我的测试"
    writesheet.write(1, 1, valuetext, style=SetStyle(None))
    writebook.save(excelname)

  
3.读取一EXCEL文件
   

 excelname="D:/test.xls"
 readbook =  xlrd.open_workbook("",formatting_info=True)
 readsheet = readbook.sheet_by_index(sheetid)
 nrowsnum = readsheet.nrows
 for line in range(0, nrowsnum):
     date = readsheet.row(line)  # 获取该sheet第i行的内容
     for colum in range(0, len(date)):
         textinsheet = str(date[colum])  # 把该行第n个单元格转化为字符串
         print(textinsheet)