We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Export from excel to datatable with select clause

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?


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.

Thanks for the answer


You are welcome.