哈,不明白你要做什么,具体一些:
一、文件内容是什么(txt表,Sql命令,dbf其它文件)
二、到出到Excel要什么格式,...作.net的报表,可以导入到Excel的
你是要自己做,把数据导入到某个特定的cell吗?
一、文件内容是什么(txt表,Sql命令,dbf其它文件)
二、到出到Excel要什么格式,...作.net的报表,可以导入到Excel的
你是要自己做,把数据导入到某个特定的cell吗?
解决方案 »
- 向高手求助,急!急!!急!!!
- 继续请教,如何直接向服务器提交信息
- ComponentOne Studio for .NET 注册问题,急急急!
- Team Coherence 代码管理工具,今天由于重新安装 安装后在VS2005源代码管理中没有发现这个插件
- 水晶報表與.NET高手請進來幫幫忙!!!!散分!!!
- [在线等]如何用类型化数据集更新数据库?
- 在vs2005中生成的类中没有命名空间了?
- combobox中绑定的数据不能显示
- 各位帮我看看这个问题
- 为什么datagridview加载速度那么慢?如何才能快些?
- A question about how to communication between two PCs
- 请问在Beta2版中如何通过数据库控件得到数据库的记录条数?(请教C#问题)
Public m_xlBook As Excel.Workbook
Public m_xlSheet As Excel.WorksheetPublic m_strFileName As StringPrivate Sub Class_Initialize()
m_strFileName = "Books1.xls"
Set m_xlApp = New Excel.Application
Set m_xlBook = m_xlApp.Workbooks.Add
Set m_xlSheet = m_xlBook.Sheets(1)
m_xlApp.Visible = False
End SubPrivate Sub Class_Terminate()
m_xlBook.Close False
m_xlApp.Quit
Set m_xlApp = Nothing
Set m_xlBook = Nothing
Set m_xlSheet = Nothing
End SubPublic Function OpenSaveAsFileName(strFileNameDefault As String) As Variant
On Error Resume Next
Dim strFileName As Variant
strFileName = m_xlApp.GetSaveAsFilename(strFileNameDefault, "Microsoft Excel 工作薄(*.xls),*.xls")
If strFileName <> False Then
Me.m_strFileName = CStr(strFileName)
End If
OpenSaveAsFileName = strFileName
If Err Then
Err.Clear
End If
End FunctionPublic Sub SaveCurrExportedExcel()
On Error Resume Next
m_xlBook.SaveAs m_strFileName
If Err Then
Err.Clear
End If
End SubPublic Function AdodcExport(ByRef ctrADO As Adodc, ByVal nSheetStartRow As Long, ByVal nSheetStartCol As Long) As Long
'''------------------------------------------------------
''' For Test Only:
Dim nRow As Long
Dim nCol As Long
On Error Resume Next
ctrADO.Recordset.MoveFirst
If Err Then
Err.Clear
AdodcExport = 0
Exit Function
End If
nRow = nSheetStartRow
nCol = 0
Do While (ctrADO.Recordset.EOF = False And ctrADO.Recordset.BOF = False)
nRow = nRow + 1
For nCol = 1 To ctrADO.Recordset.Fields.Count Step 1
m_xlSheet.Cells(nRow, nCol + nSheetStartCol).Value = Trim(ctrADO.Recordset.Fields(nCol - 1).Value)
Next nCol
ctrADO.Recordset.MoveNext
If Err Then
Err.Clear
End If
Loop
AdodcExport = nRow
End FunctionPublic Function ResExport(ByRef rsADO As ADODB.Recordset, ByVal nSheetStartRow As Long, ByVal nSheetStartCol As Long) As Long
'''------------------------------------------------------
''' For Test Only:
Dim nRow As Long
Dim nCol As Long
On Error Resume Next
If rsADO.EOF Or rsADO.BOF Then
Exit Function
End If
rsADO.MoveFirst
If Err Then
Err.Clear
ResExport = 0
Exit Function
End If
nRow = nSheetStartRow
nCol = 0
Do While (rsADO.EOF = False And rsADO.BOF = False)
nRow = nRow + 1
For nCol = 1 To rsADO.Fields.Count Step 1
m_xlSheet.Cells(nRow, nCol + nSheetStartCol).Value = Trim(rsADO.Fields(nCol - 1).Value)
Next nCol
rsADO.MoveNext
If Err Then
Err.Clear
End If
Loop
ResExport = nRow
End Function