Excel Function : DECIMAL
Category
Math and trigonometry
Description
Converts a text representation of a number in a given base into a decimal number
Microsoft Excel Reference Page
https://support.office.com/en-us/article/DECIMAL-function-ee554665-6176-46ef-82de-0a283658da2e
Syntax and Description of the DECIMAL Excel Function
syntax in java
I am trying to use the Excel function DECIMAL in a Java program but I can't seem to get the syntax right.
This is what I am trying to do:
CellStyle cellStyle = workbook.createCellStyle();
DataFormat format = workbook.createDataFormat();
cellStyle.setDataFormat(format.getFormat("DECIMAL(16,10)"));
This is what I have tried:
CellStyle cellStyle = workbook.createCellStyle();
DataFormat format = workbook.createDataFormat();
cellStyle.setDataFormat(format.getFormat("DECIMAL<
About DECIMAL Excel Function
The DECIMAL function in Excel converts a binary number to a decimal number. This function is useful for working with numbers stored as text, such as those imported from a database.
