public static void Run()
{
//Source directory
string sourceDir = RunExamples.Get_SourceDirectory();
//Output directory
string outputDir = RunExamples.Get_OutputDirectory();
// Instantiate the Workbook - load an Excel file
Workbook workbook = new Workbook(sourceDir + "sampleCreateManipulateRemoveScenarios.xlsx");
// Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];
// Create a scenario
int i = worksheet.Scenarios.Add("MyScenario");
// Get the scenario
Scenario scenario = worksheet.Scenarios[i];
// Add comment to it
scenario.Comment = "Test sceanrio is created.";
// Get the input cells for the scenario
ScenarioInputCellCollection sic = scenario.InputCells;
// Add the scenario on B4 (as changing cell) with default value
sic.Add(3, 1, "1100000");
// Save the Excel file.
workbook.Save(outputDir + "outputCreateManipulateRemoveScenarios.xlsx");
Console.WriteLine("CreateManipulateRemoveScenarios executed successfully.\r\n");
}
public static void Main()
{
//ExStart:1
// The path to the documents directory.
string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
//Instantiate the Workbook
//Load an Excel file
Workbook workbook = new Workbook(dataDir + "aspose-sample.xlsx");
//Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Remove the existing first scenario from the sheet
worksheet.Scenarios.RemoveAt(0);
//Create a scenario
int i = worksheet.Scenarios.Add("MyScenario");
//Get the scenario
Scenario scenario = worksheet.Scenarios[i];
//Add comment to it
scenario.Comment = "Test sceanrio is created.";
//Get the input cells for the scenario
ScenarioInputCellCollection sic = scenario.InputCells;
//Add the scenario on B4 (as changing cell) with default value
sic.Add(3, 1, "1100000");
//Save the Excel file.
workbook.Save(dataDir + "outBk_scenarios1.out.xlsx");
//ExEnd:1
}
public static void Main()
{
// The path to the documents directory.
string dataDir = Path.GetFullPath("../../../Data/");
//Instantiate the Workbook
//Load an Excel file
Workbook workbook = new Workbook(dataDir + "aspose-sample.xlsx");
//Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Remove the existing first scenario from the sheet
worksheet.Scenarios.RemoveAt(0);
//Create a scenario
int i = worksheet.Scenarios.Add("MyScenario");
//Get the scenario
Scenario scenario = worksheet.Scenarios[i];
//Add comment to it
scenario.Comment = "Test sceanrio is created.";
//Get the input cells for the scenario
ScenarioInputCellCollection sic = scenario.InputCells;
//Add the scenario on B4 (as changing cell) with default value
sic.Add(3, 1, "1100000");
//Save the Excel file.
workbook.Save(dataDir + "outBk_scenarios1.xlsx");
}
