Free Support Forum - aspose.com

'Freeze' first column(s) and row(s)

I might be overlooking it but I can not find information on if and how I can ‘freeze’ the first column(s) and/or row(s) so that they do not scroll along with the rest of the sheet.



If possible, how can I do that?



Thanks,



Marcel

Hi,

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

Yes, it is quite possible and it can be done easily using Aspose.Cells API.

Please see the following code to get your desired results. I have also attached the output xlsx file generated by this code and screenshot for your reference.

Please also see the following article for your more help.


Java

Workbook workbook = new Workbook();


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


//Freeze the first column and row

worksheet.freezePanes(“B2”, 1, 1);


workbook.save(DIR + “output.xlsx”, SaveFormat.XLSX);

Screenshot:

Thank you!

Great help, great support.

As always