Question


Infosys Limited
US
Last activity: 6 Nov 2018 20:02 EST
Metadata file ASPNETMMCExt.dll missing
Hi,
While validating the script in robotics studio (using the script component), I ma getting an error as Metadata file ASPNETMMCExt.dll missing. Please help
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Accepted Solution


Pegasystems Inc.
US
Please look at my post to see how to do this without a script using just Pega Robotics.
Is this script the only one in the script container? What references have you added to the script container? You will need at least:
Microsoft.Office.Interop.Excel.dll
OpenSpan.Office.dll


ANZ
IN
Hi,
Can you share the script.
Regards,
Manas


Infosys Limited
US
Thanks for checking. I have added Microsoft.Office.Interop.Excel reference
ArrayList al = new ArrayList();
//Get Sheets collection representing all the worksheets
//in the workbook excelWkBook
Sheets excelSheets = excelWkBook.Worksheets;
//Create null Worksheet object excelWorksheet
Worksheet excelWorksheet = null;
//If the Sheets collection is not empty for the input Workbook, iterate
//through the sheets, get each sheet, and add the name of the sheet
//to the arraylist al
if (excelSheets!= null)
{
for (int i = 1; i<= excelSheets.Count; i++)
{
excelWorksheet = (Worksheet)excelSheets.get_Item((object)i);
al.Add(excelWorksheet.Name.ToString());
Thanks for checking. I have added Microsoft.Office.Interop.Excel reference
ArrayList al = new ArrayList();
//Get Sheets collection representing all the worksheets
//in the workbook excelWkBook
Sheets excelSheets = excelWkBook.Worksheets;
//Create null Worksheet object excelWorksheet
Worksheet excelWorksheet = null;
//If the Sheets collection is not empty for the input Workbook, iterate
//through the sheets, get each sheet, and add the name of the sheet
//to the arraylist al
if (excelSheets!= null)
{
for (int i = 1; i<= excelSheets.Count; i++)
{
excelWorksheet = (Worksheet)excelSheets.get_Item((object)i);
al.Add(excelWorksheet.Name.ToString());
}
}


Pegasystems Inc.
US
Can you share a screenshot of the script or include the parameters and return and any "using" statements?


Infosys Limited
US
I have attached the screenshot for your reference
Accepted Solution


Pegasystems Inc.
US
Please look at my post to see how to do this without a script using just Pega Robotics.
Is this script the only one in the script container? What references have you added to the script container? You will need at least:
Microsoft.Office.Interop.Excel.dll
OpenSpan.Office.dll


Infosys Limited
US
Thanks Jeff. I am referring to the post you shared to understand excel automation in detail. I was trying this piece of automation to understand the script automation. I replicated the script automation code into a new solution and it worked fine