How to find the first column without values in excel?
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Richard de Garis
le 18 Avr 2012
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);
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!