Syncfusion.XlsIO.Base
Example 


PromptBoxText Property

Gets or sets the text in the prompt box. The prompt box text can be edit based on the validation.
Syntax
'Declaration
 
Property PromptBoxText As String
'Usage
 
Dim instance As IDataValidation
Dim value As String
 
instance.PromptBoxText = value
 
value = instance.PromptBoxText
string PromptBoxText {get; set;}
Remarks
To know more about PromptBoxText property refer this link.
Example
The following code illustrates the use of PromptBoxText property.
using Syncfusion.XlsIO;
using System.Drawing;
            
class Example
{
    static void Main()
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
           //Create a worksheet.        
           IApplication application = excelEngine.Excel;
           application.DefaultVersion = ExcelVersion.Excel2013;
           IWorkbook workbook = application.Workbooks.Create(1);
           IWorksheet worksheet = workbook.Worksheets[0];
           worksheet.Range["C3"].CellStyle.Color = Color.LightGray;
           worksheet.Range["C1"].Text = "Data Validation List in C3";
           worksheet.Range["C1"].AutofitColumns();
            
           // DataValidation in Worksheet Range
           IDataValidation dataValidation = worksheet.Range["C3"].DataValidation;
           dataValidation.ListOfValues = new string[] { "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday" };
           dataValidation.PromptBoxTitle = "Sample";
           dataValidation.PromptBoxText = "Data validation for list"; // Text of PromptBox
           dataValidation.ShowPromptBox = true;
           dataValidation.PromptBoxHPosition = 25;
           dataValidation.PromptBoxVPosition = 30;
           dataValidation.IsPromptBoxPositionFixed = true;
           dataValidation.IsPromptBoxVisible = true;
           dataValidation.IsListInFormula = true;
           workbook.SaveAs("DataValidation.xlsx");
           workbook.Close();
           excelEngine.Dispose();
        }
     }
 }
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also