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
Rapid PHP 2018 15.5
IBDAC 6.4
Online Course Booking Script 1.3.3
Database Workbench Pro 5.6.4
Job Portal Script 1.3.2
The C# PDF Library 5.2
PostgreSQL Data Access Components 6.0
Virtual Data Access Components 11.0
HTMLPad 2018 15.5
WeBuilder 2018 15.5
SentiMask SDK Trial 2.0.0
Track Order For Magento 2 1.0.0
Calendar 365 For Dynamics CRM 4.0
Scimbo 1.2
Odoo Furnito Theme 1.0
Top Code
Azizi search engine script PHP 4.1.10
Hotel Management System Restaurant Version 5.25
Travel Booking script 1.0.4
AJ Matrix v2.6
College Management System Script 1.0.4
Spider(rader) Chart for Multi Data 1.0
Frequent Itemset Searching in Data Mining 1.0
Simple Radar_system_simulation 1.0
The Spherical K-means algorithm 1.0
Discrete Frechet Distance 1.0
Personal Web Portal 5.0
Chessgra 1.1
Keno Game 1.I
VChess 6.x-1.x-dev
Advanced TicTacToe game Script 1.1
Top Rated
VisualNEO Web 2018.12.15
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
Availability Booking Calendar PHP 1.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