is it possible to change sheet name with apache poi MS excel java android

java android apache-poi rename spreadsheet
funfordevelopping picture funfordevelopping · Feb 21, 2014 · Viewed 34.3k times · Source

is there any way to update existing sheet name of MS Excel file knowing that I am using apache poi in my android app

I can create a sheet with my custom name 

HSSFSheet sheet = workbook.createSheet("my custom name");

but when I want to copy another sheet to this one , the name also is copied and my custom name is crashed

Answer

nikis picture nikis · Feb 21, 2014

The following should do the trick:

workbook.setSheetName(workbook.getSheetIndex(sheet), "newName");

Related questions

Merging cells in Excel using Apache POI

Is there any other way to merge cells in Excel using Apache POI library? I was trying using the following, but its not working // selecting the region in Worksheet for merging data CellRangeAddress region = CellRangeAddress.valueOf("A" + rowNo + ":D" + rowNo); // …

Read More
Apache POI insert image

I am having troubles with inserting a picture in an excel sheet im making. There are a lot of question about this subject, but I simply cannot figure out what am I doing wrong. My code runs, shows no errors …

Read More
Apache POI and Aspose?

hi i am creating an app which can read file like pdf/doc/docx/xls/ppt etc and display it to user.I have read that if in doc there is some images and a table , apache POI can't help …

Read More