Laurence,
This code is used to populate the data sheet. (VB.Net)
Public Sub LoadData(ByRef objpDataReader As OleDb.OleDbDataReader, ByVal spSheetName As String, ByRef ipRowCount As Integer, ByRef ipColumnCount As Integer, ByVal spRangeName As String)
TraceLog("RLWorkbook.LoadData(objpDataReader," & spSheetName & "," & ipRowCount & "," & ipColumnCount & "," & spRangeName & ")")
Dim iActiveSheet As Integer
Dim objSheet As Aspose.Cells.Worksheet
Dim objWorkSheets As Aspose.Cells.Worksheets
Dim objRange As Aspose.Cells.Range
objSheet = objmExcel.Worksheets(spSheetName)
objWorkSheets = objmExcel.Worksheets()
Try
' Try to get the pivot table position
iActiveSheet = objWorkSheets.Item(System.Configuration.ConfigurationManager.AppSettings.Get("PivotTableName")).Index
Catch ex As Exception
' has been renamed, this shouldn't throw an error.
iActiveSheet = objWorkSheets.ActiveSheetIndex
End Try
objSheet.Cells.Clear()
objRange = objmExcel.Worksheets.GetRangeByName(spRangeName)
If Not objRange Is Nothing Then
objSheet.Cells.ClearFormats(objRange.FirstRow, objRange.FirstColumn, _
objRange.FirstRow + objRange.RowCount, _
objRange.FirstColumn + objRange.ColumnCount)
Else
' Shouldn't be here, someone changed the rangename
End If
ipRowCount = objSheet.Cells.ImportFromDataReader(objpDataReader, True, 0, 0, False)
ipColumnCount = objpDataReader.FieldCount
objWorkSheets.ActiveSheetIndex = iActiveSheet
objpDataReader.Close()
End Sub
Public Sub SaveData(ByVal spSheetName As String, ByVal spFileName As String)
TraceLog("RLWorkbook.SaveData(" & spSheetName & "," & spFileName & ")")
Dim objSheet As Aspose.Cells.Worksheet
objSheet = objmExcel.Worksheets(spSheetName)
objmExcel.Save(spFileName, Aspose.Cells.FileFormatType.Excel97)
objSheet.Cells.Clear()
End Sub
Let me know if you need any additional code or information.
Thank you,
Chris