CODEWITHSUNDEEP
apigoogle-apigoogle-docsgoogle-sheets
shamim
shamim

Reputation: 6768

how to upload a excel file in google doc

use C#,want to upload excel file on google doc. bellow syntax use to upload a xls file 

//use Content-Type: text/csv
     entry.MediaSource = new MediaFileSource("E:\\Emailcontent.xls", "text/csv");

but it's not working ,after upload file convert to csv .But i don't want this conversion.I just want to upload my excel file in my google doc.Help me to upload excel file with out conversion.Thanks in advanced

  string USERNAME = "[email protected]";
            string PASSWORD = "xxxxx";

            // Start the service and set credentials
            DocumentsService service = new DocumentsService("MyDocumentsListIntegration-v1");
            service.setUserCredentials(USERNAME, PASSWORD);
            Authenticator authenticator = new ClientLoginAuthenticator("TestApi", Google.GData.Client.ServiceNames.Documents, service.Credentials);
            DocumentEntry entry = new DocumentEntry();
            // Set the document title
            entry.Title.Text = "Legal Contract";
            entry.IsSpreadsheet = true;
            // Set the media source
            //entry.MediaSource = new MediaFileSource("E:\\New Microsoft Office Word Document.doc", "application/msword");
            entry.MediaSource = new MediaFileSource("E:\\Emailcontent.xls", "text/csv");
            // Define the resumable upload link
            Uri createUploadUrl = new Uri("https://docs.google.com/feeds/upload/create-session/default/private/full");
            AtomLink link = new AtomLink(createUploadUrl.AbsoluteUri);
            link.Rel = ResumableUploader.CreateMediaRelation;
            entry.Links.Add(link);

            // Set the service to be used to parse the returned entry
            entry.Service = service;

            // Instantiate the ResumableUploader component.
            ResumableUploader uploader = new ResumableUploader();

            // Set the handlers for the completion and progress events
            uploader.AsyncOperationCompleted += new AsyncOperationCompletedEventHandler(OnDone);
            uploader.AsyncOperationProgress += new AsyncOperationProgressEventHandler(OnProgress);

            // Start the upload process
            uploader.InsertAsync(authenticator, entry, new object());

Upvotes: 1

Views: 1172

Answers (2)

Kenneth
Kenneth

Reputation: 1

To ensure documents aren't converted when you upload them, you should also append ?convert=false to the upload uri.

Upvotes: 0

Tom
Tom

Reputation: 1360

You are passing an xls (Excel) file as a text/csv. If you want to upload as xls, use

entry.MediaSource = new MediaFileSource("E:\\Emailcontent.xls", "text/csv");

If you want to upload as xls, use

entry.MediaSource = new MediaFileSource("E:\\Emailcontent.xls", "application/vnd.ms-excel");

Here is the wikipedia/google search that I used:

http://en.wikipedia.org/wiki/Internet_media_type

Upvotes: 2

Related Questions