Скачать или смотреть 2 create new excel file by python

how to create new excel file by python for more information
you can browse site:
http://ilearnwithyou.cf/module/python...
make you learn easy and step by step
first step you learn create file xlsx and save in your device
easy learn
module openpyxl
my website: http://ilearnwithyou.cf
i will use code
-------------------------source code------------------------------------------------
from openpyxl import Workbook
wb=Workbook()
wb.save("your file xlsx.xlsx")
--------------------------------------------------------------------------------------------------------------------------
Create a workbook
There is no need to create a file on the filesystem to get started with openpyxl. Just import the Workbook class and start work:

Openpyxl
The openpyxl is a Python library to read and write Excel 2010 xlsx/xlsm/xltx/xltm files.

Excel xlsx
In this tutorial we work with xlsx files. The xlsx is a file extension for an open XML spreadsheet file format used by Microsoft Excel. The xlsm files support macros. The xls format is a proprietary binary format while xlsx is based on Office Open XML format.
--------------------------------------------------------------------------------------------------------------
A Guide to Excel Spreadsheets in Python With openpyxl
Excel spreadsheets are one of those things you might have to deal with at some point. Either it’s because your boss loves them or because marketing needs them, you might have to learn how to work with spreadsheets, and that’s when knowing openpyxl comes in handy!

Spreadsheets are a very intuitive and user-friendly way to manipulate large datasets without any prior technical background. That’s why they’re still so commonly used today.
Before You Begin
If you ever get asked to extract some data from a database or log file into an Excel spreadsheet, or if you often have to convert an Excel spreadsheet into some more usable programmatic form, then this tutorial is perfect for you. Let’s jump into the openpyxl caravan!

Practical Use Cases
First things first, when would you need to use a package like openpyxl in a real-world scenario? You’ll see a few examples below, but really, there are hundreds of possible scenarios where this knowledge could come in handy.

Importing New Products Into a Database
You are responsible for tech in an online store company, and your boss doesn’t want to pay for a cool and expensive CMS system.

Every time they want to add new products to the online store, they come to you with an Excel spreadsheet with a few hundred rows and, for each of them, you have the product name, description, price, and so forth.

Now, to import the data, you’ll have to iterate over each spreadsheet row and add each product to the online store.
--------------------------------------------------------------------------------------------------------------------
Openpyxl Tutorial

This is a comprehensive Python Openpyxl Tutorial to read and write MS Excel files in Python. Openpyxl is a Python module to deal with Excel files without involving MS Excel application software. It is used extensively in different operations from data copying to data mining and data analysis by computer operators to data analysts and data scientists. openpyxl is the most used module in python to handle excel files. If you have to read data from excel, or you want to write data or draw some charts, accessing sheets, renaming sheets, adding or deleting sheets, formatting and styling in sheets or any other task, openpyxl will do the job for you.
If you want to Read, Write and Manipulate(Copy, cut, paste, delete or search for an item etc) Excel files in Python with simple and practical examples I will suggest you to see this simple and to the point Excel Openpyxl Course with examples about how to deal with MS Excel files in Python. This video course teaches efficiently how to manipulate excel files and automate tasks. Moreover, you will also get free help in writing Python code for your Excel tasks.
Everything you do in Microsoft Excel, can be automated with Python. So why not use the power of Python and make your life easy. You can make intelligent and thinking Excel sheets, bringing the power of logic and thinking of Python to Excel which is usually static, hence bringing flexibility in Excel and a number of opportunities.

First we discuss some of the keywords used in Python excel relationship which are used in openpyxl programming for excel.
An Excel file is usually called as Spreadsheet however in openpyxl we call it Workbook.
A single Workbook is usually saved in a file with extension .xlsx
A Workbook may have as less as one sheet and as many as dozens of worksheets.
Active sheet is the worksheet user is viewing or viewed before closing the file.