Read.csv()抛出错误

Question

我一直试图读取excel文件，但似乎有什么问题。该文件以excel格式存储在“文档”文件夹中。

以下是我得到的错误消息：

table <- read.csv(file.choose(),header=T,sep='\t')

Warning messages:
1: In read.table(file = file, header = header, sep = sep, quote = quote,  :
  line 1 appears to contain embedded nulls
2: In read.table(file = file, header = header, sep = sep, quote = quote,  :
  incomplete final line found by readTableHeader on 

而且，由于这些都是警告，我碰巧忽略了它们。但“桌子”中也没有读到任何东西：

table
# [1] PK...
# <0 rows> (or 0-length row.names)

Answer 1

read.csv不读取XLS(X)文件，只读取CSV文件。尝试在Excel中打开Excel文件，将其导出到CSV并重新发出read.csv命令(取决于您的系统语言，您可能希望使用read.csv2 )。

Answer 2

我也犯了类似的错误，例如：

A <- read.csv("tel.csv", sep = ",")
Error in read.table(file = file, header = header, sep = sep, quote = quote,  : 
  empty beginning of file
In addition: Warning messages:
1: In read.table(file = file, header = header, sep = sep, quote = quote,  :
  invalid input found on input connection 'tel.csv'
2: In read.table(file = file, header = header, sep = sep, quote = quote,  :
  line 1 appears to contain embedded nulls
3: In read.table(file = file, header = header, sep = sep, quote = quote,  :
  incomplete final line found by readTableHeader on 'tel.csv'

为了解决这个问题，我尝试了：

A <- read.csv("tel.csv", sep = ",",
              fileEncoding="utf-16")

啊，真灵。

Answer 3

如果您试图读取xlsx文件，请使用xlsx库，或将它们导出为csv文件。read.table或read.csv不适用于Excel文件。

install.packages("xlsx")
library(xlsx)
table <- read.xlsx("file.xlsx", 1)