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

Spreadsheetgear: Error converting to Datetime

I'm trying to parse a cell value in excel sheet and convert it to Datetime using following code.But I'm getting an error as : 'arguments.CurrentWorksheet.Workbook.NumberToDateTime(inpDate)' threw an exception of type…
Jimmy
  • 2,106
  • 12
  • 39
  • 53
0
votes
0 answers

WPF/SpreadsheetGear app

I've a C#/WPF application in which I'm using WorkbookView control.I'm using Spreadsheetgear inside my app. I've cells A and B in my worksheet.On updating value in A, I need to do some calculations and update value in cell B. The problem is that…
Jimmy
  • 2,106
  • 12
  • 39
  • 53
0
votes
1 answer

Copying Shapes (especially charts) with SpreadsheetGear

My task right now is to go through some workbooks within my C# web application and aggregate certain parts of each workbook into a single new workbook. This requires me to copy cell ranges using SpreadsheetGear. With most things, this works fine,…
coeurl
  • 1
  • 1
0
votes
1 answer

How to show html style text in excel cell with SpreadsheetGear

I get a string that contains html content, like this: "i am headhello" now, i want to write this string into excel cell, and let these html tags render the bold style. How can i do this with spreadsheetgear?
an yang
  • 29
  • 1
  • 4
0
votes
1 answer

How can I set the values of a chart series in SpreadsheetGear programmatically?

According to MSDN, Excel permits setting the Values property of a chart series programmatically from an array: Charts("Chart1").SeriesCollection(1).Values = _ Array(1, 3, 5, 7, 11, 13, 17, 19) How do I do this with a SpreadsheetGear chart? In…
David
  • 1,187
  • 1
  • 10
  • 22
0
votes
1 answer

Loading spreadsheet template file doesn't retain form button

I am using SpreadsheetGear 2012 in my application to load, modify then save a new copy of a template workbook. My code takes invoicing information from a database and formats it for the workbook. Then the user will print an invoice from the…
Stephen Fletcher
  • 689
  • 1
  • 8
  • 11
0
votes
1 answer

spreadsheetgear checking HPageBreaks

I use spreadsheetgear. I want to check how many HPageBreaks in my worksheet. I want to check the row content PageBreak. How could I do that. I have tried the following code but something went wrong SpreadsheetGear.IWorkbook wb =…
Duyet Le
  • 1
  • 1
0
votes
1 answer

Obtain cell pixel coordinates with SpreadSheetgear (non Windows Forms)

I know that WorkbookView has a RangeToLocation method (http://www.spreadsheetgear.com/support/help/spreadsheetgear.net.7.0/#SpreadsheetGear2012~SpreadsheetGear.Windows.Forms.WorkbookView~RangeToLocation(Double,Double,Double,Double).html), but if an…
Csaba Toth
  • 10,021
  • 5
  • 75
  • 121
0
votes
1 answer

Extracting the details of varied text formatting within a single SpreadsheetGear cell

I have some text in cells which are formatted in different ways, let's say: "This is mixed style within a single cell" I can access the text content and IRange's Interior property provides color data (among others), and IRange also have Style…
Csaba Toth
  • 10,021
  • 5
  • 75
  • 121
0
votes
3 answers

Spreadsheetgear not loading

I receive this error whenever I reach the part of the code that generates an excel table. Unable to load SpreadsheetGear2012.Drawing.dll or SpreadsheetGear2012.Windows.WPF.dll which contain graphics capabilities. I tried uninstalling and…
Leaf Node
  • 23
  • 6
0
votes
2 answers

SpreadSheetGear - Show only one sheet from a file in WPF MVVM

I'm displaying an Excel workbook in a SpreadSheetGear WorkbookView in an MVVM WPF application. But the workbook has 9 sheets, I only want to display one of them. I know the name of the sheet. Is there a way to do this?
Shaggydog
  • 3,456
  • 7
  • 33
  • 50
0
votes
1 answer

Getting active sort on columns

I'm using spreadsheetgear to push data to a WPF client via TCP/IP socket and DataTable... I need to save before the new data are pushed to the table the existing sorting options in order to restore the after the update. I've not found any…
advapi
  • 3,661
  • 4
  • 38
  • 73
0
votes
1 answer

How Do I Keep All Series Labels on a 3D chart

Suppose that I have a list of 40 planets (OK some are from another solar system). Astronomers have counted the number of meteors hitting the planets from January to December. So I have 40 rows of 12 columns of data. When I plot a 3D chart the…
CoolBreeze
  • 381
  • 4
  • 14
0
votes
1 answer

Set SpreadsheetGear workBookSet to an already open excel file

I am trying to use SpreadsheetGear to access an excel file that is downloaded and opened from a website. I haven't been able to find a way to set an already open and active excel file to a SpreadsheetGear workbook. Saving and then opening from…
jmt177
  • 1
0
votes
1 answer

How Do I Keep Bar Width the Same Across Multiple Charts?

Suppose I want to create two charts with horizontal bars. The names of the objects are listed on the y-axis and the horizontal bars represents some quantity. The first chart has 100 items and the second chart has 5 items. When I create the charts…
CoolBreeze
  • 381
  • 4
  • 14
1 2 3
…
16 17