CODEWITHSUNDEEP
ado.netgoogle-docs
Click Ok
Click Ok

Reputation: 8852

Accessing Google Spreadsheets with C# using ADO.Net Data Providers?

I want use Google Spreadsheets as data storage, but transparently via ADO.Net Data Provider. There is in some place an implementation?

Upvotes: 1

Views: 810

Answers (2)

angularsen
angularsen

Reputation: 8668

There is a commercial Google Sheets ADO.NET Provider by CData, but I have not yet found an open source or free one.

Upvotes: 2

Hans Olsson
Hans Olsson

Reputation: 54999

I don't think there's any ADO.Net provider for Google spreadsheets, but I'm not sure. However, Google have their own API called Google Spreadsheets API that can be used from .Net. You can find more information about this here.

It seems like it'll be a webservice you'll have to connect to it. But you can access it either as a list of rows or on a cell by cell basis and you can use queries to filter the data.

Edit: Here's a sample .Net project using it.

Upvotes: 2

Related Questions