ruby on rails 读取excel
来源:互联网 发布:mac os 百度云盘 编辑:程序博客网 时间:2024/06/06 07:52
require 'win32ole'
excel = WIN32OLE.new("Excel.Application")
excel.WorkBooks.Open("f:\\book1.xls") #打开excel
worksheet = excel.ActiveWorkbook.WorkSheets(1)
line = 1
while worksheet.Range("a#{line}")['Value']
line=line+1
end #line的值为第一处空白行的行数
line = '2'
data = []
while worksheet.Range("a#{line}")['Value']
data << worksheet.Range("a#{line}:d#{line}")['Value']
line.succ!
end
0 0
- ruby on rails 读取excel
- ruby on rails 中使用CSV导出excel文件
- Ruby & Rails on Rails 進階書單
- ruby and ruby on rails
- install Ruby on Rails
- Ruby on Rails 实践
- Ruby on Rails!
- Ruby on Rails
- 关于Ruby on Rails
- 初探Ruby on rails
- Ruby on Rails
- 了解Ruby on Rails
- Ruby on Rails 是什么?
- 什么是Ruby on Rails
- Ruby on Rails 实践
- Ruby on Rails
- 实践ruby on rails
- Ruby On Rails小结
- ECLIPSE下启动TOMCAT,服务已启动但是又自动终止
- JVM-2
- Fragment异常:Binary XML file line #8: Error inflating class fragment
- SQL2000安装时无法验证产品
- 慎用preg_replace危险的/e修饰符
- ruby on rails 读取excel
- 统计分词/无字典分词学习(3):分词效果评价和基线
- chapter 16 Object-Oriented Programming
- 《Effective C++》学习笔记条款24 若所有参数皆需类型转换,请为此采用non-member函数
- UFBFN RNDIS
- 安装tftp服务器出现如下提示:xinetd is needed by tftp-server-0.42-3.1.i386
- 编辑博客
- thinkphp 2013-12-26
- yii分页