3,158 results

Converts an array of numbers to a cell array of Excel column names

XLSCOLNUM2STR takes in an array of numbers and returns a cellular array of the same size with cell of corresponding Excel column names.example:n=[1 10; 53 256]c=xlsColNum2Str(n);c={'A' , 'J

Convert Excel column letters to numbers or vice versa, for processing data to/from XLSREAD/XLSWRITE.

properly handle the conversion from column number to strings. His program is at http://www.mathworks.com/matlabcentral/fileexchange/27182-excel-column-conversion

Read selected columns from a large Excel file using ActiveX

If you need to read one or mode columns of numeric data from a large Excel file, this will do it faster, and use less memory, than xlsread. Reads the same rows from all columns and returns an array

Set columns in Excel to Auto Fit

This function will set the selected columns to autofit.This is the same as using the Excel menu: Format -> Column -> AutoFit Selection .Example :xlsAutoFitCol('filename','Sheet1','A:F')

Converts a cell array of Excel column names to an array of Excel column numbers

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

Plots pdf, cdf & hazard rate of probability distributions and exports as Excel Chart, pdf, jpg

annotations (updating parameter values), latex and tex labels, and export to excel charts, clipboard, jpg, pdf, .mat and the printer. Exporting to excel actually transfers the data into an excel spreadsheet and

Converts Excel column name to column number and vise versa.

xlcolumn(column) column: Can be either column name (characters) or column number (positive integers). NOTE: Excel sheet is limited to 256 columns. Therefore, column number should be between

Convert excel column numbers to alphabetic coordinates

Convert excel column numbers to alphabetic coordinates

Convert Excel column header to colum number.

Take a string argument containg letters, and find out which columnnumber this correspond to in Excel. Only a brief errorcheck is done of the function.

Creates Excel Column string for writing data to excel worksheet's specific location.

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

A matrix version of VLOOKUP similar to MS Excel function.

VLOOKUP the function as vlookup in Excel [content, index] = vlookup(m, e, column, lookcolumn) look for 'e' in the 'lookcolumn'-th column of 'm', and return the coresponding 'column'-th element

Get column id from number. For example 26-'z', 702-'zz',703-'AAA', etc.. Likewise, get column number from text.

Get column id from number. For example 26-'z', 702-'zz',703-'AAA', etc..Likewise, get column number from text.

Creates graphs from existing Excel sheet containing column data.

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

Writes column headers and a matrix to excel and graphs all columns or two specified columns.

) xlschart(titles,m,chartype,chart_title,filename,sheetname) xlschart(titles,m,chartype,chart_title,xtitle,ytitle,filename) xlschart(titles,m,chartype,chart_title,xtitle,ytitle,filename,sheetname) xlschart : writes column headers and a matrix to excel

Generate characters of column indexes for Microsoft Office Excel.

Convert a positive integer into MS Excel column index format, helpful when applying functions like "writematrix". Note that the limits of row and column in MS Excel (2007+) are 1,048,576 and 16,384

Analyzes Simulink Model Complexity (Static and Dynamic Complexities)

Take column number as input argument, and return Excel columheaders as letters.

Function that convert at column number in to a Excel-column header. Made for Excel 2007. Only a brief error chech is made of the function.

This takes SEER excel column data interactively, tabulate them, write back in table format.

This program asks the user for the SEER variable stored in excel, it tabultes the eleemtns, then write it back to the excel. This facilates creation of excel tables for reporting and publication

Generate the big data excel files from the Matlab outputs

After running the program, sometime, we need the excel file of our output but it is timeconsuming to copy and paste our big data one by one we can use this program to save more time and it is also

This function to used for the undergraduation Cavendish gravitational experiment.

two-meter stick and a timer. Another student records this information into the Microsoft Excel spreadsheet. So, these data are the first three columns of Excel. In the first row and fifth colmn of this Excel

This utility tabulates the column data that to be used in a table for publication of SEER data.

It let user to interactively select the column of data to be read it takes the column name to make it into the filename to save the output it tabulates the column of data and save it to file as

Writes data to excel, allows writing to more than 702 (ZZ) columns

Modified version of xlswrite_mod. I needed to write to more than 702 columns (ZZ) since with Excel 07 it can support up to 16000 columns (XFD). I added a third character so from ZZ it will become AAA

Creates editable ISO Efficiency Curves curves of turbomachinery tested in the laboratory from existing Excel sheet containing column data.

determine the alphabetic characters of column index at a relative position in Excel sheet

% determine the alphabetic characters of column index at a relative position in Excel sheet% % GuoChao@ntu.edu.cn% 2-Sep-2020% %% Input : % 1. colCharX1: original alphabetic characters% 2. n: the

Reads the sheet names from Excel file for the given format :: .xls, .xlsm, .xlsx, .xltm, .xltx, .xltm

Reads the sheet names from Excel file for the given format :: .xls, .xlsm, .xlsx, .xltm, .xltx, .xltm%%********************************************************************************% Name

Calculates full target range in Excel A1 notation.

xlrange = xlcalcrange(h,refCell,r,c,m,n)returns the full target range, xlrange in Excel A1 notation to cover an m-by-n array, starting from an offset of r rows & c columns from the starting cell

Loop-free code routine to find a maximal subset of linearly independent columns in a matrix

This submission is a very simple code routine that I have used for many years for finding a maximal subset of linearly independent columns of a matrix. It is based on an old conversation with Bruno

This Script is intended to Delete provided sheets , It can be an Array of sheets also.

%%**********************************************************************************************************% Name : Delete_sheets_Excel% Author : Pruthvi Raj G :: (9677066394

ABC2NUM translates an A1-style (absolute) column label reference to a number; NUM2ABC does inverse.

(see below).#5942 - xlcolumn#32843 - Excel column header#30180 - Calculate Excel range#28343 - Column Converter for Excel#27182 - Excel Column Conversion#15748 - Excel Column Number To Column Name#12796

A script intended to copy sheet from one excel file and paste to another and renaming the sheet required.

%%*********************************************************************************************************************% Name : copy_sheet_Excel

Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite.

xlwrite allows to generate '.xls' & '.xlsx' files easily without having Excel installed or using COM-objects. It generates Excel files by using the Apache POI java library. This way Excel files

这是一个Matlab的函数，用于将任意正整数（列序号）转换为Excel的A1样式。 Convert positive integer (idx) to Excel A1 notation without limit of max index.

This function converts an index of column to the Excel A1 notation. But there is no limit to the maximal index.%%%function A1string = idx2A1(idx)alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';if idx >= 1

Converts the row & column number to work with xlswrite range input argument.

Converting number of columns to an alphabet representation

For those who uses actxserver.This is a simple function designed for actxserver. It convert number of columns to an alphabet representation for Excel 2013. Three alphabet representation from 'A' up

Returns input row / column limits as Microsoft Excel range.

% Converts input row / column limits to Excel range format%% syntax:% xlRange = getExcelRange(rowLimits,columnLimits)%% Inputs rowLimits, columnLimits expected as vectors defining the

Natural frequencies and Euler buckling load are calculated using finite element method technique

This modified version makes the original xlsread.m faster and also allows add-ins to be loaded.

opens/closes the activex server, load an add-in if any (by default when Excel opens as a COM server it does NOT load add-ins), and checks to see if the file already exists:Excel = actxserver

Export signal builder to excel

The signal builder block allows you to import Excel^® spreadsheet but it doesn't allow you to export the signals to excel. With this function, it can.

Converts a numeric input to a column name, for Excel representation.

EXCELCOL Converts a numeric input to a column name, for Excel representation. OUT=ExcelCol(X) takes the input "X", which may be a number or vector and converts it to the other representation

Multi column listbox, including filtering & colouring of columns & extraction of individual values

, 'NewValue', rowIndex, colIndex ) case 'changeRow' % ( h, 'changeRow', 'NewItems', rowIndex ) case 'columnColour' % ( h, 'columnColor', colIndex, 'Colour' ) case 'delCol

Plot a multicolumn format legend.

On a plot with a lot of traces the standard legend will often scroll off the bottom or the side of the figure, this function is intended to overcome this by allowing the user to define a multi column

Set a conditional format in Excel to change negative numbers text color to red.

Set a conditional format in Excel to change negative numbers' text color to red. The code can be modifeid quite easly to set any other

Append data to the next-available row of an existing Excel file with a single call to ActiveX.

is less than for successive xlsread/xlswrite calls.[SUCCESS,MESSAGE]=XLSAPPEND(FILE,ARRAY,SHEET) writes ARRAY to the Excel workbook, FILE, into the area beginning at COLUMN A and FIRST UNUSED ROW, in

Writes data to multiple ranges of existing Excel file.

Uses ActiveX commands to write data_n into range_n in an existing Excel spreadsheet. Inputs (excluding fileloc and promptforsave) must be paired.As of 10/04 update, you may provide the target range

Supply voltage and current of three phase diode bridge rectifier data set in excel file

Three phase voltage and non sinusoidal current data set in excel.voltage excel file:I column - time(sec)II column - R phase voltageIII column - Y phase voltageIV column - B phase voltagecurrent excel

Displays a matrix with per-column or per-row labels.

Sometimes, rows or columns (or both) of a displayed matrix or vector have different meanings, and it would be nice to display them along with the matrix (instead of, say, remembering that the third

This simple routine extends the function of the MATLAB csvwrite function to add column headers

I have often needed to generate data files to export from Matlab for other programs with headers to explain the contents of the columns. This simple routine extends the function of the MATLAB

Multi-Objective Optimization of Aspen Plus Distillation Column using Stochastic Algorithm (NSGA II).

integer variables, for example, BARON algorithm (deterministic) or NSGA II (Stochastic).This matlab code is an example of Multi-Objective optimization of Aspen Plus distillation column using NSGA II

Changes Freezed Panes and ColumnWidth. Adds Author

This is a small tool for my work, perhaps it'll help you.It changes the freezed Panes of an Excel File, but it doesn't force-taskkill Excel to do that.

Quickly compute the column by column correlation between two large matrices

Use corr_col to quickly compute the column by column correlation between two large matrices that would be to large to compute using diag(corr(A,B))C=CORR_COL(A, B) computes the correlation for each

Run MS Excel macro with or without parameters

Run MS Excel macroUSAGExls_run_macro(xlsfile,macro)xls_run_macro(xlsfile,macro,params)INPUT- XLSFILE: name of the XLS-file- MACRO: macro name- PARAMS: parameters for the MACROOUTPUT- XLSFILE will be

This compairs two excel sheet and gives the diffrenece

inputs and outputs are in terms of excel sheet to compare past version to present version one script is required so i have developed the script which compares two excel sheet

GUI to read and plot variables from Excel files

This GUI allows the user to select an excel file with variables (currently only for the specific format attached, but can be easily modified to import other formats using the importtool) , displays

These are the files for the Webinar "MATLAB for Excel Users" which was presented in August 2017.

The webinar highlights how MATLAB can supplement the capabilities of Excel by providing access to thousands of pre-built engineering and advanced analysis functions and versatile visualization tools

Delete selected worksheets or all empty worksheets in Excel file

Delete worksheets in Excel fileUSAGExls_delete_sheets(xlsfile)xls_delete_sheets(xlsfile,sheets)INPUT- XLSFILE: name of the Excel file- SHEETS: cell array with the worksheet names, or matrix with

Copying (ASCII) data file (including headers & column names) to XLS.

This program reads a (text data file) consisting of headers, column titles and column data (see attached data.txt). Then it opens or creates existing excel file and saves data into specified

Copy using dmeta and pasting using PasteSpecial

Very simple and small program to export a MATLAB fig or plot to a specific excel file. (location of the plot in the excel file can be changed by changing the "Range" variable... )

Convert your .plt files into .txt files which can be imported straight into Excel, Origin... etc

This function allows you "reorganizing" (sorting out) the data of the Sentaurus .plt files into column data with the name of the variables.Just run the function inside the folder where your .plt

Program wrtitten to bulk grade an excel folder with grade sheets in it.

Program allows you to set number grade parameters to convert to letter grades. Allows you select folder via window. Takes all excel files in folder one at a time to take a final numerical column

Two simple functions that convert a Dataset parameter, containing Simulink Simulation data, to excel

Many times when running simulations, you want to take the results, and use them in an excel spreadsheet, or convert them to a text format. The supplied functions enable you to save the simulation