Manage data of Excel files

In Accessing Cells of a Worksheet, we discussed basic approaches for accessing cells in a worksheet. This article uses one of those approaches to add different types of data to cells.

How to Add Data to Cells

Aspose.Cells for Python via .NET provides a class, Workbook, that represents a Microsoft Excel file. The Workbook class contains a worksheets collection that allows access to each worksheet in the Excel file. A worksheet is represented by the Worksheet class. The Worksheet class provides a cells collection. Each item in the cells collection represents an object of the Cell class.

Aspose.Cells for Python via .NET allows developers to add data to the cells in worksheets by calling the Cell class' put_value method. Aspose.Cells for Python via .NET provides overloaded versions of the put_value method that let developers add different kinds of data to cells. Using these overloaded versions of the put_value method, it is possible to add a Boolean, string, double, integer or date/time, etc. value to a cell.

How to Improve Efficiency

If you use put_value method to put a large amount of data to a worksheet, you should add values to the cells first by rows, then by columns. This approach greatly improves the efficiency of your applications.

How to Retrieve Data from Cells

Aspose.Cells for Python via .NET provides a class, Workbook that represents a Microsoft Excel file. The Workbook class contains a worksheets collection that allows access to the worksheets in the file. A worksheet is represented by the Worksheet class. The Worksheet class provides a cells collection. Each item in the cells collection represents an object of the Cell class.

The Cell class provides several properties that allow developers to retrieve values from the cells according to their data types. These properties include:

• string_value: returns the string value of the cell.
• double_value: returns the double value of the cell.
• bool_value: returns the boolean value of the cell.
• date_time_value: returns the date/time value of the cell.
• float_value: returns the float value of the cell.
• int_value: returns the integer value of the cell.

When a field is not filled, cells with double_value or float_value throw an exception.

The type of data contained in a cell can also be checked by using the Cell class' type property. In fact, the Cell class' type property is based on the CellValueType enumeration whose pre‑defined values are listed below:

Cell Value Types	Description
IS_BOOL	Specifies that cell value is Boolean.
IS_DATE_TIME	Specifies that cell value is date/time.
IS_NULL	Represents a blank cell.
IS_NUMERIC	Specifies that cell value is numeric.
IS_STRING	Specifies that cell value is a string.
IS_ERROR	Specifies that cell value is an error value.
IS_UNKNOWN	Specifies that cell value is unknown.

You can also use the above pre‑defined cell value types to compare with the type of data present in each cell.

While working on worksheets, users may add different types of data in the cells. These data types may include Boolean, integer, floating point, text or date/time values. With Aspose.Cells for Python via .NET, you can get the appropriate values from the cells according to their data types.

Advanced topics

• Accessing Cells of a Worksheet
• Convert Text Numeric Data to Number
• Creating Subtotals
• Data Filtering
• Data Sorting
• Data Validation
• Get Cell String Value with and without Formatting
• Adding HTML Rich Text inside the Cell
• Find or Search Data
• Insert Hyperlinks into Excel or OpenOffice
• Measure the Width and Height of the Cell Value in Unit of Pixels
• Conversion between cell name and row/column index
• Populate Data First by Row then by Column
• Preserve Single Quote Prefix of Cell Value or Range
• Access and Update the Portions of Rich Text of Cell