Υĩ`뷡泦霸ܲעǤߤ
?
0 likes?1,060 views
The document discusses using Ruby to add more powerful programming capabilities to Excel spreadsheets. It describes Excel as a commonly used but limited documentation tool in Japan. Ruby is proposed as a better alternative to the Visual Basic for Applications (VBA) language used for programming in Excel due to Ruby's support for regular expressions, UTF-8, closures, and object-oriented programming. The document then explains two approaches for using Ruby with Excel: using the Win32 OLE binding, which is powerful but only for Windows, and using JRuby with the Apache POI library, which supports older Excel formats but is more complex. It introduces POILite as a simpler Ruby wrapper for POI that treats Excel sheets like arrays and supports
Υĩ`뷡泦霸ܲעǤߤ
- 1. Υĩ`Excel Rubyע뤷Ƥߤ Let's injection dark ruby power to Holy Excel !RubyKaigi 2011 @koduki
- 2. about me Name : Hiroaki Nakada @twitter_id:koduki github C https://github.com/koduki
- 3. What is Excel ?
- 4. Very populer Docmentation tool in Japan
- 5. All document is written by Excel.
- 6. All document
- 7. orz
- 8. But
- 9. This is good tool to be written test data and so on.
- 10. But...
- 11. VBA (Visual Basic for Appliction)
- 12. We generate SQL, source code, XML, CSV, and so on, from Excel by VBA
- 13. Example
- 15. Not Support reguler expression Not Support UTF-8 Not Support Clouser Poor Syntax Not Support Real Object Oriented Poor Text Parsing
- 16. Ǵɷ
- 17. һΤΤ
- 18. Ruby
- 19. How do I use ruby for excel? Win32 OLE binding JRuby and POI
- 20. WinOLE32 Powerful API. Not only excel, but also IE, Outlook, and so on. Only windows plattoform.
- 21. JRuby and POI Apache POI.(Java Library) Support Excel 97, 2000, and 2003. A little complex.
- 22. More simply
- 23. I make it.
- 24. POILite Very simple POI wrapper for jruby https://github.com/koduki/POILite using Excel Sheet as simple arrray. you can write simple code. erb is very useful Example:Selenium Testcase Generator https://github.com/koduki/Tesla
- 28. build jar file > rake jar:package > java -jar dist/poilite.jar Not Install Ruby!
- 29. 夬X ⤦Τʤ
- 31. We should write test !
- 32. Thank you.