Code Directory
 Visual Basic & VB.NET
New Code
On-demand Service Booking Solution - Agriya 1.0
Ticketmaster Script 1
Lookbook for Magento 2 2.0
LuaStudio 9.70
Product Design Software 1.0
PHP Poll 1.0
Magento 2 Product Tabs 2.0.x, 2.1.x, 2.2.x
Database Workbench Pro 5.4.0
ByteScout Text Recognition SDK
Equipment Rental Script 1.0
Aliexpress Clone- Ec21 Script 1
Agriya Event Booking Solution v2.0b5
Key Transformation 8.1133
IP2Location Geolocation Database 2018
Top Code
Hawkeye Computer Graphics Projects in C++ 1.0
InSPIRE -- 2D to 3D Conversion for further image analysis 1.0
Restaurant Table Booking System 2.0
Ping Pong Game Code Script 1.1
Ad2Ex Adverser Php Script 1.06
Online Vacation Rental Booking Website Script 4.3.0
Detect circles with various radii in grayscale image via Hough Transform 1.0
Implementation of the token bucket algorithm
RLE coding 1.0
Library Management System 1.0
Hough transform for circles 1.0
Copy-move forgery detection in images
Frozen Bubble C 2.1.0
Top Rated
Indiegogo Clone 3.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
Solid File System OS edition 5.1
Classified Ad Lister 1.0
Aglowsoft SQL Query Tools 8.2
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 =


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

rN = 1;

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

L =


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.


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

>>ExcelCol(100) %The column name for the 100th column

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

x = 45;

ans =

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.

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 : 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