English 中文(简体)
阅读的Excel文档不能找到一条路?
原标题:Read excel file cannot find the path?
library("readxl")

my_data <- read_excel("GVA.xlsx")
my_data

however the console says the path does not exist. How can I import excel/csv files and know that the file will always be found.

为什么不这样做?

p.s. I am new to R

问题回答

您的工作名录中是否有GVA.xsx? 否则,R就找不到,因为你没有在你目前的名录之外绘制任何地图。 您可以通过点击:文档和;进口数据集;从Excel处取。 浏览你的档案并确定任何必要的进口选择。 R将实际制定该法典,以绘制有关档案的地图。

The following article might help: https://forum.posit.co/t/read-excel-file-from-r-project/158530

当然,最容易的方式是把你的Excel案列入与你的R法典相同的工作目录。 简言之,你的“GVA.xlsx”文档必须与你的“编码”文档相同。

否则,正如上述条款一样,你需要通过编造你的作品目录,希望这将有助于!





相关问题
import of excel in SQL imports NULL lines

I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

Excel date to Unix timestamp

Does anyone know how to convert an Excel date to a correct Unix timestamp?

C# GemBox Excel Import Error

I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...

Importing from excel "applications" using SSIS

I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...

热门标签