How to find the first column without values in excel?
2 ビュー (過去 30 日間)
古いコメントを表示
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.
0 件のコメント
採用された回答
Richard de Garis
2012 年 4 月 18 日
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);
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!