Aspose cells utility to traverse columns

Aspose.Cells Product Family
1

Hello Team,

Is there any utility which can help me traverse excel columns faster while Aspose.cells Java.

Basically I have a formula logic which is something like VLOOKUP(EA,…) now I want to apply this in multiple places but every time it should jump one cell for example EA then EC then EE then EG and so on.

So can how I do jump 2 columns every time and still put formula value intact since column names are not numeric.

2

@sourav24
Would you like to provide more detailed information? If you could provide sample files, expected results, and screenshots, it would be very helpful for us to analyze the cause, locate the issue and find a solution.

3

Hello @John.He, Thanks for your reply. Sure let me prepare the sample files and expected results. Will share it to you by tomorrow.

4

@sourav24,

Sure, please take your time to provide more details and prepare sample files, expected results, and screenshots. We will be looking forward to receiving the samples and details.