Java Apache POI打开文件？

问题描述

我有一个Java程序，它编辑一个现有的excel文件并将其保存为一个新的文件。但是，我也希望程序在结束时自动打开新创建的文件。有没有apache poi命令让我这样做？

解决方案

由于你没有提供代码，我使用的例子

让我们先创建Excel文件

  HSSFWorkbook工作簿=新HSSFWorkbook（）; 
 HSSFSheet sheet = workbook.createSheet（Sample sheet）; 
 
 Map< String，Object []> data = new HashMap< String，Object []>（）; 
 data.put（1，new Object [] {Emp No.，Name，Salary}）; 
 data.put（2，new Object [] {1d，John，1500000d}）; 
 data.put（3，new Object [] {2d，Sam，800000d}）; 
 data.put（4，new Object [] {3d，Dean，700000d}）; 
 
设置< 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 ++）; 
 if（obj instanceof Date）
 cell.setCellValue（（Date）obj）; 
 else if（obj instanceof Boolean）
 cell.setCellValue（（Boolean）obj）; 
 else if（obj instanceof String）
 cell.setCellValue（（String）obj）; 
 else if（obj instanceof Double）
 cell.setCellValue（（Double）obj）; 
} 
} 
 
 try {
 FileOutputStream out = new FileOutputStream（new File（D：\\\\
ew.xls））; 
 workbook.write（out）; 
 out.close（）; 
 System.out.println（Excel written successfully ..）; 
 
 / **从Java打开Excel文件** / 
 
 try {
 Desktop.getDesktop（）。open（new File（D：\\\ \
ew.xls））; 
} catch（IOException e）{
 // TODO自动生成的catch块
 e.printStackTrace（）; 
} 
 
} catch（FileNotFoundException e）{
 e.printStackTrace（）; 
} catch（IOException e）{
 e.printStackTrace（）; 
} 
  

输出

解决方案：将此代码使用正确的位置创建Excel后，尝试/抓取块，将自动打开

好的

尝试使用Desktop.open（）而不是Desktop.edit（）：

  Desktop dt = Desktop.getDesktop（）; 
 dt.open（new File（D：\\\\
ew.xls））; 
  

如果Desktop.open（）不可用，则可以使用Windows文件关联：

 进程p = Runtime.getRuntime（）.exec（rundll32 
 url.dll，FileProtocolHandler+D：\ \\\
ew.xls）; 
  

I have a Java program that edits an existing excel file and saves it as a new file. However, I would also like the program to automatically open the newly created file upon ending. Is there an apache poi command that lets me do this?

解决方案

As you have not Provided Code , I m using the Example of ViralPatel Tutorial

Lets Create Excel File First

HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet("Sample sheet");

    Map<String, Object[]> data = new HashMap<String, Object[]>();
    data.put("1", new Object[] { "Emp No.", "Name", "Salary" });
    data.put("2", new Object[] { 1d, "John", 1500000d });
    data.put("3", new Object[] { 2d, "Sam", 800000d });
    data.put("4", new Object[] { 3d, "Dean", 700000d });

    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++);
            if (obj instanceof Date)
                cell.setCellValue((Date) obj);
            else if (obj instanceof Boolean)
                cell.setCellValue((Boolean) obj);
            else if (obj instanceof String)
                cell.setCellValue((String) obj);
            else if (obj instanceof Double)
                cell.setCellValue((Double) obj);
        }
    }

    try {
        FileOutputStream out = new FileOutputStream(new File("D:\\new.xls"));
        workbook.write(out);
        out.close();
        System.out.println("Excel written successfully..");

        /** Opening Excel File From Java **/

        try {
            Desktop.getDesktop().open(new File("D:\\new.xls"));
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    } catch (FileNotFoundException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }

Output

Solution : Put this code with Try/Catch Block after You have created Excel with correct Location, It will be opened Automatically

Else u can invoke this as well

Try to use Desktop.open() instead of Desktop.edit() :

Desktop dt = Desktop.getDesktop();
dt.open(new File("D:\\new.xls"));

If Desktop.open() is not available then the Windows file association can be used :

 Process p =    Runtime.getRuntime()    .exec("rundll32
 url.dll,FileProtocolHandler " + "D:\\new.xls");

这篇关于Java Apache POI打开文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！