Be the first to rate this file! 7 Downloads (last 30 days) File Size: 1.35 KB File ID: #38851
image thumbnail

Excel auto alphabet cell range

by

 

This code generates the alphabetical index of any cell in excel doc.,

| Watch this File

File Information
Description

This function is useful when you want to export data from matlab to excel.
The cell range should be known, in order to place the data in proper range, if you dont have any prior information of your data range, then the need of auto-calculation of the start and end cell pointers is mandatory.
The input of the function id the number of colums your data contains. the output will be the end cell address in alphabet order, (e.g cell No. 25 will be letter 'Y'), this code is valid up to 18278 colums.

MATLAB release MATLAB 7.13 (R2011b)
Tags for This File   Please login to tag files.
Please login to add a comment or rating.

Contact us