How to copy excel file?

Question

I'm using this method to copy files . It works perfectly for all simple file types such as csv , txt , pdf etc . . . except xlsx. I don't know why Excel file doesn't want to be copied . It gets corrupted

public static void copyFileFromTo(File source, File dest)   {

    InputStream input = null;
    OutputStream output = null;

    try {
        input = new FileInputStream(source);
        output = new FileOutputStream(dest);
        byte[] buf = new byte[1024];
        int bytesRead;
        while ((bytesRead = input.read(buf)) > 0) {
        output.write(buf, 0, bytesRead); 
        }  
        input.close();
        output.close();
    }

    catch (IOException e) { 
    JOptionPane.showMessageDialog(null, e.getMessage() ); 
    System.exit(-1); 
 } 

}

score 3 · Accepted Answer · edited May 23 '17 at 12:14

Excel files are actually ZIP files (try opening in a compression program) - maybe that's the issue. I don't code in Java but I'd suggest looking for a ZIP copying routine - here's one I found on SO here: Best Way to copy a Zip File via Java

public final static int BUF_SIZE = 1024; //can be much bigger, see comment below


public static void copyFile(File in, File out) throws Exception {
  FileInputStream fis  = new FileInputStream(in);
  FileOutputStream fos = new FileOutputStream(out);
  try {
    byte[] buf = new byte[BUF_SIZE];
    int i = 0;
    while ((i = fis.read(buf)) != -1) {
        fos.write(buf, 0, i);
    }
  } 
  catch (Exception e) {
    throw e;
  }
  finally {
    if (fis != null) fis.close();
    if (fos != null) fos.close();
  }
}

Since that didn't work for you try this: http://docs.oracle.com/javase/7/docs/api/java/nio/file/Files.html#copy%28java.nio.file.Path,%20java.nio.file.Path,%20java.nio.file.CopyOption...%29

import java.io.IOException;
import java.nio.file.*;

public class Program {
    public static void main(String[] args) {

        FileSystem system = FileSystems.getDefault();
        Path original = system.getPath("C:\\programs\\my.xlsx");
        Path target = system.getPath("C:\\programs\\my2.xlsx");

        try {
            // Throws an exception if the original file is not found.
            Files.copy(original, target, StandardCopyOption.REPLACE_EXISTING);
        } catch (IOException ex) {
            System.out.println("ERROR");
        }
    }
}

Thank you. I didn't know excel was a zip. +1 :) But the method you posted above looks similar to what i posted in my question . it's not working either — john, Jul 17 '16 at 14:39
@john yep they are ZIP archives with XML files inside. See my updated post, maybe that second code segment will work for you. — Matt, Jul 17 '16 at 15:51
That method have a restion to java 7 and above . When compiling with a target for java 6 that woudl not work . Many machines still have java 6 . Mine too — john, Jul 17 '16 at 15:53
I tried to unzip an excel spreadsheet and it's beautiful ! Thank you for telling me it's a zip . I learned something today . I was imagining microsoft being more sophisticated and keeping data in some super secret format WOW ! — john, Jul 17 '16 at 15:56
Glad that helped - maybe you can use this `Apache commons IO` way to copy in Java 6: http://javarevisited.blogspot.com/2012/05/how-to-copy-file-in-java-program.html — Matt, Jul 17 '16 at 15:58

score 1 · Answer 2 · answered Jul 17 '16 at 18:19

i had this problem before you are copying more byte to new file more than the original size :

-----> if the original size is = 1050;

-----> the size of the new file is = 2048;

try this :

    public static void copyFileFromTo(File source, File dest)   {

        InputStream input = null;
        OutputStream output = null;

        try {
            int buf_size=1024;
            input = new FileInputStream(source);
            output = new FileOutputStream(dest);
            System.out.println("Size of the file :"+input.available()+" Byte");
            byte[] buf = new byte[buf_size];
            int bytesRead;
            while ((bytesRead = input.read(buf)) > 0 ) {
            output.write(buf, 0, bytesRead);
            if(input.available()<buf_size){
                System.out.println("Availble byte now is : "+input.available()+" so change the size of the array byte the to the same size");
                //if the available byte are <1024  you will copy  a array of 1024 to the file that cause domage to file
                buf= new byte[input.available()];
            }
            }                               
            input.close();
            output.close();
        }

        catch (IOException e) { 
        JOptionPane.showMessageDialog(null, e.getMessage() ); 
        System.exit(-1); 
     } 

}

How to copy excel file?

2 Answers2

Linked