Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Get Cell String Value with and without Formatting
Contents
[
Hide
]
Aspose.Cells provides a method Cell.getStringValue() which can be used to get the string value of the cell with or without any formatting. Suppose you have a cell with value 0.012345 and you have formatted it to display two decimal places only. It will then display as 0.01 in Excel. You can retrieve string values both as 0.01 and as 0.012345 using the Cell.getStringValue() method. It takes CellValueFormatStrategy enum as a parameter which has the following values:
- CellValueFormatStrategy.CellStyle
- CellValueFormatStrategy.DisplayStyle
- CellValueFormatStrategy.DisplayString
- CellValueFormatStrategy.None
The following sample code explains the use of the Cell.getStringValue() method.