While using the spreadsheet gem to export data to a Microsoft Excel file I encountered various problems and lack of proper documentation forced me to dig pretty deep. So here are a few tips you might find useful. The gem works with a workbook object and worksheets in this workbook. To get started: workbook = Spreadsheet::Workbook.new sheet1 = workbook.create_worksheet name: worksheetname To write a row of data as usually is done in reports you can use: sheet1.row(1).replace [ 'col1', 'col2', 'col3'] Rows and Columns are 0 based, so col1 would be printed on A2 (Excel coords). Now to the beauty of it all, formatting, first of all, create a format: bold = Spreadsheet::Format.new :weight => :bold bold20 = Spreadsheet::Format.new :weight => :bold, size: 20 nobold20 = Spreadsheet::Format.new size: 20 bold_grey_bg = Spreadsheet::Format.new pattern_bg_color: :cyan, weight: :bold, pattern: 1, pattern_fg_color: :black Use :weight to set bold,...
Let Your Creativity Fly... Ubuntu Studio. A multimedia creation flavor of Ubuntu. Ubuntu Studio is aimed at the GNU/Linux audio, video and graphic enthusiast as well as professional. We provide a suite of the best open-source applications available for multimedia creation. Completely free to use, modify and redistribute. Your only limitation is your imagination. Source: ubuntustudio.org
A group of assailants got a little more than they bargained for when an entire ninja school came to their victim's rescue . A 27-year-old German exchange student was being mugged in an alley near Ninja Senshi Ryu, when a ninja student noticed the commotion. The sensei along with the rest of the students rushed out to help. "You should have seen their faces when they saw us in ninja gear coming towards them," the school's sensei, Kaylan Soto, told the Herald. It's good to see ninjas working on their brand. When I was a kid they were mostly shurikens, smoke, and attitude. Source: slashdot.org