The Application.NewWorkbook property in xlwings provides a powerful way to create a new Excel workbook programmatically. It returns a Workbook object representing the newly created workbook, allowing for immediate manipulation of its contents, sheets, and properties. This functionality is essential for automating report generation, data processing workflows, or any task requiring the dynamic creation of Excel files without manual intervention.<\/p>\n\n\n\n
Functionality<\/strong> Syntax and Parameters<\/strong> While the VBA object model uses For most common use cases, calling Code Examples<\/strong><\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" The Application.NewWorkbook property in xlwings provides a powerful way to create a new Excel workbo…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-2151","post","type-post","status-publish","format-standard","hentry","category-xlwings-api-reference"],"_links":{"self":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/comments?post=2151"}],"version-history":[{"count":1,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2151\/revisions"}],"predecessor-version":[{"id":3288,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2151\/revisions\/3288"}],"wp:attachment":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/media?parent=2151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/categories?post=2151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/tags?post=2151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
The primary function of Application.NewWorkbook<\/code> is to generate a fresh, blank workbook in Excel. This new workbook becomes the active workbook, and you can start adding data, formatting, or charts right away. It is particularly useful in scenarios where you need to produce multiple output files from a single data source or when building templates on the fly. Unlike simply opening an existing file, this method ensures you begin with a clean slate, adhering to default Excel settings unless otherwise modified.<\/p>\n\n\n\n
In xlwings, you access this property through the app<\/code> object, which represents the Excel Application. The basic syntax is:<\/p>\n\n\n\nnew_wb = app.books.add()<\/code><\/pre>\n\n\n\nApplication.NewWorkbook<\/code>, xlwings employs the books.add()<\/code> method as the direct equivalent. The add()<\/code> method can accept several optional parameters to customize the new workbook:<\/p>\n\n\n\n\n
app.books.add()<\/code> for a new file).<\/li>\n\n\n\napp.books.add()<\/code> without arguments is sufficient. The method returns a Book<\/code> object (xlwings’ term for a Workbook), which you can assign to a variable for further operations.<\/p>\n\n\n\n\n
import xlwings as xw\n\n# Start a new Excel instance (visible=False for background operation)\napp = xw.App(visible=True)\n\n# Create a new workbook\nnew_workbook = app.books.add()\n\n# Access the first sheet and write data\nsheet = new_workbook.sheets[0]\nsheet.range('A1').value = 'Product'\nsheet.range('B1').value = 'Sales'\nsheet.range('A2').value = ['Widget A', 'Widget B', 'Widget C']\nsheet.range('B2').value = [1500, 2100, 1850]\n\n# Save the workbook\nnew_workbook.save(r'C:\\Reports\\NewReport.xlsx')\n# new_workbook.close()\n# app.quit()<\/code><\/pre>\n\n\n\n\n
import xlwings as xw\n\napp = xw.App(visible=False)\n\n# Specify the path to your template\ntemplate_path = r'C:\\Templates\\CompanyReport.xltx'\n\n# Create a new workbook based on the template\nnew_wb = app.books.add(template_path)\n\n# The new workbook already contains the template's formatting and sheets.\n# You can populate predefined cells.\nnew_wb.sheets['Data'].range('C5').value = 'Q4-2023'\nnew_wb.sheets['Summary'].range('B10').value = 95000\n\n# Save it with a new name\nnew_wb.save(r'C:\\Reports\\Q4_Report_Final.xlsx')\napp.quit()<\/code><\/pre>\n\n\n\n\n
import xlwings as xw\n\napp = xw.App(visible=False)\n\ndepartments = ['Sales', 'Marketing', 'Engineering', 'HR']\n\nfor dept in departments:\n # Create a new workbook for each department\n wb = app.books.add()\n wb.sheets[0].name = dept\n wb.sheets[0].range('A1').value = f'Department: {dept}'\n # ... add more department-specific data ...\n wb.save(fr'C:\\DepartmentReports\\{dept}_Data.xlsx')\n wb.close() # Close the workbook after saving to free memory\n\napp.quit()<\/code><\/pre>\n\n\n\n