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?

@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.

Thanks for the answer

@Ido.Podhajcer,

You are welcome.