DDT.ExcelDriver get cell data( string value )

Question

Sub Test&nbsp;&nbsp; Set objSheetOne = DDT.ExcelDriver("C:\Documents and Settings\uday.vangala\Desktop\MYfilesTwo.xls", "Sheet1")&nbsp; &nbsp;&nbsp; msgbox objSheetOne.ColumnCount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; While Not objSheetOne.EOF()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var1= objSheetOne.Value(0)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msgbox var1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var1= objSheetOne.Value(1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msgbox var1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var1= aqConvert.VarToStr( objSheetOne.Value(2))&nbsp; ' For second iteration it is throws an error ( may be because cell data in that&nbsp;&nbsp;&nbsp; is string)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msgbox var1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ' How to solve this.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; objSheetOne.Next&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; WEnd&nbsp;&nbsp; DDT.CloseDriver(DDT.CurrentDriver.Name)&nbsp;&nbsp; &nbsp;End SubFor second iteration it is throws an error ( may be because cell data in that&nbsp;&nbsp;&nbsp; is string).  How to solve this.

irina_lukina · Answer

Hi Uday,I recommend that you refer to the following forum thread for more information:http://community.smartbear.com/forum/post/?mode=singleThread&amp;thread=06ec1d56-6070-4abf-b79c-61387ea74f7dI hope it helps :)

udayreddy_90 · Answer

Thanks Irina&nbsp;Lukina, &nbsp;If I want to read data from Libre Office spread sheet ( with out using DDT driver ), How can I do this?- What are the plug in's required ?- What are the setting needed in my environment?

irina_lukina · Answer

Hi Uday,The fact is that TestComplete doesn't provide special support for working with LibreOffice documents. However, as far as I know, your LibreOffice allows saving the documents in the Excel format. So, I recommend that you save your document as an .xls file and then work with it using DDT drivers or any other approach mentioned in the Using Excel Files as Data Storages help topic.I hope this information helps :)

Forum Discussion

DDT.ExcelDriver get cell data( string value )

3 Replies

Recent Discussions

Name mapping gone

TestComplete: Connect to Azure Cosmos DB

Connection string using managed identity authentication

Related Content

DDT.ExcelDriver Sometimes Truncates Long Strings at 255 characters.

DDT.ExcelDriver for .xlsx not .xls

Extract certain strings from JSON data strucure