How can I determine excel range by column numbers in mscript?
32 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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;
0 Kommentare
Antworten (1)
Saffan
am 30 Aug. 2023
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:
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!