Creating multiple sheets with input function in xlsxwriter python

Question

I want to create multiple sheets using the input function. I used the split function, but still it only creates one sheet. The idea is not to be restricted by the number of sheets.

import xlsxwriter
from xlsxwriter import workbook

workbook = xlsxwriter.Workbook('doc.xlsx')

sheetnames = input("Enter value: ").split(', ')

sheetss = []
for i in sheetnames:
  sheetss.append(i)
worksheet_data = workbook.add_worksheet(i)

workbook.close()

Any ideas?

Is the workbook.add_worksheet(i) inside the for loop?

not_speshal
– not_speshal

2021-07-26 12:59:51 +00:00
Commented Jul 26, 2021 at 12:59 — not_speshal
– not_speshal, Commented Jul 26, 2021 at 12:59
no, workbook.add_worksheet(i) is outside the for loop

project.py
– project.py

2021-07-26 22:21:52 +00:00
Commented Jul 26, 2021 at 22:21 — project.py
– project.py, Commented Jul 26, 2021 at 22:21

not_speshal · Accepted Answer · 2021-07-26 12:59:56Z

2

Try:

import xlsxwriter
workbook = xlsxwriter.Workbook("test.xlsx")
sheetnames = input("Enter value: ").split(", ")
for i in sheetnames:
    workbook.add_worksheet(i)
workbook.close()

Using split() already creates a list so you don't need another variable to hold the sheetnames.

answered Jul 26, 2021 at 12:59

not_speshal

23.2k2 gold badges18 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

project.py Over a year ago

Thanks, it is working, but when I add data, only puts it in last sheet. What to do to put same data in every sheet?

not_speshal Over a year ago

@project.py - Depends what kind of data you're adding. See here. You can ask a new question if you can't figure it out.

Collectives™ on Stack Overflow

Creating multiple sheets with input function in xlsxwriter python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related