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
Vue Injector 3.3
Spectrum Analyzer pro Live 2019
Devart Excel Add-in for HubSpot 2.1
RentALLScript - Airbnb clone 2.2
SuiteCRM Theme Customization 7.11.6
iScripts NetMenus 3.1
iScripts EasyIndex 2.2
iScripts EasySnaps 2.0
Australia MyPost shipping For Magento 2 1.0.0
Australia Post eParcel For Magento 1.1.1
Source Control for SQL Server 2.0
Answers phpSoftPro 3.12
Exlcart 2.0
School College ERP 1.3.2
White-label Grocery Delivery App Solution 2.0
Top Code
IcrediBB Bulletin Board System 1.0
MATLAB Support Package for Arduino (aka ArduinoIO Package) 1.0
Azizi search engine script PHP 4.1.10
Binary MLM Plan 1.0.2
Answers phpSoftPro 3.12
Low Pass Butterworth Filter 1.0
The Shakespeare Programming Language 1.0
Faculty Evaluation System 1.1
MLM Binary Plan Script – i-Netsolution 1.0.2
MLM Software ONE 1.5.46
Online Food Ordering System 1.3.2
Cuckoo Optimization Algorithm 1.0
jDUL/DUDE 1.0
Java-2-Pseudo 1.0
Vue Injector 3.3
Top Rated
Uber Clone with Safety Measure Addons 2.0
Answers phpSoftPro 3.12
phpEnter 5.1.
Quick Maps For Dynamics CRM 3.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
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
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: 3
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: 3



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