Comments (2)
Hi please find the details,
require 'roo'
xls = Roo::Spreadsheet.open('spreadsheet_test.ods') do
sheet = xls.sheet(0)
puts sheet.cell(1, 1)
sheet.set(3, 3, "test")
end
- Roo version : 2.8.3
- Ruby version : 2.5.3
(Tried with ruby version - Ruby 2.7.1 which isn't works as well)
- MIMP : The test is not failing , but it is nothing writing in the cell of the spreadsheet.
I am attaching the spreadsheet please find.
- 0> xls.officeversion
=> "1.2"
please let me know further. Thanks
from roo.
Hey @SP8890
roo is not design to write to sheets but purely parse and read the entries.
There are other libraries that do support writing sheets with some support but as far as I understand this is not planned for roo in the near future.
from roo.
Related Issues (20)
- More XLSX methods
- Workaround needed for: open html-as-xls file HOT 1
- invalid value for Integer(): "" HOT 1
- Version 2.9.0 installed from RubyGems still not compatible with Ruby 3? HOT 2
- support for xlsb HOT 1
- Add support for boolean values in open office files exported via Google Sheets
- Excel can store dates in exponent form which causes dates to incorrectly parse to year 1900
- Tempfile cleanup causes warning on Ruby 3.1 when using Spring (or other forking preloader)
- [Doc] Iterate through each sheet with "each_with_pagename" not working anymore HOT 2
- previously exported Spanish accents couldn't be imported correctly.
- Incorrect date parsing in xlsx files to Sat, 15 Jul 1905 HOT 2
- Reading of xlsx fails if any datetime-cell is also linked
- undefined method `upto' for nil:NilClass
- Warnings are displayed when roo is used with Ruby 3.3.0 HOT 3
- New Release with fix for Roo::Base#each_with_pagename HOT 2
- FODS support?
- Unable to read content in Cell Comment
- Ruby 3.4.0: Add csv to your Gemfile or gemspec HOT 1
- With Excel sheets, cells with "0%" are converted to 'N/A' in the csv file.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from roo.