Question
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/2024-05/1f77a272-b558-4261-964a-0a7d028c27c5.jpg?h=436c2321&itok=Ilx-4hBN)
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/2024-05/1f77a272-b558-4261-964a-0a7d028c27c5.jpg?h=436c2321&itok=Ilx-4hBN)
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
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
ANZ
IN
Hi,
Can you share the script.
Regards,
Manas
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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());
}
}
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/2024-05/e90c12b7-5a50-45b6-9408-8644c06fabca.jpg?h=9bedb0c7&itok=I_lzpbin)
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/2024-05/e90c12b7-5a50-45b6-9408-8644c06fabca.jpg?h=9bedb0c7&itok=I_lzpbin)
Pegasystems Inc.
US
Can you share a screenshot of the script or include the parameters and return and any "using" statements?
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Infosys Limited
US
I have attached the screenshot for your reference
Accepted Solution
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/2024-05/1f77a272-b558-4261-964a-0a7d028c27c5.jpg?h=436c2321&itok=Ilx-4hBN)
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/2024-05/1f77a272-b558-4261-964a-0a7d028c27c5.jpg?h=436c2321&itok=Ilx-4hBN)
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
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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