How can i draw this line in excel? (use aspose)

Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » How can i draw this line in excel? (use aspose)

Last post 09-26-2011, 4:01 AM by mshakeel.faiz. 3 replies.


	Sort Posts: Previous Next

09-25-2011, 8:53 PM 331714

mepione
Joined on 09-21-2011
Posts 4

How can i draw this line in excel? (use aspose)

Attachment: Present (inaccessible)

i will draw lines like in this file

i want to know how

please help

Filed under: Apose.Cells;aspose.cells;Aspose.Excel

09-26-2011, 12:52 AM 331738 in reply to 331714

mshakeel.faiz
Joined on 02-01-2007
Posts 9,002

Re: How can i make this line in excel? (use aspose)

Attachment: Present (inaccessible)

Hi,

Please see the code below that adds a line.

C#

string filePath = @"F:\Shak-Data-RW\Downloads\source.xlsx";

Workbook workbook = new Workbook();

Worksheet worksheet = workbook.Worksheets[0];

Aspose.Cells.Drawing.LineShape shape = worksheet.Shapes.AddLine(3, 100, 3, 100, 100, 12);

workbook.Save(filePath + ".out.xlsx");

Screenshot:

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook

09-26-2011, 3:30 AM 331782 in reply to 331738

mepione
Joined on 09-21-2011
Posts 4

Re: How can i make this line in excel? (use aspose)

thank you but

i need a rise line

help please

09-26-2011, 4:01 AM 331798 in reply to 331714

mshakeel.faiz
Joined on 02-01-2007
Posts 9,002

Re: How can i draw this line in excel? (use aspose)

Attachment: Present (inaccessible)

Hi,

It seems like you will have to rotate the line to make it rise.

See the following code and the output file.

C#

string filePath = @"F:\Shak-Data-RW\Downloads\source.xlsx";

Workbook workbook = new Workbook();

Worksheet worksheet = workbook.Worksheets[0];

Aspose.Cells.Drawing.LineShape shape = worksheet.Shapes.AddLine(3, 100, 7, 0, 300, 250);

shape.RotationAngle = 270;

workbook.Save(filePath + ".out.xlsx");

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook