similar to: Import data from dynamically changing spreadsheet

Dear all, For the export to excel functionality i have used Spreadsheet::Excel gem it works fine. i would like to design the excel sheet with html ,css.(i want to give color and height and width to each cell of the excel sheet...) I have goggled for this but nothing saved me... please u people suggest me any sample code or links that i can try with... Thank you for your time to view my query

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

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

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.

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 am Generating the Excel sheet using the ruby on rails I installed the gem spreadsheet/excel and the spreadsheet and in my code i wrote the lines require ''spreadsheet/excel'' require ''spreadsheet'' i used to format the excel sheet wb = Spreadsheet::Excel.new(path) # creates the Excel sheet ws = wb.add_worksheet("employee") # creates the work

Hi colleages! I want to import data from ms-excel and other spreadsheet formats (lotus, etc). Does exist any way to do it within R? The main problem is that many spreadsheet data use comma as decimal separator and not the point as needed in R (and many software for Linux), so importing data first as a tab separated values does not solve this problem. Thanks, Tom?s Revilla

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 =

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

The first column in my Excel sheet has mostly numbers but I need to treat it as character data: > library(RODBC) > channel <- odbcConnectExcel("U:/efg/lab/R/Plasmid/construct list.xls") > plasmid <- sqlFetch(channel,"Sheet1", as.is=TRUE) > odbcClose(channel) > names(plasmid) [1] "Plasmid Number" "Plasmid"

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,

http://www.loligo.com/asterisk/misc/Presentations/Asterisk-features-20040106.xls I had been asked a while ago to put together a short Excel spreadsheet listing many of the "common" features of Asterisk as compared to a typical PBX. Many PBX vendors supply an exhaustive list of their features, and I figured I'd take as many of the unique features as others had offered, and put

Dear list, I'm running windows xp with R 2.12.0. I'm trying to load a excel spreadsheet into R using the xlsx package. I posted my code below with the error I get. > res <- read.xlsx("Copy of test_excel_input_data.xlsx", 6) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.IllegalStateException: Cannot get

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.

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

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

When I read excel files using the read.xlsx() command any cells that have formulas in them come up as NA. Is there a way to read just the numeric value of the cell without using the "paste value" command in Excel? I need to read in hundreds of Excel spreadsheets and compile them into one large super spreadsheet automatically. Hence the reason I cannot reformat each sheet manually.

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.

Hello, I experimented the Metafor and Meta packages in the scope of replacing Excel for meta-analysis. I performed the first working example provided in Michael Borenstein's book "Introduction to Meta-Analysis" with Excel, Metafor and Meta. The numbers given by my spreadsheet, which I validated from Borenstein's book, conrespond quite closely to those given by Meta, but