将excel中的若干列数据生成json格式文件

本博客的主要目的是想通过java语言实现多列数据生成json文件

比如我们现有一个excel文件如下（总共34个省份）

三列数据分别代表省份、经度和纬度，现在想生成如下json格式文件

{"name":"浙江省","lng":"120.04928840814","lat":"29.1697631465"}, {"name":"云南省","lng":"101.48578795595","lat":"24.97521852424"}, {"name":"新疆省","lng":"85.20935642655","lat":"41.11846529068"}, {"name":"香港特别行政区","lng":"114.18815498416","lat":"22.33584826665"}, {"name":"西藏自治区","lng":"88.43682786652","lat":"31.49085987835"}, {"name":"台湾","lng":"120.96642604742","lat":"23.75280834117"}, {"name":"四川省","lng":"102.709686253","lat":"30.617160589"}, {"name":"陕西省","lng":"108.86979596095","lat":"35.1913117294"}, {"name":"山西省","lng":"112.2908364953","lat":"37.57419650609"}, {"name":"山东省","lng":"118.14820982521","lat":"36.33932299435"}, {"name":"青海省","lng":"95.99534761516","lat":"35.74497433619"}, {"name":"宁夏回族自治区","lng":"106.1655673523","lat":"37.27418252583"}, {"name":"内蒙古自治区","lng":"113.94844248167","lat":"44.09549677872"}, {"name":"辽宁省","lng":"122.61050671674","lat":"41.2994293423"}

具体步骤为：

1:首先安装配置eclipse,在此不再过多叙述,可以问度娘； 2:下载poi.jar,在eclipse中引用，具体链接https://www.apache.org/dyn/closer.lua/poi/dev/bin/poi-bin-3.17-beta1-20170701.tar.gz 只需要压缩包中的poi-3.17-beta1.jar；

3：具体实现代码如下，其中建立一个二维数据用于存储经纬度，一个一维数据用于存储省名：

package readExcel; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; public class readExcel_kml { public static double[][] array1=new double[34][3]; public static String[] array2=new String[34]; public static void main(String[] args) throws FileNotFoundException, IOException { String file="E:\java.jar\province.xls"; new readExcel_kml().return_array(file); new readExcel_kml().return_array2(file); for(int i=0;i<34;i++){ System.out.println( "{"+"""+"name"+"""+":"+"""+array2[i]+"""+","+"""+"lng"+"""+":"+"""+array1[i] [1]+"""+","+"""+"lat"+"""+":"+"""+array1[i][2]+"""+"}"+"," ); } } public double[][] return_array(String file) throws IOException, FileNotFoundException { HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(file)); HSSFSheet sheet=workbook.getSheet("province"); int rows=sheet.getPhysicalNumberOfRows(); //得到所有有数据的行 for(int i=0;i<rows;i++){ HSSFRow row=sheet.getRow(i); if(row != null){ int cells=row.getPhysicalNumberOfCells(); for(int j=1;j<cells;j++){ HSSFCell cell=row.getCell(j); double cell_out=(double)cell.getNumericCellValue(); array1[i][j]=cell_out; } } } return array1; } public String[] return_array2(String file) throws IOException, FileNotFoundException { HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(file)); HSSFSheet sheet=workbook.getSheet("province"); int rows=sheet.getPhysicalNumberOfRows(); for(int i=0;i<rows;i++){ HSSFRow row=sheet.getRow(i); if(row != null){ int cells=row.getPhysicalNumberOfCells(); for(int j=0;j<cells-2;j++){ HSSFCell cell=row.getCell(j); String cell_out=(String)cell.getStringCellValue(); array2[i]=cell_out; } } } return array2; } }