Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to create a new spreadsheet programmatically in Android/Java?

I am working on Google Spreadsheets API. I stuck at a point where I want to create a new spreadsheet. Google spreadsheets API says only about retrieving already created spreadsheets and their management(including cell content updating etc..). They also listed that it is possible to create a new spreadsheet by uploading a spreadsheet file via the Google Documents List API. I have gone through Google Documents List API but I didn't find any documentation for Java. They only provided .Net documentation. So my question is "Is it possible to create a new spreadsheet in Java/Android programmatically??".

If possible, could anyone guide me to a good link or blog or a piece of article. It will be a great help to me.

Any help will be appreciated !!

UPDATE : I am not talking about creating a spreadsheet locally, rather I am talking about creating a spreadsheet through API call. Here is my scenario : I want to update some statistics to a spreadsheet. The name of spreadsheet will be in the format CURRENT_MONTH-SOME NAME.xls. So a spreadsheet must be automatically created on the beginning of each month. Currently what I doing, at the year start, I will create 12 spreadsheets for the year manually and on each month, corresponding spreadsheets are retrieved and that's month's data is inserted or deleted or modified depending on my needs. So what I am searching here, I want to make this process automated ( spreadsheet should be created programmatically. I don't also prefer dependencies like installing Google Drive app and copying files to Google Drive app, as an alternative solution ). Please let me know your thoughts and suggestions on it.

like image 392
Sanal Varghese Avatar asked Nov 13 '22 03:11

Sanal Varghese


1 Answers

if you want to create spreadsheet better to user apache POI

here is an exaample

http://viralpatel.net/blogs/java-read-write-excel-file-apache-poi/

like image 187
shreyansh jogi Avatar answered Nov 14 '22 23:11

shreyansh jogi