You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Dataframe load data from excel and query using sql #5646
No, we can't do this yet. However, if you find a library that lets you read excel files and exposes it as an IDataReader, we should be able to read it into a DataFrame once https://github.com/dotnet/corefxlab/pull/2924/files goes in
Not yet unfortunately. dotnet/corefxlab#2924 is inactive at the moment. Would you be interested in adding unit tests to that PR? If not, this is on the list for the next DataFrame release. I'm tied up with .NET 6 work at the moment though, so it'll be a while before I can get to this.
Triage: we don't think the feature is worth the investment at the moment as there isn't huge demand for it and there is a known workaround using CSV export.
Activity
pgovind commentedon Nov 18, 2020
No, we can't do this yet. However, if you find a library that lets you read excel files and exposes it as an
IDataReader, we should be able to read it into a DataFrame once https://github.com/dotnet/corefxlab/pull/2924/files goes inYohDeadfall commentedon Nov 18, 2020
There's ExcelDataReader which is ADO.NET compatible.
Kumar3010 commentedon Jan 23, 2021
@pgovind - could you please let us know if this is possilbe now
pgovind commentedon Jan 25, 2021
Not yet unfortunately. dotnet/corefxlab#2924 is inactive at the moment. Would you be interested in adding unit tests to that PR? If not, this is on the list for the next DataFrame release. I'm tied up with .NET 6 work at the moment though, so it'll be a while before I can get to this.
rosebyte commentedon Oct 1, 2026
Triage: we don't think the feature is worth the investment at the moment as there isn't huge demand for it and there is a known workaround using CSV export.