similar to: Trouble with excel download under https

Hi, I?m attempting to export data (split into multiple files from one large dataset) from R to excel using the excel.link package. The code for export is as follows: for(i in practicesNN){ #Create relevant data for input #Separate out all parts of data ? PracticeName is removed from example data for privacy reasons detailedH<-dataExport2[dataExport1$PracticeName == i &

I've created a Perl script that translates Microsoft Excel (.xls) files into comma-delimited text files (.csv) using the Perl Spreadsheet::ParseExcel module. Usage ----- perl xls2csv.pl <excel file> [<output file>] [<worksheet number>] Translate the Microsoft Excel spreadsheet file contained in <excel file> into comma separated value format (CSV) and store in

Hello, I''m using the spreadsheet/excel gem to generate an excel sheet that I want user to be able to download it once it''s generated. Please take a look on the below code: @contacts=Contact.find(:all) if @contacts.size>0 file="#{Date.today}_Report.xls" workbook=Spreadsheet::Excel.new("#{RAILS_ROOT}/public/reports/#{file}")

Hi I am using package RODBC version 1.0-1 under R version 1.7.1 on Windows XP Pro. I am having problems writing a new table to an (Excel) database using sqlSave. I connect to an empty Excel spreadsheet using odbcConnectExcel (which, I believe, uses the Microsoft Excel Driver DSN). Then I try and save a new table to the database(spreadsheet) using SqlSave, but obtain an error message. Below is

Under Windows, I have used RODBC to connect to Excel spreadsheets as per the example below: library(RODBC); connect = odbcConnectExcel("testdata.xls"); query = "SELECT [data$.ethn], [data$.sex], [data$.age], [data$.height], [data$.weight], [label$.label] FROM [data$], [label$] WHERE [data$.ethn] = [label$.ethn];" data =

DeaR all, I'd like to know how to create an Excel file with multiple spreadsheets from R. I searched the help files and found [1] but it is not what I want to do. Let's say I have a data frame called DF as in the following code # Some data set.seed(123) ID<-sample(5,100,replace=TRUE) X<-rnorm(100) Y<-rpois(100,10) Z<-X*Y DF<-data.frame(ID,X,Y,Z) str(DF) I'd like to

Hi All, Created xls file using spreadsheet Excel is not read on linux. I am creating an xls file are as follows workbook = Spreadsheet::Excel.new("Filepath") worksheet = workbook.add_worksheet("Sheet1") | | | workbook.close but when i am trying to download this it not get download. -- Posted via http://www.ruby-forum.com/.

Hi all, There have been quite a few threads in the recent months pertaining to the ability to directly write native Excel (.xls) files from R. For example, exporting R matrices and/or data frames to an Excel file, with perhaps the ability to create multiple tabs (worksheets) within a single file, with one tab/sheet per R object. There exists the xlsReadWrite package on CRAN by Hans-Peter Suter,

Hi, I encountered a problem of not being able to read in an excel spreadsheet using read.xls() in the xlsReadWrite package. can anyone help? Here is an example code write.xls(matrix(1:9,nrow=3),"ttt.xls") read.xls("ttt.xls") Error in read.xls("ttt.xls") : Unexpected error. Message: Can't find the file "ttt.xls" The "ttt.xls" file was

I'm having a problem that I've seen people talk about in the list archives. Unfortunately I haven't found any solutions that work. It is a documented bug and I've added my story to it. https://bugzilla.samba.org/show_bug.cgi?id=2346 I'm posting my problem here as well because it is causing me some serious grief. For the past few months I have been working towards

Hi all, I''ve a rails project which successfully uploads images on the development server but fails to do it on production. The only difference is that the production server is on https/ssl. On the browser the error message is the followin: ''Application error Rails application failed to start properly'' Whereas in the log/fastcgi.crash.log i found the followin error

Hello I am trying to import an *.xls spreadsheet into R. I am doing this as follows: > read.table(file("A5_DL.xls")) But obtain the error: Error in type.convert(data[[i]], as.is = as.is[i], dec = dec, na.strings = character(0)) : invalid multibyte string at '?????' So I copied it all over to a text document and tried to import that, thus: >

Hello All, I''m trying to figure out how respond_to actually works, especially with the increased focus on REST. After I set a MIME type for Excel Mime::Type.register "application/vnd.ms-excel", :xls In my index action''s respond_to block I have format.xls { @parts = Part.find(:all) headers[''Content-Type''] =

I have a client who used to have an NT server, we replaced it with Gentoo Linux and Samba v3.0.9 and they are now having what appears to be some sort of file-sharing issue with Excel. When a user opens an Excel file on the file server it opens properly, no errors or warnings of any kind. But when they try to save the file, Excel warns them that "the file may have changed by someone

> Hi, > > I am new to ruby on rails.I am having problem reading excel files. I > tried using gem ''parseexcel'' but still the error is coming. > Could you please help me with the code and how to use this gem? Is > there any better way to read excel sheets. > > Snippet of Code: > > require ''rubygems'' > require_gem

Has anyone ever seen it where every request tries to download a fcgi file but marked as a .rb file? Im running LightTPD 1.4, Ruby 1.8.4, FastCGI. The lighty config is... var.basedir = "/var/www/sites/" $SERVER["socket"] == "101.0.0.171:80" { var.servername = "stage.butlerandtanner.com" server.document-root = basedir + servername + "/public/"

All, I have run into a road block with my RoR project. The app works fine without SSL but when I try to upload a file with the site running in HTTPS, cgi.rb throws an EOFError: [13/Mar/2006:23:05:48 :: 22982] Dispatcher failed to catch: bad content body (EOFError) /usr/lib/ruby/1.8/cgi.rb:981:in `read_multipart?

Try the function sqlFetch to import the data in the spreadsheet. jo<-odbcConnectExcel("i:\\all\\sorkinjohn\\stats\\silvermannatalie\\NEMOcomb ined06-24-09.xls",readOnly = TRUE) mo<-sqlFetch(jo,'Your Sheet Name or Number',colnames=F,rownames=F) mo Hope it helps. ------------------------------------------------------------- MSc. Rodrigo Aluizio Centro de Estudos do

A path like this: \\samba\ä\a.xls cannot be found by Excel unless the user (or his group) has the write privilege on the file. (The funny looking directory name is a German "a" with a lazy colon on top of it, ASCII code 0xe4.) A symbolic link "ae->ä" solves the problem: \\samba\ae\a.xls pointing to the same file through an ASCII symbolic link is OK but

Hi,   I am trying to import data directly from an excel spreadsheet using the RODBC package. I am getting the following error messages, wondering if anyone can help me with it?   > connection = odbcConnectExcel('D:\\R files\\TestData.xls') > tables = sqlTables(connection) > tables    TABLE_CAT TABLE_SCHEM  TABLE_NAME TABLE_TYPE REMARKS 1 D:\\R files\\TestData        <NA>