Won't write to Excel

5 posts, 0 answers
  1. Don Bedner
    Don Bedner avatar
    5 posts
    Member since:
    Dec 2007

    Posted 19 Jun 2015 Link to this post

    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

  2. Boyan Boev
    Admin
    Boyan Boev avatar
    1043 posts

    Posted 24 Jun 2015 Link to this post

    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!
  3. Don Bedner
    Don Bedner avatar
    5 posts
    Member since:
    Dec 2007

    Posted 24 Jun 2015 in reply to Boyan Boev Link to this post

    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)?

     

  4. Don Bedner
    Don Bedner avatar
    5 posts
    Member since:
    Dec 2007

    Posted 25 Jun 2015 in reply to Don Bedner Link to this post

    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.
  5. Boyan Boev
    Admin
    Boyan Boev avatar
    1043 posts

    Posted 29 Jun 2015 Link to this post

    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!
Back to Top