Scriptopia – Medium

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 a useful tool for data analysis and reporting tasks.

Python

1 min read

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…

Programming

1 min read

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…

Code

1 min read

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…

Code

1 min read

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…

Python

1 min read

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…

Code

1 min read

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…

Programming

1 min read

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…

Code

1 min read

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…

Programming

1 min read

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…

Excel

1 min read

Excel

1 min read