We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Unhide the execl ROW/column IN execl using java(Code of ASPOSE ) is not work

Hi All,

I am using the code of Aspose in RFT(using Java) related to Excel file but is give error ,

So Please help me how will be use this code in RFT(Java).

Thanks in advance

This message was posted using Page2Forum from Hiding/Unhiding Rows and Columns - Aspose.Cells for Java


Thanks for your posting and considering Aspose.Cells for Java.

I tried the following code using the latest version:
for Java v7.0.4.7

and it is working fine.

I have attached the source and the output xlsx file.


String filePath=“F:\Shak-Data-RW\Downloads\book1.xlsx”;

//Instantiating a Workbook object

Workbook workbook = new Workbook(filePath);

//Accessing the first worksheet in the Excel file

Worksheet worksheet = workbook.getWorksheets().get(0);

Cells cells = worksheet.getCells();

//Hiding the 3rd row of the worksheet


//Hiding the 2nd column of the worksheet


//Saving the modified Excel file in default (that is Excel 2003) format

workbook.save(filePath + “.out.xlsx”);