web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Unanswered

Regression Suite Automation Tool - Unable to generate excel file when trying to generate test execution and parameter file , getting Test case generation completed with errors

(0) ShareShare
ReportReport
Posted on by 45

I have created test case in dev Ops and managed to load it in RSAT tool, but when trying to generate the test execution and parameters files it gives me an error shown in attached snapshot. It generate other files like xml doc and c# source file but not .xlsx   

Create an asset in Finance and operations
System.Exception: The Excel file creation failed at C:\************\attachments\Create_an_asset_59504_Base.xlsx: Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Element not found. (Exception from HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND)). ---> System.InvalidCastException: Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Element not found. (Exception from HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND)).
at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
at Microsoft.Office.Interop.Excel.ApplicationClass.set_DisplayAlerts(Boolean RHS)
at Microsoft.Dynamics.RegressionSuite.Excel.ExcelService.GenerateExcel(List`1 forms, String excelOutputFile) in D:\a\1\s\Business Process Test Tool\TaskRecordingRegressionTool\RegressionSuite\Excel\ExcelService.cs:line 327
--- End of inner exception stack trace ---
at Microsoft.Dynamics.RegressionSuite.Excel.ExcelService.GenerateExcel(List`1 forms, String excelOutputFile) in D:\a\1\s\Business Process Test Tool\TaskRecordingRegressionTool\RegressionSuite\Excel\ExcelService.cs:line 369
at Microsoft.Dynamics.RegressionSuite.CodeGeneratorHelper.ProcessXml(TestCaseModel testCase, String outputPath, String companyName, Boolean generateOnlyTestExecution, Boolean migrateUserParameters, Boolean isCreateDerivedAction) in D:\a\1\s\Business Process Test Tool\TaskRecordingRegressionTool\RegressionSuite\Helpers\CodeGeneratorHelper.cs:line 464
at Microsoft.Dynamics.RegressionSuite.WpfApp.Services.AttachmentGenerator.<>c__DisplayClass17_2.<<GenerateParentWithDerivedTests>b__0>d.MoveNext() in D:\a\1\s\Business Process Test Tool\TaskRecordingRegressionTool\RegressionSuiteWpfApp\Services\AttachmentGenerator.cs:line 353

pastedimage1637076946017v1.jpegRSAT-excel-issue.JPG

I have the same question (0)
  • huijij Profile Picture
    19,811 on at

    Hi SonalY,

    Please check the link to see if it helps:

    stackoverflow.com/.../unable-to-cast-com-object-of-type-microsoft-office-interop-excel-applicationcla

  • SonalY Profile Picture
    45 on at

    Thanks for the link... I managed to solve it ..I had to reinstall the visual studio and Microsoft office...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Siv Sagar Profile Picture

Siv Sagar 266 Super User 2025 Season 2

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 213 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 140 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans