Named ranges help


#1

I apologize if this has been answered elsewhere, although I did a search and did not find what I was looking for.

I have an existing spreadsheet with quite a few named ranged defined. I was hoping that the Worksheet.Cells.Ranges collection would contain these ranges, but it returns an empty collection. Is there another way to access these defined name ranges?

Thanks!


#2

Hi,

Currently Aspose.Excel doesn’t automatically creates range based on names. Could you elaborate your need? Maybe we can find a work around.


#3

Laurence,

No problem, I’m just going to define my ranges in the code, which will do for now.

Just a quick question, though, are there any drawing tools for drawing primitive shapes. For example, I would like to be able to create a colored circle in a cell range. I looked through the API but didn’t find anything resembling drawing tools, so I assume it is not in there. Just want to verify.

Thanks again!


#4

Sorry, Aspose.Excel doesn’t supply this feature. Have you tried to create this drawing shapes in designer file and use Aspose.Excel to import them?


#5

Laurence,

How would you import the drawing objects? I’m still learning the software, since yesterday was the first time I’ve delved into using it.


#6

Just put the drawing objects in designer file and use Excel.Open method to import it.