Is there a way to get Worksheet from the Cell in Aspose Cells?

Question

I'm looking for something like myCell.Parent or myCell.Worksheet to get the Worksheet object of a Cell in Aspose cells for .net. I didn't see any property on the Cell class that refers the Worksheet. Wondering if there is a way that I missed?

The cell should be created or referenced from worksheet. There you should know the cell's parent or worksheet. — David.Chu.ca, Feb 25 '11 at 21:12
I want to write some cool extension methods on the cell. therefore i need also the reference to the Worksheet, but i don't want to pass it as a parameter on the method. — gsharp, Feb 25 '11 at 21:57

score 2 · Answer 1 · answered Apr 20 '11 at 18:56

2

Using the latest versions of Aspose.Cells for .NET (e.g Aspose.Cells for .NET v5.3.2 etc.) now, it is possible to get the parent worksheet from the cell object. You may simply use Cell.Worksheet property.

answered Apr 20 '11 at 18:56

Amjad Sahi

31
2

score 0 · Accepted Answer · answered Feb 28 '11 at 07:37

0

I've also asked in the Aspose Forum. It's not possible yet, but the added my request as new feature request.

answered Feb 28 '11 at 07:37

gsharp

27,557
22
88
134

score -1 · Answer 3 · answered Feb 25 '11 at 21:21

-1

Convert or cast cell to Range and then you can find the Worksheet property:

Excel.Range myRange = (Excel.Range) myCell;
Excel.WorkSheet myWS = null;
if ( myCell != null ) {
   myWS = myRange.WorkSheet;
}

answered Feb 25 '11 at 21:21

David.Chu.ca

37,408
63
148
190

Not in Excel. In aspose cells. – gsharp Feb 25 '11 at 21:56

Is there a way to get Worksheet from the Cell in Aspose Cells?

3 Answers3