Excel sheet data import to MultiRow variable Set

[Geetha Lukka]

How can we load  data from excel sheet to Multirow variable set.

[AnirudhKumar]

Not possible directly.

A multi row variable set needs to have data entered manually and only stores data temporarily.

The excel load involves server side actions. Think of like this. There needs to be a feature that receives the excel sheet, then system has to attach the document in the Attachment table, then read data from the excel and finally do a redirect to your form containing the Multi Row Variable set. A Client script needs to re-populate the data in the Multi row variable set.

In short, it's possible, but involves bad UI and elaborate architecture 

[Sai Kumar B]

@Geetha Lukka 

It's possible with customization 

1.) Create a UI macro and add it as variable 

2.) When you attach the sheet click the Macro on the form the data will be populated into MRVS

You can refer to the @Kieran Anson response from this link - Attach csv to catalog item to populate a Multi-Row Variable Set (MRVs) and modify the script accordingly as per the columns in your excel sheet

[Ankur Bawiskar]

@Geetha Lukka 

this article is worth checking; see if it helps you

Service Catalog - Import Spreadsheet Info Multi Row Variable Set (MVRS)

Regards
Ankur