请教一下用python操作excel的问题

kaminjo

from win32com.client import Dispatch xls=Dispatch('Excel.Application') xls.Visible=1 xls.Workbooks.Add() for i in range(1,10,1):   for j in range(1,10,1):     xls.Cells(i,j).Value=i*j wb.SaveAs(Filename='e:\\b.xls')

如上,默认是将数据写入'Sheet1',怎样建立一个名称为'test'的工作表,然后将数据写入到这个工作表里面呢?
在网上找了好久都没发现解决方法,只好到这里请教大家了.

[ 本帖最后由 kaminjo 于 2009-11-23 09:38 编辑 ]

qshllxfx

应该是add里面加参数吧，没用过这个模块，我用的pyExcelerator，add里面可以加数据表的参数

kaminjo

找到方法了

caesarok

分享一下哈!

kaminjo

原来楼上也需要么

#!/usr/bin/env python from win32com.client import Dispatch xlApp = Dispatch("Excel.Application") xlApp.Visible = 1 # Check if any workbook exists. if xlApp.Workbooks.Count == 0: &nbsp;&nbsp;&nbsp;&nbsp;# If not, create a new one. &nbsp;&nbsp;&nbsp;&nbsp;workbook = xlApp.Workbooks.Add() else: &nbsp;&nbsp;&nbsp;&nbsp;# If yes, use the first one. &nbsp;&nbsp;&nbsp;&nbsp;workbook = xlApp.Workbooks[0] # Check if any sheet exists. if workbook.Sheets.Count == 0: &nbsp;&nbsp;&nbsp;&nbsp;# If not, add a sheet to current workbook. &nbsp;&nbsp;&nbsp;&nbsp;sheet = workbook.Sheets.Add() else: &nbsp;&nbsp;&nbsp;&nbsp;# If yes, use the first sheet of current workbook. &nbsp;&nbsp;&nbsp;&nbsp;sheet = workbook.Sheets[0] &nbsp;&nbsp;&nbsp;&nbsp; # Generate the multiplication table(9x9). for i in xrange(2, 10): &nbsp;&nbsp;&nbsp;&nbsp;# Cells(<column>, <row>) &nbsp;&nbsp;&nbsp;&nbsp;sheet.Cells(1, i).Value = i &nbsp;&nbsp;&nbsp;&nbsp;sheet.Cells(1, i).Font.Color = 0xFF0000 &nbsp;&nbsp;&nbsp;&nbsp;sheet.Cells(i, 1).Value = i &nbsp;&nbsp;&nbsp;&nbsp;sheet.Cells(i, 1).Font.Color = 0x00FF00 &nbsp;&nbsp;&nbsp;&nbsp; def a2i(ch): &nbsp;&nbsp;&nbsp;&nbsp;return ord(ch.upper()) - ord('A') + 1 def i2a(i): &nbsp;&nbsp;&nbsp;&nbsp;return chr((i-1) + ord('A')) &nbsp;&nbsp;&nbsp;&nbsp; for i in xrange(2, 10): &nbsp;&nbsp;&nbsp;&nbsp;for j in xrange(2, 10): &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;# Generate the Excel formula.       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sheet.Cells(i, j).Formula = '=%s1*A%s' % (i2a(j), i) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sheet.Cells(i, j).Font.Color = 0x000000 sheet.Name = "Multiplication Table" workbook.SaveAs('xxx.xls') xlApp.Quit()