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

Footer image in Excel 2012 using spreadsheetgear

Can we add footer image to excel 2012 using spreadsheetgear? I want to add a footer image to be appear when we export data from silverlight
Shanjee
  • 491
  • 5
  • 16
0
votes
1 answer

Stream Excel XLS, XLSX file via SpreadsheetGear

SpreadsheetGear provides a method IWorkbook OpenFromStream(Stream stream); to read in a file via a Stream. Does this read in the entire file immediately or is it possible to access values a row at a time?
NickL
  • 1,870
  • 2
  • 15
  • 35
0
votes
2 answers

RowHeight anomaly from Spreadsheetgear and Excel

I am working with Spreadsheetgear to make excel programmatically and I have a question related to row heights. I have this snippet code in C# cells[0, 0].ColumnWidth = totalColumnWidth; // recalculated column width after some formatting logic var x…
user1408865
  • 136
  • 1
  • 13
0
votes
1 answer

SpreadSheetGear cannot access series 3d Format

I can access the ISeries "fill" and "line" and then under those classes there is "format" which allows you to create gradients. However, in Excel itself the series format has "3D effect" section where you can set Shape Outline, Shape Preset to…
Dexter
  • 6,170
  • 18
  • 74
  • 101
0
votes
1 answer

Can I use SpreadsheetGear to read from a CSV file without it formatting the cells?

Given a simple CSV file that consists of a string of digit characters and a date in UK format: "00000000","01/01/2014" and code to get the used cells: IWorkbookSet workbookSet = SpreadsheetGear.Factory.GetWorkbookSet(); IWorkbook workbook =…
NickL
  • 1,870
  • 2
  • 15
  • 35
0
votes
1 answer

Spreadsheetgear tick mark position

I'm using spreadsheetgear 2012 to create Excel charts in the Visual Studio 2010 IDE. Can someone please help me figure out how to reposition the tick marks so they sit directly over the top of the tick label? In Excel, you'd do this by clicking…
user3496482
  • 1
0
votes
1 answer

SpreadsheetGear DataLabel Font Formatting

I am trying to create a single bold DataLabel on a chart using SpreadsheetGear. I can set the number to be Green using the code below: DataLabels(0).NumberFormat = "[Green]###,###,##0" But when I attempt to set a property of the Font nothing…
Joe
  • 3
  • 2
0
votes
1 answer

SpreadsheetGear range explorer Usage in Windows application

I am able to show the range explorer and also the numberformat category of it in my windows app using its default constructor, but really dont know how to retrieve the selected number format and pass it to the form's textbox. I am very new to…
nray
  • 5
  • 4
0
votes
1 answer

Load formulas and values to SpreadsheetGear UI

Is there a way to load formulas, values and maybe also cell formattings from a given datasource file, like an XML file or .xlsx file directly to SpreadsheetGear WorkbookView UI (WPF)? For example, I would create an .xlsx file which acts as a data…
Nuts
  • 2,755
  • 6
  • 33
  • 78
0
votes
1 answer

SpreadsheetGear formulas between WorkbookViews

I have 2 WorkbookViews: How to insert formulas to a Worksheet in wbw2 that refer to cells in a Worksheet in wbw1?
Nuts
  • 2,755
  • 6
  • 33
  • 78
0
votes
1 answer

SpreadsheetGear - check if IRange has values

How can I check if specific SpreadsheetGear IRange contains values (=Non-blank cells)? In Excel, I could utilize COUNTA function but there is no such in SpreadsheetGear.
Nuts
  • 2,755
  • 6
  • 33
  • 78
0
votes
1 answer

SpreadSheetGear - read unique values from Excel column

I want to read a column in Excel worksheet using SpreadSheetGear (.NET) and get unique values in that column back. Example: From the above Excel worksheet, I need to read column B and get back unique values "John" "Mike" and "Wayne" In real life,…
Nuts
  • 2,755
  • 6
  • 33
  • 78
0
votes
2 answers

How to determine if spreadsheetgear workbook is modified

I would like to confirm user before closing a workbook, that is has draft changes. Is there any way to check if workbook is dirty and has to be saved in order not to lose any data?
Vladimir Sachek
  • 1,126
  • 1
  • 7
  • 20
0
votes
1 answer

Unable to set number format

I want to put the number format for Peruvian Soles Spreadsheetgear gave me this format: "S/."#,##0_);("S/."#,##0) - but I don't know how to cast that string to put in: reportWorkbook.Worksheets[WSNombre].Cells[CPasoMOS].NumberFormat = "HERE"; I…
user2811845
  • 1
  • 1
0
votes
1 answer

Spreadsheetgear.IWorkbook/workbook object. How Do I retrieve the length of the workbok?

Development Platform: .NET 2.0 Platform: ASP.NET Spreadsheetgear: 2008 Language: C# Is there a way to retrieve the Length in bytes of a workbook without copying it/saving it to another object? I went through the documentation and several attempts…
einarabelc5
  • 1
  • 1
1 2 3
…
16 17