Hi,
To access the excel column using column number instead of column name, you can use “xlsColNum2Str” method from File Exchange as shown in the following code snippet:
% Set the column number
columnNumber = 1;
% Convert column number to column letter using xlsColNum2Str function
columnName = xlsColNum2Str(columnNumber);
% Set the row number
rowNumber = 1;
% Create the complete cell reference string
cellReference = [columnName{1}, num2str(rowNumber)];
% Set the value of the cell using the complete reference
eSheet.Range(cellReference).Value = 1;
The “xlsColNum2Str” method takes column number as input and gives column name as the output. You can get the script of the method from here:
