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
1
vote
1 answer

copy a list to a SpreadSheetGear Irange

I have the following code: using (CPASEntities ctx = new CPASEntities()) { IWorksheet ws = wb.Worksheets[0]; ws.Name = "Summary"; var tsm = (from x in ctx.tblTimesheetMasters …
JimS-CLT
  • 665
  • 4
  • 13
  • 30
1
vote
3 answers

Best library to generate excel and charts in excel?

Which is the best 3rd party library to use for exporting data and generating charts in the Excel from Asp.net. I have researched on .Net and found the following: 1. EPPlus: Since we are to work in a very tight schedule and the project is also not…
user2142938
  • 69
  • 2
  • 8
1
vote
1 answer

XLSB with SpreadsheetGear2012 - Excel cannot open the file 'test.xlsb' because the file format or file extension is not valid

I am evaluating SpreadsheetGear2012 and I want to be able to open/save all types of Excel files: .xls, .xlsx, .xlsm and .xlsb. All extensions are working fine except for .xlsb. Here is the code for creating a simple .xlsb file: …
Andrei Petrut
  • 390
  • 2
  • 15
1
vote
1 answer

SpreadsheetGear Grid: events for deleting or inserting rows or columns?

As the title says, is there an event for those actions like deleting a row or column, inserting a row or column, or changing text in a cell? I'd be very disappointed if there isn't.
newman
  • 6,841
  • 21
  • 79
  • 126
1
vote
0 answers

Can we pivot data in Excel using spreadsheetgear

I have a scenario to see weather it is possible to pivot data in excel using spreadsheetgear. We will be sending datatable from application(vb.net) and excel needs to pivot the data and paste in excel cells. Please let me know if it is…
Ramesh
  • 103
  • 1
  • 10
1
vote
0 answers

dropdown value limit in Excel when created from vb.net throws error when values are more than 255 characters

I am working on dynamic creation of dropdown using VB.Net and SpreadsheetGear dll and populate it with values as below worksheet.Range(Range).Validation.Add(ValidationType.List, ValidationAlertStyle.Stop, …
Ramesh
  • 103
  • 1
  • 10
1
vote
1 answer

SpreadSheetGear vs DataGridView Visual Studio 2008

I am creating a pros and cons list on the differences between SpreadSheetGear and the native DataGridView. Trying to determine if we should buy a control or use native DataGridView or some other native control. I don't need formulas or charting. …
Greg Williams
  • 55
  • 3
1
vote
1 answer

Is there a limit to the amount of data that can be held in a SpreadsheetGear WorkbookView?

I have an application that takes a table of data from Excel, and imports it into my embedded SpreadsheetGear.WorkbookView. I am aware of the limitations to the size of a worksheet in Excel, but I was wondering if Excel is able to handle sets of…
Jake Smith
  • 2,332
  • 1
  • 30
  • 68
0
votes
2 answers

Spreadsheetgear Maintains Lock on File

Through an C#/ASP.NET website, I'm using SpreadsheetGear to open a file from a template, then making modifications to it based off user input and then saving it a new location. When I attempt to manually open the newly created file after saving, I…
Paul Smith Jr
  • 89
  • 5
  • 14
0
votes
1 answer

Can I use an XLL add-in with SpreadsheetGear

I have a custom add-in that I need to use in SpreadsheetGear. Can I directly reference the XLL file, or is there a way of making an interface or wrapper to access it? Thanks!
Glen Little
  • 6,951
  • 4
  • 46
  • 68
0
votes
1 answer

Setting Application.ErrorCheckingOptions.BackgroundChecking with Spreadsheetgear

What's the equivalent of doing Application.ErrorCheckingOptions.BackgroundChecking = False with Spreadsheetgear ? Thanks
papps
  • 109
  • 1
  • 12
0
votes
1 answer

Charts in spreadsheet gear

I have created a chart that references table as a source .I need to delete some rows in a table after chart is plotted and leaving the chart unchanged. Is it possible to do that? -Raghu
user1152359
  • 1
0
votes
1 answer

Spreadsheetgears charts with multiple ranges as source

I have a problem when creating charts with Spreadsheetgears. I have a table with a bunch of columns and 3 rows: I need to create 3 charts with Spreadsheetgears for each row with the week names as category labels: But while these charts are easy…
Edgar
  • 4,348
  • 4
  • 40
  • 59
0
votes
1 answer

How do I disable the Drag Fill/ Auto Fill on an IRange object for Spreadsheet Gear .NET?

I am trying to disable the Drag Fill / Auto Fill functionality on spreadsheet gear IRange object, but have been unable to do so. Is there a way to disable the Drag Fill / Auto Fill functionality ? Thanks
ashish.chettiar
  • 3
  • 1
0
votes
0 answers

System.OutOfMemoryException when open the Excel file (800,000 rows) use spreadsheetgear

I have used spreadsheetgear to open the excel file about 850,000 rows. I get the error "System.OutOfMemoryException". I have tried to use the Spreadsheetgear 2023 demo to open, it's okay. I used the following code, my Spreadsheetgear is 2012…
Duyet Le
  • 1
  • 1
1 2 3
…
16 17