Forum Discussion

mrezahoseini's avatar
mrezahoseini
Contributor
10 years ago

How to read excel file from sharepoint in TestComplete

I have uploaded an excel file in sharepoint and would like to read its context.   How can I do it?   Thanks for your kind attention
  • EnergizerBunny's avatar
    EnergizerBunny
    10 years ago

    I find that this type of routine works for Excel files with the *.xlsx extension.

    It is in VBScript.

     

    Call the subroutine and pass in the fully qualified file path in the variable 'svFile'

     

     

    Sub ReadDataFromExcel(svFile)
        Dim Excel, RowCount, ColumnCount, r, c

        Set Excel = Sys.OleObject("Excel.Application")
        Excel.Workbooks.Open(svFile)

     

        RowCount = Excel.ActiveSheet.UsedRange.Rows.Count
        ColumnCount = Excel.ActiveSheet.UsedRange.Columns.Count

        For r = 1 To RowCount
            For c = 1 To ColumnCount
                Log.Message "Cell row:" & r & " col:" & c & " = " & VarToString(Excel.Cells(r, c))
            Next
        Next

     

        Excel.Quit
        Set Excel = Nothing
    End Sub

TanyaYatskovska's avatar
TanyaYatskovska
SmartBear Alumni (Retired)

Hi Mahnazrezahoseini,

 

You cannot pass URL to DDT.ExcelDriver.

 

Is it possible that you download the Excel file before working with it in your test? In this case, you would use DDT feature to read the file content.

SmartBearDan's avatar
SmartBearDan
SmartBear Alumni (Retired)
10 years ago

Hi Mahnazrezahoseini,
 
It may be possible to download the file from Sharepoint using a script like the one in the "How To" article below.  Once the file is downloaded you can then use the Data Loop like Tanya mentioned.

 

How to download a file from the Internet: http://support.smartbear.com/viewarticle/8999/

 

Reference Links:
Running a script routine from within a Keyword Test: http://support.smartbear.com/viewarticle/56271/
Data Driving a Test Case in TestComplete: http://support.smartbear.com/screencasts/testcomplete/creating-data-driven-tests/
 

Hope that helps,
Dan