AlumniHi,
Getting data from Excel is always a tough question. There are many ways of how it can be done. It's very important to choose the best way based on the current requirements. Our SmartBear Community Leader in TestComplete, shankar_r, shares best practices with us. Watch the interview here:
https://www.youtube.com/watch?v=3zQ_1xhokVQ&feature=youtu.be&t=552
Can you summarize what he said in that interview? I just watched it and I literally could not understand any of his response due to poor mic quality.
Question:
What are you trying to achieve by writing out to Excel? A lot of the suggestions on how to do so and what to do are dependant, somewhat, on the specific use case.
Generally speaking, to access an excel sheet and write out to it, you're going to want to use the COM object of Excel. High level is documented here https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sources/excel/working-via-com.html
Thanks for the link! I'll check it out today. I have a wpf application that has the option to create a 'print out' form in excel. Each page already has an excel template to sort of mirror the wpf page, but I would want to check and make sure the data from the excel print form matches the data that was just entered into the form. The location the data appears in the print out is hard coded so that should make it relatively easy to do I imagine.
