similar to: Using spreadsheet gem with Oracle data

Hi All, In my code @format_text = @workbook.add_format(:bold =>false) I get following error undefined method `font'' for {:bold =>false}:Hash in gems/spreadsheet-0.6.4/lib/spreadsheet/excel/writer/workbook.rb:352 when i try to export data into the XLS i am using following gems spreadsheet --version 0.6.4 spreadsheet-excel --version 0.3.5.1 My problem is when i use same code

Hi everybody I''am working on a Rails app (using utf-8) in which I use the Spreadsheet gem to generate Excel files (.xls in my case). I ran into some issues when trying to write foreign characters to the generated Excel-File. The solution I found so far is to use Iconv like this: Iconv.conv(''ISO-8859-9'', ''utf-8'', some_string) This works fine with for

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/.

Hello, I use a software that outputs the data in a form/dialect(?) of xml (I think its called "SpreadsheetML", see below for an excerpt). It allows (admittedly) easy import of such files into Excel. I would like, however, to import it directly into R. I am familiar how to do that with standard xml-files (mostly thanks to Duncan Temple Lang's help). But I haven't found the right

Hello all, As much as I hate saying this, I would like to maintain 2 copies of some data, one copy in the form of a table in a database, and one in the form of an Excel spreadsheet. Unfortunately, either or both copies may be modified, so I need some way to synchronize the two, much the same way as a contacts database might be synchronized between a PDA and a desktop application. I am curious to

Hi, I''m having the error: Iconv::InvalidEncoding: invalid encoding (""ISO-8859-1"", "UTF-8") when trying to post via Mechanize. It used to work just fine, but the error appeared after (I think) upgrading to Rails 2.3.2, Ruby 1.8.7, Mechanize 0.9.2 (I upgraded a while ago and only now noticed the problem). What does it mean? Is there any way to

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 &

Is there a gem that will present things in a spreadsheet-like style? I tried searching via both Google and rubygems.org and found mainly things to import and export .xls[x] and Google Spreadsheets. There was also the Exercise gem, which had zero documentation about what it *does*, which doesn''t make me confident in using it. Why do I ask? I''ve made a little app

Using spreadsheet gem and rails MY CODE GOES BELOW: book = Spreadsheet.open ''excel-file.xls'' sheet = book.worksheet 0 book.write ''output-file.xls'' and here goes the first problem: I want to remove data that comes after ";" (semicolon) in a column. Example below. FULTON BANK NA;FULTON BANK I just want it to be FULTON BANK NA for example.

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, Does anyone know if there is a way to generate Excel spreadsheets with landscape orientation with the Spreadsheet gem? -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to

I have a number of actions that use the spreadsheet/excel library to generate an Excel spreadsheet based on model data and send it to the user using the send_file method. For a while, I''ve been testing these methods with assert_response :success, and then checking the response headers to make sure the file at least looks like what I should be getting. But it occurred to me recently that

> 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

R version 2.13.1 OS X (or Windows) Colleagues, I received a number of files with a .xls extension. These files open in XL and, by all appearances, are XL files. However, it appears to me that the files are actually XML: > readLines(dir()[16])[1:10] [1] "<?xml version=\"1.0\"?>" [2] "<Workbook

Ilio Fornasero writes: > Yet, I am at this point. > > > > > ## 01. Finding the dataverse server and making a search > Sys.setenv("DATAVERSE_SERVER" =3D "dataverse.harvard.edu") > dataverse_search(".Hunger") > > > ## 02. Loading the dataset (in this example, I have chosen the word ".Hunge= > r" to get > # one list and

I am having a problem in reading the columns from an xls file. Following is the code: workbook = Spreadsheet::ParseExcel.parse(params[:dump][:file]) worksheet = workbook.worksheet(0) skip=0 worksheet.each(skip) { |row| puts row.at(0) } I am storing "Customer" in the first row first column. When I print, it is received as

Dear Group, I hope someone out there can help me with this. I am building a Rails 2.0 application for a customer. The customer has a number of Excel spreadsheets which he would like his customers to open and complete online then submit the completed spreadsheet to him via email. A typical scenario would be: (1) The ''empty'' spreadsheets are provided as a list on the web site.

Hello, After I use the lm() function to perform a multiple linear regression, and then use the step function to eliminate variables that predict the weakest, I need to export the final equation to a spreadsheet or a text file. Below is some sample code. In the end I want to export the coefficients to a spreadsheet. Will you please direct me to the appropriate syntax? Thanks for your time, --Eric

Hello all: As everyone knows the stock quotes in Yahoo can be downloaded directly on EXCEL spreadsheet. we can also use the simple sentence of package tseries of R to download Yahoo quote: x <- get.hist.quote(instrument = "ibm", start = "2010-01-01", quote = "close") x The result will display on the R console.

Hey, I want to regenerate a excel spreadsheet and send it to the browser. The excel sheet does maybe have 5 tabwindows and a lot of formulas. I use to make spreadsheet just for exporting records, but that was just making a rhtml with ";" as delimiter and set @headers["Content-Type"] = "application/vnd.ms-excel;charset=iso-8859-1" I have tried spreadsheet-0.3.2