Shulou(Shulou.com)05/31 Report--

This article mainly introduces R how to read win7_64 bit .xlsx file, the article is very detailed, has a certain reference value, interested friends must read it!

Read xlsx file (window64 bit)

> z install.packages ("XLConnect")

-Please select the CRAN server for this connection segment

Also installing the dependency 'rJava'

Try to open URL' http://mirror.bjtu.edu.cn/cran/bin/windows/contrib/3.1/rJava_0.9-6.zip'

Content type application/zip' length 758444 bytes (740 Kb)

Opened URL

Downloaded 740 Kb

Try to open URL' http://mirror.bjtu.edu.cn/cran/bin/windows/contrib/3.1/XLConnect_0.2-7.zip'

Content type 'application/zip' length 17997109 bytes (17.2 Mb)

Opened URL

Downloaded 17.2 Mb

Package 'rJava' opened successfully, MD5 and check also passed

Package 'XLConnect' opened successfully, MD5 and check also passed

The downloaded binary package is in the

C:\ Users\ Administrator\ AppData\ Local\ Temp\ RtmpC2C5IF\ downloaded_packages

> library ('XLConnect')

Error: loadNamespace () failed to calculate 'rJava'' .onload. Details:

Call: inDL (x, as.logical (local), as.logical (now),...)

Error: unable to load the shared target object 'EVOGRAGUA javaUniGUR Mel 3.1.0 RMYRJUAGUA libraryLBSERVER x64RJava.dllcircle VRO:

LoadLibrary failure: the specified module was not found.

Error: 'XLConnect' program package or namespace failed to load

> install.packages ('rJava')

Try to open URL' http://mirror.bjtu.edu.cn/cran/bin/windows/contrib/3.1/rJava_0.9-6.zip'

Content type application/zip' length 758444 bytes (740 Kb)

Opened URL

Downloaded 740 Kb

Package 'rJava' opened successfully, MD5 and check also passed

The downloaded binary package is in the

C:\ Users\ Administrator\ AppData\ Local\ Temp\ RtmpC2C5IF\ downloaded_packages

> library (rJava)

Error: loadNamespace () failed to calculate 'rJava'' .onload. Details:

Call: inDL (x, as.logical (local), as.logical (now),...)

Error: unable to load the shared target object 'EVOGRAGUA javaUniGUR Mel 3.1.0 RMYRJUAGUA libraryLBSERVER x64RJava.dllcircle VRO:

LoadLibrary failure: the specified module was not found.

Error: 'rJava' program package or namespace failed to load

> Sys.setenv (JAVA_HOME='E:\\ java\\ jdk\\ jdk1.7.0_13\\ jre'); (key steps, please pay attention)

> library (rJava)

> library ('XLConnect')

XLConnect 0.2-7 by Mirai Solutions GmbH

Http://www.mirai-solutions.com

Http://miraisolutions.wordpress.com

> df = readWorksheetFromFile ("D:/users/r_work/1.xls", sheet=1, header=TRUE) (disapproved version is too low? )

Error: OldExcelFormatException (Java): The supplied spreadsheet seems to be Excel 5.0 format 7.0 (BIFF5). POI only supports BIFF8 format (from Excel versions 97/2000/XP/2003)

> df = readWorksheetFromFile ("D:/users/r_work/1.xlsx", sheet=1, header=TRUE)

> df

Col1 Col2

1 2 3

2 3 5

3 4 7

4 5 9

5 6 11

The above is all the contents of the article "how R reads win7_64 bits .xlsx files". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.