+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Excel automation doubt (/Thread-Excel-automation-doubt)
Excel automation doubt - AAB - 03-24-2011
Hi,
Can you please guide me through the excel automation...
I am confused regarding the things which can be or which should be done manually and which of things in excel should be automated.
Scenario:
In a web application, there is non-editable grid containing 15 columns an d 16 rows. There is export to excel functionality in it.Now when you export, you get the whole data in excel sheet with time periods as column headers and datanames as row headers.
There are approximately... 13 datapoints which are to be calculated using multiple rows at a time.The calculations involve complex calculations.
So, please tell me should the efforts be put on automating this excel or not?
RE: Excel automation doubt - basanth27 - 03-24-2011
The point is, It can be done. if that answers your question,well and good. Else, I am not sure if i can decide upon the efforts which you may need to put up for this task. From what you have described the task looks doable, however, it is up to you and your estimation to see if you want to do it.