Royalty Free Microsoft Excel Compatible Spreadsheet Component for Microsoft .NET, ASP.NET, C#, VB.NET, XLS and Microsoft Visual Studio .NET

SpreadsheetGear - performance spreadsheet components

Products

Samples

Downloads

Support

Company

SpreadsheetGear 2010

SpreadsheetGear 2010 is the leading Microsoft Excel compatible spreadsheet component for the Microsoft .NET Framework.

With one safe managed assembly, SpreadsheetGear 2010 enables ASP.NET and Windows Forms developers to easily take advantage of scalable Excel Reporting, dynamic dashboards from Excel charts and ranges, powerful Windows Forms spreadsheet controls, comprehensive Excel compatible charting, the fastest and most complete Excel compatible calculations and more.

General Features

Royalty free deployment to 32 bit and 64 bit Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2).
Create, read, modify, view, edit, format, calculate, print and write Microsoft Excel 97-2003 (xls) and Excel 2007-2010 Open XML (xlsx and xlsm) workbooks without Excel.
Read and write password protected xls, xlsx and xlsm workbooks.
Scalable and reliable Excel Reporting.
Powerful Windows Forms spreadsheet controls.
Easily create images from Excel charts and ranges.
Comprehensive charting APIs.
Fastest and most complete Excel compatible calculation engine available (significantly faster than Excel).
Versatile autofilters with top or bottom n items or percent, above or below average, custom criteria, SUBTOTAL support and more (see Autofilter Features below).
Read and write CSV and tab separated text files.
Support for cell comments, pictures, text boxes, check boxes, drop-downs, list boxes, spinners, scrollbars, buttons, lines and many autoshapes.
Drag Fill / Auto Fill including support for numbers, dates, times, month names, day names and certain text patterns.
Fill Data Series support including automatic, chronological, linear, growth, day, weekday, month, year, start value, step value, stop value and the ability to use regression for linear or exponential trends.
Fast single variable and single target goal seeking.
Data validation including operators, alert messages, alert styles, custom formulas and drop-down lists.
Conditional formats with support for simple comparison operators and custom formulas.
Copy and insert DataTables into pre-formatted ranges with complete formula, border and format fixups.
Easily convert entire workbooks or specific ranges to a DataSet or DataTable.
Copy, transpose and consolidate across cells, worksheets, workbooks and workbook sets.
Insert, delete and clear rows, columns and cells.
Stable sort with an unlimited number of keys and the ability to sort text as numbers.
Grouping and outlining of rows and columns.
Supports 1,048,576 rows, 16,384 columns, 64K worksheets, unlimited workbooks and unlimited workbook sets.
Copy, insert and move entire worksheets.
C# and Visual Basic samples for ASP.NET and Windows Forms.
Reads and writes VBA Macros.

Windows Forms Spreadsheet Control Features

WorkbookView spreadsheet control provides viewing, navigation and editing support which is familiar to Excel users.
In-cell editing and optional FormulaBar control provide the ability to enter and edit cell values and formulas, including support for pointing at cell references in formulas across worksheets and workbooks.
Smart data entry with optional data validation as well as automatic recognition and formatting of dates, times, percentages, currency, scientific notation and fractions will be familiar to Excel users.
Conditional formatting enables font colors, font styles, background colors and borders which are based on simple comparison operators or complex formulas.
Grouping and outlining which allows users to easily expand and collapse the displayed level of detail.
WorkbookDesigner provides an MDI Windows application which may be used from within Visual Studio 2005, Visual Studio 2008 and Visual Studio 2010 at design time and by your applications at run time.
WorkbookExplorer provides the ability to manipulate workbooks, worksheets and defined names as well as their properties.
RangeExplorer provides extensive modeless formatting of the currently selected range with support for number formats, alignment, fonts, borders, colors, patterns, protection options, hyperlinks, conditional formats and data validation.
ChartExplorer provides basic modeless modification and formatting of the selected chart with support for chart types and data sources, legend options, primary and secondary axes options and various series options.
Modeless find and replace dialog with support for find, find all, replace and replace all.
Support for an unlimited number of workbooks associated with each WorkbookView.
DisplayReference and DisplayReferenceName properties allow complete control over what appears for each sheet tab, including the ability to make multiple workbooks appear as one workbook and the ability to specify dynamically changing ranges using worksheet functions such as OFFSET().
Cut, copy, paste and paste special support including rich data and formatting interchange with Excel and full formula fixups.
Frozen rows and columns, split panes, sheet tab colors, zoom, multi-level undo/redo, autofit rows and columns, goto, clear, printing, print preview, interruptible background calculation, real time workbook updates and more.
CommandManager provides the ability to add custom undoable commands as well as the ability to override the behavior of common commands.
Full integration with Visual Studio 2005, Visual Studio 2008 and Visual Studio 2010 including the ability to use the WorkbookDesigner, WorkbookExplorer, RangeExplorer, ChartExplorer and ShapeExplorer at design time and at runtime.
SpreadsheetGear Explorer Sample Solutions with C# and Visual Basic source code demonstrate commonly used SpreadsheetGear 2010 features and APIs.

Calculation Features

Fastest and most complete Excel compatible calculation engine available in a spreadsheet component.
332 of Excel 2003's financial, date, time, text, lookup, math, trigonometry, statistical, database and Analysis Toolpak functions (see the list below).
All types, operators, defined names, data tables and arrays.
Interruptible background calculation.
Support for 64K worksheets and unlimited workbooks in formulas.
Worksheet specific defined names and global defined names.
Custom functions, minimal recalc, iteration, precision as displayed and more.
Copy formulas between cells, worksheets, workbooks and workbook sets with full support for reference fixups.
Insert and delete worksheets, rows, columns and cells with full support for reference fixups.
Cut, copy and paste with full support for smart reference fixups across multiple worksheets and workbooks.
Special care was taken with numerical stability.

Autofilter Features

Top or bottom n items.
Top or bottom n percent.
Above or below average.
Last day, month, quarter, week or year.
This day, month, quarter, week or year.
Next day, month, quarter, week or year.
Specific day, month, year, hour, minute or second.
Year to date.
Filter by font color or interior color.
Custom criteria such as ">50".
Filter by specific list of values.
Support for the SUBTOTAL function which works in conjunction with autofilters to return various statistics for filtered items including average, count, max, min, product, standard deviation, sum and variance.
Autofilter support in many commands including cell formatting, copy & paste, fill, delete and more.

Formatting Features

Number formats, including full support for getting and setting Excel compatible custom number formats as well as getting the formatted text of a cell as Excel would display it.
Fonts, borders, Office Theme colors with tinting and shading, RGB colors, Excel palette indexed colors and patterns.
Horizontal alignment, vertical alignment, word wrap and rotated text.
Merged cells, hyperlinks and conditional formats.
Enable or disable worksheet protection, worksheet passwords and cell locking.
Grouping and outlining of rows and columns.
Automatic row heights and column widths.
Copy formats without affecting formulas or values.
Named cell style support.

Charting Features

The most comprehensive Excel compatible charting support available in a Microsoft .NET Framework component with API support for virtually every charting property.
SpreadsheetGear.Drawing.Image class provides the ability to generate an image (such as GIF or PNG) with one line of code.
Chart rendering supports the most common charting features:
- Chart types include area, bar, column, line, pie, stock, XY scatter, radar and bubble charts.
- Chart type options include multiple chart groups (combination charts), stacked and 100% stacked values, bar gap and overlap, line markers, drop lines, high-low lines, trendlines, series line smoothing, open-close bars, error bars, exploded pies, and data point labels.
- Axes options include axes titles, primary and secondary axes sets, auto and manual scaling, logarithmic and date scales, major and minor gridlines and tick marks, reversed axes, tick label positions and rotated text.
- General chart options include chart titles, legends, theme colors, auto colors, gradients including Excel compatible preset gradients, solid and dashed line styles, number formats and fonts.

Microsoft .NET Framework Features

Easy to use API which will be familiar to Excel VBA and COM developers while taking advantage of .NET's expressiveness.
Supports 32 and 64 bit versions of the Microsoft .NET Framework 2.0, .NET 3.0, .NET 3.5 and .NET 4.0 including the .NET Framework 4 Client Profile. SpreadsheetGear 2010 supports 32 bit and 64 bit versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2).
Microsoft Visual Studio 2005, Visual Studio 2008 and Visual Studio 2010 integration, including IntelliSense and Dynamic Help.
The security of 100 percent safe managed code which does not require FullTrust.
Hassle free deployment with a single strong named assembly and no license keys, registry entries or configuration issues.
No dependency on Microsoft Excel, which is not supported in a server environment.

Supported Functions

Database and List Management Functions
DAVERAGE	Indicates the average of the values that meet the specified criteria.
DCOUNT	Counts the number of cells containing numbers that meet the specified criteria.
DCOUNTA	Counts nonblank cells containing numbers or text that meet the specified criteria.
DGET	Returns a single value that meets the specified criteria.
DMAX	Extracts the highest value that meets the specified criteria.
DMIN	Extracts the lowest value that meets the specified criteria.
DPRODUCT	Returns the product of the values that meet the specified criteria.
DSTDEV	Estimates the standard deviation of a population, based on a sample of selected entries from the database.
DSTDEVP	Returns the calculation of the standard deviation of a population, based on the sum of the whole population.
DSUM	Returns the total of the values that meet the specified criteria.
DVAR	Estimates the variance of a sample population based on the values that meet the specified criteria.
DVARP	Returns the calculation of the true variance of an entire population based on the values that meet the specified criteria.

Date and Time Functions
DATE	Returns the serial number that represents a date.
DATEDIF	Returns the difference of two dates in years, months or days.
DATEVALUE	Converts date text to a DATEVALUE serial number.
DAY	Returns the corresponding day of the month serial number or date text from 1 to 31.
DAYS360	Returns the number of days between two set dates based on a 360-day year.
HOUR	Returns the hour as a serial number integer between 0 and 23.
MINUTE	Returns the serial number that corresponds to the minute.
MONTH	Returns the corresponding serial number of the month of a date between 1 and 12.
NOW	Returns the current date and time in the form of a serial number.
SECOND	Returns the seconds portion of a serial time value.
TIME	Returns the decimal value of a given time.
TIMEVALUE	Returns the decimal number for a given time.
TODAY	Returns the current date as a serial number.
WEEKDAY	Returns the corresponding day of the week as a serial number.
YEAR	Returns the corresponding year as a serial number in the form of an integer.

Financial Functions
DB	Returns the asset depreciation for a period using the fixed declining balance method.
DDB	Returns the asset depreciation for a period using the double-declining balance method or another specified method.
FV	Returns the future value of an investment that makes payments as a lump sum or as a series of equal periodic payments.
IPMT	Returns the interest for a period of time based on an investment with periodic constant payments and a constant interest rate.
IRR	Returns the internal rate of return for a series of cash flows represented by numbers in the form of values.
ISPMT	Calculates the interest paid during a defined period of an investment.
MIRR	Returns a modified internal rate of return for several periodic cash flows.
NPER	Returns the total number of periods for an investment. This is based on a periodic constant payment and a constant interest rate.
NPV	Calculates the net present value of an investment from the discount rate and several future payments and income.
PMT	Calculates the loan payment for a loan based on constant payments and constant interest rates.
PPMT	Returns the principal payment for a period of an investment based on periodic constant payments and a constant interest rate.
PV	Returns the present value based on an investment.
RATE	Returns per period the interest of an annuity.
SLN	Returns the straight-line depreciation on an asset.
SYD	Based on a specified period, SYD returns the sum-of-years' digits depreciation of an asset.
VDB	For a period you specify, returns the depreciation of an asset.

Information Functions
ERROR.TYPE	Returns the corresponding number value associated with an error type in Microsoft Excel.
ISBLANK	Returns TRUE if the cell is empty, FALSE if it contains data.
ISERR	Returns TRUE if value contains any error value except #N/A, FALSE if it does not.
ISERROR	Returns TRUE if value contains any error value (including #N/A), FALSE if it does not.
ISLOGICAL	Returns TRUE if value is a logical value, FALSE if it is not.
ISNA	Returns TRUE if value is #N/A, FALSE if it is not.
ISNONTEXT	Returns TRUE if value is not text, FALSE if it is.
ISNUMBER	Returns TRUE if value is a number, FALSE if it is not.
ISREF	Returns TRUE if value is a reference, FALSE if it is not.
ISTEXT	Returns TRUE if value is text, FALSE if it is not.
N	Returns a value converted to a number.
NA	An alternative representation of the error value #N/A.
TYPE	Determines the type of value in a cell.

Logical Functions
AND	Returns TRUE if all the arguments are TRUE in the formula, and FALSE if any one argument is FALSE.
FALSE	Returns the value FALSE. May be typed directly into the cell as "FALSE".
IF	Returns a value if one condition is TRUE and returns another value if the condition is FALSE.
NOT	Returns the reverse value of its arguments; TRUE becomes FALSE and FALSE becomes TRUE.
OR	Returns FALSE if all arguments are FALSE, and TRUE if at least one argument is TRUE.
TRUE	Returns the value TRUE. May be typed directly into the cell as "TRUE".

Lookup and Reference Functions
ADDRESS	Given specified row and column numbers, creates a cell address as text.
AREAS	Returns the number of areas based on a reference.
CHOOSE	Returns an item from a list of values..
COLUMN	Returns the column number(s) based on a given reference.
COLUMNS	Returns the number of columns based on an array or reference.
HLOOKUP	Searches for a specified value in an array or a table's top row.
HYPERLINK	Creates a shortcut to jump to a document stored on a network server.
INDEX	Returns the value of an element selected by the row number and column letter indexes.
INDIRECT	Returns the contents of a cell using its reference.
LOOKUP	Looks in the first row or column of a range or array, and returns the specified value from the same position in the last row or column of the range or array.
MATCH	Returns the relative position of an item in an array that matches a specified value in a specified order, or the position of an item.
OFFSET	Returns a reference to a range that is a specific number of rows and columns from a cell or range of cells.
ROW	Returns the row number based on a reference.
ROWS	Returns the number of rows in a reference or array.
TRANSPOSE	Returns a horizontal range of cells as vertical or vice versa.
VLOOKUP	Searches for a value in the leftmost column of a table and returns a value from the same row in a column number that you specify.

Math and Trigonometry Functions
ABS	Returns the absolute value of a number.
ACOS	Returns the arccosine of a number in radians in the range 0 to pi.
ACOSH	Returns the inverse hyperbolic cosine of a number.
ASIN	Returns the arcsine of a number in radians in the range -pi/2 to pi/2.
ASINH	Returns the inverse hyperbolic sine of a number.
ATAN	Returns the arctangent of a number in radians in the range -pi/2 to pi/2
ATAN2	Returns the four-quadrant arctangent of the specified x- and y- coordinates in radians between -pi and pi excluding -pi. A positive result represents a counterclockwise angle from the x-axis, a negative result represents a clockwise angle.
ATANH	Returns the inverse hyperbolic tangent of a number.
CEILING	Returns a number rounded up, away from zero, to the nearest multiple of significance.
COMBIN	Returns the number of combinations for a given number of items.
COS	Returns the cosine of the given angle.
COSH	Returns the hyperbolic cosine of a number.
DEGREES	Converts radians into degrees.
EVEN	Returns a number rounded up to the next even integer for positive integers and rounded down to the next even integer for negative numbers.
EXP	Returns e (2.71828182845804) raised to the power of a specified number.
FACT	Returns the factorial of a number.
FLOOR	Returns a number rounded down, toward zero, to the nearest multiple of significance.
INT	Rounds a number down to the nearest integer.
LN	Returns the natural (base e) logarithm of a number.
LOG	Returns the logarithm of a number of the base you specify.
LOG10	Returns the base-10 logarithm of a number.
MDETERM	Returns the matrix determinant of an array.
MINVERSE	Returns the inverse matrix for the matrix stored in an array.
MMULT	Returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2.
MOD	Returns the remainder of a division operation (modulus).
ODD	Returns a number rounded up away from zero to the nearest odd integer.
PI	Returns the approximate number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.
POWER	Returns the result of a specified number raised to a specified power.
PRODUCT	Multiplies all the numbers given as arguments and returns the product.
RADIANS	Converts degrees to radians.
RAND	Returns an evenly distributed random number greater than or equal to 0 and less than 1. A new random number is returned every time the worksheet is calculated.
ROMAN	Converts an Arabic numeral to Roman, as text.
ROUND	Round a number to a specified number of digits.
ROUNDDOWN	Rounds a number down, towards zero.
ROUNDUP	Rounds a number up, away from zero.
SIGN	Determines the sign of a number. Returns 1 if the value is positive, 0 if the value is 0, and -1 if the value is negative.
SIN	Returns the sine of a given angle.
SINH	Returns the hyperbolic sine of a number.
SQRT	Returns a positive square root.
SUBTOTAL	Returns a subtotal in a list or database.
SUM	Adds all the numbers in a range of cells.
SUMIF	Adds the cells specified by a certain criteria.
SUMPRODUCT	Multiplies corresponding components in the given arrays, and returns the sum of those products.
SUMSQ	Returns the sum of the squares of the arguments.
SUMX2MY2	Returns the sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2	Returns the sum of the sum of squares of corresponding values in two arrays.
SUMXMY2	Returns the sum of squares of differences of corresponding values in two arrays.
TAN	Returns the tangent of the given angle.
TANH	Returns the hyperbolic tangent of a number.
TRUNC	Truncates a number to an integer by removing the fractional part of a number.

Statistical Functions
AVEDEV	Retuns the average of the absolute deviations of data points from their mean.
AVERAGE	Returns the average of its arguments.
AVERAGEA	Returns the average of the values in its list of arguments including text and logical values.
BETADIST	Returns the cumulative beta probability density function.
BETAINV	Returns the inverse of the cumulative beta probability density function.
BINOMDIST	Returns the individual term binomial distribution probability.
CHIDIST	Returns the one-tailed probability of the chi-squared (X^2) distribution; the area in the right tail under the chi-squared distribution curve.
CHIINV	Returns the inverse of the one-tailed probability of the chi-squared (X^2) distribution.
CHITEST	Returns the test for independence of the characteristics in a table.
CONFIDENCE	Returns the confidence interval for a population mean.
CORREL	Returns the correlation coefficient between two data sets.
COUNT	Counts the number of cells that contain numbers (including dates and formulas that evaluate to numbers) within the list of arguments.
COUNTA	Counts the number of cells that are not empty.
COUNTBLANK	Counts the empty cells in a specified range.
COUNTIF	Counts the number of cells in a range that meet a given criteria.
COVAR	Returns the covariance, the average of products of deviations, for each data point pair.
CRITBINOM	Returns the minimum number yields a binomial distribution less than or equal to the specified criteria
DEVSQ	Returns the sum of the squares of deviations of a data set from their sample mean.
EXPONDIST	Returns the exponential distribution.
FDIST	Returns the F probability distribution.
FINV	Returns the inverse of the F probability distribution.
FISHER	Returns the Fisher transformation at x.
FISHERINV	Returns the inverse of the Fisher transformation at y.
FORECAST	Calculates or predicts a future value by using existing values.
FREQUENCY	Calculates how often values occur within a range of values and then returns a vertical array of numbers.
FTEST	Returns the result of an F-test.
GAMMADIST	Returns the gamma distribution.
GAMMAINV	Returns the inverse of the gamma cumulative distribution.
GAMMALN	Returns the natural logarithm of the gamma function.
GEOMEAN	Returns the geometric mean of an array or range of positive data.
GROWTH	Calculates predicted exponential growth by using existing data.
HARMEAN	Returns the harmonic mean of a data set.
HYPGEOMDIST	Returns the hypergeometric distribution.
INTERCEPT	Calculates the point at which a line will intersect the y-axis by using existing x and y values.
KURT	Returns the Kurtosis of a data set.
LARGE	Returns the k-th largest value in a data set.
LINEST	Calculates a straight line that best fits your data using the least squares method.
LOGEST	Calculates an exponential curve that fits your data and returns an array of values that describes the curve.
LOGINV	Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard deviation.
LOGNORMDIST	Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard deviation.
MAX	Returns the largest value in a set of values.
MAXA	Returns the largest value in a set of values including text and logical values.
MEDIAN	Returns the median of the given numbers.
MIN	Returns the smallest value in a set of values.
MINA	Returns the smallest value in a set of values including text and logical values.
MODE	Returns the most frequently occuring, or repetitive, number in an array or range of data.
NEGBINOMDIST	Returns the negative binomial distribution.
NORMDIST	Returns the normal cumulative distribution for the specified mean and standard deviation.
NORMINV	Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORMSDIST	Returns the standard normal cumulative distribution function.
NORMSINV	Returns the inverse of the standard normal cumulative distribution function.
PEARSON	Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.
PERCENTILE	Returns the k-th percentile of values in a range.
PERCENTRANK	Returns the rank of a value in a data set set as a percentage of the data set.
PERMUT	Returns the number of permutations for a given number of objects that can be selected from a range of numbers.
POISSON	Returns the Poisson distribution.
PROB	Returns the probability that values in a range are between two specified limits.
QUARTILE	Returns the quartile of a data set.
RANK	Returns the rank of a number in a list of numbers.
RSQ	Returns the r^2 value of a linear regression line.
SKEW	Returns the skew of a distribution.
SLOPE	Returns the slope of a regression line through data points in KNOWN_Y'S and KNOWN_X'S.
SMALL	Returns the k-th smallest value in a data set.
STANDARDIZE	Returns a normalized value from a distribution characterized by MEAN and STANDARD_DEV.
STDEV	Estimates standard deviation based on a sample.
STDEVA	Estimates standard deviation based on a sample. Includes text and logical values.
STDEVP	Estimates standard deviation based on a sample assuming that the arguments represent the total population.
STDEVPA	Estimates standard deviation based on a sample assuming that the arguments represent the total population. Includes text and logical values.
STEYX	Returns the standard error of the predicted y value for each x in the regression.
TDIST	Returns the percentage points (probability) for the student t-distribution, where a numeric value (x) is a calculated value of t for which the percentage points are to be computed.
TINV	Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
TREND	Returns the y-values along a linear trendline that best fits the values in a data set.
TRIMMEAN	Returns the mean of the interior of a data set.
TTEST	The probability associated with t-test.
VAR	Returns an estimate for the variance of a population based on a sample data set.
VARA	Returns an estimate for the variance of a population based on a sample data set and may include text or logical values.
VARP	Calculates variance based on the entire population.
VARPA	Calculates variance based on the entire population and may include text or logical values.
WEIBULL	Returns the Weibull distribution.
ZTEST	Returns the two-tailed P-value of a z-test.

Text Functions
CHAR	Returns the character specified by a number.
CLEAN	Removes all nonprintable characters from text.
CODE	Returns a numeric code from the first character in a text string. The opposite of the CHAR function.
CONCATENATE	Joins several text strings into one text string.
DOLLAR	Converts a number to text using Currency format, with the decimals rounded to the specified place.
EXACT	Compares two text strings and returns TRUE if they are exactly the same, and FALSE otherwise.
FIND	Locates one text string within another text string, and returns the number of the starting position of of FIND_TEXT from the leftmost character of WITHIN_TEXT.
FINDB	Returns the position of specified text within another specified text string based on the number of bytes each character uses from the first character of WITHIN_TEXT.
FIXED	Rounds a number to a specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.
LEFT	Returns the first character(s) in a text string.
LEFTB	Returns the first character(s) in a text string based on a specified number of bytes
LEN	Returns the number of characters in a text string.
LENB	Returns the number of characters in a text string expressed in bytes.
LOWER	Converts all letters in a text string to lowercase.
MID	Returns a specific number of characters from a text string starting at the position you specify.
MIDB	Returns a group of characters based on a specified number of bytes from a text string starting at the position you specify.
PROPER	Capitalizes the first letter of each word in a text string or sentence.
REPLACE	Replaces part of a text string with a different text string based on the number of characters you specify.
REPLACEB	Replaces part of a text string with a different text string based on the number of characters you specify in terms of bytes.
REPT	Repeats specified text a given number of times.
RIGHT	Returns the last character(s) in a text string.
RIGHTB	Returns the last character(s) in a text string based on a specified number of bytes.
SEARCH	Returns the number of the character at which a specific character or text string is first found, reading from left to right.
SEARCHB	Returns the number of the character at which a specific character or text string is first found in bytes, reading from left to right.
SUBSTITUTE	Substitutes NEW_TEXT for OLD_TEXT in a string.
T	Returns the text referred to by a value.
TEXT	Converts a value to text in a specific number format.
TRIM	Removes all spaces from text except single spaces between words.
UPPER	Converts text to uppercase.
USDOLLAR	Converts a number to text using US Dollar format, with the decimals rounded to the specified place.
VALUE	Converts a text string that represents a number to a number.

Analysis Toolpak Functions
ACCRINT	Returns accrued interest for securities that pay periodic interest.
ACCRINTM	Returns the accrued interest for securities that pay interest at the maturity date.
AMORDEGRC	Returns the depreciation for each accounting period within the formula.
AMORLINC	Returns the depreciation for each accounting period.
BESSELI	Returns the BESSEL function in modified form for imaginary arguments.
BESSELJ	Returns the actual BESSEL function.
BESSELK	Returns the BESSEL function in modified form for imaginary arguments.
BESSELY	Returns the BESSEL function, also known as the Weber or Neumann function.
BIN2DEC	Converts a binary number to decimal form.
BIN2HEX	Converts a binary number to a hexadecimal.
BIN2OCT	Converts a binary number to octal form.
COMPLEX	Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
CONVERT	Interprets data from one measurement system to another.
COUPDAYBS	Returns the number of days from the beginning of the period to the coupon-period settlement date.
COUPDAYS	Returns the number of days in the period that contains the coupon period settlement date.
COUPDAYSNC	Returns the number of days between the settlement date to the next coupon date.
COUPNCD	Returns the next coupon date after the settlement date.
COUPNUM	Returns the total number of coupons to be paid between the settlement and maturity dates, rounded up to the nearest whole coupon.
COUPPCD	Returns the coupon date previous to the settlement date.
CUMIPMT	Returns the cumulative interest on a loan between start and stop dates.
CUMPRINC	Returns the cumulative principal amount between start and stop dates on a loan or mortgage.
DEC2BIN	Converts decimal numbers to binary form.
DEC2HEX	Converts decimal numbers to hexadecimal.
DEC2OCT	Converts decimal numbers to octal.
DELTA	Tests whether numbers or values are equal with a number result. Returns "0" for unequal, "1" for equal.
DISC	Returns the security discount rate.
DOLLARDE	Converts a fraction dollar price into a decimal dollar price.
DOLLARFR	Converts a decimal dollar price into a fraction dollar price.
DURATION	Returns the Macauley duration for an assumed par value.
EDATE	Returns the value or serial number of the date which is a certain number of months before or after a user-specified date.
EFFECT	Returns the effective interest rate annually. This is based on the nominal annual interest rate and the number of compounding periods per year.
EOMONTH	Returns the date at the end of the month a specified number of months before or after a specified date.
ERF	Returns the integrated error function between a lower and upper limit.
ERFC	Returns a complementary ERF function integrated between 'x' and infinity.
FACTDOUBLE	Returns the double factorial of a number.
FVSCHEDULE	Returns the future value of a principal amount after applying several, or a series of compound interest rates.
GCD	Returns the greatest common divisor of two or more integers.
GESTEP	Returns the value 1 if the number is greater than or equal to a specified step value, otherwise it returns 0.
HEX2BIN	Converts hexadecimal numbers to binary form.
HEX2DEC	Converts hexadecimal numbers to decimal form.
HEX2OCT	Converts hexadecimal numbers to octal form.
IMABS	Returns the absolute value (modulus) of a complex number in x+yi or x+yj text format.
IMAGINARY	Returns the coefficient of a complex number in x+yi or x+yj text format.
IMARGUMENT	Returns the theta argument - an angle expressed in radians.
IMCONJUGATE	Returns the complex conjugate of a complex number in x+yi or x+yj text format.
IMCOS	Returns the cosine of a complex number in x+yi or x+yj text format.
IMDIV	Returns the quotient of complex numbers in x+yi or x+yj text format.
IMEXP	Returns the exponential of a complex number in x+yi or x+yj text format.
IMLN	Returns the natural logarithm of a complex number in x+yi or x+yj text format.
IMLOG10	Returns the common logarithm (Base 10) of a complex number in x+yi or x+yj text format.
IMLOG2	Returns the common logarithm (Base 2) of a complex number in x+yi or x+yj text format.
IMPOWER	Returns a complex number raised to a power in x+yi or x+yj text format.
IMPRODUCT	Returns the product from 2 to 29 complex numbers in x+yi or x+yj text format.
IMREAL	Returns the real coefficient of a complex number in x+yi or x+yj text format.
IMSIN	Returns the sine of a complex number in x+yi or x+yj text format.
IMSQRT	Returns the square root of a complex number in x+yi or x+yj text format.
IMSUB	Returns the difference of two complex numbers in x+yi or x+yj text format.
IMSUM	Returns the sum of 2 to 29 complex numbers in x+yi or x+yj text format.
INTRATE	Returns the interest rate of a security that is fully invested.
ISEVEN	Returns TRUE if value is an even number, FALSE if it is not.
ISODD	Returns TRUE if value is an odd number, FALSE if it is not.
LCM	Returns the least common multiple of integers.
MDURATION	Returns the modified duration of a security with a par value assumed to be $100.
MROUND	Returns a number rounded to the desired multiple. Rounds up if the remainder after dividing the number by the multiple is at least half the value of the multiple.
MULTINOMIAL	Returns the ratio of the factorial of the sum of the values to the product of the factorials.
NETWORKDAYS	Returns the number of working days between two dates. Excludes weekends and specified holidays.
NOMINAL	Returns the nominal annual interest rate given an effective rate and the total number of compounding periods for the year.
OCT2BIN	Converts an octal number to binary form.
OCT2DEC	Converts an octal number to decimal form.
OCT2HEX	Converts an octal number to hexadecimal form.
ODDFPRICE	Returns the value of a security based on a per $100 face value and an odd (short or long) first period.
ODDFYIELD	Returns the security yield with an odd first period.
ODDLPRICE	Returns the per $100 face value of a security having an odd last coupon period.
ODDLYIELD	Returns the security yield that has an odd last period.
PRICE	Returns the value of a security based on price per $100 face value and periodic interest payments.
PRICEDISC	Returns the value of a discounted security based on a price per $100 face value.
PRICEMAT	Returns the value of a security that pays interest at maturity and price per $100 face value.
QUOTIENT	Returns the integer portion of a division.
RANDBETWEEN	Returns a random integer between the integers you specify. A new random number is returned every time the worksheet is calculated.
RECEIVED	Based on a fully invested security, returns the amount received at maturity.
SERIESSUM	Returns the sum of a power series.
SQRTPI	Returns the square root of (NUMBER * Pi)
TBILLEQ	Returns the bond equivalent yield for a treasury bill.
TBILLPRICE	Returns the price per $100 face value for a treasury bill.
TBILLYIELD	Returns the yield of a treasury bill.
WEEKNUM	Returns the number where a week falls numerically within a year.
WORKDAY	Returns a date that is a specified number of working days before or after a given date.
XIRR	Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
XNPV	Returns the net present value for a schedule of cash flows that is not necessarily periodic.
YEARFRAC	Calculates the fraction of the year between two dates.
YIELD	Based on a yield that pays periodic interest, returns the yeild of the security.
YIELDDISC	Returns the annual yield for a discounted security.
YIELDMAT	Returns the annual yield based on a security that pays interest at a maturity.

Like SpreadsheetGear?

SpreadsheetGear 2010
Now Available

NEW! Autofilters, password protected workbooks, macro-enabled Open XML (.xlsm) support, Excel 2010 support, Visual Studio 2010 and .NET 4.0 support, a number of charting features and more.

Download the FREE Trial.

Microsoft Chooses
SpreadsheetGear for .NET

"After carefully evaluating SpreadsheetGear, Excel Services, and other 3rd party options, we ultimately chose SpreadsheetGear for .NET because it is the best fit for MSN Money."

Chris Donohue
Program Manager
MSN Money

Brilliant Product
Fanatical Support

“Thank you again for your brilliant product and fanatical support. We have never looked back since we discarded FarPoint’s Spread in favour of SpreadsheetGear."

Earl J. Steyn
Data Prime Solutions
Johannesburg, South Africa

SpreadsheetGear for .NET Worked as Described

"After trying every Microsoft Excel compatible spreadsheet solution for the .NET Framework I could find, SpreadsheetGear for .NET is the only one that actually worked as described."

Michael Garnett
Interpublic Group
New York, NY

My Boss Thinks
I'm a Genius

"Just wanted to give you a little good feedback on your product. I'm a programmer for a small company in Norway and we needed to create an Excel report for one of our customers. So I purchased a license for your wonderful product and it took me about 10 minutes to get the report from a DataTable into a finished Excel document!

My boss thinks I'm a genius, but hey; the credit should go to your product. At least half of it.

Cheers!"

Hans Olav Stjernholm
Chief Developer
ZapDance as, Norway

Reduced Time From
20 Minutes to 4 Seconds

"We integrated SpreadsheetGear for .NET with an existing application with about two days work and it reduced the time it takes to generate a critical daily report from 20 minutes to 4 seconds. Thanks for making my team look like miracle workers!"

Luke Melia, Software
Development Manager
Oxygen Media, New York

Fantastically Powerful
Very Easy To Use

"SpreadsheetGear for .NET is a fantastically powerful spreadsheet component which is very easy to use and expand. We delivered our mandatory customer requirements well before time so we had plenty of time to implement the nice-to-have requirements nobody ever manages to deliver."

Simon Black
Software Architect
Nokia

Every Day that Goes By
I Am More Amazed

I must say that everyday that goes by I am more amazed with your component. It’s easy to use but still powerful. No more problems using Excel workbooks in the .NET environment.

You have spared me about 3 or 4 months of work with your excellent tool. I also must say that I’m using many other components from other companies and no one has proven to be as fast and effective as you in solving a support request.

Pedro Horta
IT Analyst / Programmer
OmnicomMediaGroup
Portugal

Great Piece of Software
Solves Real Problems

"SpreadsheetGear for .NET is a great piece of software that has given me faith that there are still developers who write great code to solve real problems and are serious about supporting it."

Deane Barker
Blend Interactive
Sioux Falls, South Dakota

Great Support
Fantastic Performance

We finished our migration to SpreadsheetGear in only three weeks thanks to your great support and achieved a fantastic performance improvement. Our application used to spend 450 seconds waiting for Excel to load, calculate and save files. SpreadsheetGear does the same work in 24 seconds - 18 times faster!

Irakli Machabeli
Och-Ziff Capital Management Group
New York, NY

Performance, Flexibility
Priceless Support

"We started to use SpreadsheetGear for .NET almost two years ago when the performance of other controls was becoming problematic. We needed a control that could handle large workbooks with complex formulas to be able to apply Monte Carlo simulation to financial statements. Since that time SpreadsheetGear for .NET has become our tool of choice not only for the performance but also for the flexibility. But most of all, the technical support we receive from SpreadsheetGear LLC is priceless; it has always been fast and accurate with the vision to arrive at the desired solution."

Frédérick Faucher
Analyste Financier
Solutions Modex Inc.
Montréal, Canada

Above and Beyond Support, Exceptional

"Although there was an initial issue related to date formatting associated with a cultural problem, I found that SpreadsheetGear provided myself, and ultimately the bank, with above and beyond support, providing us with the necessary fix for the issue within 2 days. This is nothing less than exceptional, and I for one would like to thank SpreadsheetGear for their tenacity, enthusiasm and dedication to their product."

David Lashley
IT Development Manager
Commercial Bank of Qatar

SpreadsheetGear for .NET
So Much Easier

"I have one big problem with Spreadsheetgear for .NET, my billable hours are going to go down because your product is so much easier to use than a web grid. Yikes!

I sure wish I had found your product a couple of years ago. And converting my webgrid code over to SpreadsheetGear for .NET is going very quickly because all of the logic is already coded and I just have to write to the spreadsheet.

I really like not having to insert columns and rows when I need them. I really like your product so far."

Bruce Hemmerich
Manager - Business and Technical Solutions
KeyChainData, LLC

Wow!
Perfect!!!

"Wow! Thank you for the hint!

Your support is like your product: Perfect!!!"

Christian Donges
:em engineering methods AG
Darmstadt, Germany

Spreadsheet Component
Industry Veterans

"Our key developers have over fifty years of combined experience developing high performance commercially available spreadsheet technology which is used by most of the Fortune 500."

Joe Erickson
Founder and CEO
SpreadsheetGear LLC

Best Component Purchase
for Many Years

“SpreadsheetGear for .NET provides a platform for spreadsheet web extension second to none. We were able to implement our custom formulas using the SpreadsheetGear engine with ease and these interact with the Excel functions seamlessly. The performance is superb and in many cases faster than in Excel which has been a pleasant surprise. The expertise of the development team is very apparent and we look forward to the new product enhancements coming down the line. From a return on investment perspective this has been our best component purchase for many years."

Mark Scanlon
Managing Director
XLCubed Ltd

The Best Tutorial I
Have Ever Encountered

“Your SpreadsheetGear Explorer Sample Solution may be the best tutorial I have ever encountered. In a matter of minutes, I believe I fully understand the major elements and some of the subtle nuances of code needed to put an Excel compatible chart on a Windows Form. In every way I have used SpreadsheetGear, I have been delighted with the documentation, content, performance, and support."

David W. Smith
Materials Engineer
Rolls-Royce Corporation

The More I Use It
The More I Like It

"Thanks very much!

The more I understand and use SpreadsheetGear, the more I like it. Great job and excellent support."

Rob Stephens
RGS Consulting
Seattle, Washington

Natural API,
Blindingly Fast, Wow!

“Your interface-based approach is refreshing: the API is natural and the underlying code is blindingly fast for what it does.

Changing my Excel abstraction to use SpreadsheetGear brought a 2 month pull from 48 minutes (2880 seconds) to 12.7 seconds.

Wow!"

Dennis C. Wright
dWare.biz, LLC

Best Support I
Have Ever Seen

I have been developing software for 28 years and have used many tools on many different platforms. Your technical support is the best I have ever seen.

Greg Peters
Software Architect
ValuSource

Excellent Product
And Service

"Thank you for all your help during the trial period.

Your excellent product and service is what convinced us to buy this component."

Etienne Demers
OceanLogics, Canada

Hands Down the Most
Intuitive and Easy to Use

"Thanks again for your prompt response, and I would just like to say that this is by far the best library that I have worked with. It is hands down the most intuitive and easy to use API that I have used to work with Excel files. Its performance is hard to beat as well.”

Levi Wilson
Software Developer
Press Ganey Associates
South Bend, Indiana

ASP.NET and
SpreadsheetGear
A Match Made in Heaven

"ASP.NET and Microsoft Excel is a dangerous combination. ASP.NET and SpreadsheetGear is a match made in heaven. When you need your web or Windows app to interact with Excel files with lightening speed and no COM crashes, SpreadsheetGear for .NET is what you use. This product truly separates the men from the boys in the spreadsheet control marketplace."

Robbe Morris
Microsoft MVP - C#
Co-founder of EggHeadCafe.com and former Gartner Sr. Software Engineer

Your Quick Responses...
You Continue to Impress

"Your quick responses to queries are one of the original reasons why we opted for your product, and you continue to impress us with the speed at which questions and issues are dealt with."

Justin Blackwell
Volume Design Ltd.
Berkshire, United Kingdom

SpreadsheetGear Kills
The Competition

"I must say that in terms of structure and completeness, SpreadsheetGear kills the competition."

Mark Keogh, Technical Lead
BCC AdSystems
Sydney, Australia

SpreadsheetGear 2009
In a League by Itself

"SpreadsheetGear 2009 is Fantastic! I hate to think of NOT having SpreadsheetGear for even one day. These new capabilities just propelled this control way-way past any competition, of which you have none IMHO.

As a programmer, I respect the amount of work, etc., that goes into a product that works well and as advertised. We have been using SpreadsheetGear since 2006 and it has saved us countless hours, headaches and $$$. We have had no recurring crashes since we removed all Office COM objects and replaced them with SpreadsheetGear. It seems that everything runs a lot smoother and much faster.

SpreadsheetGear is in a league all by itself."

Greg Newman
Senior Software Engineer
WSFS Cash Connect

SpreadsheetGear for .NET
A Pleasure to Work With

"SpreadsheetGear for .NET is truly a pleasure to work with. I was up and running within the first day. It is the best spreadsheet generator out on the market. Performance, Ease of Use, and Full Control of the generation process sold me. I no longer have to be concerned with memory leaks, hung processes, COM Interop and slow performance. Our users demand cosmetically appealing reports without additional work. I can build templates at will, with complete control to freeze panes, page setup, cell formats, etc., etc. The old days of pre-building templates are gone. I cannot think of anything this product cannot do."

Todd Dickard
TA Billing Systems Mgr.
TravelCenters of America

Special Product
Great Job

We’ve been using SpreadsheetGear for 5 years. One of the things that makes this product special is that I really don’t have to think about it – I can spend my time worrying about the application that wraps it rather than the technology itself.

The vendor is great to work with too – technical questions are addressed quickly and accurately, without a lot of the refusal to admit problems that plagues other vendors.

Great job!!!

Bill Wilson
Development Manager
Thomson Reuters

Creating Excel Reports
Has Never Been Easier

"I really am happy with SpreadsheetGear for .NET. It works fantastic, very smooth to handle. Creating Excel Reports has never been easier for me!"

Wolfgang Kamir
Softwaretailor
Baden, Lower Austria

I'm Impressed With the
Ease of Use and Speed

"I'm impressed with the ease of use and speed of SpreadsheetGear for .NET in rendering large workbooks from a web page. Congrats for your work!"

José M. Marcenaro
Tercer Planeta
Buenos Aires, Argentina

The Daily Grind Reviews SpreadsheetGear for .NET

September 22, 2005 - "The license allows royalty free deployment, making this a cost effective alternative to Excel as well as a technically superior one for generating worksheets and performing heavy-duty calculations from your .NET applications."

Mike Gunderloy
Lead developer for Larkware
Author of numerous books and articles on programming.

Unmatched Speed
and Ease of Coding
Make it a Winner

SpreadsheetGear is a great product. The speed is unmatched and the ease of coding makes it a winner.

Steve Cruickshank
Redwood Software

First Rate Support
Superior Control

"Your support is first rate. We always get an answer within a few minutes of any request or question. This support, combined with the exceptional speed and ease of use of your superior control enables me to create complex spreadsheet solutions that work in a few minutes instead of days. Keep up the excellent work!"

Greg Newman
WSFS Bank
Newark DE

You Have an
Excellent Product

"You have an excellent product. I've finished my testing and was able to rewrite a program using VB.NET and your control. I wrote the previous version 4 years ago using VB6 which employed the Excel COM object. The old program generated about 2100 excel sheets in 8 hours. With your control it now takes 7 minutes!

I also wrote a web form in ASP.NET VB using your control. This was also previously a VB6 / Excel app. This one went from 36 minutes to less than a minute.

I'm having no trouble getting this purchase approved!"

Mark Hitchcock
Manager of Information Technology
Administrative Concepts, Inc.

SpreadsheetGear
ROCKS!!!!

"We recently bought SpreadsheetGear for an Excel reporting project and have found it to be excellent!

However, this week I have discovered that I can use SpreadsheetGear to open an Excel spreadsheet and interrogate it on the fly. This facility has literally saved me weeks of work. Hence I am just dropping you a quick email to say thank you very much.

SpreadsheetGear ROCKS!!!!"

Andrew Breward
Caboodal

Fantastic -- From Excel
To ASP.NET Dashboard
in a Single Afternoon

"Fantastic evaluation -- I started with a customer’s Excel workbook with a dashboard containing variable cells and a chart. Using SpreadsheetGear, and your Dashboard from 1693 Analytics sample as a template, I created my own ASP.NET page to display our client’s dashboard, and update based on the selection of parameters which get plugged into the variable cells. And I got this working in a single afternoon."

Andy Hofer
Directory of Development
NST Systems, Inc.
Stamford, CT

SpreadsheetGear Joins
Microsoft VSIP Program

August 23, 2005 - "We welcome SpreadsheetGear to the Microsoft Visual Studio Industry Partner Program. The improved ability to create, modify, calculate, read and write Microsoft Excel (versions 97 and higher) workbooks will allow our mutual customers to create a broad range of solutions in a rich and familiar form."

Nick Abbott
Group Manager
.NET Developer Product Marketing Group
Microsoft Corp.

Vision and Ability for Advanced Spreadsheets

September 20, 2005 - "With SpreadsheetGear, we finally have a company that understands our requirements in regards to supporting the Microsoft Excel file format in the Microsoft .NET Framework. SpreadsheetGear has the vision and the ability to provide the advanced spreadsheet functionality our customers expect in our products."

Tim Tow
President
Applied OLAP, Inc.
Former Microsoft Excel MVP

SpreadsheetGear Saved
Hours of Development

“SpreadsheetGear helped our team of developers in developing a .NET library that allows users to create custom reports. The ease of use of the SpreadsheetGear product saved us hours of development time and ultimately helped deliver an excellent product to the client. We would definitely recommend using this product!

Robert Jumblatt
Principal
CoreBix LLC
Vienna, VA

SpreadsheetGear for .NET
Robust & Comprehensive

We really love SpreadsheetGear for .NET. The comprehensive and robust set of worksheet functions ensures that our customers are able to fully leverage their Excel knowledge in our product.

Andreas Lipphardt
XLCubed Ltd
Hessen Germany

Over 100 Times Faster
Than Other Controls

"We just wanted you to know how thrilled we are by the performance we are seeing with SpreadsheetGear for .NET. A 6,000 KB Excel workbook is loading into the WorkbookView control in less than a second. This is over 100 times faster than other controls we’ve tested. That difference makes it possible for us to develop and release a viable product with the Microsoft .NET Framework."

Amy Tate
Chief .NET Architect
Applied OLAP, Inc.
Huntsville, Alabama

SpreadsheetGear - The
Best I Have Encountered

"The sample code you provided has worked very well indeed. Many thanks for your help. As a developer of bespoke software I can honestly say that of all the components my company has ever used, SpreadsheetGear is the best that I have encountered."

Peter Rose, Director
TEKenable, Ltd.
Dublin, Ireland

Microsoft, Microsoft Excel, Visual Studio and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.