To Provide index as AA,AB,AC......So on for the list of records in PDF

Zeb dee

Hi, I have to provide index as AA, AB, AC,.... etc to pdf list of rows/records using PDFPtable, but there are splits after some rows, i have code like below

String index = "";
PdfPTable table = new PdfPTable(columnWidth.Count()) { TotalWidth = TABLE_WIDTH, LockedWidth = true };
index = GetIndex(table.Size);
public static string GetIndex(int value)
{
StringBuilder sb = new StringBuilder();
do
{
value--;
int remainder = 0;
value = Math.DivRem(value, 26, out remainder);
sb.Insert(0, Convert.ToChar('A' + remainder));
} while (value > 0);
return sb.ToString();
}

this code display records from A,B,C,D.. Z and After Z AA,AB,AC ....so on and whenever split occurs i.e if split table occurs after 5 rows it again start from A,b,c... So this is not working.

Note:

My requirement is to display AA,AB,AC..... so on for total rows start to end in PDF if split occurs also. Can any one please help me on this, Thanks in advance, Zeb.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mario Scheeren5y ago
Zeb,
you cannot possibly be this ignorant or dumb ...
Call the function for EACH ROW with its OWN ROWID.

Row 1 => GetRowIndex(1)
Row 2 => GetRowIndex(2)
...
Row 18 => GetRowIndex(18)
...
Row 134 => GetRowIndex(134)
+1
Zeb dee5y ago
Hi Mario Scheeren,

Please find code as per new code and output i have got below. Please help me where i was doing wrong.

String index = ""; //this variable assign and displays AA, AB, AC..so on sequence in pdf file for the list of records

index = GetRowIndex(3) + " " +GetRowIndex(67); //passing rowindexvalue to GetRowIndex method

public static string GetRowIndex(int rowIndex)
{
int low = rowIndex % 26;
int high = (rowIndex - low) / 26;
return (high > 0) ? $"{(char)(65 + high - 1)}{(char)(65 + low)}" : $"{(char)(65 + low)}";
}

O/P:-
For all the rows the o/p is "D BP"

Thanks in Advance,
Zeb.
+1
Mario Scheeren5y ago
Changiing the requirement makes my code not work ... this is the main problem.
static string GetRowIndex(int rowIndex)
{
  int low = rowIndex % 26;
  int high = (rowIndex - low) / 26;
  return (high > 0) ? $"{(char)(65 + high - 1)}{(char)(65 + low)}" : $"{(char)(65 + low)}";
}
Console.WriteLine(GetRowIndex(3) + " " + GetRowIndex(67));
+1
Zeb dee5y ago
Hi Mario Scheeren,

Many thanks for the response, but this code is not working and it shows for first row A and second row AB, third ABC ... and again it starts with same sequence after table splits.

The O/P i got below:-

Please help me
String index = "";
PdfPTable table = new PdfPTable(columnWidth.Count()) { TotalWidth = TABLE_WIDTH, LockedWidth = true };
index = GetIndex(table.Size); //==>Please help me here highlighted which number should i pass if i need to get to pdf rows Index As AA, AB, AC, AD , AE...... so on
+1
Mario Scheeren5y ago
static string LetterColumn(int value)
{
    StringBuilder sb = new StringBuilder();
    for (int i  = 0; i < value; i++)
    {
        int low = i % 26;
        int high = (i - low) / 26;
        if (high > 0)
        {
            sb.Append((char)(65 + high- 1));
        }
        sb.Append((char)(65 + low));
        sb.Append(" ");
    }
    return sb.ToString();
}
+1