rubyµÄExcel²Ù×÷
require 'win32ole'
excel = WIN32OLE::new('excel.Application')
workbook = excel.Workbooks.Open('E:\RubyApp\bmk.xls')
worksheet = workbook.Worksheets(1) #get hold of the first worksheet
worksheet.Select #bring it to the front -need sometimes to run macros, not for working with a worksheet from ruby
#excel['Visible'] = true #make visible, set to false to make invisible again. Don't need it to be visible for script to work
#value1=worksheet.Range('a12')['Value'] #get value of single cell
#puts value1
#data = worksheet.Range('a1:c12')['Value'] #read into 2D array
#data.each do |data1|
#data1.each do |data2|
#puts data2
#end
#end
line = '1'
while worksheet.Range("c#{line}")['Value']
line.succ!
end #line now holds row number of first empty row
puts line
#i=3
#puts worksheet.cells(i-1,1).text[8,16].to_i+1
#´¦Àí×¼¿¼Ö¤ºÅ£¬ÈÃËü×Ô¶¯Ôö¼Ó
#while i < line.to_i
for i in 3...line.to_i
worksheet.cells(i,1).value="00320501"+(worksheet.cells(i-1,1).text[8,15].to_i + 1).to_s
worksheet.cells(i,2).value="320501"+(worksheet.cells(i-1,2).text[6,13].to_i + 1).to_s
if worksheet.cells(i,7).text.length==18
worksheet.cells(i,5).value=worksheet.cells(i,7).text[6,8]
else
worksheet.cells(i,5).value="19"+worksheet.cells(i,7).text[6,6]
end
worksheet.range("h#{i}").value=worksheet.range("h#{i-1}").value.to_s
worksheet.range("i#{i}").value=worksheet.range("i#{i-1}").value.to_s
worksheet.range("k#{i}").value=worksheet.range("k#{i-1}").value.to_s
worksheet.range("l#{i}").value=worksheet.range("l#{i-1}").value.to_s
worksheet.range("o#{i}").value=worksheet.range("o#{i-1}").value.to_s
worksheet.range("p#{i}").value=worksheet.range("p#{i-1}").value.to_s
worksheet.range("q#{i}").value=worksheet.range(&
Ïà¹ØÎĵµ£º
Ruby 101£º¶ÔÏóºÍ·½·¨
Written by Allen Lee
´Ó¾²Ì¬·½·¨ËµÆð
ÔÚÉÏһƪÎÄÕÂĩ⣬ÎÒÃÇÌáµ½ÁËÊܱ£»¤µÄ¾²Ì¬·½·¨……Êܱ£»¤µÄ¾²Ì¬·½·¨£¿£¿RubyµÄprotected²»ÊÇÓÃÀ´ÏòÏàͬÀàÐ͵IJ»Í¬ÊµÀý¿ª·ÅÊÜÏÞ·½·¨µÄ·ÃÎʵÄÂð£¨Íü¼ÇprotectedµÄÓ÷¨ÁË£¿²»Òª½ô£¬»ØÈ¥ÉÏһƪÎÄÕ¸´Ï°Ò»Ï°ɡ££© ......
±¾ÎĽéÉÜÁËRuby on RailsµÄÏêϸ°²×°²½Öè¡£ÎÄÖÐʹÓõÄRuby on Rails°æ±¾ÊÇ1.8.6-26¡£°²×°RubyÖ®ºó°²×°Rails£¬È»ºó¾Í¿ÉÒÔ´´½¨WebÓ¦Ó㬲¢ÔÚ±¾µØ²âÊÔÁË¡£
1¡¢°²×°ruby
²»ÓÃ˵ ÊÇÏÂÔØ°²×°°ü£ºhttp://rubyforge.org/frs/?group_id=167£¬×¢Òâ°æ±¾---º¦È˲»Ç³£¬ºóÃæ»á˵µ½£¬ÎÒϵÄÊÇ1.8.6-26
×°Íêºó£¬¿ÉÒÔÓÃruby -v ²âÊÔÊÇ·ñ° ......
<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 680460288 22 0 262145 0;}
@font-face
{font-family:"Cambria Mat ......
Ruby 101£º¶¯Ì¬±à³Ì
Written by Allen Lee
µ±method_missingµÄħ·¨Ê§Ð§Ê±……
ÔÚÉÏһƪÎÄÕÂÀÎÒÃÇͨ¹ýÖØдHashÀàµÄmethod_missing·½·¨°ÑHash¶ÔÏóÄ£Äâ³ÉÄäÃû¶ÔÏ󣬵«ÊÇ£¬ÕâÖÖ×ö·¨ÓÐʱ»á²úÉúһЩĪÃûÆäÃîµÄÎÊÌ⣬¾Ù¸öÀý×Ó°É£¬¼ÙÈçÎÒ°Ñprocess·½·¨£¨ÍêÕûʵÏֲμûÉÏһƪÎÄÕ ......
ruby on rails°²×°mysqlÊý¾Ý¿â
1. ÏÂÔØmysqlÈí¼þ
http://www.mysql.cn/
mysqlÖÐÎĹٷ½ÍøÕ¾ÏÂÔØ°²×°Èí¼þ£¬Ñ¡Ôñ5.0
2. °²×°mysql£¬ÉèÖÃĬÈÏ×Ö·û¼¯Îªutf-8
3. ÏÂÔØmysql for rubyµÄÇý¶¯²¢°²×°
http://rubyforge.org/ËÑË÷mysql£¬ÕÒµ½mysql -win
µã»÷ÏÂÔØ£¬½øÈëÒ³Ãæ
http://rubyforge.org/frs/?group_id= ......