Last post Dec 16, 2010 01:02 AM by Mansoor Sulaiman
Dec 15, 2010 08:30 AM|Inx|LINK
I need to find a way to itarate through the x-axis of an excelsheet. the problem is that as you all might know, the x-axis in excel is not numerical, but alphabetical.. A,B,C....AA,AB,AC...BA,BB,BC...AAB,AAC...etc your get it
and I also need to be able to fetch a range between two cells..
so for instance in this case...I whould need to get the range between a static set cell..for instance E1, and then iterate from that cell x-ammount of cells forward in the x-axis and then in the end of the loop fetch the range between E1 and the last cell
thats iterated trough...
So does anyone have a sulotion to this?..I tried to build a function for converting numbers into the alphabetical order of excel..but my brain got kind of "fried" after a while...
Thanks in advance!
Dec 16, 2010 01:02 AM|Mansoor Sulaiman|LINK
Try to use OfficeInterop dll..you will get all the functionalities of excel.