• español
    • English
    • Deutsch
  • English 
    • español
    • English
    • Deutsch
  • Login
View Item 
  •   PRCR Home
  • Polytechnic University of Puerto Rico
  • Design Project Articles Master Degree
  • Computer Science
  • View Item
  •   PRCR Home
  • Polytechnic University of Puerto Rico
  • Design Project Articles Master Degree
  • Computer Science
  • View Item
JavaScript is disabled for your browser. Some features of this site may not work without it.

Automated Data Acquisition using Microsoft Excel

Thumbnail
View/Open
Articulo Final_Luis Martinez (348.6Kb)
Date
2016
Author
Martínez González, Luis F.
Metadata
Show full item record
Abstract
The process of Web Scraping allows the automated extraction of data from an entire website and turn it into a tabular dataset that can be used for reporting and analysis. There are numerous techniques and tools for web scraping and each one of them are better suited for certain scenarios. One of the most popular techniques, is the direct extraction of the data from the markup language within the website. That is the technique that will discussed in this paper and it will be put into practice by developing a tool using Microsoft Excel. For most individuals that regularly wok with data, Microsoft Excel is one of the most important and useful tools they can have when they need to do a quick analysis or visualize data. Microsoft Excel is powered by an extensible framework and that is Visual Basic for Applications, which allows the implementation of robust functionalities in a tool. In this paper, it will be combined the power of Microsoft Excel and its underlying features, and a popular Web Scraping technique to automate the process of web data acquisition and have this data ready to be processed in Microsoft Excel. Key Terms - Data Automation, Microsoft Excel, Web Programming, Web Scraping.
URI
http://hdl.handle.net/20.500.12475/530
Collections
  • Computer Science

PRC Repository copyright © 2022  COBIMET, Inc.
Contact Us
Theme by 
Atmire NV
 

 

Browse

All of PRCRCommunities & CollectionsBy Issue DateAuthorsTitlesSubjectsThis CollectionBy Issue DateAuthorsTitlesSubjects

My Account

LoginRegister

Statistics

View Usage Statistics

PRC Repository copyright © 2022  COBIMET, Inc.
Contact Us
Theme by 
Atmire NV