similar to: how to split, remove part of data in column with spreadsheet gem

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

The updated package has been submitted to CRAN and has begun to propagate to CRAN mirrors. Package: WriteXLS Version: 1.9.0 Description: Cross-platform perl based R function to create Excel (XLS) files from one or more data frames. Each data frame will be written to a separate named worksheet in the Excel spreadsheet. The worksheet name will be the name of the data frame it contains or can be

The updated package has been submitted to CRAN and has begun to propagate to CRAN mirrors. Package: WriteXLS Version: 1.9.0 Description: Cross-platform perl based R function to create Excel (XLS) files from one or more data frames. Each data frame will be written to a separate named worksheet in the Excel spreadsheet. The worksheet name will be the name of the data frame it contains or can be

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

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

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

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

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}")

Folks, Is there a parameter somewhere in RODBC that enables more columns to be retrieved from an Excel worksheet? # This next bit uses an undocumented call in RODBC z <- odbcConnectExcel("./BBaselinePtQaires_apr2011.xls") BQ <- sqlFetch(z, "BBaselinePtQaires") Gives me: z RODBC[1] And BQ 134 obs. of 59 variables I have all the rows in the worksheet but only the

The updated package has been submitted to CRAN and will propagate to mirrors over the next day or so. It is maintained on R-Forge at http://r-forge.r-project.org/projects/writexls, where downloads will eventually be available as well. Package: WriteXLS Version: 2.0.1 Description: Cross-platform Perl based R function to create Excel 2003 (XLS) files from one or more data frames. Each data

The updated package has been submitted to CRAN and will propagate to mirrors over the next day or so. It is maintained on R-Forge at http://r-forge.r-project.org/projects/writexls, where downloads will eventually be available as well. Package: WriteXLS Version: 2.0.1 Description: Cross-platform Perl based R function to create Excel 2003 (XLS) files from one or more data frames. Each data

> 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

Jorge was kind enough to point out that I made a mistake in referencing gabor's solution. See below. Thanks Jorge. -------- Begin forwarded message -------- Subject: Re: [R] Writing xls - multiple sheets Date: 3/12/2009 6:03:13 PM From: Jorge Ivan Velez To: markleeds@verizon.net Hi Mark, Yes, he did (as always), but it is not what Ferry needed. Here is Gabor's post:

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

The updated package has been submitted to CRAN and will propagate to mirrors over the next day or so. It is maintained on R-Forge at http://r-forge.r-project.org/projects/writexls , where downloads are available as well. Package: WriteXLS Version: 1.7.1 Description: Cross-platform perl based R function to create Excel (XLS) files from one or more data frames. Each data frame will be

The updated package has been submitted to CRAN and will propagate to mirrors over the next day or so. It is maintained on R-Forge at http://r-forge.r-project.org/projects/writexls , where downloads are available as well. Package: WriteXLS Version: 1.7.1 Description: Cross-platform perl based R function to create Excel (XLS) files from one or more data frames. Each data frame will be

A new package called WriteXLS (Version 1.5.0), containing a single function of the same name, is now available via CRAN. The package is made available under the GPL, version >=2. The function is based upon a Perl script that I have previously posted on r-help, now wrapped in R for convenience. It provides a cross- platform function to create Excel 2003 (XLS) files from one or more

A new package called WriteXLS (Version 1.5.0), containing a single function of the same name, is now available via CRAN. The package is made available under the GPL, version >=2. The function is based upon a Perl script that I have previously posted on r-help, now wrapped in R for convenience. It provides a cross- platform function to create Excel 2003 (XLS) files from one or more

The updated package has been submitted to CRAN and will propagate to mirrors over the next day or so. It is maintained on R-Forge at http://r-forge.r-project.org/projects/writexls , where downloads will be available as well. There is a transient problem at the moment with R-Forge and the build system, so there may be delays using R-Forge to get the updated package builds. Package: