Python + OpenPyXl = Excel, электронные таблицы на питоне. Как создать xlsx, изменить и стилизовать

Uploaded By: Myvideo

Published on

20 Jul 2024

1 view

0

0 votes

0

About Share Download Add to

Как на питоне создать экселевский файлик? Как прочитать xlsx на Python? Как сделать красивое оформление таблиц, как использовать формулы. Об этом в сегодняшнем видео. ~~ 👽 Код из видео 🤑 Спасибо блоггеру ~~ ☠️ Таймкоды 00:00 О чем это видео 00:57 Почему OpenPyXl 02:04 Структура кода для видео 02:47 Использование Faker для генерации фейковых данных для заливки в таблицы 03:27 Создание xlsx файла и запись в него 07:13 Чтение таблиц эксель на питоне 12:03 Модификация таблиц с помощью openpyxl (колонки, строки, добавление, перемещение) 16:55 Автофильтры и сортировка 20:01 Стилизация данных (цвета, границы, заливки, шрифты) 28:39 Формулы в экселе с помощью openpyxl ~~ Я буду ссылаться на это видео в следующих видео из сериала про тинькоф Инвестиции ~~ #python #excel #программирование

Share with your friends

Link:

Embed:

<iframe width="640" height="360" src="//myvideo.cc/embed/dWJDbmMrMzI5SytNaE0zeSttWHhiTC92bG1xOXV1ZTdNbWRoSDFSRUJFVT0" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>

Video Size:

Custom size:

x

Autoplay video

Hide player controls

Hide resume playing

Add to Playlist:

Favorites

My Playlist

Watch Later

ДОШИРАК - ОТРАВА

21 minute ago

00:10:42

ДОШИРАК - ОТРАВА

1 81%

Программирование с нуля самоучитель скачать бесплатно Бесплатные it курсы

40 minutes ago

00:02:11

Программирование с нуля самоучитель скачать бесплатно Бесплатные it курсы

1 88%

Python - 341 - Restaurant Web App with Django - Creating the App QR Code

1 hour ago

00:03:44

Python - 341 - Restaurant Web App with Django - Creating the App QR Code

1 77%

Python - 340 - Restaurant Web App with Django - Today

1 hour ago

00:03:36

Python - 340 - Restaurant Web App with Django - Today

1 44%

Python - 339 - Job Application Web App with Django - Adding the Navigation Bar

1 hour ago

00:06:53

Python - 339 - Job Application Web App with Django - Adding the Navigation Bar

1 32%

Python - 338 - Job Application Web App with Django - Creating a Base Template

1 hour ago

00:11:53

Python - 338 - Job Application Web App with Django - Creating a Base Template

1 83%

Python - 337 - Job Application Web App with Django - Customizing the Admin Interface

1 hour ago

00:06:30

Python - 337 - Job Application Web App with Django - Customizing the Admin Interface

1 89%

Python - 336 - Job Application Web App with Django - Creating an Admin Interface

1 hour ago

00:07:08

Python - 336 - Job Application Web App with Django - Creating an Admin Interface

1 40%

Python - 335 - Job Application Web App with Django - Today

1 hour ago

00:00:35

Python - 335 - Job Application Web App with Django - Today

1 70%

Python - 334 - Job Application Web App with Django - Send an Email with Django

1 hour ago

00:09:08

Python - 334 - Job Application Web App with Django - Send an Email with Django

1 45%

Python - 333 - Job Application Web App with Django - Store the Data in the Database

1 hour ago

00:04:57

Python - 333 - Job Application Web App with Django - Store the Data in the Database

1 24%

Python - 332 - Job Application Web App with Django - Creating a Form Model

1 hour ago

00:12:27

Python - 332 - Job Application Web App with Django - Creating a Form Model

1 58%

Python - 331 - Job Application Web App with Django - Code the HTML of the Application Form

1 hour ago

00:08:09

Python - 331 - Job Application Web App with Django - Code the HTML of the Application Form

1 40%

Python - 330 - Job Application Web App with Django - Today

1 hour ago

00:01:26

Python - 330 - Job Application Web App with Django - Today

1 6%

Python - 329 - Job Application Web App with Django - Creating a View and a Template

1 hour ago

00:10:34

Python - 329 - Job Application Web App with Django - Creating a View and a Template

1 11%

Python - 328 - Job Application Web App with Django - Setting up Database Models

1 hour ago

00:12:57

Python - 328 - Job Application Web App with Django - Setting up Database Models

1 95%

Python - 327 - Job Application Web App with Django - Setting up a Django Project and an App

1 hour ago

00:09:23

Python - 327 - Job Application Web App with Django - Setting up a Django Project and an App

1 6%

Python - 326 - Job Application Web App with Django - Today

1 hour ago

00:01:34

Python - 326 - Job Application Web App with Django - Today

1 24%

Python - 325 - Job Application Web App with Flask - Sending a Confirmation Email

1 hour ago

00:09:53

Python - 325 - Job Application Web App with Flask - Sending a Confirmation Email

1 62%

Python - 324 - Job Application Web App with Flask - Showing Submission Notification

1 hour ago

00:07:02

Python - 324 - Job Application Web App with Flask - Showing Submission Notification

1 49%

Python - 323 - Job Application Web App with Flask - Storing the User Data in the Database

1 hour ago

00:07:25

Python - 323 - Job Application Web App with Flask - Storing the User Data in the Database

1 63%

Python - 322 - Job Application Web App with Flask - Creating a Database

1 hour ago

00:11:03

Python - 322 - Job Application Web App with Flask - Creating a Database

1 32%

Python - 321 - Job Application Web App with Flask - Getting the User Data

2 hours ago

00:14:30

Python - 321 - Job Application Web App with Flask - Getting the User Data

1 90%

Python - 320 - Job Application Web App with Flask - Today

2 hours ago

00:00:49

Python - 320 - Job Application Web App with Flask - Today

1 32%

0 Comments

Guest