Can we set different data type for columns in excel

Aspose.Cells Product Family
1

Hi,

We have a use-case to create excel , such that the columns can have different data types. One column can be of date type and other numeric type. Can we set data types to columns while creating excel through aspose cells. Please help us with the Java code for the problem. Discovered one api : style.setNumber() , but need more help.

Thanks

2

@saurabh.arora,

Thanks for your query.

Well, you may apply different data validation types as per your needs on your specified columns/cells range in the worksheet, see the document section/sub-sections with examples for your reference:

Hope, this helps a bit.