Convert Excel to Python Data

How to Convert Excel Workbook to Dictionary

Here’s an example code snippet to demonstrate how to export excel data to dictionary using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Traverse all worksheets and convert workbook to Dictionary using Aspose.Cells for Python Excel library.

The output result:

{'Sheet1': [['City', 'Region', 'Store'], ['Chicago', 'Central', 3055], ['New York', 'East', 3036], ['Detroit', 'Central', 3074]], 'Sheet2': [['City2', 'Region2', 'Store3'], ['Seattle', 'West', 3000], ['philadelph', 'East', 3082], ['Detroit', 'Central', 3074]], 'Sheet3': [['City3', 'Region3', 'Store3'], ['Seattle', 'West', 3166], ['New York', 'East', 3090], ['Chicago', 'Central', 3055]]}

How to Convert Excel Workbook to List

Here’s an example code snippet to demonstrate how to export excel data to list using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Traverse all worksheets and convert workbook to list using Aspose.Cells for Python Excel library.

The output result:

[[['City', 'Region', 'Store'], ['Chicago', 'Central', 3055], ['New York', 'East', 3036], ['Detroit', 'Central', 3074]], 
[['City2', 'Region2', 'Store3'], ['Seattle', 'West', 3000], ['philadelph', 'East', 3082], ['Detroit', 'Central', 3074]], [['City3', 'Region3', 'Store3'], ['Seattle', 'West', 3166], ['New York', 'East', 3090], ['Chicago', 'Central', 3055]]]

How to Convert Worksheet to List

Here’s an example code snippet to demonstrate how to export worksheet data to list using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Get the first worksheet.
  3. Convert worksheet data to list using Aspose.Cells for Python Excel library.

The output result:

[['City', 'Region', 'Store'], ['Chicago', 'Central', 3055], ['New York', 'East', 3036], ['Detroit', 'Central', 3074]]

How to Convert a ListObject of Excel to List

Here’s an example code snippet to demonstrate how to export ListObject data to list using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Get the first worksheet.
  3. Create ListObject object.
  4. Convert ListObject data to list using Aspose.Cells for Python Excel library.

The output result:

[['City', 'Region', 'Store'], ['Chicago', 'Central', 3055], ['New York', 'East', 3036], ['Detroit', 'Central', 3074]]

How to Convert a Row of Excel to List

Here’s an example code snippet to demonstrate how to export Row data to list using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Get the first worksheet.
  3. Get Row object by row index.
  4. Convert Row data to list using Aspose.Cells for Python Excel library.

The output result:

['Detroit', 'Central', 3074]

How to Convert a Column of Excel to List

Here’s an example code snippet to demonstrate how to export Column data to list using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Get the first worksheet.
  3. Get Column object by column index.
  4. Convert Column data to list using Aspose.Cells for Python Excel library.

The output result:

['Store', 3055, 3036, 3074]

How to Convert a Range of Excel to List

Here’s an example code snippet to demonstrate how to export range data to list using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Get the first worksheet.
  3. Create the Range.
  4. Convert Range data to list using Aspose.Cells for Python Excel library.

The output result:

[['Region', 'Store'], ['Central', 3055], ['East', 3036]]
Using Aspose.Cells for Python via .NET as a Pandas Excel Engine