We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Get referred column names from smart marker

Hi,
I referred this Fetch all the smart markers in the excel template for fetching a smart marker from a sheet. Now, is it possible to get the cell names of the cells referred by a smart marker? Those cells maybe in the same sheet or other sheet in the same workbook.
Eg1. if the smart marker in a cell is
&=&=TEXT(DataSheet!A{r},“MM/DD/YYYY”)
Then I want to extract the sheet name and column name: DataSheet!A

Eg2. &=&=IF(OR(DataSheet!G{r}="",DataSheet!G{r}=0),"",DataSheet!X{r})
It should give me this:
DataSheet!G
DataSheet!X

Eg3. &=&=IF(OR(J{r}=0,J{r}=""),"",ROUND((J{r}*250)/G{r}*100,2))
It should give:
Sheet1!J or J
Sheet1!G or G (where Sheet1 is the sheet containing this marker)

Is there a way to do this?

@ManjuBhagtani,
Thank you for your query.

I am afraid there is not such API or method available which can be used to fetch this information. You can find the cell containing the markers only using the referred link above. After that you may split it to obtain markers part and get the desired detail via your own code and logic. Feel free to contact us if you have any other query or issue regarding Aspose.Cells. We will be happy to provide you assistance at the earliest.