从 Excel 填充时，Ruby（鞋子）列表框崩溃

发布于 2024-12-05 11:31:03 字数 407 浏览 1 评论 0原文

我在使用鞋子时遇到问题。我基本上试图打开一个 Excel 文档并将工作表的名称传递到列表框。选择文件后按下按钮将调用以下方法。（这一切都有效并且文件打开）

exc = WIN32OLE::new('excel.Application')
excWB = exc.Workbooks.Open(xlsFile)
@excWS = Array::new
exc.visible = true
excWB.Worksheets.each { |ws| @excWS.push(ws.name) }
para @excWS
list_box :items=> @excWS

不仅名称没有显示在列表框中，应用程序在加载框后不久就崩溃了，没有错误。 para @excWS 显示工作表的名称没有问题。

我做错了什么？

原文

I've got a problem when using Shoes. I'm basically trying to open an excel document and pass the names of the worksheets to a list_box. The following method is called on a button press after selecting a file. (This all works and the file opens)

exc = WIN32OLE::new('excel.Application')
excWB = exc.Workbooks.Open(xlsFile)
@excWS = Array::new
exc.visible = true
excWB.Worksheets.each { |ws| @excWS.push(ws.name) }
para @excWS
list_box :items=> @excWS

Not only do the names not show up in the list_box, the app crashes shortly after loading the box with no error. para @excWS shows the names of the worksheets with no problem.

What am I doing wrong?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

撩起发的微风 2024-12-12 11:31:03

这是编码的问题
这有效

Shoes.app :width => 400, :height => 340, :size => 8 do
  require 'win32ole'
  exc = WIN32OLE::new('excel.Application')
  excWB = exc.Workbooks.Open('C:/Shoes/0.r1514/test/book1.xls')
  @excWS = Array::new
  exc.visible = false
  excWB.Worksheets.each { |ws| @excWS.push(ws.name.force_encoding("UTF-8")) }
  list_box :items=> @excWS
  exc.ActiveWorkbook.Close(0);
  exc.Quit();
end

it is the encoding that was the problem
This works

Shoes.app :width => 400, :height => 340, :size => 8 do
  require 'win32ole'
  exc = WIN32OLE::new('excel.Application')
  excWB = exc.Workbooks.Open('C:/Shoes/0.r1514/test/book1.xls')
  @excWS = Array::new
  exc.visible = false
  excWB.Worksheets.each { |ws| @excWS.push(ws.name.force_encoding("UTF-8")) }
  list_box :items=> @excWS
  exc.ActiveWorkbook.Close(0);
  exc.Quit();
end

回复收藏 0 原文

~没有更多了~