similar to: Spreadsheet problems

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

Hello R List... I am seeking to continually make a call to an excel sheet and pull data from it. The data on the excel sheet keeps changing real time and I need to pull this data in R. Can someone please suggest me how to do the same. Thank you. -- View this message in context: http://r.789695.n4.nabble.com/Import-data-from-dynamically-changing-spreadsheet-tp2310626p2310626.html Sent from the R

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 &

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.

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

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

I''m currently new to Rails and Ruby and I''m trying to learn from my mistakes, this time I''m trying to upload 2 files from a form for later processing, however, after I hit the "Submit" button. I keep getting this error: TypeError in UploadFilesController#create app/controllers/upload_files_controller.rb:28:in `new''

I am happy to announce that a new version of xlsReadWritePro is available. xlsReadWritePro natively reads and writes Excel files (v97 - 2003) on Windows. The pro version is more powerful than the free version but, beeing a small company, we ask you to support our development and maintenance effort. The following capabilities have been added (compared to xlsReadWrite): ? in-memory objects

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 =

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

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

People, I thought I needed to have some familiarity with NNs for some of my current (non-profit, brain-related) projects so I started looking at various programming environments including R and I got this working: http://gekkoquant.com/2012/05/26/neural-networks-with-r-simple-example however I needed pictures to help understand what was going on and then I found this:

Hello, I''m developing an app that basically, receives a 10MB or less XLSX files with +30000 rows or so, and another XLSX file with about 200rows, I have to read one row of the smallest file, look it up on the largest file and write data from both files to a new one. I just did a test reading a few rows from the largest file using ROO (Spreadsheet doesn''t support XSLX and

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

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