Download, unzip, and load Excel file in R using tempfiles only -

-

i trying , failing write process download .zip archive, extract particular excel file archive, , load excel file r workspace without ever writing of files (the .zip or .xls) hard drive.

i have written version of process works zipped .csvs, doesn't work .xls. here's how version goes, using 1 of urls i'm targeting in current project , using readworksheetfromfile() instead of read.csv() @ appropriate moment:

library(xlconnect) waed.old.link <- "http://eventdata.parusanalytics.com/data.dir/pitf.world.19950101-20121231.xls.zip" waed.old.file <- "pitf.world.19950101-20121231.xls" tmp <- tempfile() download.file(waed.old.link, tmp) tmp2 <- tempfile() tmp2 <- unz(tmp, waed.old.file) waed.old <- readworksheetfromfile(tmp2, sheet = 1, startrow = 3, startcol = 1, endcol = 73) unlink(tmp) unlink(tmp2)

and here's pops after line 8, 1 tries ingest spreadsheet waed.old:

error in path.expand(filename) : invalid 'path' argument

i tried read_excel() @ step , got same result:

> waed.old <- read_excel(tmp2, skip = 2) error in file.exists(path) : invalid 'file' argument

i gather has pointing readworksheetfromfile() @ connection rather file, i'm not sure that's right, , don't know how fix if is. searched stackoverflow , web answer couldn't find 1 right on point. i'd appreciate help.

as say, because unz returns connection object file within zip (but not explicitly unzip file), while readworksheetfromfile expects path file.

use unzip explicitly unzip file.

tmp2 <- unzip(zipfile=tmp, files = waed.old.file, exdir=tempdir()) # readworksheetfromfile(tmp2, ...)

Comments

Post a Comment

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

-
i lost "unknown" error: karma.conf.js: frameworks: ['mocha', 'should'], plugins: ['karma-mocha', 'karma-should', 'karma-phantomjs-launcher'], ... browsers: ['phantomjs'], error: 23 07 2015 14:35:37.691:warn [karma]: no captured browser, open http://localhost:9876/ 23 07 2015 14:35:37.701:info [karma]: karma v0.13.3 server started @ http://localhost:9876/ 23 07 2015 14:35:37.707:info [launcher]: starting browser phantomjs 23 07 2015 14:35:37.738:error [karma]: { [error: spawn unknown] code: 'unknown', errno: 'unknown', syscall: 'spawn' } error: spawn unknown @ exports._errnoexception (util.js:749:11) @ childprocess.spawn (child_process.js:1093:11) @ exports.spawn (child_process.js:933:9) @ object._execcommand (c:\users\jinga4x\git\mdl-sample-project\node_modules\karma\lib\launchers\process.js:63:21) @ object._start (c:\users\jinga4x\git\md...
Read more

Nuget pack csproj using nuspec -

-
i want create nuget package contains specified in nuspec file, still version csproj. in order use token have pack like: nuget pack myproj.csproj but when adds dependencies , creates unwanted folder in nuget package. nuspec file is: <?xml version="1.0" encoding="utf-8"?> <package xmlns="http://schemas.microsoft.com/packaging/2011/08/nuspec.xsd"> <metadata> <id>test</id> <version>$version$</version> <title>test</title> <authors>test</authors> <owners>test</owners> <requirelicenseacceptance>false</requirelicenseacceptance> <description>test</description> <summary>test</summary> <releasenotes>test</releasenotes> <copyright>test</copyright> </metadata> <files> <file src="bin\debug\*.dll" target="lib\net45" /> <file s...
Read more

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

-
i have aspxgridview includes new , delete button. delete button includs gv_rowdeleting event. want show aspxpopupcontrol (id="pupconfirm"). want user have confirm password delete item. tried: protected void gv_rowdeleting(object sender, devexpress.web.data.aspxdatadeletingeventargs e) { pupconfirm.showonpageload = true; } but nothing happened. please me. !!! you can create template column javascript prompt confirmation. <itemtemplate> <asp:linkbutton id="btndelete" runat="server" text="delete" commandname="delete" onclientclick="javascript:if(!confirm('are sure want delete record?')){return false;}"> </asp:linkbutton> </itemtemplate>
Read more