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
0
votes
1 answer

Excel data to SQL Server using SpreadSheetGear dll

Can anyone please let me know if there is any API provided by third party SpreadSheetGear dll to save data from Excel to SQL Server ( similar we do using macros) My requirement : I have to download data from web application using spreadsheetgear and…
Ramesh
  • 33
  • 1
  • 10
0
votes
0 answers

Need to speed up processing a SpreadsheetGear IWorksheet

Ok, I have a spreadsheet with 11,500 rows, and 12 columns. It uploads fine, but processing it takes forever. We're using SpreadsheetGear, and what I'm doing right now is putting the data into a DataTable, and iterating over it. With a 300 row file,…
MJR
  • 169
  • 2
  • 15
0
votes
1 answer

Spreadsheetgear replace formula with it's result

I am using spreadsheetgear 2012 for c# .net excel manipulation purpose. I have some excel formulas in some of the cells. Now I want to replace the formula in the excel with the evaluated number. Is there any particular way to do this? Tried…
sam_haz
  • 189
  • 3
  • 15
0
votes
0 answers

Alternative for Range.SpecialCells method (excel) in Spreadsheetgear(excel)

I am converting VBA and excel/OLE code into c# with spreadsheetgear. I got stuck in Range.SpecialCells method. I am unable to found out replace for it in c# and spreadsheetgear. In VBA Range.SpecialCells is used as: SpecialCells(xlCellTypeLastCell,…
Pratap Singh Ranawat
  • 23
  • 7
0
votes
0 answers

SpreadsheetGear2017, #Ref! error

I am using SpreadsheetGear 2017 (the latest) to read an Excel 2016 .xlsm file. One cell is giving me a #Ref! error when I debug, even though the cell displays the value fine in the spreadsheet itself. The cell's formula is…
jenn
  • 11
  • 2
0
votes
0 answers

Calculate the estimated time for a job involving C# ,SQL and spreadsheet gear operations

I have a .Net Console application which processes jobs. People are able to both submit and view the running and failed statuses of jobs. To imagine a job, each one can be thought of as follows: Excel file in (open) Process the Excel file Excel…
Vinoth
  • 972
  • 1
  • 16
  • 47
0
votes
1 answer

Silverlight Spreadsheet Gear - Issue in updating the filtered row

We have build an utility using silverlight and spreadsheet gear. Using this utility, we allow user to read data from backend and allow them to modify the data and then the utility would update the modified field back to the backend. The problem…
Das
  • 11
  • 4
0
votes
1 answer

Suppression State Error BC30002 Type 'SpreadsheetGear.Drawing.Image' is not defined

I am using spreadsheetgear for my project. I have included the spreadsheetgear by using NuGet package and it is also showing in my reference list. Severity Code Description Project File Line Suppression State Error BC30002 Type…
urfusion
  • 5,528
  • 5
  • 50
  • 87
0
votes
1 answer

What colors are allowed in SpreadsheetGear?

In setting the interior color of a cell, I find that some colors are allowed and some are ignored. For example, this works (where ws is an IWorksheet object): ws.Cells[r, c].Interior.Color = Colors.LightPink; but when attempting this…
Der Wolf
  • 1,171
  • 9
  • 11
0
votes
0 answers

Use spreadsheetgear to check if excel contains macros

I am trying to check if an uploaded excel file contains Macro's. I am using Spreadsheetgear for opening excel files. Is there a way to check if it contains macro's? I do not have to run, change or open the macro's, just need to know if they exist.
Bartvandee
  • 289
  • 3
  • 19
0
votes
1 answer

Excel formula is displayed as text upon exporting using SpreadsheetGear

I have a template and I need to populate data into dynamically generated ranges each of which consists of 23 columns. Also I am using data table to populate data into the range. The formula is also generated dynamically for each column and…
Ram Kishore
  • 35
  • 1
  • 7
0
votes
1 answer

Make drop down list default value selected in Excel using spreadsheet gear + VB.Net

I am using below code to create a dropdownlist in Excel with "Yes,No" vallues displayed, but initially it is showing blank worksheet.Range("I4:I5").Validation.Add(ValidationType.List, ValidationAlertStyle.Information, ValidationOperator.Default,…
Ramesh
  • 33
  • 1
  • 10
0
votes
1 answer

SpreadhsheetGear to read bulk excel file

I want to read a bulk excel file using SpreadhsheetGear public ValueFormulaSet ReadData(string sheetName, string address) { var wrksh = this.Workbook.Worksheets[sheetName]; var range = wrksh.Range[address]; var…
Krishnan
  • 66
  • 10
0
votes
1 answer

How to set the color of a cell or range to transparent?

I know how to set the color to red for example: row.Interior.Color = Color.FromArgb(255, 0, 0); But how to set the background to transparent?
Manuel Koch
  • 331
  • 2
  • 14
0
votes
1 answer

How to Cache SpreadSheetGear objects in ASP.NET MVC application?

In an ASP.NET MVC application I'm performing calculations which are in an xlsx file. We are talking about 18K variables in the calculations (xlsx file is around 10MB), so loading them them into a SpreadSheetGear instance takes a while. Therefore I…
Csaba Toth
  • 10,021
  • 5
  • 75
  • 121
1 2 3
…
16 17