java - 双引号中的值在导出到 Excel 时不起作用

Question

在我用 java 编写的导出到 Excel 功能中，双引号中的值在下载的 Excel 中消失了。有没有解决这个问题的方法？

Answer 1

How you are trying to export the data into excel? please post?

Simple example with Apache POI-
{
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet("Test Export");
        Map<String, Object[]> data = new HashMap<String, Object[]>();
//cell value in double quotes  
        data.put("2", new Object[] {"1", "\"abc\""});
        data.put("3", new Object[] {"2", "\"xyz\""});
        Set<String> keyset = data.keySet();
        int rownum = 0;
        for (String key : keyset) {
            Row row = sheet.createRow(rownum++);
            Object [] objArr = data.get(key);
            int cellnum = 0;
            for (Object obj : objArr) {
                Cell cell = row.createCell(cellnum++);
                    cell.setCellValue((String)obj);
        }
        }
        try {
            FileOutputStream out =new FileOutputStream(new File("/home/rahul/Desktop/testExport.xls"));
            workbook.write(out);
            out.close();     
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
}