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

Aspose.Cells Product Family
1

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

2

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:
3

Thank you!

Great help, great support.

As always