Skip to content

Instantly share code, notes, and snippets.

View zdavatz's full-sized avatar
🎯
Focusing

Zeno R.R. Davatz zdavatz

🎯
Focusing
View GitHub Profile
@zdavatz
zdavatz / klehner sample code spreadsheet ruby erb
Created April 8, 2011 07:45
klehner sample code spreadsheet ruby erb
@workbook = Spreadsheet.open(dummyPath, "rb+")
@inputDate = # some user-entered string
<p>Worksheet name is :<%= sheet.name %></p>
<table border="1">
<% sheet.each do |row| %>
<tr>
<% (0..sheet.column_count).each do |col|%>
<% format = row.format(col) %>
<td>
<% if row[col] == @inputDate # what am I comparing here? %>
@zdavatz
zdavatz / suite.rb
Created July 20, 2011 13:23
spreadsheet test/suite.rb
~/.software/spreadsheet/test> ruby suite.rb
Loaded suite suite
Started
.................................................
Finished in 1.620807 seconds.
49 tests, 929 assertions, 0 failures, 0 errors
@zdavatz
zdavatz / raffi.rb
Created August 23, 2011 09:21
spreadsheet 0.6.5.7
require 'rubygems'
require 'spreadsheet'
book = Spreadsheet.open '/tmp/test.xls'
#r = book.worksheets[0].row(0)
#r[1] = "B1"
book.write 'in-one-cell-out-1.xls' # this needs to be repaired in Excel 2010
r = book.worksheets[1].row(0)
r[1] = "B2"
book.write 'in-one-cell-out-2.xls' # good
@zdavatz
zdavatz / gist:1306123
Created October 22, 2011 15:38
Jason Hanks, Ruby Spreadsheet problem with JReport
require 'rubygems'
require 'test/unit'
require 'spreadsheet'
class TC_SpreadsheetExcel < Test::Unit::TestCase
def spreadsheet_info(filename)
puts "-----------------------------------------"
puts " File: #{filename}"
puts "-----------------------------------------"
@zdavatz
zdavatz / 01_oddb_vhost.conf
Created January 25, 2012 08:05
working /etc/apache2/vhosts.d/01_oddb_vhost.conf for mod_ruby 1.3.0 (ruby 1.8)
<Directory /var/www/oddb.org/doc>
Options ExecCGI FollowSymlinks Indexes
AllowOverride None
Order allow,deny
Allow from all
</Directory>
<Directory /var/www/oddb.org/data/css>
Order allow,deny
Allow from all
</Directory>
@zdavatz
zdavatz / 21_mod_ruby.conf
Created January 25, 2012 08:06
/etc/apache2/modules.d/21_mod_ruby.conf from gentoo
<IfDefine RUBY>
LoadModule ruby_module modules/mod_ruby.so
# taken from the example file
# If the ruby module is installed, this will be enabled.
# for Apache::RubyRun
RubyRequire apache/ruby-run
# exec files under /ruby as ruby scripts.
<Location /ruby>
@zdavatz
zdavatz / kernel_config_3.2.1
Created February 7, 2012 09:03
kernel_config_3.2.1
#
# Automatically generated file; DO NOT EDIT.
# Linux/x86_64 3.2.1 Kernel Configuration
#
CONFIG_64BIT=y
# CONFIG_X86_32 is not set
CONFIG_X86_64=y
CONFIG_X86=y
CONFIG_INSTRUCTION_DECODER=y
CONFIG_OUTPUT_FORMAT="elf64-x86-64"
@zdavatz
zdavatz / gentwoo emerge error
Created February 7, 2012 20:35
gentwoo emerge error
Calculating dependencies... done!
>>> Verifying ebuild manifests
>>> Emerging (1 of 1) app-portage/gentwoo-0.0.20120206.1 from betagarden
>>> Failed to emerge app-portage/gentwoo-0.0.20120206.1, Log file:
>>> '/var/tmp/portage/app-portage/gentwoo-0.0.20120206.1/temp/build.log'
>>> Jobs: 0 of 1 complete, 1 failed Load avg: 0.29, 0.08, 0.07
* Package: app-portage/gentwoo-0.0.20120206.1
* Repository: betagarden
* Maintainer: naota@gentoo.org
@zdavatz
zdavatz / ImageMap
Created August 13, 2012 11:31
ImageMap
<img src="Abilify_30_Mg_Oral_Tablet_0.jpg" width="860" height="800" border="0" usemap="#map" />
<map name="map">
<!-- #$-:Image map file created by GIMP Image Map plug-in -->
<!-- #$-:GIMP Image Map plug-in by Maurits Rijk -->
<!-- #$-:Please do not edit lines starting with "#$" -->
<!-- #$VERSION:2.3 -->
<!-- #$AUTHOR:Unknown -->
<area shape="circle" coords="231,300,174" alt="Fachinfo von Hypericum-Mepha® 250/500 Lactab" target="Fachinfo von Hypericum-Mepha® 250/500 Lactab" href="http://ch.oddb.org/de/gcc/fachinfo/swissmedicnr/61367" />
<area shape="circle" coords="650,300,167" alt="Preisvergleich Inderal 40 mg" target="Preisvergleich Inderal 40 mg" href="http://ch.oddb.org/de/gcc/compare/ean13/7680317061227" />
require 'net/http'
# create a path to the file "C:\RailsInstaller\cacert.pem"
cacert_file = File.join(Dir.home, "cacert.pem")
Net::HTTP.start("curl.haxx.se") do |http|
resp = http.get("/ca/cacert.pem")
if resp.code == "200"
open(cacert_file, "wb") { |file| file.write(resp.body) }