Foxtable(狐表)用户栏目专家坐堂 → EXCEL打印错误


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

主题:EXCEL打印错误

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


加好友 发短信
等级:一尾狐 帖子:423 积分:4231 威望:0 精华:0 注册:2009/5/16 21:42:00
EXCEL打印错误  发帖心情 Post By:2011/10/17 23:38:00 [只看该作者]

EXCEL打印错误!
Dim Book As New XLS.Book(ProjectPath & "Attachments\TAXI單.xls")
Dim fl As String = ProjectPath & "Reports\TAXI單.xls"
For n As Integer = 0 To Ls.Count-1 '向工作表的單元格中設置值
    Sheet(n, 0).Value = Ls(n) 
   Next 
Dim  Ls As New List(Of String )
For Each r As DataRow In DataTables("TAXI").Select("修理內容 Is Not Null")
    Ls.AddRange(r("修理內容").split(" "))
Next
Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(fl)
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
Ws.PrintOut
App.Quit

 回到顶部