Create an excel with data validation(dropdown in one column) and hidden sheet

Aspose.Cells Product Family
1

I want to create and download an excel using aspose.cells JAVA.

image.png (7.0 KB)

It has columns like attached image. The third column contains a data validation dropdown, which user can select value from. By default , it will show blank with dropdown symbol.

And this excel will have only this sheet, no other sheet creation will be allowed.

Can you guide me with code snippet to achieve this using aspose.cells JAVA

2

@rinkusm,

Hi, I am going to move this topic to the Aspose.Cells forum.

There, someone from that team will give you proper support on your question.

3

@rinkusm
1,

Please add validation : Data Validation|Documentation
2,

Please protect the structure of the workbook as the following: