偶用下面的代码实现把数据导入EXCEL中,但没有边线,如果实现呢,还有加上一个题目和时间,如果写,请帮偶改一下,谢谢
Public Sub OutDataToExcel(Flex As MSHFlexGrid) '导出至Excel
Dim s As String
Dim i As Integer
Dim j As Integer
Dim k As Integer
On Error GoTo Ert
Me.MousePointer = 11
Dim Excelapp As Excel.Application
Set Excelapp = New Excel.Application
On Error Resume Next
DoEvents
Excelapp.SheetsInNewWorkbook = 1
Excelapp.Workbooks.Add
Excelapp.ActiveSheet.Cells(1, 3) = s
Excelapp.Range("C1").Select
Excelapp.Selection.Font.FontStyle = "Bold"
Excelapp.Selection.Font.Size = 16
With Flex
k = .Rows
For i = 0 To k - 1
For j = 0 To .Cols - 1
DoEvents
' Excelapp.ActiveSheet.Cells(3 + I, j + 1) = "'" & .TextMatrix(I, j)这个里面的"'"里的'是为了转换为文本格式
Excelapp.ActiveSheet.Cells(3 + i, j + 1) = "" & .TextMatrix(i, j)
Next j
Next i
End With
Me.MousePointer = 0
Excelapp.Visible = True
Excelapp.Sheets.PrintPreview
Ert:
If Not (Excelapp Is Nothing) Then
Excelapp.Quit
End If
End Sub
Public Sub OutDataToExcel(Flex As MSHFlexGrid) '导出至Excel
Dim s As String
Dim i As Integer
Dim j As Integer
Dim k As Integer
On Error GoTo Ert
Me.MousePointer = 11
Dim Excelapp As Excel.Application
Set Excelapp = New Excel.Application
On Error Resume Next
DoEvents
Excelapp.SheetsInNewWorkbook = 1
Excelapp.Workbooks.Add
Excelapp.ActiveSheet.Cells(1, 3) = s
Excelapp.Range("C1").Select
Excelapp.Selection.Font.FontStyle = "Bold"
Excelapp.Selection.Font.Size = 16
With Flex
k = .Rows
For i = 0 To k - 1
For j = 0 To .Cols - 1
DoEvents
' Excelapp.ActiveSheet.Cells(3 + I, j + 1) = "'" & .TextMatrix(I, j)这个里面的"'"里的'是为了转换为文本格式
Excelapp.ActiveSheet.Cells(3 + i, j + 1) = "" & .TextMatrix(i, j)
Next j
Next i
End With
Me.MousePointer = 0
Excelapp.Visible = True
Excelapp.Sheets.PrintPreview
Ert:
If Not (Excelapp Is Nothing) Then
Excelapp.Quit
End If
End Sub
解决方案 »
- 如何将一个数据库的查询记录集导入到另一个数据库?
- 请教制作中英双语界面的问题
- 如何调用程序本身的函数(高手来帮忙)
- 打印问题
- 我這麽聲明Set wscControl = New MSWinsockLib.Winsock爲什麽不對?
- 哪有插入图片的控件啊?
- 初学VB,应该从哪开始?
- mincer 限你3天内写出这个危害CSDN的小花帽病毒的修复程序!!否则咱们法庭上见!不信是吧?咱走着瞧!!高中毕业,你想和CIH想比呀??技术还差得很远。看哪个大学敢要你!
- 如何进行语音识别
- Un1你好,我找不到metadraw控件
- 怎么样随即抽取数据库中的数据呢?
- 如何做当我查询到某个记录时,指针自动指向该记录在DataGrid中的位置,并高亮该处?如何才能把记录集的指针指到我找到的记录处?
你不能自己先写好一个漂亮的excel文件做模斑吗?