rubyXL

rubyXL copied to clipboard

So here is what I'm trying to do: 1) Given an excel file with a single sheet it in (the template sheet) 2) Duplicate that sheet one or more times...

MyklClason

Convenience method for accessing individual merged cells, rather than just a reference

11

Merged cells are a little bit of a red herring. Sometimes you want to access the actual cells rather than the reference/the MergedCell's. For example to obtain indivual borders for...

caramdache

xlsm format not working

8

I'm generating a xlsm format but office 365 excel can't open it ```ruby workbook = RubyXL::Workbook.new worksheet = workbook.add_worksheet('Sheet2') worksheet.add_cell(0, 0, 'Test') # Sets cell A1 to string "Test" workbook.write("file.xlsm")...

bouaik

Sticky rows

5

Hi guys, First of all, thanks for this awesome gem :-) I have been looking for a way to implement sticky rows, unfortunately without success. If this is not a...

jurriaanschrofer

insert_row: bad value for cell#column and cell#worksheet

14

After inserting a new row in a worksheet, it appears that the newly created cells are missing some attributes: the following code can be used as a workaround: ``` r...

lionelperrin

Performance Issue on writing, and trying to fix it

5

*I open this thread related to what I've posted #245* *Because initially the problem was on import/update of a excel file, and in my case on export.* *See progress here:...

anykeyh

Images in other sheets seems to corrupt file

2

I'm experiencing a strange problem. I have an excel file with several sheets where there is a company logo at the top of each sheet. However, when I try to...

mlmagnussen

Anyone assist me to add comment in XLSX file using RubyXL?

13

I'm using rubyXL (3.3.17). I want to add comment in cell. It would be helpful if anyone assist me on it. I need syntax to insert comment.

PriyankaRPathak

How to write a hyperlink to a cell?

14

Hello, Currently, I trying to write a hyperlink to . xlsx file like so - `sheet1.add_link(i, 3, "http://app.com/barcodes/#{bar_code_image}.png")` The cell turns to be in text format by default. How can...

SingularityMatrix

Error recovery when opening MS Excel:

6

Hi, using rubyXL, I am transforming an existing MS-Excel into a new one... When I open the new one, MS-Excel reports an error and tries to fix the errors... **Excel...

kyalpani