public static void Main(string[] args)
{
//ExStart:1
// The path to the documents directory.
string dataDir = Aspose.Cells.Examples.Utils.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 book = new Workbook();
//Add a Data Worksheet
Worksheet dataSheet = book.Worksheets.Add("DataSheet");
//Add Chart Worksheet
Worksheet sheet = book.Worksheets.Add("MyChart");
//Put some values into the cells in the data worksheet
dataSheet.Cells["B1"].PutValue(1);
dataSheet.Cells["B2"].PutValue(2);
dataSheet.Cells["B3"].PutValue(3);
dataSheet.Cells["A1"].PutValue("A");
dataSheet.Cells["A2"].PutValue("B");
dataSheet.Cells["A3"].PutValue("C");
//Define the Chart Collection
ChartCollection charts = sheet.Charts;
//Add a Column chart to the Chart Worksheet
int chartSheetIdx = charts.Add(ChartType.Column, 5, 0, 25, 15);
//Get the newly added Chart
Aspose.Cells.Charts.Chart chart = book.Worksheets[2].Charts[0];
//Set the background/foreground color for PlotArea/ChartArea
chart.PlotArea.Area.BackgroundColor = Color.White;
chart.ChartArea.Area.BackgroundColor = Color.White;
chart.PlotArea.Area.ForegroundColor = Color.White;
chart.ChartArea.Area.ForegroundColor = Color.White;
//Hide the Legend
chart.ShowLegend = false;
//Add Data Series for the Chart
chart.NSeries.Add("DataSheet!B1:B3", true);
//Specify the Category Data
chart.NSeries.CategoryData = "DataSheet!A1:A3";
//Get the Data Series
Aspose.Cells.Charts.Series ser = chart.NSeries[0];
//Apply the 3-D formatting
ShapePropertyCollection spPr = ser.ShapeProperties;
Format3D fmt3d = spPr.Format3D;
//Specify Bevel with its height/width
Bevel bevel = fmt3d.TopBevel;
bevel.Type = BevelPresetType.Circle;
bevel.Height = 2;
bevel.Width = 5;
//Specify Surface material type
fmt3d.SurfaceMaterialType = PresetMaterialType.WarmMatte;
//Specify surface lighting type
fmt3d.SurfaceLightingType = LightRigType.ThreePoint;
//Specify lighting angle
fmt3d.LightingAngle = 20;
//Specify Series background/foreground and line color
ser.Area.BackgroundColor = Color.Maroon;
ser.Area.ForegroundColor = Color.Maroon;
ser.Border.Color = Color.Maroon;
//Save the Excel file
book.Save(dataDir + "3d_format.out.xlsx");
//ExEnd:1
}
public static void Run()
{
// Instantiate a new Workbook
Workbook book = new Workbook();
//Rename the first worksheet
book.Worksheets[0].Name = "DataSheet";
// Add a Data Worksheet
Worksheet dataSheet = book.Worksheets["DataSheet"];
// Add Chart Worksheet
Worksheet sheet = book.Worksheets.Add("MyChart");
// Put some values into the cells in the data worksheet
dataSheet.Cells["B1"].PutValue(1);
dataSheet.Cells["B2"].PutValue(2);
dataSheet.Cells["B3"].PutValue(3);
dataSheet.Cells["A1"].PutValue("A");
dataSheet.Cells["A2"].PutValue("B");
dataSheet.Cells["A3"].PutValue("C");
// Define the Chart Collection
ChartCollection charts = sheet.Charts;
// Add a Column chart to the Chart Worksheet
int chartSheetIdx = charts.Add(ChartType.Column, 5, 0, 25, 15);
// Get the newly added Chart
Aspose.Cells.Charts.Chart chart = book.Worksheets["MyChart"].Charts[0];
// Set the background/foreground color for PlotArea/ChartArea
chart.PlotArea.Area.BackgroundColor = Color.White;
chart.ChartArea.Area.BackgroundColor = Color.White;
chart.PlotArea.Area.ForegroundColor = Color.White;
chart.ChartArea.Area.ForegroundColor = Color.White;
// Hide the Legend
chart.ShowLegend = false;
// Add Data Series for the Chart
chart.NSeries.Add("DataSheet!B1:B3", true);
// Specify the Category Data
chart.NSeries.CategoryData = "DataSheet!A1:A3";
// Get the Data Series
Aspose.Cells.Charts.Series ser = chart.NSeries[0];
// Apply the 3-D formatting
ShapePropertyCollection spPr = ser.ShapeProperties;
Format3D fmt3d = spPr.Format3D;
// Specify Bevel with its height/width
Bevel bevel = fmt3d.TopBevel;
bevel.Type = BevelPresetType.Circle;
bevel.Height = 2;
bevel.Width = 5;
// Specify Surface material type
fmt3d.SurfaceMaterialType = PresetMaterialType.WarmMatte;
// Specify surface lighting type
fmt3d.SurfaceLightingType = LightRigType.ThreePoint;
// Specify lighting angle
fmt3d.LightingAngle = 20;
// Specify Series background/foreground and line color
ser.Area.BackgroundColor = Color.Maroon;
ser.Area.ForegroundColor = Color.Maroon;
ser.Border.Color = Color.Maroon;
// Save the Excel file
book.Save(outputDir + "outputApplying3DFormat.xlsx");
Console.WriteLine("Applying3DFormat executed successfully.");
}
