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
Online Food Delivery Script php 1.0.3
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
Issue Manager App 1.0
Ecuaciones Lineales 1.0
Taxi - movement of bacteria to the food 1.0
Student Information Management System 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
Java-2-Pseudo 1.0
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
Excel Column String Creator 1.0
File ID: 81265






Excel Column String Creator 1.0
Download Excel Column String Creator 1.0http://www.mathworks.comReport Error Link
License: Shareware
File Size: 10.0 KB
Downloads: 3
Submit Rating:
Excel Column String Creator 1.0 Description
Description: When you use the "xlswrite" (or "xlsread") function sometimes you need to specify the excel worksheet column to write Matlab Data. For example (from Matlab Help on xlswrite)

s = xlswrite('tempdata.xls', d, 'Temperatures', 'E1')
"E1" means in excel is
column number = 5 ;
row number = 1 ;

If you use xlswrite command automatically you need a converter that converts the "5"th column to "E".

For example let the xlswrite command as;

s = xlswrite('tempdata.xls', d, 'Temperatures', L)

suppose "L" is a variable you should create in your code..

>> cN= xlsColStr(5)

cN =

E

after that you can unite with row number to create exact location like:

rN = 1;

>> L = strcat(cN,num2str(rN))

L =

E1

Of course you could use this while reading an excel data too.

License: Shareware

Related: Variable, Create, quotlquot, suppose, Converts, quot quotth, quotequot, xlscolstr, quot

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

File Size: 10.0 KB

Downloads: 3



More Similar Code

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



excelcolumn converts a vector of integers > 0 and <= 256 into excel column head characters and, conversely, an array or cell array of excel column head strings into the equivalent integer.



Out=ExcelCol(In) takes the input In, which may be a number, vector, char, or cell and converts it to the other representation

EXAMPLES:
>>ExcelCol(100) %The column name for the 100th column
>>'CV'



DHTML JavaScript component with ASP.NET wrapper WebControl and DataGrid objects to display, edit and upload data in table, grid, tree view or grid with tree on HTML page. Compatible with IE 5.0+, Mozilla 1.0+, Firefox 1.0+, Opera 7.60+. / Manages...



NUM2ABC(X), where X is an integer, returns a string corresponding to the column label commonly employed by spreadsheet programs, such as Microsoft
Excel.

Example:
x = 45;
num2abc(x);

ans =
AS



ABC2NUM(S), where S is a one or two letter string representing a column label commonly employed by spreadsheet programs, returns a number corresponding to the spreadsheet column indicated by S.


Example:
S = 'CS';
...



Rails plugin used to emulate an Excel feature where a dropdown is at the top of a table and contains all the unique values for a column. Select a value from the dropdown and the table will only show items that have the matching value.



Often I get data to import in MS Excel files, and the column headers are not very useful for column names. They contain spaces, punctuation, and special characters that make a simple import difficult.

This script opens the file in...



XLSRANGENAMES Returns a list of named ranges in an excel workbook
RangeNames = XLSRangeNames(filename)
RangeNames is a (n x 2) cell array with the name of the named range in
the first column and the value (aka location) in the...



xlsgraph(xtitle,ytitle,chartype,chart_title,filename,sheetname)

xlsgraph : creates an Excel graph by searching specified sheet for selected columns headers.

xtitle: title(s) of column to be x-axis (picked from titles).

User Review for Excel Column String Creator
- required fields
     

Please enter text on the image