Relative Content

Tag Archive for office-jsexcel-addins

How to implement an range selector input using Excel Javascript API?

I have an Excel Add-In that opens a taskpane and, using Excel Javascript API, displays a form that the user fills in. In that form, I need to include an input where the user should be able to select a cell/range. In other words, the same behaviour of this Excel component:

How to find Merger cell for givenNamedRange(NamedItem)

I want To create One object in which I want to store Cell address and there column and row index.
I have achieve that using this code but in mereged cell I’m facing issue. If A1 and B1 Cell is merged than I want only A1 Cell but currently I get both A1 and B1 cell.
Is there way I can find merged cell from given range(namedRange).