如何将VB中提取数据库的数据生成EXCEL电子表格的形式 本人目前正在做一个银行的软件遇到一个困难,如何将VB中提取数据库的数据生成EXCEL电子表格的形式!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 很简单,创建EXCEL对象,用这个对象来操作。技术支持:[email protected] 引用excelDim objExcel As ObjectDim objRange As Excel.RangeOn Error Resume Next Set objExcel = GetObject(, "Excel.Application") If objExcel Is Nothing Then Set objExcel = CreateObject("Excel.Application") End If objExcel.Workbooks.AddSet objRange = objExcel.Range(objExcel.Cells(intRow, 1), objExcel.Cells(intRow, 2)) objRange.Merge objRange.Font.Size = 10 objRange.FormulaR1C1 = "制表人:" & strMaker Set objRange = objExcel.Range(objExcel.Cells(intRow, 3), objExcel.Cells(intRow, 4)) objRange.Merge objRange.Font.Size = 10 objRange.FormulaR1C1 = "制表时间:" & strMakeTime intRow = intRow + 1。Set objRange = objExcel.Range(objExcel.Cells(intRow, 1), objExcel.Cells(mf.FixedRows + intRow - 1, mf.Cols)) '=================End================ objRange.Font.Name = "宋体" objRange.Font.Size = 12 objRange.Font.Bold = True objRange.RowHeight = 24 objRange.VerticalAlignment = 2 objRange.HorizontalAlignment = 3 'Set objRange = objExcel.Range(objExcel.Cells(mf.FixedRows + 1, 1), objExcel.Cells(mf.Rows, mf.Cols))'old '===============Begin========== Set objRange = objExcel.Range(objExcel.Cells(mf.FixedRows + intRow, 1), objExcel.Cells(mf.Rows + intRow - 1, mf.Cols)) '================End========== objRange.NumberFormat = "#" objRange.Font.Name = "宋体" objRange.Font.Size = 10 'objRange.Borders.LineStyle = owcLineStyleSolid objRange.Borders.LineStyle = 7 objRange.Borders.Weight = 2 objRange.BorderAround 7, xlThick' objRange.Borders(xlEdgeBottom).LineStyle = owcLineStyleSolid' objRange.Borders(xlEdgeRight).LineStyle = owcLineStyleSolid' objRange.Borders(xlDiagonalDown).LineStyle = owcLineStyleSolid' objRange.Borders(xlEdgeBottom).Weight = owcLineWeightThick' objRange.BorderAround = 9 objExcel.Visible = True vb 调用odbc 如何判断一个程序时候已经运行? Access 与 VB 连接问题。 请教一个sql语句,大家来说说有什么好的建意没有 MSHFlexGrid的问题 请问怎么样判断鼠标移出控件(如图片框) 关于文本文件的问题?好急在线等待!高分求教! 谁能告诉我excel柱状图的chartType的数值?比如5代表xlPie,但是不知道柱状图是多少?告诉我数值,不要常量,因我不用VB,用常量程序不认 高手们啊!你们在哪儿啊!每次我的问题总是没人回答? 谁能建议一个好一点的vb打包工具? 读数据库 窗体缩小到一定大小,维持预定最小大小
Dim objExcel As Object
Dim objRange As Excel.RangeOn Error Resume Next
Set objExcel = GetObject(, "Excel.Application")
If objExcel Is Nothing Then
Set objExcel = CreateObject("Excel.Application")
End If
objExcel.Workbooks.AddSet objRange = objExcel.Range(objExcel.Cells(intRow, 1), objExcel.Cells(intRow, 2))
objRange.Merge
objRange.Font.Size = 10
objRange.FormulaR1C1 = "制表人:" & strMaker Set objRange = objExcel.Range(objExcel.Cells(intRow, 3), objExcel.Cells(intRow, 4))
objRange.Merge
objRange.Font.Size = 10
objRange.FormulaR1C1 = "制表时间:" & strMakeTime
intRow = intRow + 1。
Set objRange = objExcel.Range(objExcel.Cells(intRow, 1), objExcel.Cells(mf.FixedRows + intRow - 1, mf.Cols))
'=================End================
objRange.Font.Name = "宋体"
objRange.Font.Size = 12
objRange.Font.Bold = True
objRange.RowHeight = 24
objRange.VerticalAlignment = 2
objRange.HorizontalAlignment = 3 'Set objRange = objExcel.Range(objExcel.Cells(mf.FixedRows + 1, 1), objExcel.Cells(mf.Rows, mf.Cols))'old
'===============Begin==========
Set objRange = objExcel.Range(objExcel.Cells(mf.FixedRows + intRow, 1), objExcel.Cells(mf.Rows + intRow - 1, mf.Cols))
'================End==========
objRange.NumberFormat = "#"
objRange.Font.Name = "宋体"
objRange.Font.Size = 10 'objRange.Borders.LineStyle = owcLineStyleSolid
objRange.Borders.LineStyle = 7
objRange.Borders.Weight = 2
objRange.BorderAround 7, xlThick
' objRange.Borders(xlEdgeBottom).LineStyle = owcLineStyleSolid
' objRange.Borders(xlEdgeRight).LineStyle = owcLineStyleSolid
' objRange.Borders(xlDiagonalDown).LineStyle = owcLineStyleSolid
' objRange.Borders(xlEdgeBottom).Weight = owcLineWeightThick
' objRange.BorderAround = 9
objExcel.Visible = True