SQL Queries

Aspose.Cells Product Family
1

Hi,

Is it possible using aspose.cells, to do SQL queries against a worksheet? I know that the answer was no, as of 2007, but I was wondering if this feature was put in place since then.

This message was posted using Aspose.Live 2 Forum
2

Currently we don't support SQL queries. Could you elaborate your need? Thus we can see if there are any workarounds. We can also investigate this feature based on your detailed requirements.

3

@MarkKaras,

I guess you want to import data from data source/database. If you need to import data from some external data source, you have to first import data (you may use your own ADO.NET code (you may write/use your own SQL queries based on your requirements too.) to first fetch it and then fill it to some container like DataTable or Arrays/ List). Now, you may use Aspose.Cells APIs to import it into worksheet cells, see the document on data importing options provided by Aspose.Cells for your complete reference.

We recommend you to kindly try our latest trial version here:
Aspose.Cells for .NET (Latest Version)

A ready to run VS.NET examples are available here for testing different features without writing any code.

Let us know if we can be of any further help.