Actions

Excel to Database to Excel, a Round Trip via Rails

-


Event
MinneBar 10 (11 April 2015)
Panel
This is not a panel.
Summary
None
URL
Topic
Schedule
2015-04-11 13:45


Room: Louis Pasteur


Presenters

[[Image:|120x120px|border|baseline|link=Ben Leadholm]]
Ben Leadholm



Businesses have too much logic encapsulated in Excel workbooks. This is *so* twentieth century. Learn how to migrate your worksheets into database tables, and leverage the Rails platform to perform calculations, sorting, and reporting. Learn how to export information into Excel workbooks to share with colleagues.

OS Platform: (primary) Windows and (optional) Mac OS

INTRO (Part I) : Intro to Rails, Databases, and why you should migrate business logic away from Excel.

Part II: How to set up Ruby and Rails on a Windows notebook.

Part III: How to leverage Rails and Gems to migrate Excel workbooks (both in the old .xls and new .xlsx formats) to database tables.

Part IV: How to perform calculations in Structured Query Language (SQL). If there is time, we will explore

Part V: How to leverage Rails to display your data in different formats.

Part IV: How to export your data as an Excel workbook, with different formatting.

blog comments powered by Disqus



MediaWiki spam blocked by CleanTalk.