Foxtable(狐表)用户栏目专家坐堂 → [求助]导入EXCEL问题


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

主题:[求助]导入EXCEL问题

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


加好友 发短信
等级:小狐 帖子:341 积分:3422 威望:0 精华:0 注册:2014/8/20 20:14:00
[求助]导入EXCEL问题  发帖心情 Post By:2014/10/14 22:44:00 [只看该作者]

Dim dlg As New OpenFileDialog '定义一个新的OpenFileDialog
dlg.Filter = "Excel文件|*.xls"
If dlg.ShowDialog = DialogResult.OK Then '如果用户单击了确定按钮
    Dim Book As New XLS.Book(dlg.FileName)
   
    Dim Sheet As XLS.Sheet = Book.Sheets(0)

  Tables("水卫工程量").StopRedraw()
    Dim sts() As String = { "分项工程名称","楼层_名称","楼层_数量","构件_名称","构件_数量","构件_型号规格","管道_计算公式","管道_小计","管道_合计","备注","管道油漆特征_除锈","管道油漆特征_底漆","管道油漆特征_面漆","土方_埋地","土方_埋地深度","土方_特征","土方_长度","油漆面积_基数","油漆面积_除锈","油漆面积_底漆","油漆面积_面漆","支架_基数","支架_合计kg","备忘录" }
   
    SystemReady = False  '关闭刷新
    Try
        'Tables("水卫工程量").AddNew '先添加第一行 标注行
        For x As Integer = 2 To Sheet.Rows.Count -1
            Dim r As Row = Tables("水卫工程量").AddNew '添加2行
           
           
            For y As Integer = 0 To sts.Length -1
               
                r(sts(y)) = sheet(x,y).text
               
            Next
        Next


    Catch ex As Exception
        MessageBox.Show("计算错误")
    End try
    SystemReady = True  '关闭刷新
End If

以上代码导入数值列或字符列没有问题,逻辑列出现错误,不知道怎么写代码

[此贴子已经被作者于2014-10-14 22:46:22编辑过]

 回到顶部