【SQL开源代码栏目提醒】:本文主要为网学会员提供“【最新】分享:VB6_0 VB导出EXCEL 方法源代码(转载) 百度空间_应用平台 - 法律章程”,希望对需要【最新】分享:VB6_0 VB导出EXCEL 方法源代码(转载) 百度空间_应用平台 - 法律章程网友有所帮助,学习一下!
????????????????VB6.0 VB??????????excel ???????????????????????? ??è????è???? ??????????????????é????_??????????¨??????????°??????????¨????¨??????????¨????·??????: ???????? ??: HOHO??…¤??‰??PK????????????????????¨??????è????????‰????€??????é??¨è????±è????·????????????????é±?? ?????????? ????é???????????????????????????? ??????é??¨????????????????€????°??????????????????????????????????????????????????????????????????????????????‰??????????????iPad??¤§??????????¨????¨é€??????é€??é€????…??????¨????¤ ?????????????????????? é????é??????????é???? é??????????????°???????????????????????????????????? VB6.0 VB??????????excel ???????????????????????? ??è????è???? ????????????????€???? ????¨Msflexgrid??????Textmatrix??±????€¤????Msflexgrid??????????????€??????????????…???? ????????????…????????????????????????????????°Excelè??¨????????????????者??????????CSV?? ?????? ?????????????????????? ????????????????????è????????????????????????????????Excel??·????è??¨ Public Sub Exportformname As Form flexgridname As String Dim xlApp As Object Excel.Application Dim xlBook As Object Excel.Workbook Dim xlSheet As Object Excel.Worksheet Screen.MousePointer vbHourglass On Error GoTo Err_Proc Set xlApp CreateObjectExcel.Application Set xlBook xlApp.Workbooks.Add Set xlSheet xlBook.Worksheets1 Begin to fill data to sheet Dim i As Long Dim j As Integer Dim k As Integer With formname.Controlsflexgridname For i 0 To .rows - 1 k 0 For j 0 To .Cols - 1 If .colwidthj 20 Or .colwidthj 0 Then k k 1 xlSheet.Cellsi 1 k.Value .TextMatrixi j End If Next j Next i End With xlApp.Visible True Screen.MousePointer vbDefault Exit Sub Err_Proc: Screen.MousePointer vbDefault MsgBox è??·??????è??????¨????????????è??????·??????‰è??…Excel???? vbExclamation????¤?? End Sub Public Function ExporToExcelstrOpen As String ????????¤°????ExporToExcel ??????è????????????????????°??????????°EXCEL ????¨??????????ExporToExcelsql????è?????????????????????? Dim Rs_Data As New ADODB.Recordset Dim Irowcount As Integer Dim Icolcount As Integer Dim cn As New ADODB.Connection Dim xlApp As New Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet Dim xlQuery As Excel.QueryTable With Rs_Data If .State adStateOpen Then .Close End If .ActiveConnection providermsdasqlDRIVERMicrosoft Visual FoxPro DriverUIDDeletedyesNullnoCollateMachineBackgroundFetchnoExclusiveNoSourceTypeDBFSourceDBD:DBF .CursorLocation adUseClient .CursorType adOpenStatic .Source strOpen .Open End With With Rs_Data If .RecordCount 1 Then MsgBox ??????????‰è??°???? Exit Function End If è??°??????€??????° Irowcount .RecordCount ????????????€??????° Icolcount .Fields.Count End With Set xlApp CreateObjectExcel.Application Set xlBook Nothing Set xlSheet Nothing Set xlBook xlApp.Workbooks.Add Set xlSheet xlBook.Worksheetssheet1 xlApp.Visible True ??·?????? ????è????è??????????????????…EXCEL????°?????? Set xlQuery xlSheet.QueryTables.AddRs_Data xlSheet.Rangea1 xlQuery.FieldNames True ???????????????????????? xlQuery.Refresh xlApp.Application.Visible True Set xlApp Nothing ????è????????¤????????????Excel Set xlBook Nothing Set xlSheet Nothing End Function ????????¤°????OutDataToExcel ??????è????????°??MsFlexGrid????¤????????????????????????????????…??????è??????????????°Excelè??¨?? ????????è????è??????‰????° Public Sub OutDataToExcelFlex As MSFlexGrid ??????????è????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.Cells1 3 s Excelapp.RangeC1.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.Cells3 i j 1 .TextMatrixi 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 ????????????????¨??????????‰??…¨????è??·????????‰????€????????????????é?? ??????????????€ ??‰????€?????????? ??????????????è????: http://hi.baidu.com/cadel1985/blog/item/4725e0294b504af499250a8f.html ????è????: cadel1985 ??????????€????????????: é??????????????°?????? ??????é????: 2010-08-21 14:28 è????è????: 1?????? ????????¨: 0?????? ??????è????????????????: 2 ??????è????????????????: 3 ??…±????‰0????????????è??¨è¤???????? ...????????‰??è??????????????‰??????????¨è¤????????????è??????…????¨????????????????¨è¤???????? é??????????????°???????????? ????????…??????????????: apachetomcaté…??????è???? é????é????è¤??è??????????????????±??????AC97??????HD AUDIO VBé??è??è??????¨?? vb long ???????????? è??????????è????è????1 ???????????????????????? ??????é???????????????? ??????è??‰???????????? ??????é??????è???? è?????????????????????? 2006-2011 copy Baidu上一篇:VB物流管理系统毕业设计 源代码 论文 答辩