Open and Save Word document in Google Cloud Storage

4 Feb 202523 minutes to read

Prerequisites

Google cloud storage is required.
Service account is required.
Service account key is required.

Open Word document from Google Cloud Storage

Steps to open a Word document from Google Cloud Storage.

Step 1: Create a new ASP.NET Core Web Application (Model-View-Controller).

Create a ASP.NET Core Web App project in visual studio

Step 2: Name the project.

Name the project

Step 3: Install the following Nuget packages in your application from NuGet.org.

Install Syncfusion.DocIO.Net.Core NuGet Package
Install Google.Cloud.Storage.V1 NuGet Package

Step 4: Add a new button in the Index.cshtml as shown below.

CSHTML
@{Html.BeginForm("EditDocument", "Home", FormMethod.Get);
    {
        <div>
            <input type="submit" value="Edit Document" style="width:150px;height:27px" />
        </div>
    }
    Html.EndForm();
}

Step 5: Include the following namespaces in HomeController.cs.

C#
using Google.Apis.Auth.OAuth2;
using Google.Cloud.Storage.V1;
using Syncfusion.DocIO.DLS;

Step 6: Include the below code snippet in HomeController.cs to open a Word document from Google Cloud Storage.

C#
public async Task<IActionResult> EditDocument()
{
    //Download the file from Google
    MemoryStream memoryStream = await GetDocumentFromGoogle();

    //Create an instance of WordDocument
    using (WordDocument wordDocument = new WordDocument(memoryStream, Syncfusion.DocIO.FormatType.Docx))
    {
        //Access the section in a Word document
        IWSection section = wordDocument.Sections[0];

        //Add new paragraph to the section
        IWParagraph paragraph = section.AddParagraph();
        paragraph.ParagraphFormat.FirstLineIndent = 36;
        paragraph.BreakCharacterFormat.FontSize = 12f;

        //Add new text to the paragraph
        IWTextRange textRange = paragraph.AppendText("In 2000, AdventureWorks Cycles bought a small manufacturing plant, Importadores Neptuno, located in Mexico. Importadores Neptuno manufactures several critical subcomponents for the AdventureWorks Cycles product line. These subcomponents are shipped to the Bothell location for final product assembly. In 2001, Importadores Neptuno, became the sole manufacturer and distributor of the touring bicycle product group.") as IWTextRange;
        textRange.CharacterFormat.FontSize = 12f;

        //Saving the Word document to a MemoryStream
        MemoryStream outputStream = new MemoryStream();
        wordDocument.Save(outputStream, Syncfusion.DocIO.FormatType.Docx);

        //Download the Word file in the browser
        FileStreamResult fileStreamResult = new FileStreamResult(outputStream, "application/msword");
        fileStreamResult.FileDownloadName = "EditWord.docx";
        return fileStreamResult;
    }
}

Download file from Google cloud storage

This is the helper method to download Word document from Google cloud storage.

C#
/// <summary>
/// Download file from Google
/// </summary>
/// <returns></returns>
public async Task<MemoryStream> GetDocumentFromGoogle()
{
    try
    {
        //Your bucket name
        string bucketName = "Your_bucket_name";

        //Your service account key file path
        string keyPath = "credentials.json";

        //Name of the file to download from the Google Cloud Storage
        string fileName = "WordTemplate.docx";

        //Create Google Credential from the service account key file
        GoogleCredential credential = GoogleCredential.FromFile(keyPath);

        //Instantiates a storage client to interact with Google Cloud Storage
        StorageClient storageClient = StorageClient.Create(credential);

        //Download a file from Google Cloud Storage
        MemoryStream memoryStream = new MemoryStream();
        await storageClient.DownloadObjectAsync(bucketName, fileName, memoryStream);
        memoryStream.Position = 0;

        return memoryStream;
    }
    catch (Exception ex)
    {
        Console.WriteLine($"Error retrieving document from Google Cloud Storage: {ex.Message}");
        throw; // or handle the exception as needed
    }
}

You can download a complete working sample from GitHub.

By executing the program, you will get the Word document as follows.

Output Word document

Save Word document to Google Cloud Storage

Steps to save a Word document to Google Cloud Storage.