how to unprotect the password protected Excel file using Jxl

import java.io.File;

import java.io.IOException;

import jxl.Workbook;

import jxl.read.biff.BiffException;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import jxl.write.WriteException;

public class JExcelApiTest

{

public static void main(String[] args)

{

try

{

Workbook workbook = Workbook.

getWorkbook(new File("/path/to/protected.xls"));

WritableWorkbook copy = Workbook.

createWorkbook(new File("/path/to/unprotected.xls"), workbook);

WritableSheet[] sheets = copy.getSheets();

for (WritableSheet sheet : sheets)

{

sheet.getSettings().setProtected(false);

}

copy.write();

copy.close();

}

catch (BiffException e)

{

e.printStackTrace();

}

catch (IOException e)

{

e.printStackTrace();

}

catch (WriteException e)

{

e.printStackTrace();

}

}

}

Hope this helps

AbiSSa at 2007-7-9 20:40:50 >