将flexgrid中的内容导出到excel中,如何根据flexgrid表格的列宽设定excel中相应列的列宽呀?
-------------
将flexgrid中的内容导出后,在excel中,各个列的宽度是一样的,导致很多列都是重新调整一下列宽才能打印,我想如何在导出时设置一个excel中的列宽呢?
如何设置呢?
请大家给个思路,谢谢.我的代码如下:
'-----------------------------------------------
'功能:导出电子表格[将表格msflexgrid中的数据直接导出到电子表格中]
'创建日期:2006/06/17
'更新日期:2006/06/17
'参数:
' grd--传过来的表格名称
' arrayflag()--指定各列是否导出,元素下标对应各列,元素值0表不不导出,1表示导出
'-----------------------------------------------
Public Function flexgridtoexcel(grd As MSFlexGrid, arrayflag() As Integer) As Boolean
On Error GoTo errhandle
Dim ColCount As Integer
Dim i As Integer
Dim k As Integer
Dim rowcount As Integer
Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Dim sRange As String
Dim icolpos As Integer '电子表格的当前列
ColCount = grd.Cols '取表格列数
rowcount = grd.Rows '取表格行数
xlApp.Visible = True '显示电子表格程序 Set xlBook = xlApp.Workbooks.Add
'Set xlsheet = xlBook.Worksheets(3)
'xlsheet.Visible = xlSheetHidden
'Set xlsheet = xlBook.Worksheets(2)
'xlsheet.Visible = xlSheetHidden '//隐藏sheet2
Set xlsheet = xlBook.Worksheets(1)
xlsheet.Name = "导出数据"
VB.Screen.MousePointer = vbHourglass
'下面合并单元格
' xlsheet.Cells(1, 1) = strtitle
' xlsheet.Range(xlsheet.Cells(1, 1), xlsheet.Cells(1, ColCount)).Merge
'xlsheet.Range(xlsheet.Cells(1, 1), xlsheet.Cells(1, ColCount)).Font.Size = 18
'设置标题[注意:电子表格的行和列都是从1开始的,而flexgrid的行和列都是从0开始的]
icolpos = 0
For i = 0 To ColCount - 1
If arrayflag(i) = 1 Then
icolpos = icolpos + 1
xlsheet.Cells(1, icolpos) = grd.TextMatrix(0, i)
End If
Next
'填入单元格
For i = 1 To rowcount - 1
icolpos = 0
For k = 0 To ColCount - 1
If arrayflag(k) = 1 Then
icolpos = icolpos + 1
xlsheet.Cells(i + 1, icolpos) = CStr(grd.TextMatrix(i, k))
End If
Next
Next
'增加表格线
With xlsheet
.Range(.Cells(1, 1), .Cells(rowcount, icolpos)).Borders.LineStyle = xlContinuous
End With
'xlBook.Close False '不提示保存就关闭
Set xlsheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing
VB.Screen.MousePointer = vbDefault
flexgridtoexcel = True
Exit Function
errhandle:
VB.Screen.MousePointer = vbHourglass
flexgridtoexcel = False
MsgBox Err.Description
End Function
-------------
将flexgrid中的内容导出后,在excel中,各个列的宽度是一样的,导致很多列都是重新调整一下列宽才能打印,我想如何在导出时设置一个excel中的列宽呢?
如何设置呢?
请大家给个思路,谢谢.我的代码如下:
'-----------------------------------------------
'功能:导出电子表格[将表格msflexgrid中的数据直接导出到电子表格中]
'创建日期:2006/06/17
'更新日期:2006/06/17
'参数:
' grd--传过来的表格名称
' arrayflag()--指定各列是否导出,元素下标对应各列,元素值0表不不导出,1表示导出
'-----------------------------------------------
Public Function flexgridtoexcel(grd As MSFlexGrid, arrayflag() As Integer) As Boolean
On Error GoTo errhandle
Dim ColCount As Integer
Dim i As Integer
Dim k As Integer
Dim rowcount As Integer
Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Dim sRange As String
Dim icolpos As Integer '电子表格的当前列
ColCount = grd.Cols '取表格列数
rowcount = grd.Rows '取表格行数
xlApp.Visible = True '显示电子表格程序 Set xlBook = xlApp.Workbooks.Add
'Set xlsheet = xlBook.Worksheets(3)
'xlsheet.Visible = xlSheetHidden
'Set xlsheet = xlBook.Worksheets(2)
'xlsheet.Visible = xlSheetHidden '//隐藏sheet2
Set xlsheet = xlBook.Worksheets(1)
xlsheet.Name = "导出数据"
VB.Screen.MousePointer = vbHourglass
'下面合并单元格
' xlsheet.Cells(1, 1) = strtitle
' xlsheet.Range(xlsheet.Cells(1, 1), xlsheet.Cells(1, ColCount)).Merge
'xlsheet.Range(xlsheet.Cells(1, 1), xlsheet.Cells(1, ColCount)).Font.Size = 18
'设置标题[注意:电子表格的行和列都是从1开始的,而flexgrid的行和列都是从0开始的]
icolpos = 0
For i = 0 To ColCount - 1
If arrayflag(i) = 1 Then
icolpos = icolpos + 1
xlsheet.Cells(1, icolpos) = grd.TextMatrix(0, i)
End If
Next
'填入单元格
For i = 1 To rowcount - 1
icolpos = 0
For k = 0 To ColCount - 1
If arrayflag(k) = 1 Then
icolpos = icolpos + 1
xlsheet.Cells(i + 1, icolpos) = CStr(grd.TextMatrix(i, k))
End If
Next
Next
'增加表格线
With xlsheet
.Range(.Cells(1, 1), .Cells(rowcount, icolpos)).Borders.LineStyle = xlContinuous
End With
'xlBook.Close False '不提示保存就关闭
Set xlsheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing
VB.Screen.MousePointer = vbDefault
flexgridtoexcel = True
Exit Function
errhandle:
VB.Screen.MousePointer = vbHourglass
flexgridtoexcel = False
MsgBox Err.Description
End Function
解决方案 »
- [DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或拒绝访问
- 如何取得右下角任务栏的程序名称、路径?
- RDO和ADO的区别,,,急急,急急急,在线等.......,解决立即结帖
- Adodc控件,用Microsoft.Jet.OLEDB.4.0连接ACCESS数据库,ACCESS数据库不能有密码?Adodc的BUG?
- 如何判断对象是否已经创建?
- 请问vs2005中datagridview中修改了数据后,怎么更新进数据库啊?
- 求助:怎样在Microsoft Excel中设置股票代码、名称、即时报价?
- 关于VB的MDI窗体的几个小问题(问题解决后立即给分)
- vb中可以使用多线程吗,how?
- 怎么在VB中实现类似模式对话框的窗体?
- imagelist的图片为什么变得模糊了?
- 100分求-读取IE缓存内文件问题
cells.autofit 不行嗎
cells.autofit 不行嗎
--------------
请指教,如何用呀?如何指定全部列呀?