Assignment I of CMSC-5718, Intro to Computational Finance

Preperation

Read Excel Sheet in R

There are several packages available for reading Excel xls/xlsx files:

  1. Function*odbcConnectExcel* in package RODBC
  2. Package xlsx
  3. Function read.xls in package gdata

On some other blog articles (here is one)

Install Package XLSX

Package homepage on CRAN: http://cran.r-project.org/web/packages/xlsx/index.html

Notice: you might need to install dependency package xlsxjars and rJava, and make sure you have link JDK to R correctly, otherwise, execute the following in terminal as root:

R CMD javareconf

to add Java support to R.

Import Data from Excel Sheet

Since the Excel spread sheet include some instruction information, I need to specify the columns and rows which stores the "real" data.

  • Smithd8882014-04-19 07:55

    Hi! This is my first visit to your blog! We are a baakedbgef