Use different methods to obtain data according to different cell types. For example: if the type of cell is an array, use the getNumericCellValue() method to obtain the data in the cell; if the type of cell is a string, use the getStringCellValue() method to obtain the content in the cell. Then under normal circumstances, a row corresponds to a record in the database, that is, an entity. Then you can encapsulate the data you get into the entity, and then put the entity into the collection, so that you can get all the data in excel. data.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Use different methods to obtain data according to different cell types. For example: if the type of cell is an array, use the getNumericCellValue() method to obtain the data in the cell; if the type of cell is a string, use the getStringCellValue() method to obtain the content in the cell. Then under normal circumstances, a row corresponds to a record in the database, that is, an entity. Then you can encapsulate the data you get into the entity, and then put the entity into the collection, so that you can get all the data in excel. data.