Re: Renaming Excel Spreadsheets

[Emile van Sebille]

Greg Lindstrom wrote:

Hello,

I am working with Python to create Excel spreadsheets and have run into
a couple of problems I hope you can help me with.

First...are there any bindings/libraries into Open Office?

Now, back to Excel.

--Does anyone know a way to create N worksheets? By default, 3 are
created, but I would like more.

--Is it possible to rename a worksheet inside of the workbook (change
"Sheet1" to "July 08", for example).

Here's some code from years back that adds sheets to a workbook and then
renames them.

Sheets = [["SlsSrce",None,1],
["SalesReps",None,1],
["Control",None,1]]

replist = []
for k in repkeys:
if k in currentReps:
replist.append([k, reps[k]])
Sheets.append(['Rep-%s' % k, None, 1])

def WorkBookSetup(Sheets):
# xl.Visible = 1
wbi = xl.Workbooks.Add()
wbi.Activate()
sheetcount = xl.Sheets.Count
index = 0
for name, ref, nextline in Sheets:
if index >= sheetcount:
wbi.Sheets.Add()
index = index + 1
index = 0
for name, ref, nextline in Sheets:
wbi.Sheets[index].Name = name
Sheets[index][1] = wbi.Sheets[index]
index = index + 1
return wbi

HTH,

Emile