Importing Excel sheet - Reference Values are not recognized

[michiusa69]

Hey there!

I get an error message (#REF) when trying to import a Excelsheet A with referenced values within A to another Exelsheet B. Is it even possible to do that with QTP?

Thanks you folks!

[Anand]

i have a workaround- read the reference Excel.

[supputuri]

Hi michiusa69,

First of all I have a question, is it mandatory to lmport the file into QTP?
If the answer is not/not sure, then you can read the value directly from the excel rather than importing the sheet into QTP so that you don't loose any data links.

[lkng2001]

My workaround is to loop through the parameter's values and remove the "[]" from "=[]Sheet1!A1"

Code:

Function RemoveBracket(strSheetName)
    RowCount = Datatable.GetSheet(strSheetName).GetRowCount
    For i = 1 To RowCount
        DataTable.GetSheet(strSheetName).GetParameter("ParameterName").ValueByRow(i) = "=Sheet1!A1"
    Next
End Function