calendar bulk update

Question

Hi

I have an excel file contains data as shown above. I want to update the calendar by reading the excel file by programmatically or using any plugin. Is this possible? if yes, how? Thanks.

vinayp0002 · Answer

Hello Niranjan Basetapla , 
 We have a plugin - Excel tools which provides a function to read the excel sheet (readexcelsheet) . After reading the data from Excel, 
 in case if you need to do this activity multiple times in the future, better store this data in a table through respective CDT and update that data in an editable grid and then export the updated data as required (Export Data store Entity to Excel smart service). 
 There is no OOTB function to directly to update the excel.