Skip to main content
February 3, 2022
Question

calendar bulk update

  • February 3, 2022
  • 3 replies
  • 0 views

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. 

    3 replies

    vinayp0002
    February 4, 2022

    Hello [mention:b43d92bf03864608867074c321528122:e9ed411860ed4f2ba0265705b8793d05],

    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.

    harshitb6843
    February 4, 2022

    Hi Niranjan,

    I am not sure to what calendar are you referring to here. Appian also has an internal calendar that is used with the date-time functions. 
    However, as the other commenter said, you can use this plugin here - https://community.appian.com/b/appmarket/posts/excel-tools

    But I am curious to know about your "Calendar" thing.

    February 25, 2022

    The plugin Excel tools provide a function to read the excel sheet (readexcelsheet).

    spades