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

How to add a triangle marker to any cell corner of SpreadsheetGear grid?

This is a SpreadsheetGear Grid specific question. I know you can add a comment to a cell and the cell gets red triangle marker at the top right corner automatically. But I have a need to add a small triangle (different color) to any cell corner to…
newman
  • 6,841
  • 21
  • 79
  • 126
2
votes
1 answer

How can you set the scope for a defined name programmatically using SpreadsheetGear?

The support for working with defined names in SpreadsheetGear isn't as good as for other components of Excel. Can this be done? If so, how? When I copy in a sheet from another workbook, the scope is limited to that worksheet, and I'd like to be able…
vwfreak
  • 369
  • 2
  • 5
  • 18
2
votes
1 answer

Spreadsheetgear column width changing event?

Is there any event in spreadsheetgear for worksheet column width changing? I want to perform some operation when user clicks on column separator and drags it to change its width in worksheet. What precisely I want to do is to show a small tooltip…
Shiv Ram Khatik
  • 21
  • 2
2
votes
1 answer

Copy Excel RangeSelection to array in Windows Application

Thanks for any help in advance :) Context I am using SpreadsheetGear within my Windows Application and there are certain cases where a user will want to copy data from an open Excel application and paste the two dimensional grid into the…
Jake Smith
  • 2,332
  • 1
  • 30
  • 68
2
votes
2 answers

Accessing Comment Changes in a Spreadsheetgear WorkbookView Control

I have a C# application that uses SpreadsheetGear's WorkbookView control. A user wants to be able to have changes he makes to comments on a cell saved. Does anyone know of a way to capture changes when a user edits a comment. The cell edit events…
Daniel
  • 5,602
  • 4
  • 33
  • 36
1
vote
1 answer

Cell styles in SpreadsheetGear C# .NET

I try create excel document via SpreadsheetGear. And i would like to apply some styles on headers?fonts etc same as on screenshot: I wrote the following code: static string[] fieldsName = { "Name", "LastName", …
JDo
  • 338
  • 1
  • 4
  • 18
1
vote
1 answer

How to get actual columns range Spreadsheetgear

I have an Excel worksheet which has 50 Rows and 38 columns "Filled" with actual data but when I try to get the .UsedRange I am getting More than 1025 Rows and 250 columns as Used range! Please let me know how can I get only actual Used ranges with…
JDo
  • 338
  • 1
  • 4
  • 18
1
vote
1 answer

how to consolidate data in excel from multiple worksheets?

I have to merge the worksheet and worksheet 1 data into a single sheet. I tried the FileStream method to open the file and read the data from there and paste it into the destination worksheet. Qdv.UserApi.IWbs WBS = es.CurrentVersion.Wbs; …
Ashwini GUPTA
  • 27
  • 6
1
vote
1 answer

Reading object directly from AWS S3 bucket and return workbook using SpreadsheetGear

An excel file can be downloaded from S3 to web-server and then can be populated in a Spreadsheetgear workbook object. However, I am trying to read an array of bytes or streams from an excel file stored in an S3 bucket and populate a workbook object.…
SOUVIK SAHA
  • 191
  • 2
  • 4
1
vote
1 answer

Adding a table to an existing excel file with spreadsheetgear

I use Spreadsheetgear to export the results of custom SQL queries as excel files. Now I want to improve this system: The user will be able to upload an excel template file into the database (currently as varbinary). For example, it could have one…
Infrisios
  • 201
  • 2
  • 8
1
vote
2 answers

SpreadsheetGear get column by name?

I'm just starting to work on a project that uses SpreadsheetGear. CopyFromDataTable is used to get all the data from a database. There are a lot of fields to work with; we're formatting them, hiding certain ranges if they're empty, etc. As an…
John Straka
  • 1,874
  • 5
  • 28
  • 49
1
vote
1 answer

SpreadsheetGear - Save Specific Workbook Sheet to CSV

I am opening an existing Excel file using SpreadsheetGear, using the following code: SpreadsheetGear.IWorkbook xlBook = SpreadsheetGear.Factory.GetWorkbook(fileName, System.Globalization.CultureInfo.CurrentCulture); …
Fritz45
  • 752
  • 1
  • 10
  • 23
1
vote
1 answer

SpreadsheetGear 2012 - 2017 Upgrade - SpreadsheetGear.data no longer valid

In Spreadsheetgear 2012, I have code below which populates a datatable and then passes it to an IRange. My issue is that in 2017 for .netstandard (Nuget package 8.2.10), there is no SpreadsheetGear.data. I can't even locate any method of…
Steve Newton
  • 1,046
  • 1
  • 11
  • 28
1
vote
1 answer

SpreadsheetGear - Issue with copying sheets from one Workbook to another

I would like to merge all sheets from several Workbooks and save them in one excel file. I am trying to copy all the sheets in one Workbook and then save the workbook to a file. The problem is - only the last sheet is saved in the file. Below is…
Manish
  • 510
  • 2
  • 12
1
vote
1 answer

C# SpreadsheetGear : Fetch calculated value of a formula

I am using a formula to create hyperlinks in excel. Excel Formula : =HYPERLINK(CONCATENATE("https://loremipsum.com/#/Advert/",[@[Customer CID]],"/dolorsit"), "View") This formula is evaluating as expected in excel but when I go fetch this through…
s7h
  • 51
  • 3
1 2 3
…
16 17