Home > Archive > 2015 > Volume 5 Number 7 (Jul. 2015) >
IJIET 2015 Vol.5(7): 527-531 ISSN: 2010-3689
DOI: 10.7763/IJIET.2015.V5.562

A Methodology of Employing Spreadsheet Software as a Tool for Integrating Web Services

Somchai Chatvichienchai and Wataru Miyagi

Abstract—Web services are client and server applications that communicate over hypertext transfer protocol (HTTP) of the world wide web’s (WWW).Web services are built around the Web browser standards and can be used by any browser on any platform. However, web browsers themselves lack the ability to analyst and process web data offline as users need. In order to perform data analysis, users have to output data from web sites in CSV or XML format, and have spreadsheet software (such as Microsoft Excel, etc.) imported the data. This inconvenient and time-consuming task is a bottle neck in analyzing data of web applications. The objective of this paperis to present a methodology that employs Excel as a toolfor web serviceintegration and offline data processing. Furthermore, this paper presents the technical feature comparison between webbrowsers and Excel in aspect of web application client. Based on this methodology, we have developed an Excel-based online accommodation search program thatintegrates web services of Google Map and Rakuten Travel which is the biggest accommodation booking web site of Japan.

Index Terms—Spreadsheet software, XML, web service, Google Map, search.

The authors are with the Dapartment of Information and Media Studies of University of Nagasaki, Japan (e-mail: somchaic@sun.ac.jp, B2210060@sun.ac.jp).


Cite: Somchai Chatvichienchai and Wataru Miyagi, "A Methodology of Employing Spreadsheet Software as a Tool for Integrating Web Services," International Journal of Information and Education Technology vol. 5, no. 7, pp. 527-531, 2015.

General Information

  • ISSN: 2010-3689 (Online)
  • Abbreviated Title: Int. J. Inf. Educ. Technol.
  • Frequency: Monthly
  • DOI: 10.18178/IJIET
  • Editor-in-Chief: Prof. Dr. Steve Thatcher
  • Executive Editor: Ms. Nancy Y. Liu
  • Abstracting/ Indexing: Scopus (CiteScore 2022: 2.0), INSPEC (IET), UGC-CARE List (India), CNKI, EBSCO, Google Scholar
  • E-mail: ijiet@ejournal.net


Article Metrics in Dimensions