麻烦老师们帮忙看看
一个Excel文件里面有两个工作表【省】和【州】 怎么直接写值到excel指定单元格
代码代码如下：
Dim time As String =Format(Date.now,"yyyyMMddHHmmss")
Dim Book As New XLS.Book(ProjectPath & "Attachments\主要指标一览表.xls") '打开模板
Dim fl As String = ProjectPath & "Reports\" & Date.Today.Year & "年" & Date.Today.Month & "月主要指标一览表.xls"
Dim Sheet As XLS.Sheet = Book.Sheets(0)
Sheet(6,6).Value = "省级制单人:" 红色部分没有写入值
Dim Sheet1 As XLS.Sheet = Book.Sheets(1)
Sheet1(8,6).Value = "州级制单人:" 红色部分没有写入值
book.AddDataTable("主要指标一览表","主数据源","S ele ct * from {主要指标一览表}")
Book.Build() '生成报表
Book.Save(fl)
一个Excel文件里面有两个工作表【省】和【州】
想在工作表【省】中Sheet(6,6).Value = "省级制单人:"
想在工作表【州】中Sheet(8,6).Value = "州级制单人:"
[此贴子已经被作者于2023/5/18 16:14:23编辑过]
加好友 
发短信
Post By：2023/5/18 16:12:00 [显示全部帖子]
