java - 使用Java下载文件，没有api，奇怪的错误

Question

我正在尝试从 this 下载文件站点，通过单击 Excel 图标。通过右键单击该图标，我得到了粘贴到我的 java 程序中的链接，如下所示:

public static void main(String[] args){

    BufferedReader br;
    String thisLine="";
    String file="";
    try {
      // connect and download the file
      ReadableByteChannel rbc;
      file="test.xls";
      URL website = new URL("http://www.anaptyxi.gov.gr/DesktopModules" +
                "/AVMap.ErgaReports_v2/SearchHandler.ashx?lang=el-GR" +
                "&pageMode=3&searchValue=&searchField=&dateFrom=&dateTo=" +
                "&perioxesMode=2&selectedPerioxes[]=01_36_514&ergaType[]=1" +
                "&ergaType[]=2&ergaType[]=3&enisx=&kad=&company=&includePollaplhs=1" +
                "&export=xls");
      rbc = Channels.newChannel(website.openStream());

      FileOutputStream xls = new FileOutputStream(file);  
      xls.getChannel().transferFrom(rbc, 0, Long.MAX_VALUE);             
      xls.close();               
    } catch (FileNotFoundException e1) {
        // TODO Auto-generated catch block
        e1.printStackTrace();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }   
}

这会创建一个 Excel 文件，但它只包含字符串:

Error executing the request. Try limiting your criteria. Any ideas?

Answer 1

该网站可能正在检查 User-Agent header ，但没有响应，因为您使用的是 java。

这应该可以修复它:

   public static void main(String[] args){

   BufferedReader br;
   String thisLine="";
   String file="";
   try {
       //   connect and download the file
      ReadableByteChannel rbc;
      file="test.xls";
      // connect and download the file
      URL website = new URL("http://www.anaptyxi.gov.gr/DesktopModules" +
                        "/AVMap.ErgaReports_v2/SearchHandler.ashx?lang=el-GR" +
                        "&pageMode=3&searchValue=&searchField=&dateFrom=&dateTo=" +
                        "&perioxesMode=2&selectedPerioxes[]=01_36_514&ergaType[]=1" +
                        "&ergaType[]=2&ergaType[]=3&enisx=&kad=&company=&includePollaplhs=1" +
                        "&export=xls");

      // Adding request headers to mimic the browser
      URLConnection con = website.openConnection();
      con.addRequestProperty("Accept", "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8");
      con.addRequestProperty("User-Agent", "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.90 Safari/537.36");
      rbc = Channels.newChannel(con.getInputStream());  // !!!


      FileOutputStream xls = new FileOutputStream(file);  
      xls.getChannel().transferFrom(rbc, 0, Long.MAX_VALUE);             
      xls.close();               
    } catch (FileNotFoundException e1) {
        // TODO Auto-generated catch block
        e1.printStackTrace();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }