Forum Discussion

payaldalal's avatar
payaldalal
Occasional Contributor
15 years ago

Want to Write data into Excel file

I want to Write data from 'Form' to the 'Excel File'.

1. I am using aqFile method.

2. Right now data is going to Excel file but on same column.

3. After each text box value data should inserted on next column on same row.

3. Which command is given to send value to next column?

3 Replies

  • I think you need to do a search on Excel dll API to find out...
  • I  use COM to do this. Just Google for "COM + VBScript + Excel".



    Thankyou

  • Hi Payal,




    You need to work with Excel by using its COM object. A sample project demonstrating how you can do this is shipped with TestComplete. You can find it here:




    Windows Vista and Windows Server 2008:

    <Users>\Public\Documents\TestComplete 7 Samples\Scripts\MSOffice\

    Other operating systems:

    <Documents and Settings>\All Users\Documents\TestComplete 7 Samples\Scripts\MSOffice\




    Documentation on the Excel object model can be found in the MSDN Library: