Java – Use the Google API Java client to upload a database to a Google spreadsheet

Use the Google API Java client to upload a database to a Google spreadsheet… here is a solution to the problem.

Use the Google API Java client to upload a database to a Google spreadsheet

I

would like to get some feedback before I start. I’m interested in having my Android app upload my SQLite database to a Google spreadsheet. I got some mixed feedback from a couple of people, so I wanted to make sure I was moving in the right direction.

Should I use Google API Java Client? , or more specifically create spreadsheets using the Google Documents List API, and then use the Google Spreadsheet API to add and edit data in the spreadsheet. Is this the right way to do what I’m doing? If so, do you know of some useful sample code?

I really appreciate someone’s guidance on this matter. If something is unclear in my question, please ask.

Cheers
George

Solution

Do not use the deprecated Document List API.

All the actions you list (create a spreadsheet and fill it out) can be done by GData Spreadsheets API implementation. The documentation contains good Java examples.

If you also want to share a spreadsheet or move it to a specific Drive folder, use Google Drive SDK

Related Problems and Solutions