Add Calender to my excel cell

Aspose.Cells Product Family
1

Hi,
Is there any way I can add excel Calender to my Excel sheet’s cell

2

@Amrinder_Singh,

Would you please describe your requirement with more details? It will be much better if you can create one template file in ms excel manually with the content you expect. If so from the file we can understand your requirement clearly and provide the possible solution.

3

@johnson.shi

I have added the file Calender.zip (7.2 KB)

The required output is if my cell is date type i want to choose date from datepicker or Calender. Right now I’m entering date mannualy. But I want one datepicker or Calender from where I can choose date.

4

@Amrinder_Singh,

Thanks for the sample Excel file but you have not provided your desired Excel file where date picker or calendar control/object is (already) applied to the cell in the worksheet. You have applied Date data validation to “E8” cell only which Aspose.Cells supports. Please use MS Excel to create your desired Excel file manually which should have date picker or Calendar attached to a cell value. We will understand your requirements and then check on how to do it via Aspose.Cells APIs.

5

@amjad.sahi
Hi,
Actually that is my requirement I want to add calender/datepicker in my excel using aspose.Cells

6

@Amrinder_Singh,
Currently, we do not support adding calender/datepicker using Aspose.Cells. You can add the calendar/datepicker in Excel through third-party controls, and these will be preserved during the Aspose.Cells operation. Apologies for any inconvenience caused to you.

7

@Amrinder_Singh,

Aspose.Cells can only create/manipulate those data models and objects that are supported by ms excel itself, otherwise the generated file with some kind of unsupported data will cause applications such as ms excel corrupted or give error.

Currently we do not know there is some kind of object in ms excel which can be used like calendar/datepicker. If you know or have some idea about the way to implement such kind of function in ms excel, please create one example in ms excel manually and provide us the sample file, then we can provide solution and code example to achieve it by Aspose.Cells dynamically according to your data.