How can I determine excel range by column numbers in mscript?

For example I want to set the range Range('A1') as Cell(1,1).

How can I switch the code below by column numbers?

eSheet.Range('A1').Value = 1;

Answer 1

[Saffan]

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:

Excel Column Number To Column Name - File Exchange - MATLAB Central (mathworks.com)