Forum Discussion

gnivlag's avatar
gnivlag
Occasional Contributor
12 years ago

Table Checkpoint that uses a spreadsheet as a store

I currently have a test that uses a Table Checkpoint that verifies the contents of a DevExpress data grid.  By default, the Table Checkpoint uses a Table Store that stores the expected contents of the DevExpress grid.  What I've noticed is that over time I've been needing to frequently modify the Table Store within TestComplete which is not as easy as modifying the stored data directly in a spreadsheet (CSV or Excel).  Is there an easy way that I can use a spreadsheet as a store instead of having to rely upon TestComplete's Table Store mechanism?
  • paul_scroce's avatar
    paul_scroce
    Frequent Contributor
    12 years ago


    One option is to add a new DBTable store item to connect to an Excel document



    The Connection string for Excel 2007 would be like

    Provider=Microsoft.ACE.OLEDB.12.0; Data Source="C:\Test.xlsx"; Extended Properties="Excel 12.0; HDR=YES; IMEX=1";



    Select the data source type Custom query

    Enter the query code on the next page of the wizard, like Select * from [Sheet1$]

    Specify the data range to store on the next page of the wizard.



    When the spreadsheet is modified you need to edit the existing dbtable item using the wizard to update the data again.



     


    http://support.smartbear.com/viewarticle/32081/
  • gnivlag's avatar
    gnivlag
    Occasional Contributor
    12 years ago
    Thank you for your reply. Is there an existing feature request for this such that an Excel spreadsheet can be referenced as a checkpoint and modified such that TestComplete is not needed for modifying or updating the Excel spreadsheet?