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 workbook = new Workbook();
//Get the first worksheet in the book.
Worksheet worksheet = workbook.Worksheets[0];
//Add a new line to the worksheet.
Aspose.Cells.Drawing.LineShape line1 = worksheet.Shapes.AddLine(5, 0, 1, 0, 0, 250);
//Set the line dash style
line1.LineFormat.DashStyle = MsoLineDashStyle.Solid;
//Set the placement.
line1.Placement = PlacementType.FreeFloating;
//Add another line to the worksheet.
Aspose.Cells.Drawing.LineShape line2 = worksheet.Shapes.AddLine(7, 0, 1, 0, 85, 250);
//Set the line dash style.
line2.LineFormat.DashStyle = MsoLineDashStyle.DashLongDash;
//Set the weight of the line.
line2.LineFormat.Weight = 4;
//Set the placement.
line2.Placement = PlacementType.FreeFloating;
//Add the third line to the worksheet.
Aspose.Cells.Drawing.LineShape line3 = worksheet.Shapes.AddLine(13, 0, 1, 0, 0, 250);
//Set the line dash style
line3.LineFormat.DashStyle = MsoLineDashStyle.Solid;
//Set the placement.
line3.Placement = PlacementType.FreeFloating;
//Make the gridlines invisible in the first worksheet.
workbook.Worksheets[0].IsGridlinesVisible = false;
//Save the excel file.
workbook.Save(dataDir + "book1.out.xls");
//ExEnd:1
}
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 workbook = new Workbook();
//Get the first worksheet in the book.
Worksheet worksheet = workbook.Worksheets[0];
//Add a line to the worksheet
Aspose.Cells.Drawing.LineShape line2 = worksheet.Shapes.AddLine(7, 0, 1, 0, 85, 250);
//Set the line color
line2.LineFormat.ForeColor = Color.Blue;
//Set the line style.
line2.LineFormat.DashStyle = MsoLineDashStyle.Solid;
//Set the weight of the line.
line2.LineFormat.Weight = 3;
//Set the placement.
line2.Placement = PlacementType.FreeFloating;
//Set the line arrows.
line2.EndArrowheadWidth = MsoArrowheadWidth.Medium;
line2.EndArrowheadStyle = MsoArrowheadStyle.Arrow;
line2.EndArrowheadLength = MsoArrowheadLength.Medium;
line2.BeginArrowheadStyle = MsoArrowheadStyle.ArrowDiamond;
line2.BeginArrowheadLength = MsoArrowheadLength.Medium;
//Make the gridlines invisible in the first worksheet.
workbook.Worksheets[0].IsGridlinesVisible = false;
//Save the excel file.
workbook.Save(dataDir + "book1.out.xls");
//ExEnd:1
}
