How to get all columns (example A,B,C ...) in excel and return to array

HI,

How about the following expression? (Case for 100 columns)

Enumerable.Range(1,100).Select(Function(i) ExcelUtilities.ConvertColumnIndexToColumnLetter(i)).ToArray

Note: please add UiPath.Excel.Helper namespace in advance.

Sample20230324-5L.zip (2.4 KB)

Regards,

2 Likes