This is a migrated thread and some comments may be shown as answers.

Won't write to Excel

4 Answers 82 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Don Bedner
Top achievements
Rank 1
Don Bedner asked on 19 Jun 2015, 05:16 PM

I've been trying to perform the complete steps associated to this documentation and can't get the update to Excel to work:  http://docs.telerik.com/teststudio/advanced-topics/coded-samples/general/write-into-data-source 

I have added a reference to this path\file:  C:\Program Files (x86)\Microsoft Visual Studio 11.0\Visual Studio Tools for Office\PIA\Office14\Microsoft.Office.Interop.Excel.dll

as described here:  http://docs.telerik.com/teststudio/advanced-topics/coded-steps/add-assembly-reference Please see the attached jpg file to see the error.​

What am I doing wrong?

 

Here is a copy of the pertainent entries from the Log file:

'6/19/2015 1:04:40 PM' - Using 'InternetExplorer' version '11.0' as default browser.
'6/19/2015 1:04:41 PM' - 'Pass' : 1. Navigate to : 'http://www.checkdomain.com/'
'6/19/2015 1:04:41 PM' - 'Pass' : 2. Enter text 'www.ask.com' in 'DomainText'
'6/19/2015 1:04:42 PM' - 'Pass' : 3. Click 'Submit'
'6/19/2015 1:04:42 PM' - LOG: 1
'6/19/2015 1:04:42 PM' - LOG: 2
'6/19/2015 1:04:42 PM' - LOG: 3
'6/19/2015 1:04:43 PM' - LOG: 4
'6/19/2015 1:04:43 PM' - LOG: 5
'6/19/2015 1:04:43 PM' - LOG: 6
'6/19/2015 1:04:44 PM' - 'Pass' : 4. [AddToExcelFile_CodedStep] : New Coded Step

4 Answers, 1 is accepted

Sort by
0
Boyan Boev
Telerik team
answered on 24 Jun 2015, 12:30 PM
Hello Don,

What happens after executing the test? The Excel file is not updated?

Please send me your test project so I can review it and give you a solution.

Hope to hear from you soon.

Regards,
Boyan Boev
Telerik
 
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Don Bedner
Top achievements
Rank 1
answered on 24 Jun 2015, 02:09 PM

I've attached the entire project but it appears to be too big -- how can I get this to you in a size that meets your 2MB limit (which is too small)?

 

0
Don Bedner
Top achievements
Rank 1
answered on 25 Jun 2015, 02:02 PM
I was able to get this to work.  I didn't have security rights to write to the root of the C: drive.  I switched the output file to be written to the Temp directory and the code worked.
0
Boyan Boev
Telerik team
answered on 29 Jun 2015, 08:19 AM
Hi Don,

I am very happy to hear that.

If you need further assistance please let us know.

Regards,
Boyan Boev
Telerik
 
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
Tags
General Discussions
Asked by
Don Bedner
Top achievements
Rank 1
Answers by
Boyan Boev
Telerik team
Don Bedner
Top achievements
Rank 1
Share this question
or