Any way to create a new worksheet using xlwings?

python excel xlwings
hd810 picture hd810 · Oct 14, 2014 · Viewed 9.3k times · Source

Using Python xlwings, how can I create a new worksheet?

Answer

Felix Zumstein picture Felix Zumstein · Oct 19, 2014 
import xlwings as xw
wb = xw.Book()
wb.sheets.add()

See also the docs.

Related questions

Read data in Excel column into Python list

I am using python xlwings to read a column of data in Excel 2013. Column A is populated with numbers. To import this column into a python list py_list, I have the following code; import xlwings as xw wb = xw.…

Read More
How do I call an Excel macro from Python using xlwings?

I've read the API docs for xlwings, and played around with Workbook and Sheet objects in the interpreter, but I can't figure out how to call a macro from Python. How do I use xlwings to call an Excel macro …

Read More
Open a Workbook with XLWINGS without making it visible

I am starting to use XLWings (not that I like Excel, at all, but it is something I HAVE TO do). The thing is that I cannot find the way to make Python open a Workbook without showing it. It …

Read More