From the course: Advanced Hands-On Python: Working with Excel and Spreadsheet Data

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Writing workbook properties

Writing workbook properties

From the course: Advanced Hands-On Python: Working with Excel and Spreadsheet Data

Start my 1-month free trial Buy for my team

Writing workbook properties

“

- [Instructor] Using XlsxWriter, you can also programmatically set the document properties of a workbook, and these properties contain information about the workbook such as the title, the author, descriptive keywords, and so on. You can see these properties when you're in Excel by going to the Properties Viewer, so let's run our example code as it currently is before we make any changes, just to create an empty workbook so we can see what we're talking about. So I'm going to run this and you can see that properties.xlsx has been created, so let's go ahead and open that in Excel. So the way you do this on the Mac is by going to the File menu and choosing properties about the the workbook. Here on Windows, I'm going to go to the File tab and click on Info, and then right here where it says Properties, I'm going to click on this and choose Advanced Properties. And you can see that here in the Summary tab, there's title, subject, author, manager, company, so on. There's a hyperlink base…

Contents