Menu
View Categories

Python Integration

Convert an Excel Range into a juypter NoteBook #

Use this feature to create a Jupyter notebook from your selected cell range. When you click the button, a notebook is generated in your workbook’s directory, containing the code to load the selected Excel range directly into a Pandas DataFrame. The code specifies the workbook path, sheet name, columns, and rows, as well as how many rows to skip or include.

There are also additional settings available (see image below):

  • Copy Python Code: Copy the generated Python code to your clipboard instead of creating a Jupyter notebook. Useful if you already have a Python file or Jupyter notebook.
  • Use Absolute Path: Choose to use an absolute file path instead of a relative one.
  • Ignore Row Parsing: This option is helpful if you expect new data to be added to your Excel file, as it will automatically expand to include the last row/cell.
  • Change DataFrame Name: Set a custom name for your DataFrame variable (default is “df”).

Python Settings

DEMO VIDEO:


Convert an Excel Range into Pandas DataFrame #

Use this feature to convert a selected Excel range into a Pandas DataFrame. When you click the button, a Python file (with the current workbook’s name) is generated in your workbook’s directory. The Python file contains code to load the selected Excel range directly into a Pandas DataFrame. It includes the workbook path, sheet name, columns, and rows, as well as how many rows to skip or include.

There are also additional settings available (see image below):

  • Copy Python Code: Copy the generated Python code to your clipboard instead of saving it to a Python file. Useful if you want to integrate it into an existing Python script.
  • Use Absolute Path: Choose to use an absolute file path instead of a relative one.
  • Ignore Row Parsing: This option is helpful if you expect more data to be added, as it will automatically expand to include the last row/cell.
  • Change DataFrame Name: Set a custom name for your DataFrame variable (default is “df”).

Python Settings

DEMO VIDEO:


Create XLWings Python File #

Use this feature to generate a Python file from your selected cell range. When you click “Create Xlwings Template,” a Python file is created in the workbook’s directory. The file contains boilerplate code to access the selected range using xlwings, which is ideal for automating tasks in Excel. Almost all VBA features are available in xlwings, as it uses the same Win32 COM API.

Check out the xlwings documentation for more details on its capabilities and how to use it.


Run Python Files From Excel #

Use this feature to execute Python files directly from Excel. This is useful if you want to trigger Python automation or run any kind of Python script right from your workbook.

For a detailed walkthrough, check out the video: