''' <summary>
''' 获取从Excel文档到DataTable
''' </summary>
''' <param name="path">excel路径</param>
''' <returns>返回DataTable</returns>
''' <remarks>从excel文档导入到</remarks>
Private Function GetDataTable(path As String) As DataTable
Dim wb As Aspose.Cells.Workbook = New Aspose.Cells.Workbook()
wb.Open(path)
Dim cells As Aspose.Cells.Cells = wb.Worksheets("明细").Cells
Return cells.ExportDataTable(1, 0, cells.MaxDataRow, cells.Columns.Count, False)
End Function
''' 获取从Excel文档到DataTable
''' </summary>
''' <param name="path">excel路径</param>
''' <returns>返回DataTable</returns>
''' <remarks>从excel文档导入到</remarks>
Private Function GetDataTable(path As String) As DataTable
Dim wb As Aspose.Cells.Workbook = New Aspose.Cells.Workbook()
wb.Open(path)
Dim cells As Aspose.Cells.Cells = wb.Worksheets("明细").Cells
Return cells.ExportDataTable(1, 0, cells.MaxDataRow, cells.Columns.Count, False)
End Function