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
Paste phpSoftPro 1.4.1
Bytescout PDF SDK 1.8.1.243
Odoo Crafito Theme 1.0
Uber Clone- Taxi Booking App 4.1
Excel Add-in for BigCommerce 1.7
Online Food Delivery Script php 1.0.3
Break Script | Youtube Clone Script 1.0.3
Advanced Content Manager Magento 2 extension 2.2.x
dbForge Studio for PostgreSQL 1.0
ODBC Driver for Salesforce MC 1.3
Social Media Script 1.0
ByteScout PDF Renderer SDK 9.0.0.3079
Magento Mobile App Builder 2.0.0
Binary MLM Plan 1.0.2
Review Assistant 4.0
Top Code
Simplified Gradient Descent Optimization 1.0
Gradient Descent Visualization 1.0
Planyo online reservation system module 6.x-1.8
Phase Locked Loop Synthesis and Simulation 1.0
Online Food Delivery Script php 1.0.3
Taxi - movement of bacteria to the food 1.0
Memory (a.k.a. Concentration) 1.0
Savsoft Quiz - Online Quiz Management System 1.0
Frequent Itemset Searching in Data Mining 1.0
Liquid Frog - Free Kiss Gallery 1.0
Aspose.OCR for .NET 1.4.0.0
Free PHP MySQL Guestbook Script n/a
Issue Manager App 1.0
Binary MLM Plan 1.0.2
Uber Clone- Taxi Booking App 4.1
Top Rated
Output Messenger 1.8.0
Aliexpress Clone- Ec21 Script 1
Indiegogo Clone 3.0
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
Magento Product Designer 1.0
OFOS - Just Eat Clone Script 1.0
PrestaShop Upload Images Module 1.2.1
Trading Software 1.2.4
Deals and Discounts Website Script 1.0.2
ADO.NET Provider for ExactTarget 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