Export from excel to datatable with select clause

Aspose.Cells Product Family
1

Hi, I am planning to use Aspose cells to to query excel files in .Net,
Does Aspose support query to datatable with select clause, I can’t find something like that in documentation only export worksheet to datatable?

2

@Ido.Podhajcer,

No, there is no such option available in Aspose.Cells APIs. Aspose.Cells only provides means to export Excel data range (in the worksheet) to fill a datatable. So, once you got datatable with data, then you may easily specify filter crieteria for desired data using .NET (System.Data) API, see the thread for your reference.

3

Thanks for the answer

4

@Ido.Podhajcer,

You are welcome.