Foxtable(狐表)用户栏目专家坐堂 → 自定路径汇总数据怎么报错


  共有8363人关注过本帖平板打印复制链接

主题:自定路径汇总数据怎么报错

帅哥哟,离线,有人找我吗?
lpxjw_zyl
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:小狐 帖子:376 积分:4189 威望:0 精华:0 注册:2008/9/1 14:18:00
自定路径汇总数据怎么报错  发帖心情 Post By:2012/3/3 12:16:00 [只看该作者]

Dim dlg As New OpenFileDialog
dlg.MultiSelect = True
dlg.Filter= "Excel文件|*.xls"
If dlg.ShowDialog = DialogResult.OK Then
   
Dim Book As New XLS.Book(dlg.FileName)
For Each Sheet As XLS.Sheet In Book.Sheets
    Output.Show(Sheet.name)
    For h As Integer = 0 To Sheet.Rows.count -1
        For l As Integer = 0 To Sheet.cols.count -1
            Tables("学籍").rows(h)(l) =  Tables("学籍").rows(h)(l) & Sheet(h,l).Value
        Next
    Next
Next

End If


 回到顶部