Hello, Is it possible to access Excel spreadsheets through ruby? If so is there somewhere a code example I can have a look at? Thanks, Bernd
on 2006-02-07 03:37
on 2006-02-07 04:05
I've seen something in the source code... /usr/share/doc/ruby-docs-1.8.4/ext/win32ole/sample/ require 'win32ole' #application = WIN32OLE.new('Excel.Application.5') application = WIN32OLE.new('Excel.Application') application.visible = TRUE workbook = application.Workbooks.Add(); worksheet = workbook.Worksheets(1); worksheet.Range("A1:D1").value = ["North","South","East","West"]; worksheet.Range("A2:B2").value = [5.2, 10]; worksheet.Range("C2").value = 8; worksheet.Range("D2").value = 20; range = worksheet.Range("A1:D2"); range.Select chart = workbook.Charts.Add; workbook.saved = TRUE; application.ActiveWorkbook.Close(0); application.Quit(); On Tue, 7 Feb 2006 10:36:00
on 2006-02-07 04:17
DÅ?a Utorok 07 FebruÃ¡r 2006 02:36 Paatsch, Bernd napÃsal: > Hello, > > Is it possible to access Excel spreadsheets through ruby? > If so is there somewhere a code example I can have a look at? > > Thanks, > Bernd If the machine in question is a Windows box with Excel already installed, your best bet is probably using Win32OLE and accessing an Excel interface via COM. Best look at Win32OLE, and Windows / Excel automation docs. http://www.rubygarden.org/ruby?ScriptingExcel looks like good introductory sample code too. If not, I can only recall a writer package that worked with the binary format, and I had mixed success getting it run on and off Cygwin. There might be something out there that will let you read the zipped XML format out there, but I can't recall anything off the top of my head, nor see something that flicks a lightbulb on in the first screen of googlage results. You might feel particularly adventurous and try compiling the POI ruby bindings, if the thought of working with with GCC compiled Java doesn't scare you. (It does indeed scare me...) That said, the topic is also fairly recurrent on the list in my opinion, so give searching the ML archives a try too. David V.
on 2006-02-07 06:40
Paatsch, Bernd wrote: > Hello, > > Is it possible to access Excel spreadsheets through ruby? > If so is there somewhere a code example I can have a look at? > > Thanks, > Bernd I once counted 5 ways to get at Excel data: CSV, OLE, XML, ADO and i can't remember what the other one was.
on 2006-02-07 10:02
There are lots you can do, some pointers have already been posted. Please feel free to specify your needs more clearly and we can adress them together. All the best Jon Egil S. -- Jon Egil S. Phone: +47 98232340 firstname.lastname@example.org
on 2006-02-07 16:06
Paatsch, Bernd wrote: > Is it possible to access Excel spreadsheets through ruby? > If so is there somewhere a code example I can have a look at? In case you missed this: http://groups.google.com/group/comp.lang.ruby/brow...