Search
Code Directory
 ASP
 ASP.NET
 C/C++
 CFML
 CGI/PERL
 Delphi
 Development
 Flash
 HTML
 Java
 JavaScript
 Pascal
 PHP
 Python
 SQL
 Tools
 Visual Basic & VB.NET
 XML
New Code
Inventory Manager For Dynamics CRM 4.0
Dockit Migrator for SharePoint 11.8.6905
Australia Post Shipping For Magento 2 1.0.0
StarTrack Shipping For Magento 2 2.0.0
Mydala script 1.3
dotConnect for FreshBooks 1.8
Odoo Kingfisher Theme 1.0
Bitcoin Mining Software - Bitcoin Mining Script 1.0.2
Excel Add-in for Magento 1.7
Excel Add-in for MailChimp 1.7
Devart Excel Add-in for QuickBooks 1.7
Excel Add-in for PostgreSQL 1.7
Devart Excel Add-in for MySQL 1.7
Devart Excel Add-in for NetSuite 1.7
Excel Add-in for Salesforce 1.7
Top Code
ATN Site Builder 3.0
ATN Resume Finder 2.0
PHP Review Script 1.0
Invoice Manager by PHPJabbers 3.0
ICPennyBid Penny Auction Script 4.0
Excel Add-in for PostgreSQL 1.1
Excel Add-in for Salesforce 1.1
Excel Add-in for MailChimp 1.1
Aglowsoft SQL Query Tools 8.2
Classified Ad Lister 1.0
Solid File System OS edition 5.1
ADO.NET Provider for ExactTarget 1.0
Deals and Discounts Website Script 1.0.2
dotConnect for FreshBooks 1.8
Excel Add-in for Magento 1.6
Top Rated
phpEnter 5.1.
Single Leg MLM 1.2.1
Azizi search engine script PHP 4.1.10
Paste phpSoftPro 1.4.1
Extreme Injector 3.7
Deals and Discounts Website Script 1.0.2
ADO.NET Provider for ExactTarget 1.0
Solid File System OS edition 5.1
Classified Ad Lister 1.0
Aglowsoft SQL Query Tools 8.2
Invoice Manager by PHPJabbers 3.0
ICPennyBid Penny Auction Script 4.0
PHP Review Script 1.0
ATN Resume Finder 2.0
ATN Site Builder 3.0
Convert index to Excel A1 notation 1.0
File ID: 84187






Convert index to Excel A1 notation 1.0
Download Convert index to Excel A1 notation 1.0http://www.mathworks.comReport Error Link
License: Shareware
File Size: 10.0 KB
Downloads: 2
Submit Rating:
Convert index to Excel A1 notation 1.0 Description
Description: This function translates an index to the Excel A1 notation that is used in xlswrite.

%%%
function a1String = idx2A1(idx)

alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';

if idx < 27
a1String = alphabet(idx);
else
idx2 = rem(idx,26);
if idx2 == 0
a1String = [alphabet(floor(idx/26)-1),'Z'];
else
a1String = [alphabet(floor(idx/26)),alphabet(idx2)];
end
end
%%%

License: Shareware

Related: abcdefghijklmnopqrstuvwxyz, alphabet, alphabetidx, remidx, alphabetflooridx, idx idx, String, Index, translates, Excel

O/S:BSD, Linux, Solaris, Mac OS X

File Size: 10.0 KB

Downloads: 2



More Similar Code

XLCALCRANGE(REFCELL,R,C,M,N) returns the full target range XLRANGE in Excel A1 notation to cover an array of size M rows & N columns and starting from an offset of R rows & C columns from REFCELL.

Any workbookworksheet prefix is removed from REFCELL, as are any absolute '$' markers prior to range calculation.
i.e.
REFCELL = 'C:directorypath[filename.xlsm]worksheet1'!$P$6:$AC$91

becomes:



The functions convert sol-fa notation in plain text to a matrix or to a MIDI sequence that represents the sound, or read the note data from a MIDI sequence and convert it to sol-fa notation.

The GUI is an attempt at a sol-fa editor and...



Aostsoft PDF to Office Document Converter is a competent and utility program specially used to batch convert PDF to Word(*.DOC,*.DOCX,*.DOCM),Excel(*.XLS,*.XLSX,*.XLSM),PowerPoint(*.PPT,*.PPTX*.PPTM,*.PPS,*.PPSX,*.PPSM), RTF, HTML,TXT. It is able...



Convert CSV to XML.



Java library that easily converts a Json array to Excel or CSV



RustemSoft presents Convert XML to Any Data Format that is a set of XML tools: XMLFox Advance XML/XSD editor and XML conversion module with command-line interface. XMLFox Advance is XML editing and validation tool for creating valid well-formed...



PDF Extractor SDK for Windows software developers: PDF to Text, PDF to XML, Images from PDF, Read PDF information, PDF to CSV for Excel.

Bytescout PDF Extractor SDK allows to convert PDF to text, PDF to XML, PDF to CSV, extract images...



XLSCOLSTR2NUM takes in a cellular array of characters and returns a array of numbers of the same size with elements corresponding to Excel column numbers.

See Also XLSCOLNUM2STR



PDF Extractor SDK for Windows software developers: PDF to Text, PDF to XML, Images from PDF, Read PDF information, PDF to CSV for Excel.

Bytescout PDF Extractor SDK allows to convert PDF to text, PDF to XML, PDF to CSV, extract images...



Aostsoft PDF to DOCX XLSX PPTX PPSX Converter is a powerful and easy-to-use software. It will directly convert PDF to a DOCX, XLSX, PPTX, PPSX document with preserving the original format, layout, text, pictures, graphics etc. of your PDF files....

User Review for Convert index to Excel A1 notation
- required fields
     

Please enter text on the image