Shulou(Shulou.com)06/02 Report--

This article mainly explains the "java Poi how to read the data in the excel file", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "java Poi how to read the data in the excel file" bar!

Poi reads the excel file. When excel has a function, poi directly reads the excel function and cannot return the result of the function calculation:

Resolution steps:

Sheet.setForceFormulaRecalculation (true)

Determine whether the column format is a function, and the calculation result can be obtained by directly getNumericCellValue () for the function.

Cell cell = row.getCell (gCellName); if (cell.getCellType () = = CellType.FORMULA) {double result = cell1.getNumericCellValue ();}

If the amount of excel data is small, the excel read time does not affect, when the amount of data is large, the read excel time will be a bit long.

Thank you for your reading, the above is the content of "how java Poi reads the data in the excel file". After the study of this article, I believe you have a deeper understanding of how java Poi reads the data in the excel file, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.