Ask a Question

Want to Write data into Excel file

payaldalal
Occasional Contributor

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?
Thanks.
Regards,
Payal
3 REPLIES 3
seafalcon
Contributor

RE: Want to Write data into Excel file

I think you need to do a search on Excel dll API to find out...
Find the faith in life
syedsafvan
Contributor

RE: Want to Write data into Excel file

I  use COM to do this. Just Google for "COM + VBScript + Excel".



Thankyou

Syed Ahmed Safvan

RE: Want to Write data into Excel file

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:


--
Dmitry Nikolaev

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
cancel
Showing results for 
Search instead for 
Did you mean: