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
Rapid PHP 2018 15.0
Bytescout BarCode Generator SDK 4.70.0.981
Data Puppy Lite (32-bit) 1.0
ProZ clone script 1.0.3
VideoCap Live Streaming SDK ActiveX 8.5
Magento Web to Print 1.0
dbForge Data Compare for MySQL 5.4
dbForge Query Builder for MySQL 4.3
ODBC Driver for NetSuite 1.2
Rapid CSS 2018 15.0
ByteScout PDF Extractor SDK 9.0.0.3079
TeeGrid for .NET 2018
HotelDruid 2.2.3
Metamill 8.2.2022
EXE Stealth Protector 4.23
Top Code
OpenCV Delphi wrapper 1.0
Fuzzy k means 1.0
ABBYY FineReader Engine 9.0
Online Food Ordeing System 1.0
Advance Auto Index-DjAmolWap 10.4
Djamolwap 13
GnuWin64 64
Advanced Forced Matrix Script 1.0
BMI Calculator Widget 1.3
2D/3D CAD Import VCL - AutoCAD DXF DWG / HPGL HPGL2 PLT 5
The Spherical K-means algorithm 1.0
Crazy Teris 1.90
Bad Behavior 2.0.42
Jellybean Factory 1.0
C Code Completer 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
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
Readymade MLM Products 2.01
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