Enum UpdateLinksType

UpdateLinksType enumeration

Represents how to update links to other workbooks when the workbook is opened.

public enum UpdateLinksType

Values

NameValueDescription
UserSet0Prompt user to update.
Never1Do not update, and do not prompt user.
Always2Always update.

Examples

[C#]

namespace Demos
{
    using Aspose.Cells;
    using System;

    public class UpdateLinksTypeDemo
    {
        public static void UpdateLinksTypeExample()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();

            // Access the workbook settings
            WorkbookSettings settings = workbook.Settings;

            // Set the UpdateLinksType to Always update
            settings.UpdateLinksType = UpdateLinksType.Always;

            // Add a new worksheet to the workbook
            Worksheet worksheet = workbook.Worksheets[0];

            // Add sample data to the worksheet
            worksheet.Cells["A1"].PutValue("External Link Example");
            worksheet.Cells["A2"].PutValue("Data");

            // Save the workbook
            workbook.Save("UpdateLinksTypeExample.xlsx");

            // Output the current UpdateLinksType setting
            Console.WriteLine("UpdateLinksType is set to: " + settings.UpdateLinksType);
        }
    }
}

See Also