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
Code Review Bundle 1.0
Magento Delivery Date Scheduler 1.0
Devart Excel Add-ins 1.8
Faculty Evaluation System 1.1
dbForge Studio for PostgreSQL 2.0
Yelp Script - Yelp Clone 1.3
Database Workbench Pro 5.4.6
Extensibility Studio 3.0
Bytescout Spreadsheet SDK 3.0.0.1699
Magento 2 Admin Mobile App 1.0
Data Compare for MySQL 5.3
ODBC Driver for Zoho CRM 1.3
ODBC Driver for SugarCRM 1.3
Bytescout PDF To HTML SDK 9.0.0.3079
Azizi search engine script PHP 4.1.10
Top Code
Luxand FaceSDK 6.5.1
ICPos - Point of sale script 1.1
Idem File Synchronization 2.2
Auto CMS 2.0
Continuous Morlet Wavelet Transform 1.0
ChequePRO Cheque Printing writing System 1.0
Flying Butterfly script
OpenGL Demos 1.1
Code39 Decoder SDK/Android 2.5
Business Card Design Software 1.0.2
3D World (OpenGL walk through city) Script 1.1
PDF417 Decoder SDK/LIB 1.5
MyPHPAuction Ebay Clone 2.0
OpenGl 3D Effect 1.1
Serial Splitter
Top Rated
Output Messenger 1.8.0
Aliexpress Clone- Ec21 Script 1
Indiegogo Clone 3.0
Advanced MLM Software 1.2
Online Food Ordeing System 1.0
PHP Image Resize Script 1.0
Best Spotify Clone 1.0
Get Random Record Based on Weight 1.0.0
PHP Point of sale 10.0
Travel Portal Script 9.29
Excel Add-in for Bigcommerce 1.6
Magento Product Designer 1.0
OFOS - Just Eat Clone Script 1.0
PrestaShop Upload Images Module 1.2.1
Trading Software 1.2.4
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