期刊名称：International Journal of Innovative Research in Computer and Communication Engineering
印刷版ISSN：2320-9798
电子版ISSN：2320-9801
出版年度：2015
卷号：3
期号：11
DOI：10.15680/IJIRCCE.2015.0311129
出版社：S&S Publications
摘要：The world around us now completely relies on technology that should be faster, reliable, and easy tocomplete a given task in a stipulated time. From home entertainment to military services and automobiles to healthcare theessence of the automation is required in order to bring upon effective results without much human intervention. With thisnotion of support to the fast growing technology in mind to optimize productivity of the service being provided, theautomation of software becomes the prime importance. Automation helps to increase the productivity and also the qualitybeyond the human capability.In this thesis, the Automation techniques are employed in converting the data present in one file format to another format.The data used for parsing was extracted from stored files with particular extension and it is consolidated to generate anexcel report file. Both white box and black box testing is carried out for the same to validate the result with the givenrequirements.Automation is also employed with the help of macros that generate chart according to the input values given. Automation isalso employed on dumping the data where the data from the data source of one category is extracted and dumped intoseveral other sheets of same category. This data retrieval and data consolidation simplified the task of the user whootherwise would have to work and give instructions manually thereby increasing overall productivity and reliability.
