Find Column Index as per text in the Cell

Aspose.Cells Product Family
1

Hi.

We are using Aspose.Cells for .Net with version 4.2.0.

The first row contains the Headers as below

Id Name Date

I want to find the Cell position of the column which has the text as "Name". I tried using the method CellsHelper.CellNameToIndex(). But this require the Cell Name which i don't know in my case.

Please suggest to the earliest.

Thanks,

Milind

2

Hi,


Thanks for your query.

Well, you may try using Find or Search feature provided by Aspose.Cells APIs, you may find the string “Name” and get the underlying cell which contains that string for your requirements, see the document for your reference:

Since you are using very older version i.e., v4.2.0 for which we are not sure if Find or Search options were available in that version. Anyways, you may try to find the relevant APIs (as mentioned in the document/ article) in your older version. We also recommend you to upgrade to and use latest versions of Aspose.Cells APIs as over the years we have enhanced existing features and included new features and fixes to make the product more robust and feature rich APIs.

Thank you.