Open in app

Sign In

Write

Sign In

Scriptopia
Scriptopia

54 Followers

Home

About

1 day ago

Python openpyxl — Change font size

Python script that will change the font size of a cell within an Excel spreadsheet using the openpyxl library. Openpyxl is a library that allows us to interact with Excel files in Python. It provides a range of tools for reading, writing, manipulating, and formatting Excel data. This makes it…

Python

1 min read

Python openpyxl — Change font size
Python openpyxl — Change font size
Python

1 min read


5 days ago

Python openpyxl — Add dashed border to cell in spreadsheet

Python script that will add a dashed border to a cell within a spreadsheet using openpyxl. Openpyxl is a library that allows us to interact with Excel files in Python. This makes it a useful tool for data analysis and reporting tasks. If you find this sample of code useful please be sure to subscribe to our YouTube channel for daily coding content.

Programming

1 min read

Python openpyxl — Add dashed border to cell in spreadsheet
Python openpyxl — Add dashed border to cell in spreadsheet
Programming

1 min read


5 days ago

Python openpyxl — Add colored border to cell in spreadsheet

Python script that will add a colored border to a cell within a spreadsheet using openpyxl. Openpyxl is a library that allows us to interact with Excel files in Python. It provides a range of tools for reading, writing, manipulating, and formatting Excel data. This makes it a useful tool for data analysis and reporting tasks. If you found this useful please support us by subscribing to our YouTube channel for daily coding content.

Code

1 min read

Python openpyxl — Add colored border to cell in spreadsheet
Python openpyxl — Add colored border to cell in spreadsheet
Code

1 min read


Mar 21

Python openpyxl — Double accounting underline cells

Python script that will apply a double accounting underline to a cell within an existing Excel spreadsheet using the openpyxl library. Openpyxl is a library that allows us to interact with Excel files in Python. It provides a range of tools for reading, writing, manipulating, and formatting Excel data. This makes it a useful tool for data analysis and reporting tasks. If you found this of use to you, please subscribe to our YouTube channel for daily coding content.

Code

1 min read

Python openpyxl — Double accounting underline cells
Python openpyxl — Double accounting underline cells
Code

1 min read


Mar 21

Python openpyxl — Single accounting underline cells

Python script that will apply a single accounting underline to a cell within an existing Excel spreadsheet using the openpyxl library. Openpyxl is a library that allows us to interact with Excel files in Python. It provides a range of tools for reading, writing, manipulating, and formatting Excel data. This makes it a useful tool for data analysis and reporting tasks. If you found this useful please subscribe to our YouTube channel for daily coding content.

Python

1 min read

Python openpyxl — Single accounting underline cells
Python openpyxl — Single accounting underline cells
Python

1 min read


Mar 13

Python openpyxl — Center align columns in spreadsheet

Python script that will center align an entire column within an existing Excel spreadsheet using the openpyxl library. Openpyxl is a library that allows us to interact with Excel files in Python. It provides a range of tools for reading, writing, manipulating, and formatting Excel data. This makes it a useful tool for data analysis and reporting tasks. See the example below where we center align all cells within column ‘A’. If you found this post useful be sure to subscribe to our YouTube channel for daily coding content.

Code

1 min read

Python openpyxl — Center align columns in spreadsheet
Python openpyxl — Center align columns in spreadsheet
Code

1 min read


Mar 13

Python Binance — Get price percentage change

Python script that will retrieve the 24 hour price percentage change for all trading pairs using the Binance API. To do this we will be using the requests library which allows Python code to send HTTP requests and receive HTTP responses via the Binance API. See below where print the symbol of the trading pair on the Binance exchange as well as the 24 hour percentage change to output. Also be sure to support us by subscribing to our YouTube channel for daily coding content.

Programming

1 min read

Python Binance — Get price percentage change
Python Binance — Get price percentage change
Programming

1 min read


Mar 10

Python openpyxl — Read data from spreadsheet

Python script that will read cell data within an existing Excel spreadsheet using the openpyxl library. Openpyxl is a library that allows us to interact with Excel files in Python. It provides a range of tools for reading, writing, manipulating, and formatting Excel data. This makes it a useful tool for data analysis and reporting tasks. In the above example we retrieve the values in cells A5 and B5 and assign them to ourname and role variables respectively. An image of our spreadsheet can be seen below. If you found this post useful please be sure to subscribe to our YouTube channel for daily coding content.

Code

1 min read

Python openpyxl — Read data from spreadsheet
Python openpyxl — Read data from spreadsheet
Code

1 min read


Mar 10

Python openpyxl — Change font to italic

Python script that will change font to italic within an existing Excel spreadsheet using the openpyxl library. Openpyxl is a library that allows us to interact with Excel files in Python. It provides a range of tools for reading, writing, manipulating, and formatting Excel data. This makes it a useful tool for data analysis and reporting tasks. See the example below where we change the font to italic for cell ‘A1’ within our existing spreadsheet. If you found this useful be sure to subscribe to our YouTube channel for daily coding content.

Programming

1 min read

Python openpyxl — Change font to italic
Python openpyxl — Change font to italic
Programming

1 min read


Mar 9

Python openpyxl — Change font to bold

Python script that will change font to bold within an existing Excel spreadsheet using the openpyxl library. Openpyxl is a library that allows us to interact with Excel files in Python. It provides a range of tools for reading, writing, manipulating, and formatting Excel data. See the example below where we set the cell ‘A1’ within our existing spreadsheet to bold font. Be sure to support us by subscribing to our YouTube channel for daily coding content.

Excel

1 min read

Python openpyxl — Change font to bold
Python openpyxl — Change font to bold
Excel

1 min read

Scriptopia

Scriptopia

54 Followers

Programming - Projects - Source Code available for everything - Scriptopia.co.uk

Following
  • Michael Rhodes

    Michael Rhodes

  • nancy

    nancy

  • Hapijur Rahaman

    Hapijur Rahaman

  • Ed-iT

    Ed-iT

  • EddyevonAnonymous

    EddyevonAnonymous

See all (513)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech