Google Sheets and .NET Core with C#
Вставка
- Опубліковано 13 тра 2019
- If you’d like to use the data in your Google Sheets projects from your C# applications, this is the guide for you.
We’ll use Google’s official v4 API SDK for .NET to access an example spreadsheet inside of Google Sheets.
Read the blog post for more: www.twilio.com/blog/2017/03/g... - Наука та технологія
A few days ago, I was busy with google sheet api and learned many tutorials about that. After all, your tutorial is the best!
This is so helpful, I can't stress enough. May the success be with you.
This video is outstanding, thanks so much! I tried a whole bunch of tutorials and GitHub projects, but none of them came even close to this!
You saved my career and my life. God bless you!
Amazing! Hands down, the BEST tutorial for Google sheets with C#!
Thanks for watching!
I am in the process of making a Winform app to facilitate data manipulation from a google sheet and this was extremely helpful in setting the environment up!
Really helpful. Complete information, well presented and easy to understand. Thanks so much. Will use this in a Blazor project.
Thanks for putting this video together! It was super helpful in getting my project running with GoogleSheets :)
Thank you. Better than google's own tutorials.
awesome vid thanks a bunch! spent a whole night trying to figure this out on my own and didn't turn out so well so thanks again!
Really helpful tutorial. Thanks!
Thanks for the video - very helpful to get me started.
Wow, great !
Thanks you so much :)
Thanks a lot ,You were time saver.
Thanks for the video, helps a lot :)
Wow! I have been struggling to get that for for days - you did it in seconds - very smart!
Very clear - this is good video instruction.
I want more pls!
Like how to activate a tab in a sheet - it seems to be a nightmare to set active tab in google sheets API
Thanks! Great video!
Thank You For this !
Thanks for the video, got me going with what I have in mind!
Do you know if it's possible to use batch update an append request?
I hope this gets updated so it can be relly useful
Very helpful ❤️❤️
Cool,thanks man ))
Thank you 😇
Thank you!
Absolutely amazing video, can you show how to connect mysql to Google sheets ?
Hi,
I had build this using Windows Forms, but i have a question that is when we share this code to others then we have to ask the user to create the service credentials.? or is there any Simpler way to do that.
To make it simpler, can we use our gmail account address Instead of creating google service credentials. We just have to make sure that the user not need to do any manual configuration.?
Thanks.
best tutorial
Are you using omnisharp for formatting? Can you share the config?
Thank you! 👍
can i filter sheet using this code?? i have phone numbers i want to pass column and phone number to filter the record
Thanks for the video. How can i format a cell using c#?
Managed to get it working perfect to the above utilities. One caveat is that i cannot figure out how to remove the entire row, instead of erasing that row of values. Some online searches led me to another format of inputting the dimension ranges with a start and ending index 1 higher than the start... but i barely got this to work.
Thanks. I have a question though @twilio
What if someone access the file in google sheets the same time you are accessing it via code. Won’t it break? Happened to me several times. Guess going around it by moving all info to sql is the only way?
Maybe you can create another spreadsheet where you can import and see all the data of the spreadsheet connected to your app
thx a lot
Thanks Bro)
Cool! how can i determine the last row?
Thank u
can we used named ranges in this to make it easier?
hi, you example write,read,update in php ?
how to do this in Windows Form Application C#.. we don't have a csproj file there..
vary nice tutorial what about if I want to use this with WPF? where I can put the TeamGroup ? i try and get an error in var response = request.Execute(); thank you for your time
Hi and thanks for the Video! It helps much! Is it possible to search the position of a Name? So i can change perphaps the birthday of mr. Brown?
We need one for Golang!
Okay, we'll take a look and see if we can get this done :)
How can I create another sheet in the same file?
thanksssss
How can I insert a column of values?
Hello, very well explained, everything here and in the blog helped a lot. Though, I have an issue with creating a new worksheet. I managed to create it with a configuration but I can't see to get it to appear in the actual Google sheet. Any way you could answer that?
Are you getting an error?
Moreover, suppose we delete the row in the middle, and when I try to read the whole sheet including the gap one, it's throwing me an exception. S0, how do we remove the white blank space in the middle of the sheets using the code?
you dont ezpz
I want to read data from spreadsheet but with just C#. Do you have any video on it?
How can I install this API on windows using Visual studio 2019?
Tools > Nuget Package Manager > Manage Nuget Package Manages for Solution. Tag 'Browse', type search 'Google Sheets API'
Can I write to the sheet from the console? so it would show in my google drive like edited by [console]... Where can I find this tutorial thx
You can definitely make edits from a console application. As for making is show up as edited by console, that would require some additional work.
can we make it with visual basic .net please ?
Thanks i just coppied that 1o1 and moddified it a bit. ÄHRE
It's all fine but how about I read all sheet to the 'IList' then I remove empty rows and store this List as Source for my DataGrid, and when I want to update some object for example object with index 250 in my 'IList', how the hell can I know the range to update the actual sheet? Is there any way to find the range position according to received IList on read method?
when i create a project, i dont have any .csproj file!!! what should i do?
What did you run to create the project?
Can you make a video tutorial about Google Sheet Api to WindowsForms C#
Would you consider your (.Net core) application as SOAP or as REST ?
What is the deference?
Great. Thanks you so much. That what I'm lookinh for since a week. Great tutorials.
Ok, how should we find a practical cell and then update. Suppose I jave to find the name="Abhishek" and if it found then I will to the CRUD operation.
Does this still work?
I have to make a daily insertion of 200 rows in my GoogleSheet, how can I do that without reaching the API requests/minute limitation? I've tried to do a for statement and I've reached the limit. Is it possible to pass multiple row data in just one request?
Amazing video by the way :)
Is it possible to access a row using some field value e.g. by a congressman name?
You probably want the GetDataByFilterRequest googleapis.dev/dotnet/Google.Apis.Sheets.v4/latest/api/Google.Apis.Sheets.v4.SpreadsheetsResource.GetByDataFilterRequest.html
I am not getting a JSON file when I perform all the steps as in the video
Do I need an OAuth client ID?
Because only there I get a json file. but there are bugs...
Thanks!!
you need to create a api key, which will give you the option to download the json file. please note once downloaded you will not be able to download again; unless a new key is created.
sorry a newbie question, where can i find the termnial?
Are you on Mac or Windows?
You are awesome. Is it possible to connect google sheets and vba?
Can you make an updated video about this?
I have an errror sayign "There are no versions available for the package 'Google.api'."
What OS are you using?
This video was created using macOS but it would work exactly the same on Windows.
@@twilio Works on linux :D
When I try to add the json file it says cp is not recognized as an internal or external command, operable program or batch file
You’re looking for “copy” on Windows.
@@twilio thanks everything works now
Is there a link to the source?
It uses a different spreadsheet but the basics are the same: www.twilio.com/blog/2017/03/google-spreadsheets-and-net-core.html?
Not to necro an old video too much but figured I'd shoot a shot. Anybody figured out how to make something like this work in Unity?
dude how did you end up in terminal?
In this case, I was using iTerm2 and I just ran the application. If you’re on Windows you could use Command Prompt or Powershell. I edit out the launching of applications usually to keep things moving.
I did everything but always it was giving auth error, I found solition in this video. The missing thing was share doc to client mail. How is that stupid? api access should mean that, I have created owner api access but it has auth error.
Hello everyone, I have a question. Can anyone help me? I need to make a Windows forms application related to Google Sheets. It will have a simple interface, but I do not know how to proceed.
Can I use Google sheets for 1000 clients?
it says Google.Api package not found?
Sounds like either your Google NuGet packages didn't install correctly or you're missing a namespace declaration.
I think they split the package,
try
Google.Apis.Oauth2.v2
Google.Apis.Sheets.v4
For credentials and SheetsService
@@d.arruda6308 Thank u maan
How to fill the cells with color?
Check out this stackoverflow answer for details on how to do this in a batch update: stackoverflow.com/a/42926722
@@twilio much obliged!!!)
You're my god
Nah, just a video creator who hopefully helped you :)
Hello Sir. I got this error on response.execute. Please help! Thanks!
Google.GoogleApiException: 'Google.Apis.Requests.RequestError
Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See developers.google.com/identity/sign-in/web/devconsole-project. [401]
Errors [
Message[Invalid Credentials] Location[Authorization - header] Reason[authError] Domain[global]
]
How update row or column by ID (find in range congress!A:A value "sen" and update range congress!A(row index):Grow (index) value) ?
Hi man! Can I get the full code?
www.twilio.com/blog/2017/03/google-spreadsheets-and-net-core.html
@@twilio can i filter sheet using this code?? i have phone numbers i want to pass column and phone number to filter the record
It doesn't work anymore
Maybe some of the process has changed in 3 years? I get "System.InvalidOperationException: 'Error creating credential from JSON or JSON parameters. Unrecognized credential type .'"
It only opens spreadsheets and not word documents and powerpoint files?
This example is only Google Sheets. There are APIs for documents and slides though as well.
@@twilio Thankyou