python删除excel的sheet页_Python能不能用win32com这个包来删除excel的sheet？

from win32com.client import Dispatch

import win32com.client

xlApp = win32com.client.Dispatch('Excel.Application')

xlBook = self.xlApp.Workbooks.Open(filename) #filename是需要打开的excel文件,或者绝对路径

xlBook.Worksheets(sheet).Delete() #sheet是你要删除的列表名称,如'Sheet1'

推荐你用下easyExcel这个包,基本功能都齐全了.

自己调整下格式,换行缩进粘贴代码真麻烦.

#!/usr/bin/env python3

# -*- coding: utf-8 -*-

from win32com.client import Dispatch

import win32com.client

class easyExcel:

"""A utility to make it easier to get at Excel. Remembering

to save the data is your problem, as is error handling.

Operates on one workbook at a time."""

def __init__(self, filename=None): #打开文件或者新建文件(如果不存在的话)

self.xlApp = win32com.client.Dispatch('Excel.Application')

if filename:

self.filename = filename

self.xlBook = self.xlApp.Workbooks.Open(filename)

else:

self.xlBook = self.xlApp.Workbooks.Add()

self.filename = ''

def save(self, newfilename=None): #保存文件

if newfilename:

self.filename = newfilename

self.xlBook.SaveAs(newfilename)

else:

self.xlBook.Save()

def close(self): #关闭文件

self.xlBook.Close(SaveChanges=0)

del self.xlApp

def getCell(self, sheet, row, col): #获取单元格的数据

"Get value of one cell"

sht = self.xlBook.Worksheets(sheet)

return sht.Cells(row, col).Value

def setCell(self, sheet, row, col, value): #设置单元格的数据

sht = self.xlBook.Worksheets(sheet)

sht.Cells(row, col).Value = value

def setCellformat(self, sheet, row, col): #设置单元格的样式

"set value of one cell"

sht = self.xlBook.Worksheets(sheet)

sht.Cells(row, col).Font.Size = 15#字体大小

sht.Cells(row, col).Font.Bold = True#是否黑体

sht.Cells(row, col).Name = "Arial"#字体类型

sht.Cells(row, col).Interior.ColorIndex = 3#表格背景

sht.Cells(row, col).BorderAround(1,4)#表格边框

sht.Rows(3).RowHeight = 30#行高

sht.Cells(row, col).HorizontalAlignment = -4131 #水平居中xlCenter

sht.Cells(row, col).VerticalAlignment = -4160 #

def deleteRow(self, sheet, row):

sht = self.xlBook.Worksheets(sheet)

sht.Rows(row).Delete()#删除行

sht.Columns(row).Delete()#删除列

def getRange(self, sheet, row1, col1, row2, col2): #获得一块区域的数据，返回为一个二维元组

"return a 2d array (i.e. tuple of tuples)"

sht = self.xlBook.Worksheets(sheet)

return sht.Range(sht.Cells(row1, col1), sht.Cells(row2, col2)).Value

def addPicture(self, sheet, pictureName, Left, Top, Width, Height): #插入图片

"Insert a picture in sheet"

sht = self.xlBook.Worksheets(sheet)

sht.Shapes.AddPicture(pictureName, 1, 1, Left, Top, Width, Height)

def deleteSheet(self, sheet): #删除列表

"delete the hole sheet"

shts = self.xlBook.Worksheets

shts(sheet).Delete()

def cpSheet(self, before): #复制工作表

"copy sheet"

shts = self.xlBook.Worksheets

shts(1).Copy(None,shts(1))

def getMaxCol(self, sheet): #获取最大行数

"get the max col number, not the count of used col number"

shts = self.xlBook.Worksheets

return shts(sheet).Columns.Count