Stack Overflow
Stack Overflow

Questions tagged [roo]

Please use either spring-roo or roo-gem

104 questions
6
votes
2 answers

roo gem file .xlsx does not exist

I use cloud9 ide to use ruby on rails! I'm testing the gem 'roo' to bring excel file to my DB. before I do it, I wanted to test this gem work. gem doc : https://github.com/roo-rb/roo but there is a problem to bring file! The error message is like…
Hyung Kyu Park
  • 255
  • 2
  • 3
  • 12
5
votes
0 answers

Carrierwave: How to unmount Uploader for batch upload

I have a Product model which has an :image attribute. It uses carrierwave for image uploading: mount_uploader :image, ImageUploader That works fine for my New/Edit form but since I have a batch upload option using roo gem for excel upload,…
Bassman
  • 99
  • 10
4
votes
5 answers

undefined method `fetch_value' for nil:NilClass when using Roo

I am trying to use Roo to import data from an Excel spreadsheet into a table (data_points) in a Rails app. I am getting the error: undefined method `fetch_value' for nil:NilClass and that error references my data_point.rb file at line (see below…
WallE
  • 83
  • 1
  • 1
  • 9
4
votes
1 answer

Importing a csv with Roo of 55 rows is causing an ActionDispatch::Cookies::CookieOverflow

I'm using roo-rb/roo to import csv files of data into my database. But with 55 rows, 4 columns, I am getting an ActionDispatch::Cookies::CookieOverflow error. Anyone know what could be causing this or what would be trying to create this cookie…
Sean Keating
  • 1,718
  • 14
  • 28
3
votes
2 answers

Unable to launch Eclipse neon 4.6 - asks for roo distribution

I installed Eclipse Neon 4.6 on my linux (Mint) OS. After unsuccessfully trying to install STS (Spring), I uninstalled and reinstalled using the update site - http://dist.springsource.com/release/TOOLS/update/e4.6/. Now, when I launch eclipse,…
Venkat M
  • 31
  • 1
3
votes
0 answers

OLE2 signature is invalid when trying to open my XLS file

I'm using the Roo gem, and the following code: Roo::Excel.new(file.path) This raises the following exception: Ole::Storage::FormatError: OLE2 signature is invalid The file I'm using its a .xls, when I open it and re-saved it from LibreOffice it…
victorhazbun
  • 786
  • 8
  • 16
3
votes
0 answers

Issue import cell string using roo

When I import an excel data file is saving format as number. Excel example |num_doc| |name| 1234 CR7 5678 Beckham 9102 Bush Controller client_controller.rb: def import Client.import(params[:file]) end Model client.rb @errors =…
Carlos Morales
  • 1,137
  • 3
  • 15
  • 38
3
votes
1 answer

How to open xls files with roo

I have an ".xls" file, and I have to open it with roo, and it have to be opened with rake. This is my rake file: require 'roo' namespace :exel do task open: :environment do workbook = Roo::Excel.new("lib/tasks/users.xls") …
Kazik
  • 705
  • 1
  • 8
  • 20
3
votes
0 answers

Roo shell not being able to install jdbc bundle due to slf4j dependencies

I'm stuck trying to setup a DRBE project with Roo 1.3.1 current release. I setup the project within STS latest version on latest eclipse release also, all fresh new install to avoid conflicts. Then I setup via Roo shell the JPA, user, database, and…
Leo Nomdedeu
  • 338
  • 2
  • 5
3
votes
2 answers

Perform command does not work in Spring Roo

When running the 'perform tests' command in Roo I get the following error: createprocess error=2,the system cannot find the file specified. Now, all the posts on the net suggest that maven should be in PATH. I did that, I rebooted, my maven…
fonZ
  • 2,428
  • 4
  • 21
  • 40
3
votes
1 answer

Export Excel (xls or xlsx or CSV) sheet with validation/ rule applied on column

I want to export a template Excel sheet, so that user can fill it and can upload with their data. In exported sheet, I want to put some validation or rule on column values. So that, user only can fill the value as per rules applied which can be only…
Kamesh
  • 471
  • 1
  • 4
  • 19
2
votes
0 answers

Could not find artifact javax.xml.crypto:xmldsig

Each time when I'm trying to build the Spring application I got an error: im@im:~/projects/nsn_maintenance_be/maintenance$ mvn clean install [INFO] Scanning for projects... [INFO] …
Max Gabderakhmanov
  • 912
  • 1
  • 18
  • 36
2
votes
0 answers

Loading external DLLs (e.g. stringio.so) in embedded Ruby interpreter

I'm using the Ruby interpreter embedded in the game Dwarf Fortress (it ships with 1.8.x, but I've replaced the DLL with 1.9.3), and I'm trying to include the Roo library so I can work with spreadsheets. puts(RUBY_DESCRIPTION) def addDir(libdir) …
jimbofreedman
  • 332
  • 3
  • 10
2
votes
1 answer

How to ignore hidden sheets when importing xlsx files with rails and roo

I am using Roo to import xlsx files into my rails app. The imports work fine, however, while trying to make a 'workbook' importer instead of just a 'worksheet' importer, I noticed that there are tons of hidden sheets on some of the files. For…
Joseph Freivald
  • 396
  • 2
  • 17
2
votes
4 answers

Validation of uploaded Excel file before save using Rails with Roo-xls gem

In a model, before uploading an .xls file, I want to be able to validate excel files before they are saved by the application. I am trying to open the to-be-saved excel file from the :file_url object(column in comits table where the .xls files will…
Raymond Ruiz-Veve
  • 167
  • 12
1
2 3 4 5 6 7