Working with Excel Sheets using java programming

Question

I got a small problem while working with a project.

I already have an excel file with some sheets in it.

Whenever I need to create a new excel file sheet with a particular name, I need to check if there's already a sheet with that name,

If it is so,

1.Then I need to delete it(thus deleting any old info),note the position of the sheet and create a new one with the same name at the same position

If not

1.Then i need to create a new sheet

I am stuck with it.Could anyone give some insights/some steps to accomplishing the task? Could I do the same with Apache POI or conveniently any other API?

Thanks in advance.I am supposed to use java as a medium while doing this.

i think usage of JExcel API would be right for this kind of requirement — Pavan Kumar K
– Pavan Kumar K, Commented May 30, 2013 at 5:56

Abdul · Accepted Answer · 2013-05-30 06:02:22Z

3

If you are using POI, you can get no. of sheets in xls file by workbook.getNumberOfSheets().

You can iterate over them using regular for loop and check sheet names, if name matches with sheet name, you can delete it using workbook.removeSheetAt(index). And now you can create new sheet with same name and at given index.

Hope this helps.

answered May 30, 2013 at 6:02

Abdul

515 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MaheshVarma · Accepted Answer · 2013-05-30 06:02:41Z

0

xlsx4j is something you may want to look at

click here for more info

answered May 30, 2013 at 6:02

MaheshVarma

2,1557 gold badges36 silver badges60 bronze badges

Comments

Pavan Kumar K · Accepted Answer · 2013-05-30 06:04:37Z

0

The folloiwng code from JExcelAPI should work....

InputStream inp = new FileInputStream("workbook.xls");
//InputStream inp = new FileInputStream("workbook.xlsx");

Workbook wb = WorkbookFactory.create(inp);
Sheet sheet = wb.getSheetAt("sheet_name");
if(sheet != null)
{
 wb.removeSheet(index);
 //further functionality
}
else
{
  //code if sheet does not exists
}

answered May 30, 2013 at 6:04

Pavan Kumar K

1,3849 silver badges15 bronze badges

Comments

mauretto · Accepted Answer · 2013-05-30 06:05:58Z

0

apache-poi could menage it.

Use: HSSFWorkbook.createSheet(sheetName) to create the new sheet. If it throws java.lang.IllegalArgumentException then it already exists, so you can find and delete it:

HSSFWorkbook.getSheetIndex(sheetName) to get index and HSSFWorkbook.removeSheetAt(index). Finally you can move your new sheet at desired position by: HSSFWorkbook.setSheetOrder(sheetName, position)

answered May 30, 2013 at 6:05

mauretto

3,2823 gold badges31 silver badges31 bronze badges

1 Comment

mauretto Over a year ago

@user151065 please remeber to accept this answer if it solves your question.

Collectives™ on Stack Overflow

Working with Excel Sheets using java programming

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related