copy workbook(xls) using xls

[Rahul Dhaware]

if workbook1 contains pattern in some cell then in the copy workBook that pattern is getting copied
but pattern color is not getting copied.

Please see the code below.

File file = new File("C:\\New Microsoft Excel Worksheet.xls");
File file2 = new File("C:\\test1.xls");
Workbook workbook1 = Workbook.getWorkbook(file);
WritableWorkbook copy = Workbook.createWorkbook(file2, workbook1);

Please help me.

[Rob Spoor]

Which library are you using? I don't recognize class Workbook, and I think there are not a lot of people who do.

[Bauke Scholtz]

Rob Prime wrote:Which library are you using? I don't recognize class Workbook, and I think there are not a lot of people who do.

Apache POI HSSF: http://poi.apache.org/apidocs/org/apache/poi/hssf/model/Workbook.html

Which is one of the most commonly used Java API´s for Excel though.

[Rob Spoor]

I always used the usermodel subpackage, not the model. That one includes HSSFWorkbook, so that's why I didn't recognize it.

I think the Other Open Source Software forum will get some more reponse.

[Rahul Dhaware]

I am using jxl lib files.