Aaron mg

Aaron mg

1647345974

Create the largest DeFi exchange on Tron network

The most heard term in crypto space for trading cryptocurrency is DeFi Exchange aka "Decentralized finance exchange ". Its concepts have attracted many crypto investors to trade in it.

There are many DeFi exchange right now which runs on different blockchain networks like binance, Ethereum, Tron, and many more. Among these, Tron is trending now Because Tron network has just acquired Justswap and named as sunswap with their native token sun and the crypto investors are more interested in investing in it. This is because many crypto influencers claimed that sunswap is the largest decentralized exchange on the Tron network.

Obviously, there will be a huge discussion between the entrepreneur's network on launching a sunswap like exchange to enter the world of DeFi.

So there are no competitors for sunswap in terms of the Tron blockchain network. Launching a DeFi exchange on the Tron network will result in a huge success for sure.

The first comers will get a better audience. so to launch your DeFi exchange on the Tron network choosing a versatile Sunswap clone script will be a smart move

what is the sunswap clone script and how it will be useful for launching a DeFi exchange?

Sunswap clone script is a prebuild DeFi exchange clone script used to launch a DeFi Exchange on the Tron blockchain network with your own architecture and design.

Features of sunswap clone script

Token swap 
Automated Market Maker 
Staking 
Pooling 
Multiple wallet connection support 
Advanced UI/UX 
Cutting-edge Price chart tools
Multi-lingual support  
Transaction history and more

Security Features of our SunSwap Clone Script

Inbuilt security APIs
Immutable smart contracts
Multi-layered security options 
Advanced decryption 
Server-side entry forgery features 
Protection against DDoS
End-to-end SSL encryption 
Encrypted bridging

With the above briefing on launching a DeFi Exchange on the Tron blockchain network, you will have a clear understanding of the SunSwap clone script

Where to get a Sunswap clone script?

To get a ready-to-launch sunswap clone script with the above-mentioned features, you have to choose the best provider in the market.

My best choice is to go with Coinsclone because of their transparent development process and the premium output of the platform. They know what a DeFi Exchange want exactly as their experienced in this field for many years and helped many startups to taste their success in the crypto space

If you are a crypto startup planning to create a DeFi Exchange on the Tron blockchain in a cost-effective way, then connecting with Coinsclone will be an excellent solution for your business.

Quote your requirements and get a live free demo >> SunSwap Clone Script

You can also contact their experts for discussing your business requirement for the best outcome,


Mail Id: hello@coinsclone.com
Telegram: https://t.me/Coinzclone
Whatsapp: +91 9500575285
Skype: live:hello_20214
 

What is GEEK

Buddha Community

Create the largest DeFi exchange on Tron network
Easter  Deckow

Easter Deckow

1655630160

PyTumblr: A Python Tumblr API v2 Client

PyTumblr

Installation

Install via pip:

$ pip install pytumblr

Install from source:

$ git clone https://github.com/tumblr/pytumblr.git
$ cd pytumblr
$ python setup.py install

Usage

Create a client

A pytumblr.TumblrRestClient is the object you'll make all of your calls to the Tumblr API through. Creating one is this easy:

client = pytumblr.TumblrRestClient(
    '<consumer_key>',
    '<consumer_secret>',
    '<oauth_token>',
    '<oauth_secret>',
)

client.info() # Grabs the current user information

Two easy ways to get your credentials to are:

  1. The built-in interactive_console.py tool (if you already have a consumer key & secret)
  2. The Tumblr API console at https://api.tumblr.com/console
  3. Get sample login code at https://api.tumblr.com/console/calls/user/info

Supported Methods

User Methods

client.info() # get information about the authenticating user
client.dashboard() # get the dashboard for the authenticating user
client.likes() # get the likes for the authenticating user
client.following() # get the blogs followed by the authenticating user

client.follow('codingjester.tumblr.com') # follow a blog
client.unfollow('codingjester.tumblr.com') # unfollow a blog

client.like(id, reblogkey) # like a post
client.unlike(id, reblogkey) # unlike a post

Blog Methods

client.blog_info(blogName) # get information about a blog
client.posts(blogName, **params) # get posts for a blog
client.avatar(blogName) # get the avatar for a blog
client.blog_likes(blogName) # get the likes on a blog
client.followers(blogName) # get the followers of a blog
client.blog_following(blogName) # get the publicly exposed blogs that [blogName] follows
client.queue(blogName) # get the queue for a given blog
client.submission(blogName) # get the submissions for a given blog

Post Methods

Creating posts

PyTumblr lets you create all of the various types that Tumblr supports. When using these types there are a few defaults that are able to be used with any post type.

The default supported types are described below.

  • state - a string, the state of the post. Supported types are published, draft, queue, private
  • tags - a list, a list of strings that you want tagged on the post. eg: ["testing", "magic", "1"]
  • tweet - a string, the string of the customized tweet you want. eg: "Man I love my mega awesome post!"
  • date - a string, the customized GMT that you want
  • format - a string, the format that your post is in. Support types are html or markdown
  • slug - a string, the slug for the url of the post you want

We'll show examples throughout of these default examples while showcasing all the specific post types.

Creating a photo post

Creating a photo post supports a bunch of different options plus the described default options * caption - a string, the user supplied caption * link - a string, the "click-through" url for the photo * source - a string, the url for the photo you want to use (use this or the data parameter) * data - a list or string, a list of filepaths or a single file path for multipart file upload

#Creates a photo post using a source URL
client.create_photo(blogName, state="published", tags=["testing", "ok"],
                    source="https://68.media.tumblr.com/b965fbb2e501610a29d80ffb6fb3e1ad/tumblr_n55vdeTse11rn1906o1_500.jpg")

#Creates a photo post using a local filepath
client.create_photo(blogName, state="queue", tags=["testing", "ok"],
                    tweet="Woah this is an incredible sweet post [URL]",
                    data="/Users/johnb/path/to/my/image.jpg")

#Creates a photoset post using several local filepaths
client.create_photo(blogName, state="draft", tags=["jb is cool"], format="markdown",
                    data=["/Users/johnb/path/to/my/image.jpg", "/Users/johnb/Pictures/kittens.jpg"],
                    caption="## Mega sweet kittens")

Creating a text post

Creating a text post supports the same options as default and just a two other parameters * title - a string, the optional title for the post. Supports markdown or html * body - a string, the body of the of the post. Supports markdown or html

#Creating a text post
client.create_text(blogName, state="published", slug="testing-text-posts", title="Testing", body="testing1 2 3 4")

Creating a quote post

Creating a quote post supports the same options as default and two other parameter * quote - a string, the full text of the qote. Supports markdown or html * source - a string, the cited source. HTML supported

#Creating a quote post
client.create_quote(blogName, state="queue", quote="I am the Walrus", source="Ringo")

Creating a link post

  • title - a string, the title of post that you want. Supports HTML entities.
  • url - a string, the url that you want to create a link post for.
  • description - a string, the desciption of the link that you have
#Create a link post
client.create_link(blogName, title="I like to search things, you should too.", url="https://duckduckgo.com",
                   description="Search is pretty cool when a duck does it.")

Creating a chat post

Creating a chat post supports the same options as default and two other parameters * title - a string, the title of the chat post * conversation - a string, the text of the conversation/chat, with diablog labels (no html)

#Create a chat post
chat = """John: Testing can be fun!
Renee: Testing is tedious and so are you.
John: Aw.
"""
client.create_chat(blogName, title="Renee just doesn't understand.", conversation=chat, tags=["renee", "testing"])

Creating an audio post

Creating an audio post allows for all default options and a has 3 other parameters. The only thing to keep in mind while dealing with audio posts is to make sure that you use the external_url parameter or data. You cannot use both at the same time. * caption - a string, the caption for your post * external_url - a string, the url of the site that hosts the audio file * data - a string, the filepath of the audio file you want to upload to Tumblr

#Creating an audio file
client.create_audio(blogName, caption="Rock out.", data="/Users/johnb/Music/my/new/sweet/album.mp3")

#lets use soundcloud!
client.create_audio(blogName, caption="Mega rock out.", external_url="https://soundcloud.com/skrillex/sets/recess")

Creating a video post

Creating a video post allows for all default options and has three other options. Like the other post types, it has some restrictions. You cannot use the embed and data parameters at the same time. * caption - a string, the caption for your post * embed - a string, the HTML embed code for the video * data - a string, the path of the file you want to upload

#Creating an upload from YouTube
client.create_video(blogName, caption="Jon Snow. Mega ridiculous sword.",
                    embed="http://www.youtube.com/watch?v=40pUYLacrj4")

#Creating a video post from local file
client.create_video(blogName, caption="testing", data="/Users/johnb/testing/ok/blah.mov")

Editing a post

Updating a post requires you knowing what type a post you're updating. You'll be able to supply to the post any of the options given above for updates.

client.edit_post(blogName, id=post_id, type="text", title="Updated")
client.edit_post(blogName, id=post_id, type="photo", data="/Users/johnb/mega/awesome.jpg")

Reblogging a Post

Reblogging a post just requires knowing the post id and the reblog key, which is supplied in the JSON of any post object.

client.reblog(blogName, id=125356, reblog_key="reblog_key")

Deleting a post

Deleting just requires that you own the post and have the post id

client.delete_post(blogName, 123456) # Deletes your post :(

A note on tags: When passing tags, as params, please pass them as a list (not a comma-separated string):

client.create_text(blogName, tags=['hello', 'world'], ...)

Getting notes for a post

In order to get the notes for a post, you need to have the post id and the blog that it is on.

data = client.notes(blogName, id='123456')

The results include a timestamp you can use to make future calls.

data = client.notes(blogName, id='123456', before_timestamp=data["_links"]["next"]["query_params"]["before_timestamp"])

Tagged Methods

# get posts with a given tag
client.tagged(tag, **params)

Using the interactive console

This client comes with a nice interactive console to run you through the OAuth process, grab your tokens (and store them for future use).

You'll need pyyaml installed to run it, but then it's just:

$ python interactive-console.py

and away you go! Tokens are stored in ~/.tumblr and are also shared by other Tumblr API clients like the Ruby client.

Running tests

The tests (and coverage reports) are run with nose, like this:

python setup.py test

Author: tumblr
Source Code: https://github.com/tumblr/pytumblr
License: Apache-2.0 license

#python #api 

Techno Loader

Techno Loader

1611739021

DeFi Exchange Development - Create Your Own DeFi Crypto Exchange

Decentralized Finance has emerged as a groundbreaking solution that provides a high level of efficiency and transparency to every business. Moreover, implementing this blockchain-based mechanism has now become very easy with the help of rapidly increasing DeFi exchange development globally. In this article, we will explore different aspects of this technology and will try to tell its benefits in as many details as possible. So let us start with the very basic question.

Want to develop DeFi Cryptocurrency Exchange Platform? Call/Whatsapp +917014607737 | Skype : technoloader | Email: info@technoloader.com

What do you mean by a DeFi exchange?

If you are familiar with the term ‘exchange’ and its working, then you just have to be familiar with the other word. The concept of decentralized finance aka DeFi introduces you to a unique financial modus operandi.

If you have already assumed that the ambit of this solution is limited to your transactions, then you are absolutely wrong. It actually goes beyond that helps you optimize every single aspect of your enterprise.

But when we combine this pioneering framework with an exchange, things become very specific in relation to trading. The decentralized method brings matchless transparency in every transaction and it helps you get better insights about the markets as well.

When you trade cryptos, you require a more reliable system for buying and selling a digital asset. With this particular mechanism, it becomes possible for you to delve deeper into blockchain and extract the benefits.

How does my business get benefits from a DeFi exchange?

If you have been thinking about launching your own business, then you already know that a large number of entrepreneurs have developed a propensity towards this niche. A crypto exchange can help you buy and sell cryptos either on a centralized or a decentralized structure.

The defi variant takes this to a level ahead, it allows you to trade over a system that is decentralized to the core. With this framework, you can make the exchange of tokens more efficient than ever.

By launching a DeFi exchange, you offer much better options to the increasing fold of crypto holders. Moreover, you allow the traders to explore a different space without putting their assets at risk. This structure helps you get one step ahead on every front, it enables you to strategize every move while removing the technical frailties.

Once you become familiar with this domain, you get better functionality and deliver some great results to the frequent exchanging of digital tokens.

Here are some notable benefits that a DeFi exchange delivers:

• It enables the traders to place the transactions in a 100% decentralized environment.
• It eradicates all the intermediaries and reduces or nullifies the charges over transactions.
• It gives a well-structured system to settle the purchases and selling of any token.
• The nodes and the algorithm ensures that there are absolutely no flaws at any step.
• Along with the blockchain, you get benefits from the other decentralized solutions as well.
• The level of transparency is unmatched and you get to enhance it on many fronts.
• There is absolutely no defect in the transaction and the entire structure ensures that.
• No matter how many transactions you have to execute, the results are always accurate.
• Besides the volume, the quality of the transactions also remains immaculate with many high-end features.
• By implementing this system, you get a high level of efficacy that reaches every single user.

Why should I take a risk of starting a DeFi exchange?

You should ask this question before putting your money in any business and a DeFi exchange makes no difference. Though we will tell you the reasons but keep in mind, no other explanation can convince you better than your own research.

Since the advent of Bitcoin, the number of crypto users has been rising and recently, the original crypto hit the highest price ever. All these events indicate that cryptocurrency will soon become a mainstream solution.

The crypto trading market is already gaining lots of traction and it will only get better with time. Thus, we can say that the future of a DeFi exchange that delivers much better services is certainly very bright. You might think that there must be a large number of entrepreneurs who are planning the same and the competition might cause a failure as well.

If you look at the increasing number of crypto users, you will not be very frightened about the future of any crypto-based venture.

How should I hire developers for creating a tailor-made DeFi exchange?

Needless to mention, you will have to work with experts who have already built exemplary applications using this technology. You need to understand that the platform has to be very user-friendly and intuitive. Just introducing an exchange using new technology is not enough, you also need to make sure that the true benefits are made accessible to the users. That is only possible when you pay heed to the overall structure and emphasize the user-experience.

When you hire developers for your exchange, you need to choose the well-versed professionals who have the know-how to deliver the kind of results you require. This is made possible by monitoring the entire recruitment process and ensuring that you handpick the most talented professionals.

You also have to be wiser and pick people who don’t have to be necessarily best but those who are appropriately trained. Then only, you can save yourself from splurging money and get precisely what you require.

Upshot

With Technoloader, you can have excellent DeFi exchange development solutions that will play a pivotal role in the growth of your enterprise. Our developers give you a custom-built program that materializes your vision and gives you much more than you expect.

We work on every project after doing a thorough research and ensure that your requirements are met. To make this possible, we are ready to go to any extent and always end up satisfying our valued clients. Our services and products provide you a firm base and let your startup become a successful venture.

Do you want to know the feasibility of the DeFi exchange for your business? Chat right now!

Skype : technoloader
Email Id : info@technoloader.com
Telegram : @vipinshar
Phone : +917014607737

#defi exchange development #defi #cryptocurrency #exchange

Eva Watson

Eva Watson

1614930110

Cryptocurrency Exchange Development Company | Create Crypto Exchange | Antier Solutions

The cross-functional and cohesive team of Antier Solutions incorporates a technology-agnostic approach and modern agile methodology to deliver cryptocurrency exchange platform development services. The company emphasizes on diligent integration of world-class features in terms of security, UI/UX, functionality, and scalability on a single platform to deliver meaningful outcomes that provide an essential competitive edge. Our profound team of blockchain experts aligns forward-thinking solutions with a coherent roadmap to accelerate deployment. Antier fortifies crypto exchange development with its top-notch marketing techniques to nurture your venture and prepare it for long-term success.

For more information, call us: +91 98550 78699 (India), +1 (315) 825 4466 (US)

#cryptocurrency exchange development company #white label crypto exchange software #buy crypto exchange software #cryptocurrency exchange platform #cryptocurrency exchange software #starting a crypto exchange

aviana farren

aviana farren

1623742835

How To Overcome The Challenges Involved In Cryptocurrency Exchange Development?

Creating their own cryptocurrency exchange has become a common phenomenon among entrepreneurs in the cryptosphere in recent years. Cryptocurrency exchanges are the main driving force behind the crypto market volume growth over the past decade, and they have provided lucrative opportunities for many entrepreneurs around the world. Many entrepreneurs have become millionaires by launching their own cryptocurrency exchange, which is why the demand and competition around crypto exchanges have drastically increased in the last few years.

Even though starting your own cryptocurrency exchange is lucrative, there are also many challenges involved in the cryptocurrency exchange development process. Especially in this intensely competitive scenario, every aspect of your cryptocurrency exchange development plays a crucial role in determining the success and visibility of your exchange over your competitors. To ensure long-term sustainability and success for your exchange, it is essential that you identify the pain points involved with crypto exchange development, and learn how to convert the odds into your favor. So, let’s go ahead and take a look at some of the significant challenges involved in developing an exchange from scratch, and solutions that will help to overcome them.

Read More @ https://bit.ly/3vpK64S

#creating their own cryptocurrency exchange #cryptocurrency exchanges #cryptocurrency exchange development #cryptocurrency exchange development process #cryptocurrency exchange software development #crypto exchange software solutions

Shubham Ankit

Shubham Ankit

1657081614

How to Automate Excel with Python | Python Excel Tutorial (OpenPyXL)

How to Automate Excel with Python

In this article, We will show how we can use python to automate Excel . A useful Python library is Openpyxl which we will learn to do Excel Automation

What is OPENPYXL

Openpyxl is a Python library that is used to read from an Excel file or write to an Excel file. Data scientists use Openpyxl for data analysis, data copying, data mining, drawing charts, styling sheets, adding formulas, and more.

Workbook: A spreadsheet is represented as a workbook in openpyxl. A workbook consists of one or more sheets.

Sheet: A sheet is a single page composed of cells for organizing data.

Cell: The intersection of a row and a column is called a cell. Usually represented by A1, B5, etc.

Row: A row is a horizontal line represented by a number (1,2, etc.).

Column: A column is a vertical line represented by a capital letter (A, B, etc.).

Openpyxl can be installed using the pip command and it is recommended to install it in a virtual environment.

pip install openpyxl

CREATE A NEW WORKBOOK

We start by creating a new spreadsheet, which is called a workbook in Openpyxl. We import the workbook module from Openpyxl and use the function Workbook() which creates a new workbook.

from openpyxl
import Workbook
#creates a new workbook
wb = Workbook()
#Gets the first active worksheet
ws = wb.active
#creating new worksheets by using the create_sheet method

ws1 = wb.create_sheet("sheet1", 0) #inserts at first position
ws2 = wb.create_sheet("sheet2") #inserts at last position
ws3 = wb.create_sheet("sheet3", -1) #inserts at penultimate position

#Renaming the sheet
ws.title = "Example"

#save the workbook
wb.save(filename = "example.xlsx")

READING DATA FROM WORKBOOK

We load the file using the function load_Workbook() which takes the filename as an argument. The file must be saved in the same working directory.

#loading a workbook
wb = openpyxl.load_workbook("example.xlsx")

 

GETTING SHEETS FROM THE LOADED WORKBOOK

 

#getting sheet names
wb.sheetnames
result = ['sheet1', 'Sheet', 'sheet3', 'sheet2']

#getting a particular sheet
sheet1 = wb["sheet2"]

#getting sheet title
sheet1.title
result = 'sheet2'

#Getting the active sheet
sheetactive = wb.active
result = 'sheet1'

 

ACCESSING CELLS AND CELL VALUES

 

#get a cell from the sheet
sheet1["A1"] <
  Cell 'Sheet1'.A1 >

  #get the cell value
ws["A1"].value 'Segment'

#accessing cell using row and column and assigning a value
d = ws.cell(row = 4, column = 2, value = 10)
d.value
10

 

ITERATING THROUGH ROWS AND COLUMNS

 

#looping through each row and column
for x in range(1, 5):
  for y in range(1, 5):
  print(x, y, ws.cell(row = x, column = y)
    .value)

#getting the highest row number
ws.max_row
701

#getting the highest column number
ws.max_column
19

There are two functions for iterating through rows and columns.

Iter_rows() => returns the rows
Iter_cols() => returns the columns {
  min_row = 4, max_row = 5, min_col = 2, max_col = 5
} => This can be used to set the boundaries
for any iteration.

Example:

#iterating rows
for row in ws.iter_rows(min_row = 2, max_col = 3, max_row = 3):
  for cell in row:
  print(cell) <
  Cell 'Sheet1'.A2 >
  <
  Cell 'Sheet1'.B2 >
  <
  Cell 'Sheet1'.C2 >
  <
  Cell 'Sheet1'.A3 >
  <
  Cell 'Sheet1'.B3 >
  <
  Cell 'Sheet1'.C3 >

  #iterating columns
for col in ws.iter_cols(min_row = 2, max_col = 3, max_row = 3):
  for cell in col:
  print(cell) <
  Cell 'Sheet1'.A2 >
  <
  Cell 'Sheet1'.A3 >
  <
  Cell 'Sheet1'.B2 >
  <
  Cell 'Sheet1'.B3 >
  <
  Cell 'Sheet1'.C2 >
  <
  Cell 'Sheet1'.C3 >

To get all the rows of the worksheet we use the method worksheet.rows and to get all the columns of the worksheet we use the method worksheet.columns. Similarly, to iterate only through the values we use the method worksheet.values.


Example:

for row in ws.values:
  for value in row:
  print(value)

 

WRITING DATA TO AN EXCEL FILE

Writing to a workbook can be done in many ways such as adding a formula, adding charts, images, updating cell values, inserting rows and columns, etc… We will discuss each of these with an example.

 

CREATING AND SAVING A NEW WORKBOOK

 

#creates a new workbook
wb = openpyxl.Workbook()

#saving the workbook
wb.save("new.xlsx")

 

ADDING AND REMOVING SHEETS

 

#creating a new sheet
ws1 = wb.create_sheet(title = "sheet 2")

#creating a new sheet at index 0
ws2 = wb.create_sheet(index = 0, title = "sheet 0")

#checking the sheet names
wb.sheetnames['sheet 0', 'Sheet', 'sheet 2']

#deleting a sheet
del wb['sheet 0']

#checking sheetnames
wb.sheetnames['Sheet', 'sheet 2']

 

ADDING CELL VALUES

 

#checking the sheet value
ws['B2'].value
null

#adding value to cell
ws['B2'] = 367

#checking value
ws['B2'].value
367

 

ADDING FORMULAS

 

We often require formulas to be included in our Excel datasheet. We can easily add formulas using the Openpyxl module just like you add values to a cell.
 

For example:

import openpyxl
from openpyxl
import Workbook

wb = openpyxl.load_workbook("new1.xlsx")
ws = wb['Sheet']

ws['A9'] = '=SUM(A2:A8)'

wb.save("new2.xlsx")

The above program will add the formula (=SUM(A2:A8)) in cell A9. The result will be as below.

image

 

MERGE/UNMERGE CELLS

Two or more cells can be merged to a rectangular area using the method merge_cells(), and similarly, they can be unmerged using the method unmerge_cells().

For example:
Merge cells

#merge cells B2 to C9
ws.merge_cells('B2:C9')
ws['B2'] = "Merged cells"

Adding the above code to the previous example will merge cells as below.

image

UNMERGE CELLS

 

#unmerge cells B2 to C9
ws.unmerge_cells('B2:C9')

The above code will unmerge cells from B2 to C9.

INSERTING AN IMAGE

To insert an image we import the image function from the module openpyxl.drawing.image. We then load our image and add it to the cell as shown in the below example.

Example:

import openpyxl
from openpyxl
import Workbook
from openpyxl.drawing.image
import Image

wb = openpyxl.load_workbook("new1.xlsx")
ws = wb['Sheet']
#loading the image(should be in same folder)
img = Image('logo.png')
ws['A1'] = "Adding image"
#adjusting size
img.height = 130
img.width = 200
#adding img to cell A3

ws.add_image(img, 'A3')

wb.save("new2.xlsx")

Result:

image

CREATING CHARTS

Charts are essential to show a visualization of data. We can create charts from Excel data using the Openpyxl module chart. Different forms of charts such as line charts, bar charts, 3D line charts, etc., can be created. We need to create a reference that contains the data to be used for the chart, which is nothing but a selection of cells (rows and columns). I am using sample data to create a 3D bar chart in the below example:

Example

import openpyxl
from openpyxl
import Workbook
from openpyxl.chart
import BarChart3D, Reference, series

wb = openpyxl.load_workbook("example.xlsx")
ws = wb.active

values = Reference(ws, min_col = 3, min_row = 2, max_col = 3, max_row = 40)
chart = BarChart3D()
chart.add_data(values)
ws.add_chart(chart, "E3")
wb.save("MyChart.xlsx")

Result
image


How to Automate Excel with Python with Video Tutorial

Welcome to another video! In this video, We will cover how we can use python to automate Excel. I'll be going over everything from creating workbooks to accessing individual cells and stylizing cells. There is a ton of things that you can do with Excel but I'll just be covering the core/base things in OpenPyXl.

⭐️ Timestamps ⭐️
00:00 | Introduction
02:14 | Installing openpyxl
03:19 | Testing Installation
04:25 | Loading an Existing Workbook
06:46 | Accessing Worksheets
07:37 | Accessing Cell Values
08:58 | Saving Workbooks
09:52 | Creating, Listing and Changing Sheets
11:50 | Creating a New Workbook
12:39 | Adding/Appending Rows
14:26 | Accessing Multiple Cells
20:46 | Merging Cells
22:27 | Inserting and Deleting Rows
23:35 | Inserting and Deleting Columns
24:48 | Copying and Moving Cells
26:06 | Practical Example, Formulas & Cell Styling

📄 Resources 📄
OpenPyXL Docs: https://openpyxl.readthedocs.io/en/stable/ 
Code Written in This Tutorial: https://github.com/techwithtim/ExcelPythonTutorial 
Subscribe: https://www.youtube.com/c/TechWithTim/featured 

#python