本文主要功能是将Mongo数据库中的数据导入Excel文件。
1、导入依赖包
mongodb-driver-3.4.2.jar
mongodb-driver-core-3.4.2.jar
bson-3.4.2.jar
poi-3.10.1-20140818.jar
2、直接上代码
public class MongoToExcel {
private static Integer PORT = 27017; //端口号
private static String IP = "localhost"; //IP
private static String DATABASE = "database"; //数据库名
private static String USERNAME = "username"; //用户名
private static String PASSWORD = "password"; //密码
private static String COLLECTION = "test"; //文档
private static String ADDRESS = "d:\\workbook.x