This topic describes how to share and download a workbook after data analysis is completed.

Prerequisites

Sharing and download are allowed. You can perform the following steps: On the Configuration Management page, turn on Allow Sharing and Allow Download in the Spreadsheet section.Configuration Management
Note You must use your Alibaba Cloud account to access the Configuration Management page and configure relevant settings.

Background information

Workbook sharing is applicable to the following scenarios:
  • Collaboratively edit a workbook with multiple users.

    For example, a workbook is used to collect personal information of team members and information about whether they enroll for an event. You can share the workbook with the team members and grant them permissions to edit the workbook.

  • Share analysis results with other users.

    You can share a workbook with other users and grant them permissions to view the workbook.

Go to the workbook editing page

  1. Go to the DataStudio page.
    1. Log on to the DataWorks console.
    2. In the left-side navigation pane, click Workspaces.
    3. In the top navigation bar, select the region where the target workspace resides. Find the target workspace and click Data Analytics in the Actions column.
  2. On the DataStudio page, click the Icon icon in the upper-left corner and choose All Products > Data Development > DataAnalysis.
  3. On the DataAnalysis homepage, click Experience Now. The Web Excel page appears.
  4. In the All Spreadsheets section of the Web Excel page, click the name of the workbook that you want to edit in the File Name column to go to the workbook editing page.
    If you create a workbook in this step, the workbook editing page appears after the workbook is created. For more information, see Edit a workbook and analyze data.

Export a workbook

  1. In the upper-right corner of the workbook editing page, choose Export > Generate MaxCompute Build Table Statement.
  2. In the Export as MaxCompute Table dialog box, set relevant parameters.
    Export
    Insert mode Parameter Description
    Insert Data into MaxCompute Table (INSERT OVERWRITE) (insert overwrite) Workspace The workspace to which the MaxCompute table belongs.
    Table The MaxCompute table to which you want to insert data.
    Create MaxCompute Table and Insert Data (INSERT OVERWRITE) Workspace The workspace to which the MaxCompute table belongs.
    Table Name The name of the MaxCompute table. Make sure that the table name is unique. You can click Check Duplicate Names to check whether the table name exists.
  3. After the parameters are set, click Copy SQL Statement and then click Close.
    Notice Only non-partitioned tables are supported.
  4. On the workbook editing page, click the ste icon in the upper-left corner and choose All Products > Data Development > DataStudio.
  5. Insert data to an existing MaxCompute table or create a MaxCompute table and insert data to the created table.
    • Insert Data into MaxCompute Table (INSERT OVERWRITE) (insert overwrite)

      If you select Insert Data into MaxCompute Table (INSERT OVERWRITE) (insert overwrite) as the insert mode, go to the editing page of the MaxCompute table to which you want to insert data. On the editing page of the MaxCompute table, click DDL mode. In the DDL mode dialog box, paste the copied SQL statement and click Generate table structure.

    • Create MaxCompute Table and Insert Data (INSERT OVERWRITE)

      If you select Create MaxCompute Table and Insert Data (INSERT OVERWRITE) as the insert mode, create a MaxCompute table and execute the copied SQL statement.

  6. Click Submit to development environment and Submit to production environment in sequence.
    If you are using a workspace in basic mode, you only need to click Submit to production environment.

Share a workbook

In the upper-right corner of the workbook editing page, click Share. In the dialog box that appears, set the sharing method as needed.Share
You must configure the following information before you can share a workbook with other users:
  • Link: After you specify Users with Edit Access and Users with Read Access or turn on Visible to All, click Copy Link and send the copied URL to other users as needed.
    If you turn on Access Code, a URL with an access code is generated.Copy
  • Users with Edit Access: To specify users with permissions to edit the workbook, click Add in the Users with Edit Access section. In the Share File with These Users dialog box, enter and select the names of the users to be granted the edit permissions, and click OK.
    Note You can grant the edit permissions to up to 10 users.
  • Visible to All: To allow all users to view the workbook, turn on Visible to All.
  • Users with Read Access: To specify users with permissions to view the workbook, turn off Visible to All and click Add in the Users with Read Access section. In the Share File with These Users dialog box, enter and select the names of the users to be granted the read permissions, and click OK.
    Note You can grant the read permissions to up to 30 users.
After the sharing method is set, you can send the URL to other users. The users can access the workbook through the URL. On the Web Excel page, you can also view the workbooks that are shared with you.Share

Download a workbook

In the upper-right corner of the workbook editing page, click Download to download the workbook to a local directory.Download