Workbook workbook = new Workbook();
// Access first worksheet from the collection
Worksheet sheet = workbook.getWorksheets().get(0);
// Add the line arrow to the worksheet
Shape line1 = sheet.getShapes().addShape(MsoDrawingType.LINE, 4, 0, 4, 0, 100, 300);//method 1
//add a arrow at the line begin
line1.getLine().setBeginArrowheadStyle(MsoArrowheadStyle.ARROW_OPEN);//arrow type
line1.getLine().setBeginArrowheadWidth(MsoArrowheadWidth.NARROW);//arrow width
line1.getLine().setBeginArrowheadLength(MsoArrowheadLength.LONG);//arrow length
//add a arrow at the line end
line1.getLine().setEndArrowheadStyle(MsoArrowheadStyle.ARROW);//arrow type
line1.getLine().setEndArrowheadWidth(MsoArrowheadWidth.WIDE);//arrow width
line1.getLine().setEndArrowheadLength(MsoArrowheadLength.SHORT);//arrow length
// Add the line arrow to the worksheet
Shape line2 = sheet.getShapes().addShape(MsoDrawingType.LINE, 4, 0, 4, 0, 100, 300);//method 1
//add a arrow at the line begin
line2.getLine().setBeginArrowheadStyle(MsoArrowheadStyle.ARROW_OPEN);//arrow type
line2.getLine().setBeginArrowheadWidth(MsoArrowheadWidth.NARROW);//arrow width
line2.getLine().setBeginArrowheadLength(MsoArrowheadLength.LONG);//arrow length
//add a arrow at the line end
line2.getLine().setEndArrowheadStyle(MsoArrowheadStyle.ARROW);//arrow type
line2.getLine().setEndArrowheadWidth(MsoArrowheadWidth.WIDE);//arrow width
line2.getLine().setEndArrowheadLength(MsoArrowheadLength.SHORT);//arrow length
line2.setRotationAngle(135);
// Add the line arrow to the worksheet
Shape line3 = sheet.getShapes().addShape(MsoDrawingType.LINE, 10, 0, 10, 0, 30, 50);//method 1
//add a arrow at the line begin
line3.getLine().setBeginArrowheadStyle(MsoArrowheadStyle.ARROW);//arrow type
line3.getLine().setBeginArrowheadWidth(MsoArrowheadWidth.MEDIUM);//arrow width
line3.getLine().setBeginArrowheadLength(MsoArrowheadLength.SHORT);//arrow length
line3.getLine().setWeight(4.5);
line3.setWidthPt(7.5);
line3.setHeightPt(13.5);
// Add the line arrow to the worksheet
Shape line4 = sheet.getShapes().addShape(MsoDrawingType.LINE, 12, 0, 10, 0, 30, 50);//method 1
//add a arrow at the line begin
line4.getLine().setBeginArrowheadStyle(MsoArrowheadStyle.ARROW);//arrow type
line4.getLine().setBeginArrowheadWidth(MsoArrowheadWidth.MEDIUM);//arrow width
line4.getLine().setBeginArrowheadLength(MsoArrowheadLength.SHORT);//arrow length
line4.getLine().setWeight(4.5);
line4.setRotationAngle(90);
line4.setWidthPt(7.5);
line4.setHeightPt(13.5);
//Save the file.
workbook.save(filePath + "java_out.xlsx", SaveFormat.XLSX);
Workbook workbook = new Workbook();
// Access first worksheet from the collection
Worksheet sheet = workbook.Worksheets[0];
// Add the line arrow to the worksheet
Shape line1 = sheet.Shapes.AddShape(MsoDrawingType.Line, 4, 0, 4, 0, 100, 300);//method 1
//add a arrow at the line begin
line1.Line.BeginArrowheadStyle = MsoArrowheadStyle.ArrowOpen;//arrow type
line1.Line.BeginArrowheadWidth = MsoArrowheadWidth.Narrow;//arrow width
line1.Line.BeginArrowheadLength = MsoArrowheadLength.Long;//arrow length
//add a arrow at the line end
line1.Line.EndArrowheadStyle = MsoArrowheadStyle.Arrow;//arrow type
line1.Line.EndArrowheadWidth = MsoArrowheadWidth.Wide;//arrow width
line1.Line.EndArrowheadLength = MsoArrowheadLength.Short;//arrow length
// Add the line arrow to the worksheet
Shape line2 = sheet.Shapes.AddShape(MsoDrawingType.Line, 4, 0, 4, 0, 100, 300);//method 1
//add a arrow at the line begin
line2.Line.BeginArrowheadStyle = MsoArrowheadStyle.ArrowOpen;//arrow type
line2.Line.BeginArrowheadWidth = MsoArrowheadWidth.Narrow;//arrow width
line2.Line.BeginArrowheadLength = MsoArrowheadLength.Long;//arrow length
//add a arrow at the line end
line2.Line.EndArrowheadStyle = MsoArrowheadStyle.Arrow;//arrow type
line2.Line.EndArrowheadWidth = MsoArrowheadWidth.Wide;//arrow width
line2.Line.EndArrowheadLength = MsoArrowheadLength.Short;//arrow length
line2.RotationAngle = 135;
// Add the line arrow to the worksheet
Shape line3 = sheet.Shapes.AddShape(MsoDrawingType.Line, 10, 0, 10, 0, 30, 50);//method 1
//add a arrow at the line begin
line3.Line.BeginArrowheadStyle = MsoArrowheadStyle.Arrow;//arrow type
line3.Line.BeginArrowheadWidth = MsoArrowheadWidth.Medium;//arrow width
line3.Line.BeginArrowheadLength = MsoArrowheadLength.Short;//arrow length
line3.Line.Weight = 4.5;
line3.WidthPt = 7.5;
line3.HeightPt = 13.5;
// Add the line arrow to the worksheet
Shape line4 = sheet.Shapes.AddShape(MsoDrawingType.Line, 12, 0, 10, 0, 30, 50);//method 1
//add a arrow at the line begin
line4.Line.BeginArrowheadStyle = MsoArrowheadStyle.Arrow;//arrow type
line4.Line.BeginArrowheadWidth = MsoArrowheadWidth.Medium;//arrow width
line4.Line.BeginArrowheadLength = MsoArrowheadLength.Short;//arrow length
line4.Line.Weight = 4.5;
line4.RotationAngle = 90;
line4.WidthPt = 7.5;
line4.HeightPt = 13.5;
//Save the file.
workbook.Save(filePath + "net_out.xlsx", SaveFormat.Xlsx);
The issues you have found earlier (filed as CELLSNET-55010) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.