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
0 answers

How to get Range result from Autofilter in Spreadsheetgear

I have the worksheet to keep BOM data. The columns as following: Bom header…
Duyet Le
  • 1
  • 1
0
votes
1 answer

Creating a Dependent Drop-Down List where the VALUES (not just the list) come from an INDIRECT Function

The software our company uses utilizes SpreadsheetGear to build dashboards for Estimating. The data from our estimating software is fed into a sheet into this dashboard, and I build my formulas to read things from that sheet. The limitation with…
pladin517
  • 1
  • 1
0
votes
3 answers

Excel column data type exclusive of the header row

Using spreadsheetgear, is there any way to get the "probable" data type for a column, exclusive of the header row (if one exists) and reasonably tolerant of sparse population without having to do a sample myself...is there already a way to do this?…
Tim Jarvis
  • 18,465
  • 9
  • 55
  • 92
0
votes
1 answer

Do not want to show the default selection of cells at dragging time in SpreadSheetGear

Scenario: Select a cell, and after pressing the left button from the mouse and moving (dragging) to another cell it changes all the traversing cell's borders. Expected behavior: We do not need the default borders of cells when dragging one cell to…
Khalid Farhan
  • 435
  • 1
  • 3
  • 19
0
votes
2 answers

How do I create multiple groups in a spreadsheet and have them collapsed when the spreadsheet is opened?

I am attempting to create a spreadsheet with multiple summary rows, all of which are collapsed when the workbook is opened. I've tried using SummaryRows(), but it collapses the entire spreadsheet into a single group controlled by a single button. My…
S. Davenport
  • 140
  • 1
  • 7
0
votes
0 answers

SpreadsheetGear.Factory.GetWorkbook(filename), and file locking

I noticed that when calling SpreadsheetGear's Factory.GetWorkbook(filename) method, that it can successfully read in the file, even if that file is currently open in Excel. I'm guessing the method is doing something like opening a FileStream using…
Moe Sisko
  • 11,665
  • 8
  • 50
  • 80
0
votes
1 answer

SpreadsheetGear set background color dynamically

I have a excel report with SpreadsheetGear component and get data from dataTable. one of column is true/false. I want to set background color for my celles dynamically if my data is true the background color must be red and if false the color must…
shayan kamalzadeh
  • 114
  • 8
0
votes
1 answer

SpreadsheetGear draw an arow

How can draw arrow in excel file with SpreadsheetGear component? I create excel file with c# code and I have 2 Data table for show in my excel . now I want to draw arrow and connect each row of 2 data tabel
shayan kamalzadeh
  • 114
  • 8
0
votes
1 answer

Cursor does not show/blink in dark cell in Spreadsheetgear

I am using SpreadsheetGear in our WPF project. The cursor color is black: In the light color cell, blinking of the cursor is visible But in the dark color cell cursor is not visible clearly. Please see this GIF How can make it visible? Any Idea? Is…
Khalid Farhan
  • 435
  • 1
  • 3
  • 19
0
votes
1 answer

CopyAfter() is meant to return the newly created sheet, but doesn't seem to

Update: it turns out it was the SaveToStream() method which saves all sheets instead of the the one, that was the confusing part which lead me to believe the sheet being returned wasn't right Given the documentation on the CopyAfter() method, the…
PandaWood
  • 8,086
  • 9
  • 49
  • 54
0
votes
1 answer

IWorkbook.SaveToStream throws System.IndexOutOfRangeException

When calling the following code to convert a workbook to a memory stream in order to save it to an external storage system. private static MemoryStream GetWorkbookStream(IWorkbook workbook) { using var workbookStream = new MemoryStream(); …
Liam Hall
  • 147
  • 9
0
votes
1 answer

Read .xlsx to dto via SpreadSheetGear

I would like to read exel file to custom model (map it!) using spreadsheetgear in .Net Core 3.1 console app. My excel file looks like: | Customers | Sales Item | Sale Date | Contact | Quantity | | IBM | Keyboard | 28-10-2011 | | 2 …
JDo
  • 338
  • 1
  • 4
  • 18
0
votes
0 answers

how to read .xlsx files using SpreadsheetGear2017

I'm trying to read an Excel file with extension .xlsx which is created using Spreadsheetgear2017 and I'm getting an exception stating Corrupt open XML file. Here I'm sure that the sheet doesnt contain any Cell comments and form controls as the sheet…
upendra
  • 1
  • 1
0
votes
1 answer

I need a better way to approximate the List Separator in an ASP web app

We host our web forms app on a Windows server. We utilize SpreadSheetGear to write formulas to cells and allow the user to download the workbook. We determine the list separator by the Server culture (this is a problem). We service customers in USA…
w2-
  • 19
  • 5
0
votes
0 answers

Spreadsheetgear C# - Calculate SHA hash of VBA code

I need to compare macros between two spreadsheet to find if they are same. I have to read excel using Spreadsheetgear in C#. We are computing SHA hash for comparing cells. I am not sure how to read Macro code as object so that hash can be…
Atul Yadav
  • 1
1 2 3
…
16 17