You cannot post messages because only members can post, and you are not currently a member.
Description:
Support mailing list for the Ruby gem 'roo'
|
|
|
Roo Concerns
|
| |
Couple of Things 1. Is roo going to continue to be actively developed? I'm thinking about using it in a big project, but I'm concerned about the future of Roo since Hugh is no longer active and he is the only one, that I saw, that has the source on github. 2. Not so much of a concern, but I noticed that as of right now, you need... more »
|
|
|
(Errno: Errno:EACCES) - When trying to download excel file
|
| |
Hi,
I am trying to download / open a file from a url:
book = Excel.new( URL );
puts 'Loaded'
The file is downloaded and a new folder/excel sheet is created, though
an error occurs before the following statement (puts) is executed:
'unlink': Permission denied - { newly created filepath } (Errno:... more »
|
|
|
Unified parser object with auto detect
|
| |
In the README.txt file
s = Openoffice.new("myspreadsheet. ods") # creates an
Openoffice Spreadsheet instance
s = Excel.new("myspreadsheet.xls") # creates an Excel
Spreadsheet instance
s = Google.new("myspreadsheetkey_a t_google") # creates an Google
Spreadsheet instance... more »
|
|
|
Patch to support different cases in xlsx internal files
|
| |
Hello everyone, I tried to process the xlsx file with Roo, but I couldn't read any strings from the file. After frustrating for three hours or so, I found the reason (and solution). The internal file which contains strings had a non standard name - "sharedstrings.xml" instead of "sharedStrings.xml". I fixed the issue... more »
|
|
|
Install roo
|
| |
Hi all,
I have installed Ruby 1.8.7 and watir 1.4 and am trying to
install roo using the command
"gem install roo" and i get the foll error
Error installing roo:
C:\Ruby187>gem install roo
ERROR: Could not find a valid gem 'roo' (>= 0) in any repository
ERROR: Possible alternatives: roo... more »
|
|
|
Load numeric value as text
|
| |
Roo was implemented in our code which has caused me some issues. The
largest issue is how numeric values are loaded as floats. I've made
certain that the cell format is text but the value is still loaded as
a float. I read a post in another group perhaps where the author was
having the same issue but was able to get the value imported as a... more »
|
|
|
Currency Format
|
| |
Hi,
I have a column in my excel which is formatted with type currency.
When I convert that xlsx file to csv, I loose the format. I tried
adding that format to excelx.rb file but still no effect. How do I
preserve the currency format in my generated csv and also commas.
e.g.
1. In .xlsx, I have $0.24 rounded to 2 decimal places. While the csv... more »
|
|
|
Parse from column headers
|
| |
Can we parse from column headers instead of saying column names A, B,
C..? We can do that in fastercsv but I dont know whether we can do
this in Roo gem. Can nayone help?
|
|
|
