java解析excel文件为txt文件

java解析excel文件，并将其以建松格式保存到txt文件中。
1、maven配置

<!-- poi-->
<dependency>
   <groupId>org.apache.poi</groupId>
   <artifactId>poi</artifactId>
   <version>3.9</version>
</dependency>

<!-- jsckson -->
<dependency>
    <groupId>com.fasterxml.jackson.core</groupId>
    <artifactId>jackson-core</artifactId>
    <version>2.6.6</version>
</dependency>
<dependency>
    <groupId>com.fasterxml.jackson.core</groupId>
    <artifactId>jackson-databind</artifactId>
    <version>2.2.2</version>
</dependency>

2、java代码实现

import com.fasterxml.jackson.annotation.JsonInclude;
import com.fasterxml.jackson.databind.DeserializationFeature;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.databind.PropertyNamingStrategy;
import com.fasterxml.jackson.databind.SerializationFeature;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

import java.io.*;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.LinkedHashMap;
import java.util.Map;
import java.util.concurrent.ConcurrentLinkedQueue;

/**
 * Created by xxx on 2016/11/8.
 */
public class ExcelToTxt {

    private static Map<Integer, String> keyMapName = new LinkedHashMap<Integer, String>();
    private static Map<String, String> keyMapContext = new LinkedHashMap<String, String>();

    static ConcurrentLinkedQueue<String> queues = new ConcurrentLinkedQueue<String>();

    static ObjectMapper objectMapper = new ObjectMapper()
            .setSerializationInclusion(JsonInclude.Include.NON_EMPTY)
            .disable(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES)
            .disable(SerializationFeature.FAIL_ON_EMPTY_BEANS)
           .setPropertyNamingStrategy(PropertyNamingStrategy.CAMEL_CASE_TO_LOWER_CASE_WITH_UNDERSCORES);

    public static void main(String[] args){

        try {
            HSSFWorkbook wb = null;
            POIFSFileSystem fs = null;

            String filePath = "F:\\datafortag\\quan-2016-11-08.xls";
            fs = new POIFSFileSystem(new FileInputStream(new File(filePath)));
            wb = new HSSFWorkbook(fs);

            HSSFSheet sheet = wb.getSheetAt(0);
            Integer rowNum;
            HSSFRow rowName = sheet.getRow(0);
            for (int cellNum = rowName.getFirstCellNum(); cellNum < rowName.getLastCellNum(); cellNum++){
                keyMapName.put(cellNum, rowName.getCell(cellNum).getStringCellValue());
            }

            for(rowNum = 2; rowNum <= sheet.getLastRowNum(); rowNum++){
                HSSFRow row = sheet.getRow(rowNum);
                if(row != null){
                    for (int cellNum = row.getFirstCellNum(); cellNum< row.getLastCellNum(); cellNum++){
                        if(row.getCell(cellNum).getStringCellValue() != null && !"".equals(row.getCell(cellNum).getStringCellValue())) {
                            keyMapContext.put(keyMapName.get(cellNum), row.getCell(cellNum).getStringCellValue());
                        }
                    }
                }
                if(keyMapContext != null && keyMapContext.size() > 0) {
                    queues.add(objectMapper.writeValueAsString(keyMapContext));
                }
            }

            File file = new File("F:\\datafortag\\quan-2016-11-08.txt");
            FileOutputStream fileOutputStream = new FileOutputStream(file);
            OutputStreamWriter outputStream = new OutputStreamWriter(fileOutputStream);
            BufferedWriter bufferedWriter = new BufferedWriter(outputStream);

            int i = 0;
            while (true){
                if(!queues.isEmpty()) {
                    String context = queues.poll();
                    if(context == null) continue;
                    bufferedWriter.write(context);
                    bufferedWriter.newLine();
                    i++;
                    System.out.println("total ：" + i);
                }
                if(queues.isEmpty()){
                    try{
                        bufferedWriter.flush();
                        bufferedWriter.close();
                        outputStream.flush();
                        outputStream.close();
                        fileOutputStream.flush();
                        fileOutputStream.close();
                    }
                    catch (Exception e){
                        e.printStackTrace(System.out);
                    }
                    break;
                }
            }
        } catch (Exception e){

        }
    }
}