How to find the first column without values in excel?

2012 4 18
1 个回答
回答已采纳
1 次查看（30 天）

0 个投票

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.

请先登录，再回答此问题。

 采纳的回答

Richard de Garis
Richard de Garis 2012-4-18

0 个投票

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);

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

osminbas
osminbas 2012-4-18
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by