SpreadsheetGear - performance spreadsheet components
| | | |
Products
Downloads
Support
Company
SpreadsheetGear for .NET 2007
SpreadsheetGear for .NET 2007 is a royalty free Microsoft Excel compatible spreadsheet component built by industry veterans for any Microsoft .NET Framework solution, featuring the fastest and most complete Excel compatible calculation engine as well as rich Windows Forms Spreadsheet Controls.

Provide a solid foundation for a rich user experience by starting with basic Excel compatible features including multiple worksheets, multiple workbooks, smart data entry, custom number formats, merged cells, cut, copy, paste, insert, delete, clear, find, replace, conditional formats, data validation, sort, group & outline, split/frozen panes, form controls, pictures, autoshapes, cell comments, print, undo and redo.

Add advanced features such as the FormulaBar, RangeExplorer, WorkbookExplorer, DisplayReference, paste special, interruptible background calculation, high performance APIs, real time workbook updates, global and worksheet specific defined names, precision as displayed and array formulas and you have all the features you need to satisfy the most demanding Excel Power User.

Top it all off with simple pricing and licensing, Visual Studio integration, hassle free deployment, one year of all new versions as well as one year of phone and email support from the SpreadsheetGear developers who write the code and you have the spreadsheet component which makes you “look like a genius”.
Excel Automation Samples Download SpreadsheetGear for .NET

General Features
  • Create, read, modify, view, edit, format, calculate, print and write Microsoft Excel workbooks without Excel.
  • Fastest and most complete Excel compatible calculation engine available (significantly faster than Excel).
  • Rich Windows Forms Spreadsheet Control with FormulaBar, WorkbookDesigner, WorkbookExplorer and RangeExplorer.
  • Support for cell comments, pictures, text boxes, check boxes, dropdowns, list boxes, spinners, scrollbars, buttons, lines and many autoshapes.
  • 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 64K worksheets, unlimited workbooks and unlimited workbook sets.
  • Copy, insert and move entire worksheets.
  • C# and VB samples for ASP.NET and Windows Forms.
  • Reads and writes VBA Macros.
  • Royalty free client and server deployment.
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 and Visual Studio 2008 at design time and by 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.
  • Modeless find and replace dialog with support for find, find all, replace and replace all.
  • Support for 64K worksheets in each workbook and unlimited 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 and Visual Studio 2008 including the ability to use the WorkbookDesigner, WorkbookExplorer and RangeExplorer at design time and at runtime.
  • SpreadsheetGear Explorer Sample Solution with C# and Visual Basic source code for Visual Studio 2005 and Visual Studio 2008 demonstrates commonly used SpreadsheetGear for .NET features and APIs.
Calculation Features
  • Fastest and most complete Excel compatible calculation engine available in a spreadsheet component.
  • All financial, date, time, text, lookup, math, trigonometry, statistical and database functions.
  • 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.
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.
  • Copy formats without affecting formulas or values.
  • Merged cells.
  • Horizontal alignment, vertical alignment, word wrap and shrink to fit.
  • Fonts.
  • Borders.
  • Colors and patterns.
  • Hyperlinks.
  • Enable or disable worksheet protection, worksheet passwords and cell locking.
  • Conditional formats.
  • Grouping and outlining of rows and columns.
  • Automatic row heights and column widths.
Limited Charting Features
  • Reads and writes charts.
  • Maintains gradients, fonts, number formats, etc...
  • Charts are copied when a complete worksheet is copied.
  • Chart series data sources are fixed up as needed when worksheets and cells are copied, inserted and deleted.
  • Supports defined names as series data sources which provides the ability to modify data sources with the IName.RefersTo property.
.NET Features
  • Easy to use API which will be familiar to Excel VBA and COM developers.
  • Supports Microsoft .NET Framework version 1.1, Microsoft .NET Framework version 2.0 and 64-Bit Microsoft .NET Framework version 2.0 (WorkbookView control requires .NET 2.0). Works with Microsoft .NET Framework version 3.0 and .NET Framework version 3.5.
  • Microsoft Visual Studio.NET 2003, Visual Studio 2005 and Visual Studio 2008 integration, including IntelliSense and Dynamic Help.
  • The security of 100 percent safe managed code, does not require FullTrust.
  • Hassle free deployment with a single assembly (SpreadsheetGear.dll).
  • No license keys, registry entries or configuration files to deal with.
  • No dependency on Microsoft Excel, which is not supported in a server environment.
Supported Functions
Database and List Management Functions
DAVERAGEIndicates the average of the values that meet the specified criteria.
DCOUNTCounts the number of cells containing numbers that meet the specified criteria.
DCOUNTACounts nonblank cells containing numbers or text that meet the specified criteria.
DGETReturns a single value that meets the specified criteria.
DMAXExtracts the highest value that meets the specified criteria.
DMINExtracts the lowest value that meets the specified criteria.
DPRODUCTReturns the product of the values that meet the specified criteria.
DSTDEVEstimates the standard deviation of a population, based on a sample of selected entries from the database.
DSTDEVPReturns the calculation of the standard deviation of a population, based on the sum of the whole population.
DSUMReturns the total of the values that meet the specified criteria.
DVAREstimates the variance of a sample population based on the values that meet the specified criteria.
DVARPReturns the calculation of the true variance of an entire population based on the values that meet the specified criteria.
Date and Time Functions
NOWReturns the current date and time in the form of a serial number.
TODAYReturns the current date as a serial number.
DATEVALUEConverts date text to a DATEVALUE serial number.
DAYReturns the corresponding day of the month serial number or date text from 1 to 31.
HOURReturns the hour as a serial number integer between 0 and 23.
MINUTEReturns the serial number that corresponds to the minute.
MONTHReturns the corresponding serial number of the month of a date between 1 and 12.
SECONDReturns the seconds portion of a serial time value.
TIMEVALUEReturns the decimal number for a given time.
YEARReturns the corresponding year as a serial number in the form of an integer.
WEEKDAYReturns the corresponding day of the week as a serial number.
DAYS360Returns the number of days between two set dates based on a 360-day year.
DATEReturns the serial number that represents a date.
TIMEReturns the decimal value of a given time.
Financial Functions
IRRReturns the internal rate of return for a series of cash flows represented by numbers in the form of values.
NPVCalculates the net present value of an investment from the discount rate and several future payments and income.
MIRRReturns a modified internal rate of return for several periodic cash flows.
SLNReturns the straight-line depreciation on an asset.
FVReturns the future value of an investment that makes payments as a lump sum or as a series of equal periodic payments.
NPERReturns the total number of periods for an investment. This is based on a periodic constant payment and a constant interest rate.
PMTCalculates the loan payment for a loan based on constant payments and constant interest rates.
PVReturns the present value based on an investment.
RATEReturns per period the interest of an annuity.
ISPMTCalculates the interest paid during a defined period of an investment.
SYDBased on a specified period, SYD returns the sum-of-years' digits depreciation of an asset.
DBReturns the asset depreciation for a period using the fixed declining balance method.
DDBReturns the asset depreciation for a period using the double-declining balance method or another specified method.
IPMTReturns the interest for a period of time based on an investment with periodic constant payments and a constant interest rate.
PPMTReturns the principal payment for a period of an investment based on periodic constant payments and a constant interest rate.
VDBFor a period you specify, returns the depreciation of an asset.
Information Functions
NAAn alternative representation of the error value #N/A.
ERROR.TYPEReturns the corresponding number value associated with an error type in Microsoft Excel.
ISBLANKReturns TRUE if the cell is empty, FALSE if it contains data.
ISERRReturns TRUE if value contains any error value except #N/A, FALSE if it does not.
ISERRORReturns TRUE if value contains any error value (including #N/A), FALSE if it does not.
ISLOGICALReturns TRUE if value is a logical value, FALSE if it is not.
ISNAReturns TRUE if value is #N/A, FALSE if it is not.
ISNONTEXTReturns TRUE if value is not text, FALSE if it is.
ISNUMBERReturns TRUE if value is a number, FALSE if it is not.
ISREFReturns TRUE if value is a reference, FALSE if it is not.
ISTEXTReturns TRUE if value is text, FALSE if it is not.
NReturns a value converted to a number.
TYPEDetermines the type of value in a cell.
Logical Functions
FALSEReturns the value FALSE. May be typed directly into the cell as "FALSE".
TRUEReturns the value TRUE. May be typed directly into the cell as "TRUE".
NOTReturns the reverse value of its arguments; TRUE becomes FALSE and FALSE becomes TRUE.
ANDReturns TRUE if all the arguments are TRUE in the formula, and FALSE if any one argument is FALSE.
ORReturns FALSE if all arguments are FALSE, and TRUE if at least one argument is TRUE.
IFReturns a value if one condition is TRUE and returns another value if the condition is FALSE.
Lookup and Reference Functions
COLUMNReturns the column number(s) based on a given reference.
ROWReturns the row number based on a reference.
AREASReturns the number of areas based on a reference.
COLUMNSReturns the number of columns based on an array or reference.
ROWSReturns the number of rows in a reference or array.
TRANSPOSEReturns a horizontal range of cells as vertical or vice versa.
HYPERLINKCreates a shortcut to jump to a document stored on a network server.
INDIRECTReturns the contents of a cell using its reference.
INDEXReturns the value of an element selected by the row number and column letter indexes.
LOOKUPLooks 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.
MATCHReturns the relative position of an item in an array that matches a specified value in a specified order, or the position of an item.
ADDRESSGiven specified row and column numbers, creates a cell address as text.
CHOOSEReturns an item from a list of values..
HLOOKUPSearches for a specified value in an array or a table's top row.
VLOOKUPSearches 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.
OFFSETReturns a reference to a range that is a specific number of rows and columns from a cell or range of cells.
Math and Trigonometry Functions
PIReturns the approximate number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.
RANDReturns 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.
ABSReturns the absolute value of a number.
ACOSReturns the arccosine of a number in radians in the range 0 to pi.
ACOSHReturns the inverse hyperbolic cosine of a number.
ASINReturns the arcsine of a number in radians in the range -pi/2 to pi/2.
ASINHReturns the inverse hyperbolic sine of a number.
ATANReturns the arctangent of a number in radians in the range -pi/2 to pi/2
ATANHReturns the inverse hyperbolic tangent of a number.
COSReturns the cosine of the given angle.
COSHReturns the hyperbolic cosine of a number.
DEGREESConverts radians into degrees.
EVENReturns a number rounded up to the next even integer for positive integers and rounded down to the next even integer for negative numbers.
EXPReturns e (2.71828182845804) raised to the power of a specified number.
FACTReturns the factorial of a number.
INTRounds a number down to the nearest integer.
LNReturns the natural (base e) logarithm of a number.
LOG10Returns the base-10 logarithm of a number.
MDETERMReturns the matrix determinant of an array.
MINVERSEReturns the inverse matrix for the matrix stored in an array.
ODDReturns a number rounded up away from zero to the nearest odd integer.
RADIANSConverts degrees to radians.
SIGNDetermines 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.
SINReturns the sine of a given angle.
SINHReturns the hyperbolic sine of a number.
SQRTReturns a positive square root.
TANReturns the tangent of the given angle.
TANHReturns the hyperbolic tangent of a number.
LOGReturns the logarithm of a number of the base you specify.
ROMANConverts an Arabic numeral to Roman, as text.
TRUNCTruncates a number to an integer by removing the fractional part of a number.
PRODUCTMultiplies all the numbers given as arguments and returns the product.
SUMAdds all the numbers in a range of cells.
SUMSQReturns the sum of the squares of the arguments.
ATAN2Returns 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.
CEILINGReturns a number rounded up, away from zero, to the nearest multiple of significance.
COMBINReturns the number of combinations for a given number of items.
FLOORReturns a number rounded down, toward zero, to the nearest multiple of significance.
MMULTReturns 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.
MODReturns the remainder of a division operation (modulus).
POWERReturns the result of a specified number raised to a specified power.
ROUNDRound a number to a specified number of digits.
ROUNDDOWNRounds a number down, towards zero.
ROUNDUPRounds a number up, away from zero.
SUMX2MY2Returns the sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2Returns the sum of the sum of squares of corresponding values in two arrays.
SUMXMY2Returns the sum of squares of differences of corresponding values in two arrays.
SUMIFAdds the cells specified by a certain criteria.
SUMPRODUCTMultiplies corresponding components in the given arrays, and returns the sum of those products.
Statistical Functions
COUNTBLANKCounts the empty cells in a specified range.
FISHERReturns the Fisher transformation at x.
FISHERINVReturns the inverse of the Fisher transformation at y.
GAMMALNReturns the natural logarithm of the gamma function.
NORMSDISTReturns the standard normal cumulative distribution function.
NORMSINVReturns the inverse of the standard normal cumulative distribution function.
GROWTHCalculates predicted exponential growth by using existing data.
LINESTCalculates a straight line that best fits your data using the least squares method.
LOGESTCalculates an exponential curve that fits your data and returns an array of values that describes the curve.
TRENDReturns the y-values along a linear trendline that best fits the values in a data set.
AVEDEVRetuns the average of the absolute deviations of data points from their mean.
AVERAGEReturns the average of its arguments.
AVERAGEAReturns the average of the values in its list of arguments including text and logical values.
COUNTCounts the number of cells that contain numbers (including dates and formulas that evaluate to numbers) within the list of arguments.
COUNTACounts the number of cells that are not empty.
DEVSQReturns the sum of the squares of deviations of a data set from their sample mean.
GEOMEANReturns the geometric mean of an array or range of positive data.
HARMEANReturns the harmonic mean of a data set.
KURTReturns the Kurtosis of a data set.
MAXReturns the largest value in a set of values.
MAXAReturns the largest value in a set of values including text and logical values.
MEDIANReturns the median of the given numbers.
MINReturns the smallest value in a set of values.
MINAReturns the smallest value in a set of values including text and logical values.
MODEReturns the most frequently occuring, or repetitive, number in an array or range of data.
SKEWReturns the skew of a distribution.
STDEVEstimates standard deviation based on a sample.
STDEVAEstimates standard deviation based on a sample. Includes text and logical values.
STDEVPEstimates standard deviation based on a sample assuming that the arguments represent the total population.
STDEVPAEstimates standard deviation based on a sample assuming that the arguments represent the total population. Includes text and logical values.
VARReturns an estimate for the variance of a population based on a sample data set.
VARAReturns an estimate for the variance of a population based on a sample data set and may include text or logical values.
VARPCalculates variance based on the entire population.
VARPACalculates variance based on the entire population and may include text or logical values.
CHIDISTReturns the one-tailed probability of the chi-squared (X^2) distribution; the area in the right tail under the chi-squared distribution curve.
CHIINVReturns the inverse of the one-tailed probability of the chi-squared (X^2) distribution.
CHITESTReturns the test for independence of the characteristics in a table.
CORRELReturns the correlation coefficient between two data sets.
COUNTIFCounts the number of cells in a range that meet a given criteria.
COVARReturns the covariance, the average of products of deviations, for each data point pair.
FREQUENCYCalculates how often values occur within a range of values and then returns a vertical array of numbers.
FTESTReturns the result of an F-test.
INTERCEPTCalculates the point at which a line will intersect the y-axis by using existing x and y values.
LARGEReturns the k-th largest value in a data set.
PEARSONReturns 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.
PERCENTILEReturns the k-th percentile of values in a range.
PERMUTReturns the number of permutations for a given number of objects that can be selected from a range of numbers.
QUARTILEReturns the quartile of a data set.
RSQReturns the r^2 value of a linear regression line.
SLOPEReturns the slope of a regression line through data points in KNOWN_Y'S and KNOWN_X'S.
SMALLReturns the k-th smallest value in a data set.
STEYXReturns the standard error of the predicted y value for each x in the regression.
TINVReturns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
TRIMMEANReturns the mean of the interior of a data set.
PERCENTRANKReturns the rank of a value in a data set set as a percentage of the data set.
RANKReturns the rank of a number in a list of numbers.
ZTESTReturns the two-tailed P-value of a z-test.
CONFIDENCEReturns the confidence interval for a population mean.
CRITBINOMReturns the minimum number yields a binomial distribution less than or equal to the specified criteria
EXPONDISTReturns the exponential distribution.
FDISTReturns the F probability distribution.
FINVReturns the inverse of the F probability distribution.
FORECASTCalculates or predicts a future value by using existing values.
GAMMAINVReturns the inverse of the gamma cumulative distribution.
LOGINVReturns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard deviation.
LOGNORMDISTReturns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard deviation.
NEGBINOMDISTReturns the negative binomial distribution.
NORMINVReturns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
POISSONReturns the Poisson distribution.
STANDARDIZEReturns a normalized value from a distribution characterized by MEAN and STANDARD_DEV.
TDISTReturns 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.
PROBReturns the probability that values in a range are between two specified limits.
BETADISTReturns the cumulative beta probability density function.
BETAINVReturns the inverse of the cumulative beta probability density function.
BINOMDISTReturns the individual term binomial distribution probability.
GAMMADISTReturns the gamma distribution.
HYPGEOMDISTReturns the hypergeometric distribution.
NORMDISTReturns the normal cumulative distribution for the specified mean and standard deviation.
TTESTThe probability associated with t-test.
WEIBULLReturns the Weibull distribution.
Text Functions
CHARReturns the character specified by a number.
CLEANRemoves all nonprintable characters from text.
CODEReturns a numeric code from the first character in a text string. The opposite of the CHAR function.
LENReturns the number of characters in a text string.
LENBReturns the number of characters in a text string expressed in bytes.
LOWERConverts all letters in a text string to lowercase.
PROPERCapitalizes the first letter of each word in a text string or sentence.
TReturns the text referred to by a value.
TRIMRemoves all spaces from text except single spaces between words.
UPPERConverts text to uppercase.
VALUEConverts a text string that represents a number to a number.
DOLLARConverts a number to text using Currency format, with the decimals rounded to the specified place.
USDOLLARConverts a number to text using US Dollar format, with the decimals rounded to the specified place.
LEFTReturns the first character(s) in a text string.
LEFTBReturns the first character(s) in a text string based on a specified number of bytes
RIGHTReturns the last character(s) in a text string.
RIGHTBReturns the last character(s) in a text string based on a specified number of bytes.
FIXEDRounds 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.
CONCATENATEJoins several text strings into one text string.
EXACTCompares two text strings and returns TRUE if they are exactly the same, and FALSE otherwise.
REPTRepeats specified text a given number of times.
TEXTConverts a value to text in a specific number format.
FINDLocates 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.
FINDBReturns 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.
SEARCHReturns the number of the character at which a specific character or text string is first found, reading from left to right.
SEARCHBReturns the number of the character at which a specific character or text string is first found in bytes, reading from left to right.
MIDReturns a specific number of characters from a text string starting at the position you specify.
MIDBReturns a group of characters based on a specified number of bytes from a text string starting at the position you specify.
SUBSTITUTESubstitutes NEW_TEXT for OLD_TEXT in a string.
REPLACEReplaces part of a text string with a different text string based on the number of characters you specify.
REPLACEBReplaces part of a text string with a different text string based on the number of characters you specify in terms of bytes.
SpreadsheetGear for .NET
2007 V3.1 Now Available
See What's New and
download the Licensed or
Evaluation version Now.
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
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
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
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
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
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.
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 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
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.

Microsoft VSIP Program
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
By Far the Best Library
That I Have Worked With
"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
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
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
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
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
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
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 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
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
Spreadsheet Component
Industry Veterans
"For more than twenty years, we have been creating and leading the development of high performance spreadsheet technology which is used by most of the Fortune 500."

Joe Erickson
Founder and CEO
SpreadsheetGear LLC
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
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
Copyright © 2003-2008 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.
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.