Cannot create spreadsheet in google drive

Question

I tried to create a spreadsheet in Android. It sent a success message but it wasn't created.

I used the following code to create it:

MetadataChangeSet metadataChangeSet = new MetadataChangeSet.Builder()
.setMimeType("application/vnd.google-apps.spreadsheet").setTitle("MonthExpense").build();
IntentSender intentSender = Drive.DriveApi
.newCreateFileActivityBuilder()
.setInitialMetadata(metadataChangeSet)
.setInitialDriveContents(result.getDriveContents())
.build(appobject.mGoogleApiClient);
try {
activity.startIntentSenderForResult(intentSender, 56, null, 0, 0, 0);
}

If I use any other mimetype it works correctly can anyone please guide me in the right way.

Edit If i try any other mime type it works with out problem, So i guess the problem related with "application/vnd.google-apps.spreadsheet"

Answer 1

Try to change application/vnd.google-apps.spreadsheet to application/vnd.ms-excel

Create a WorkBook. This is the end of my working code

final private ResultCallback<DriveContentsResult> driveContentsCallback = new ResultCallback<DriveContentsResult>() {
    @Override
    public void onResult(final DriveContentsResult result) {
        if (!result.getStatus().isSuccess()) {
            showMessage("Error while trying to create new file contents");
            return;
        }
        final DriveContents driveContents = result.getDriveContents();

        // Perform I/O off the UI thread.
        new Thread() {
            @Override
            public void run() {

 //CREATE YOUR WORKBOOK HERE
ByteArrayOutputStream bos = new ByteArrayOutputStream();
                    try {
                        wb.write(bos);
                        byte[] bytes = bos.toByteArray();
                        outputStream.write(bytes);
                        //WORKBOOK FILENAME
                        writer.write(fileName);
                        wb.close();
                    } catch (IOException e) {
                        Log.e(TAG, e.getMessage());
                    }

                    MetadataChangeSet changeSet = new MetadataChangeSet.Builder()
                            .setTitle(fileName)
                            .setMimeType("application/vnd.ms-excel")
                            .setStarred(true).build();

                    // create a file on root folder
                    Drive.DriveApi
                            .getRootFolder(getGoogleApiClient())
                            .createFile(getGoogleApiClient(), changeSet,
                                    driveContents)
                            .setResultCallback(fileCallback);