Skip to content

A boilerplate code to connect Google Spreadsheet Using Java [Read and Write]

License

Notifications You must be signed in to change notification settings

sordgom/Google-Spreadsheet-Using-Java

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Read and Write to Google Spreadsheet using Java

This is a boilerplate project that can be used to read and write from a Google Spreadsheet!


Prerequisites

The foremost task, go to the following link and give it a read. https://developers.google.com/sheets/api/quickstart/java

  • Make sure you complete Step 1.
  • Download the credentials.json and keep it handy

Installing

  • git clone https://github.com/wizArD-1910/Connect-To-Google-Spread-Sheet-Using-Java.git
  • gradle build
  • Copy credentials.json to src/main/resources
  • gradle run
  • A browser window will open, accept and allow google for permissions after reading them
  • Output should be displayed

Reading

  • Go to ReadFromSheet.java
  • Change the spreadsheet id
  • Go to build.gradle
  • Change mainClassName = 'SheetsQuickstart' to mainClassName = 'ReadFromSheet'
  • gradle run

Writing

  • Go to WriteToSheet.java
  • Change the spreadsheet id
  • Go to build.gradle
  • Change mainClassName = 'SheetsQuickstart' to mainClassName = 'WriteToSheet'
  • gradle run

Important Information

After changing SCOPE or SpreadSheetId of your project, delete your tokens folder and rerun the application

Project Structure

|-src
    |-main
        |-java
            |-ReadFromSheet
            |-SheetsQuickstart
            |-WriteToSheet
        |-resources
            |-credential.json
|-build.gradle
|-settings.gradle
|-README.md

Ending Notes

  • The repository follows Conventional Commits and Gitmoji styling
  • The .idea folder contains files that will change project settings for better understanding of comments
  • For comments follow:
    • //TODO: When you want users to complete some tasks
    • //INFO: Add external Information
    • //Bug: To suggests for bugs in code
    • //URL: For adding URLs

Comment Styling

About

A boilerplate code to connect Google Spreadsheet Using Java [Read and Write]

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages