How to find the first column without values in excel?

Hello,

I have an Excel worksheet where I have a certain number of columns of data. I am trying to find the first column which does not have any data so that I can write a vector in that column using xlswrite. I appreciate any help.

Answer 1

[Richard de Garis]

You can try the Excel Range.End property, starting with a cell in a range beyond your data that you know is empty and look back from there. e.g.

Excel = actxGetRunningServer('Excel.Application');
xlworkSheet = Excel.ActiveWorkbook.Worksheets.Item('worksheet_name');

% Excel enumeration according to the help documentation
xlToLeft = -4159;

columnNo = xlworksheet.Range('AAA1').End(xlToLeft);
firstEmptyCol = xlworksheet.Range('A1').offset(0,columnNo-1);

[osminbas]

Hi Richard,

Thank you. I actually used

Columns={'A','B','C'....}

for hh=1:15;

ColNum=strcat(Columns(hh),':',Columns(hh));

Test=xlsread(filePattern4{1,1},ColNum{1,1});

if numel(Test)==0;

break

end

end

And I used the hh value as the next column: Columns(hh)

Anyway, thank you.