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
Easy CSS Menu 5.0
Bytescout PDF SDK 1.7.0.222
Kickstarter clone script 2.0.5
Indiegogo Clone 3.0
Mercato 1.0
Readymade PHP Classified Script 3.3
Udacity Clone Script 1.20
PHP News Script 1.0.5
Exe Guarder 4.14
dbForge Search 2.2
EaseClouds Virtual File System SDK 2.1.1.2
dbForge SQL Decryptor 3.1
Fortune Gigs Script 2.03
Pricing Plans and Subscription Payment Script 1.0
PHP Image Resize Script 1.0
Top Code
Easy CSS Menu 5.0
Billing System 1.0.1
Chatbot widget 1.0.0
Udacity Clone Script 1.20
PHP Image Resize Script 1.0
SvQrBarcode
Matlab Face Detection using classifiers and adaptive boosting 1.0
PHP News Script 1.0
Exe Guarder 4.14
Best Spotify Clone 1.0
Image Edge Detection Using Ant Colony Optimization 1.0
ASIO Proxy
Kickstarter clone script 2.0.5
dbForge Search 2.2
Pricing Plans and Subscription Payment Script 1.0
Top Rated
PHP Image Resize Script 1.0
Jango Clone Script 1.0
Best Spotify Clone 1.0
Get Random Record Based on Weight 1.0.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
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
Sine Wave Using JavaFX 1.0
ICPennyBid Penny Auction Script 4.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