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...
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/