Except win32ole is there any other package to drive excel,CSV operations using Ruby?
Thanks
Asked
Active
Viewed 72 times
0
Arup Rakshit
- 116,827
- 30
- 260
- 317
-
Do you want to tell Excel to do it, or do you want to directly manipulate the spreadsheet? – the Tin Man Jan 09 '13 at 21:18
-
There are at least two ways to deal with spreadsheets. You can have Ruby tell Excel to do things via OLE, or, you can open the spreadsheet in Ruby and load the CSV file and add it to the spreadsheet, without launching Excel. – the Tin Man Jan 09 '13 at 21:20
-
I mentioned not to use `win32ole`. Looking for alternatives! – Arup Rakshit Jan 09 '13 at 21:24
2 Answers
1
http://rubygems.org/search?utf8=%E2%9C%93&query=excel
Choose what you like. If you specify what you want to do, maybe we can help you more. Until then, look at the gems on this list, they should help you :)
Maximilian Stroh
- 1,086
- 1
- 10
- 26
-
-
since the file extension doesn't matter, just open the txt file. it should contain plain text. `File.open("your_file","r").read` and you'll get the contents as a string. – Maximilian Stroh Jan 09 '13 at 21:32
-
Use `File.read('your_file')` instead of `File.open("your_file","r").read`. – the Tin Man Jan 10 '13 at 03:20
1
I can't vouch for it, but roo exists. It's pretty old though.
writeexcel is newer, but I think it can only write to spreadsheets, not read.
edit
spreadsheet also appears to be up to date, but it's only compatible with MS excel, according to the documentation.
Zajn
- 4,078
- 24
- 39
-
`spreadsheet` or `writeexcel` contains more excel operations or both are same? – Arup Rakshit Jan 09 '13 at 21:23
-
At a glance, it looks like `spreadsheet` does. You'll have to look into it more yourself though. – Zajn Jan 09 '13 at 21:24
-