Stack Overflow
Stack Overflow

Questions tagged [spreadsheetgear]

SpreadsheetGear 2012 enables ASP.NET, Windows Forms, WPF and Silverlight developers to easily take advantage of scalable Excel Reporting, dynamic dashboards from Excel charts and ranges, powerful spreadsheet controls, comprehensive Excel compatible charting, the fastest and most complete Excel compatible calculations and more.

SpreadsheetGear 2012 enables ASP.NET, Windows Forms, WPF and Silverlight developers to easily take advantage of scalable Excel Reporting, dynamic dashboards from Excel charts and ranges, powerful spreadsheet controls, comprehensive Excel compatible charting, the fastest and most complete Excel compatible calculations and more.

SpreadsheetGear LLC is a privately held software publisher located in Lenexa, Kansas. The company was founded by Joe Erickson in 2003 to develop a new generation of Microsoft Excel compatible spreadsheet components for Microsoft .NET and Silverlight.

With a singular focus on spreadsheet technology and unparalleled experience, SpreadsheetGear is committed to being the leader in spreadsheet components.

Resources

254 questions
19
votes
1 answer

Excel number format strings (e.g. "@", "$-409]d-mmm-yy;@") - Complete reference availability?

I'm using Spreadsheet Gear to do some Excel programming. I want more control over number formats and it appears that I need to use the NumberFormat property to achieve this. I've seen suggestions that you can use "@" to specify a string for example,…
gbro3n
  • 6,729
  • 9
  • 59
  • 100
11
votes
1 answer

Get the number of rows of data with SpreadSheetGear?

I've checked a few online resources, maybe I'm blind but I've as yet been unable to find an answer to this. I'm uploading a file, converting it to a stream, feeding it into SpreadSheetGear. Now, I need to loop through every row and read the data…
Chris
  • 3,191
  • 4
  • 22
  • 37
6
votes
3 answers

How to get SpreadsheetGear.IRange.AutoFit() give the right width to each column?

I Use Spreadsheetgear to generate an Excel Workbook. My Workbook is very simple: I insert Strings in cells The first line is Bold I draw borders around the headers and between the columns. At the end of the process, i call…
Samuel Rossille
  • 18,940
  • 18
  • 62
  • 90
4
votes
1 answer

Spreadsheetgear deletes Pivot Table on Load: can it ignore certain sheets?

I use SpreadsheetGear 2012 to update some Data in an Excel Template out of a Database. This Excel Template is defined by the User and does have some other Sheets defined with Diagrams etc. referring to the Worksheet with the primary Data on it. This…
datepicker
  • 43
  • 4
4
votes
2 answers

freeze top row using spreadsheetgear

How can I freeze top row (and only the row) using spreadsheetgear? when I try this: worksheet.WindowInfo.FreezePanes = true; It freezes both the top row and the first column (A). I only need it to freeze the top row.
Zar Shardan
  • 5,675
  • 2
  • 39
  • 37
4
votes
1 answer

Performance difference when reading/writing many files with EPPlus versus Spreadsheet Gear

I've made a simple performance test between EPPlus and Spreadsheet Gear to see if there is any significant difference that would justify buying Spreadsheet Gear. I am no expert at either application so it's possible the tests aren't written the most…
amcdrmtt
  • 1,253
  • 12
  • 13
4
votes
2 answers

Send spreadsheet as email attachment using SpreadsheetGear

A client has asked me to enhance one of their apps in order to send out an email containing an excel spreadsheet. They happened to have an old copy of SpreadsheetGear (2009) lying around, so I thought it might save time if I used it. As it happens…
PeteH
  • 2,394
  • 1
  • 20
  • 29
4
votes
1 answer

How to get and set value/location on vertical scroll bar in SpreadsheetGear control

I am using the SpreadsheetGear control. I would like to be able to get the position of the vertical scroll bar so that after a refresh of the control I can return users to the same set of rows they were viewing before the refresh. The…
turnip_cyberveggie
  • 151
  • 11
3
votes
2 answers

How to add a dropdownlist in excel using spreadsheetgear?

I want to add drop down list in one of column of Excel sheet. How to add it using spreadsheetgear????
kumar
  • 1,117
  • 13
  • 34
  • 58
3
votes
1 answer

Spreadsheetgear error when uses clipboard

In my application I use spreadsheetgear to work with Excel files. I use the following code: //move incorrect to aux incorrectLine.Select(); //select the line to be…
Razvan
  • 319
  • 3
  • 11
3
votes
1 answer

What color code is this?

I'm looking at a code snippet which places text in an excel header: headerText.Append(@"&""Calibri""&20&K04-024HEADER-TEXT"); &""Calibri"" modifies the font, &20 modifies the size, and &K04-024 modifies the color (to navyish). The question is, what…
jdylanmc
  • 829
  • 11
  • 24
3
votes
1 answer

IWorkbook.GetDataSet does not work after SpreadsheetGear update

I just updated spreadsheetgear from our outdated version (6.0.3.222) to the latest version (8.3.20.102) via NuGet, replacing all old SpreadsheetGear.dll files with newer ones of the same name. After the update I get errors claiming that interfaces…
Infrisios
  • 201
  • 2
  • 8
3
votes
1 answer

Spreadsheetgear run macro?

Is it possible to run existing excel macros in Spreadsheetgear?
naeron84
  • 2,955
  • 3
  • 30
  • 37
3
votes
2 answers

How to validate a excel expression programmatically

I have been developing an application that one of it's responsability is provide to user an page that it's possible to write math expression in EXCEL WAY. It is an application in ASP.NET MVC, and it's use the SpreadSheetGear library to EXECUTE excel…
Aitiow
  • 882
  • 2
  • 9
  • 18
3
votes
2 answers

SpreadsheetGear fonts look blurred compared to Excel

I'm evaluating the SpreadsheetGear component for Excel file manipulation. However, out of the box the fonts look slightly blurred or hazy when the same spreadsheet is viewed side-by-side with Excel. Is there some anti-aliasing setting I'm…
Jon
  • 5,247
  • 6
  • 30
  • 38
1
2 3
…
16 17