Stack Overflow
Stack Overflow

Questions tagged [rubyxl]

RubyXL is a ruby lib for reading/writing/modifying .xlsx and .xlsm files

RubyXL is a ruby lib for reading/writing/modifying .xlsx and .xlsm files

44 questions
0
votes
1 answer

Find first visible worksheet using RubyXL

I am parsing an Excel workbook using RubyXL and discovered that workbook[0] returns the first worksheet regardless of whether it is hidden. I would like to isolate the first visible worksheet by coding something like workbook[0].not_hidden. How can…
sscirrus
  • 55,407
  • 41
  • 135
  • 228
0
votes
1 answer

how to get specific value cell index using rubyXL gem

I have a static header in my excel template and I want to find each column cell index using cell value. Example: Row1: cell1, cell2, cell3 I want to find the cell index which has a value [cell3].
nirav kanani
  • 47
  • 8
0
votes
1 answer

Importing excel files into rails using RubyXL

I'm trying to build a simple excel importer using RubyXL in rails to display barcode numbers. What i want to do is import am excel file and display the barcode results on an index page. I'm running into a couple errors and I'm not sure what exactly…
Jacy
  • 1
0
votes
1 answer

RubyXL : How can I make a cell as dropdown in XLSX

I am using RubyXL gem to read and write a xlsm file.In my project there is a field Country which should diplay all list of countries in a dropdown in xlsm.I have tried with DataValidation but when I tried to open the file it is showing as 'We found…
Mary Reena
  • 1
0
votes
1 answer

Spreadsheet reader fails to detect fill colour unless file is opened + saved in LibreOffice

I'm using the RubyXL gem to read background colours of cells of an xlsx spreadsheet generated in Excel. This works fine if the file is opened or saved in LibreOffice. The fill colours are all detected as white ('ffffff') on the first read if this is…
Alex Arthur
  • 37
  • 5
0
votes
0 answers

How to close an open workbook using rubyXL gem

I have used below code to read and write from worksheet.But when the worksheet is already in open and if I try to run the code its failing because of permission error.I want to make sure when I hit the run the opened excel file should close. require…
Apzal Bahin
  • 61
  • 12
0
votes
1 answer

I would like to parse csv by ruby to create a report

I have a csv report with two rows which has headers of "Date" & "Customer_name": ["Date", "Customer_Name"] ["Monday", "John"] ["", "David"] ["", "Sam"] ["", "Kenny"] ["Tuesday", "Mary"] ["", "Jade"] ["", "Lindsay"] ["Wednesday", "Tom"] ["",…
new_2_programming
  • 3
  • 2
0
votes
1 answer

Send xlsx file to front end - AngularJS

I want to send xlsx file created by rubyXL gem to front end, which is AngularJS. When I save worksheet in a stream and send it by send_data method, I get the data, but I can't open the created document because it is broken. workbook =…
Max Rostov
  • 3
  • 6
0
votes
0 answers

The excel file does not show changes when writing through ruby script using rubyXL

require "uri" require "net/http" require 'HTTParty' require 'Nokogiri' require 'faker' require 'watir-webdriver' require 'rubyXL' @workbook = RubyXL::Parser.parse("02.xlsx") @worksheet = @workbook[0] @worksheet.change_row_fill(0,…
Hassan Abbas
  • 1,166
  • 20
  • 47
0
votes
0 answers

How to reduce the time of execution ruby/cucumber script

Basically below is my code,I try to verify every element from the excel sheet is present in the web page or not(Data is displayed in table format in web page). If it not there , the cell will be colored red else green. this code takes much time to…
RPD
  • 47
  • 8
0
votes
1 answer

trying to increment a value of the object by assigning to a variable i . Please advice

Below is my code.I'm trying to input value from the excel sheet to the text boxes in the page. Eg : In text box id is 'allocationRegContrib[17].newFundValue' I want to input a value say 20. Similarly for another text box whose id is…
RPD
  • 47
  • 8
0
votes
0 answers

How to fill color in each cell

I'm using Roo and RubyXL to modify an Excel spreadsheet. When I comment out the code that fills the color in the Excel sheet, then I do not get any error. My full code: require 'rubyXL' require 'roo' workbook =…
RPD
  • 47
  • 8
0
votes
1 answer

Can't read from xlsx file with rubyXL

I'm trying to work with excel files(xlsx) in ruby using rubyXl. I have no problem writing but can't get to output the content of a cell. require 'rubyXL' workbook =…
jvvpc
  • 3
  • 1
  • 5
0
votes
2 answers

Ruby : trying to install rubyXL gem from file

I am just starting with Ruby on Rails and need to use the RubyXL gem (https://github.com/gilt/rubyXL). I was told by one of the other devs to use bundle install. I cannot seem to get the syntax correct however, if I run "bundle install…
fred basset
  • 9,774
  • 28
  • 88
  • 138
1 2
3