how to create a new xlsx file using openpyxl?

Question

Does anybody knows how to create a new xlsx file using openpyxl in python?

filepath = "/home/ubun/Desktop/stocksinfo/yyy.xlsx"
wb = openpyxl.load_workbook(filepath)
ws = wb.get_active_sheet()

What do I need to add?

What do you really want? You want to create a new xlsx file? — Anand S Kumar, Aug 08 '15 at 12:34

score 51 · Answer 1 · edited Sep 17 '22 at 13:50

51

I'm sorry my head is turning around. :) This solves the problem

filepath = "/home/ubun/Desktop/stocksinfo/test101.xlsx"
wb = openpyxl.Workbook()

wb.save(filepath)

This will create a new file.

Documentation site contains quickstart on front page.

edited Sep 17 '22 at 13:50

Robert Lujo

answered Aug 08 '15 at 14:11

Newboy11

I'm doing this now, but openpyxl.Workbook() throws error. Simply wb = Workbook() works when already imported with from openpyxl import Workbook – Will Croxford Feb 07 '19 at 09:55

score 17 · Answer 2 · edited Aug 16 '19 at 07:43

17

Install and Import openpyxl

import openpyxl

Create new workbook

wb = openpyxl.Workbook()

Get SHEET name

Sheet_name = wb.sheetnames

Save created workbook at same path where .py file exist

wb.save(filename='Test.xlsx')

edited Aug 16 '19 at 07:43

answered Aug 16 '19 at 07:19

arpit patel

1

Please follow the guidelines on https://stackoverflow.com/help/how-to-answer since in the current form, your answer looks hastily written. – B--rian Aug 16 '19 at 07:37

score 4 · Answer 3 · edited Nov 10 '18 at 17:52

4

wb.save(…)

edited Nov 10 '18 at 17:52

Stephen Rauch

answered Aug 08 '15 at 12:32

Charlie Clark

sir I'm trying to create a non existing file. not modify a existing file – Newboy11 Aug 08 '15 at 12:55
So what? Just use the name for your new file. – Charlie Clark Aug 08 '15 at 13:38

3 Answers3