Named ranges help


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?




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



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!


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?



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.


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