public static void Run()
{
// ExStart:1
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create directory if it is not already present.
bool IsExists = System.IO.Directory.Exists(dataDir);
if (!IsExists)
{
System.IO.Directory.CreateDirectory(dataDir);
}
// Instantiate a new Workbook.
Workbook excelbook = new Workbook();
// Insert a value.
excelbook.Worksheets[0].Cells["C2"].PutValue("Age Groups");
// Set the font text bold.
excelbook.Worksheets[0].Cells["C2"].GetStyle().Font.IsBold = true;
// Add a radio button to the first sheet.
Aspose.Cells.Drawing.RadioButton radio1 = excelbook.Worksheets[0].Shapes.AddRadioButton(3, 0, 2, 0, 30, 110);
// Set its text string.
radio1.Text = "20-29";
// Set A1 cell as a linked cell for the radio button.
radio1.LinkedCell = "A1";
// Make the radio button 3-D.
radio1.Shadow = true;
// Set the weight of the radio button.
radio1.Line.Weight = 4;
// Set the dash style of the radio button.
radio1.Line.DashStyle = MsoLineDashStyle.Solid;
// Add another radio button to the first sheet.
Aspose.Cells.Drawing.RadioButton radio2 = excelbook.Worksheets[0].Shapes.AddRadioButton(6, 0, 2, 0, 30, 110);
// Set its text string.
radio2.Text = "30-39";
// Set A1 cell as a linked cell for the radio button.
radio2.LinkedCell = "A1";
// Make the radio button 3-D.
radio2.Shadow = true;
// Set the weight of the radio button.
radio2.Line.Weight = 4;
// Set the dash style of the radio button.
radio2.Line.DashStyle = MsoLineDashStyle.Solid;
// Add another radio button to the first sheet.
Aspose.Cells.Drawing.RadioButton radio3 = excelbook.Worksheets[0].Shapes.AddRadioButton(9, 0, 2, 0, 30, 110);
// Set its text string.
radio3.Text = "40-49";
// Set A1 cell as a linked cell for the radio button.
radio3.LinkedCell = "A1";
// Make the radio button 3-D.
radio3.Shadow = true;
// Set the weight of the radio button.
radio3.Line.Weight = 4;
// Set the dash style of the radio button.
radio3.Line.DashStyle = MsoLineDashStyle.Solid;
// Save the excel file.
excelbook.Save(dataDir + "book1.out.xls");
// ExEnd:1
}
public static void Run()
{
// ExStart:1
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create directory if it is not already present.
bool IsExists = System.IO.Directory.Exists(dataDir);
if (!IsExists)
{
System.IO.Directory.CreateDirectory(dataDir);
}
// Instantiate a new Workbook.
Workbook excelbook = new Workbook();
// Add a group box to the first worksheet.
Aspose.Cells.Drawing.GroupBox box = excelbook.Worksheets[0].Shapes.AddGroupBox(1, 0, 1, 0, 300, 250);
// Set the caption of the group box.
box.Text = "Age Groups";
box.Placement = PlacementType.FreeFloating;
// Make it 2-D box.
box.Shadow = false;
// Add a radio button.
Aspose.Cells.Drawing.RadioButton radio1 = excelbook.Worksheets[0].Shapes.AddRadioButton(3, 0, 2, 0, 30, 110);
// Set its text string.
radio1.Text = "20-29";
// Set A1 cell as a linked cell for the radio button.
radio1.LinkedCell = "A1";
// Make the radio button 3-D.
radio1.Shadow = true;
// Set the weight of the radio button.
radio1.Line.Weight = 4;
// Set the dash style of the radio button.
radio1.Line.DashStyle = MsoLineDashStyle.Solid;
// Add another radio button.
Aspose.Cells.Drawing.RadioButton radio2 = excelbook.Worksheets[0].Shapes.AddRadioButton(6, 0, 2, 0, 30, 110);
// Set its text string.
radio2.Text = "30-39";
// Set A1 cell as a linked cell for the radio button.
radio2.LinkedCell = "A1";
// Make the radio button 3-D.
radio2.Shadow = true;
// Set the weight of the radio button.
radio2.Line.Weight = 4;
// Set the dash style of the radio button.
radio2.Line.DashStyle = MsoLineDashStyle.Solid;
// Add another radio button.
Aspose.Cells.Drawing.RadioButton radio3 = excelbook.Worksheets[0].Shapes.AddRadioButton(9, 0, 2, 0, 30, 110);
// Set its text string.
radio3.Text = "40-49";
// Set A1 cell as a linked cell for the radio button.
radio3.LinkedCell = "A1";
// Make the radio button 3-D.
radio3.Shadow = true;
// Set the weight of the radio button.
radio3.Line.Weight = 4;
// Set the dash style of the radio button.
radio3.Line.DashStyle = MsoLineDashStyle.Solid;
// Get the shapes.
Aspose.Cells.Drawing.Shape[] shapeobjects = new Aspose.Cells.Drawing.Shape[] { box, radio1, radio2, radio3 };
// Group the shapes.
Aspose.Cells.Drawing.GroupShape group = excelbook.Worksheets[0].Shapes.Group(shapeobjects);
// Save the excel file.
excelbook.Save(dataDir + "book1.out.xls");
// ExEnd:1
}
public static void Main(string[] args)
{
// The path to the documents directory.
string dataDir = Path.GetFullPath("../../../Data/");
// Create directory if it is not already present.
bool IsExists = System.IO.Directory.Exists(dataDir);
if (!IsExists)
{
System.IO.Directory.CreateDirectory(dataDir);
}
//Instantiate a new Workbook.
Workbook excelbook = new Workbook();
//Insert a value.
excelbook.Worksheets[0].Cells["C2"].PutValue("Age Groups");
//Set the font text bold.
excelbook.Worksheets[0].Cells["C2"].GetStyle().Font.IsBold = true;
//Add a radio button to the first sheet.
Aspose.Cells.Drawing.RadioButton radio1 = excelbook.Worksheets[0].Shapes.AddRadioButton(3, 0, 2, 0, 30, 110);
//Set its text string.
radio1.Text = "20-29";
//Set A1 cell as a linked cell for the radio button.
radio1.LinkedCell = "A1";
//Make the radio button 3-D.
radio1.Shadow = true;
//Set the foreground color of the radio button.
radio1.FillFormat.ForeColor = Color.LightGreen;
// set the line style of the radio button.
radio1.LineFormat.Style = MsoLineStyle.ThickThin;
//Set the weight of the radio button.
radio1.LineFormat.Weight = 4;
//Set the line color of the radio button.
radio1.LineFormat.ForeColor = Color.Blue;
//Set the dash style of the radio button.
radio1.LineFormat.DashStyle = MsoLineDashStyle.Solid;
//Make the line format visible.
radio1.LineFormat.IsVisible = true;
//Make the fill format visible.
radio1.FillFormat.IsVisible = true;
//Add another radio button to the first sheet.
Aspose.Cells.Drawing.RadioButton radio2 = excelbook.Worksheets[0].Shapes.AddRadioButton(6, 0, 2, 0, 30, 110);
//Set its text string.
radio2.Text = "30-39";
//Set A1 cell as a linked cell for the radio button.
radio2.LinkedCell = "A1";
//Make the radio button 3-D.
radio2.Shadow = true;
//Set the foreground color of the radio button.
radio2.FillFormat.ForeColor = Color.LightGreen;
// set the line style of the radio button.
radio2.LineFormat.Style = MsoLineStyle.ThickThin;
//Set the weight of the radio button.
radio2.LineFormat.Weight = 4;
//Set the line color of the radio button.
radio2.LineFormat.ForeColor = Color.Blue;
//Set the dash style of the radio button.
radio2.LineFormat.DashStyle = MsoLineDashStyle.Solid;
//Make the line format visible.
radio2.LineFormat.IsVisible = true;
//Make the fill format visible.
radio2.FillFormat.IsVisible = true;
//Add another radio button to the first sheet.
Aspose.Cells.Drawing.RadioButton radio3 = excelbook.Worksheets[0].Shapes.AddRadioButton(9, 0, 2, 0, 30, 110);
//Set its text string.
radio3.Text = "40-49";
//Set A1 cell as a linked cell for the radio button.
radio3.LinkedCell = "A1";
//Make the radio button 3-D.
radio3.Shadow = true;
//Set the foreground color of the radio button.
radio3.FillFormat.ForeColor = Color.LightGreen;
// set the line style of the radio button.
radio3.LineFormat.Style = MsoLineStyle.ThickThin;
//Set the weight of the radio button.
radio3.LineFormat.Weight = 4;
//Set the line color of the radio button.
radio3.LineFormat.ForeColor = Color.Blue;
//Set the dash style of the radio button.
radio3.LineFormat.DashStyle = MsoLineDashStyle.Solid;
//Make the line format visible.
radio3.LineFormat.IsVisible = true;
//Make the fill format visible.
radio3.FillFormat.IsVisible = true;
//Save the excel file.
excelbook.Save(dataDir + "book1.xls");
}
public static void Main(string[] args)
{
// The path to the documents directory.
string dataDir = Path.GetFullPath("../../../Data/");
// Create directory if it is not already present.
bool IsExists = System.IO.Directory.Exists(dataDir);
if (!IsExists)
{
System.IO.Directory.CreateDirectory(dataDir);
}
//Instantiate a new Workbook.
Workbook excelbook = new Workbook();
//Add a group box to the first worksheet.
Aspose.Cells.Drawing.GroupBox box = excelbook.Worksheets[0].Shapes.AddGroupBox(1, 0, 1, 0, 300, 250);
//Set the caption of the group box.
box.Text = "Age Groups";
box.Placement = PlacementType.FreeFloating;
//Make it 2-D box.
box.Shadow = false;
//Add a radio button.
Aspose.Cells.Drawing.RadioButton radio1 = excelbook.Worksheets[0].Shapes.AddRadioButton(3, 0, 2, 0, 30, 110);
//Set its text string.
radio1.Text = "20-29";
//Set A1 cell as a linked cell for the radio button.
radio1.LinkedCell = "A1";
//Make the radio button 3-D.
radio1.Shadow = true;
//Set the foreground color of the radio button.
radio1.FillFormat.ForeColor = Color.LightGreen;
//Set the line style of the radio button.
radio1.LineFormat.Style = MsoLineStyle.ThickThin;
//Set the weight of the radio button.
radio1.LineFormat.Weight = 4;
//Set the line color of the radio button.
radio1.LineFormat.ForeColor = Color.Blue;
//Set the dash style of the radio button.
radio1.LineFormat.DashStyle = MsoLineDashStyle.Solid;
//Make the line format visible.
radio1.LineFormat.IsVisible = true;
//Make the fill format visible.
radio1.FillFormat.IsVisible = true;
//Add another radio button.
Aspose.Cells.Drawing.RadioButton radio2 = excelbook.Worksheets[0].Shapes.AddRadioButton(6, 0, 2, 0, 30, 110);
//Set its text string.
radio2.Text = "30-39";
//Set A1 cell as a linked cell for the radio button.
radio2.LinkedCell = "A1";
//Make the radio button 3-D.
radio2.Shadow = true;
//Set the foreground color of the radio button.
radio2.FillFormat.ForeColor = Color.LightGreen;
//Set the line style of the radio button.
radio2.LineFormat.Style = MsoLineStyle.ThickThin;
//Set the weight of the radio button.
radio2.LineFormat.Weight = 4;
//Set the line color of the radio button.
radio2.LineFormat.ForeColor = Color.Blue;
//Set the dash style of the radio button.
radio2.LineFormat.DashStyle = MsoLineDashStyle.Solid;
//Make the line format visible.
radio2.LineFormat.IsVisible = true;
//Make the fill format visible.
radio2.FillFormat.IsVisible = true;
//Add another radio button.
Aspose.Cells.Drawing.RadioButton radio3 = excelbook.Worksheets[0].Shapes.AddRadioButton(9, 0, 2, 0, 30, 110);
//Set its text string.
radio3.Text = "40-49";
//Set A1 cell as a linked cell for the radio button.
radio3.LinkedCell = "A1";
//Make the radio button 3-D.
radio3.Shadow = true;
//Set the foreground color of the radio button.
radio3.FillFormat.ForeColor = Color.LightGreen;
//Set the line style of the radio button.
radio3.LineFormat.Style = MsoLineStyle.ThickThin;
//Set the weight of the radio button.
radio3.LineFormat.Weight = 4;
//Set the line color of the radio button.
radio3.LineFormat.ForeColor = Color.Blue;
//Set the dash style of the radio button.
radio3.LineFormat.DashStyle = MsoLineDashStyle.Solid;
//Make the line format visible.
radio3.LineFormat.IsVisible = true;
//Make the fill format visible.
radio3.FillFormat.IsVisible = true;
//Get the shapes.
Aspose.Cells.Drawing.Shape[] shapeobjects = new Aspose.Cells.Drawing.Shape[] { box, radio1, radio2, radio3 };
//Group the shapes.
Aspose.Cells.Drawing.GroupShape group = excelbook.Worksheets[0].Shapes.Group(shapeobjects);
//Save the excel file.
excelbook.Save(dataDir + "book1.xls");
}