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

Enable expand/collapse buttons for Outlines/Groups on a protected worksheet in SpreadsheetGear

Is there a way to still toggle the expand/collapse buttons for Outlines/Groups in SpreadsheetGear even when the sheet has IWorksheet.ProtectContents set to true? Thanks.
Rachid Benbrik
  • 71
  • 1
  • 3
0
votes
1 answer

Spreadsheetgear - Add background color via conditional formatting

I'm trying to use conditional formatting to add a salmon background color when a cell's value exceeds a certain threshold. Here's my code: Dim condition As IFormatCondition = thisRow(0, 6).FormatConditions.Add(FormatConditionType.CellValue,…
TheIronCheek
  • 1,077
  • 2
  • 20
  • 50
0
votes
1 answer

How to Detect Missing Columns in SpreadsheetGear

Suppose I get a spreadsheet with columns D and E missing: A B C F G How can I detect that columns D and E are missing using SpreadsheetGear? I have SpreadsheetGear 2012. re: Can you be more specific about what "missing means"? When you start with a…
CoolBreeze
  • 381
  • 4
  • 14
0
votes
0 answers

Is there any way to specify the encoding UTF-8 in SpreadsheetGear to generate CSV files?

Below is my sample VB.Net code to generate CSV file but I don't find a way to specify UTF-8 encoding. Can anyone help me on this? Public Sub GenerateCsvFile(ByVal dt As DataTable, ByVal strFilePath As String) Dim workbook As…
VInayK
  • 1,501
  • 6
  • 34
  • 47
0
votes
1 answer

IRange.Copy throws InvalidOperationException for merged cells

I am using below method to copy value without formula from a range of excel to the same range (basically removing formula). This range has 7 cells but they are merged. void Copy(IRange destination, PasteType pasteType, PasteOperation pasteOperation,…
Viraj Sanghavi
  • 96
  • 5
0
votes
4 answers

Are there any third-party tools which allow importing XML data into Excel?

We are currently working on an application that has been using COM Interop in C# to import data into an Excel workbook. This data is fairly complex and lengthy, so we have been using the Import from XML feature in Excel. Because of the issues with…
xdhmoore
  • 8,935
  • 11
  • 47
  • 90
0
votes
1 answer

How to scroll to column in SpreadsheetGear WorkBookView control?

I have to proofread about 30-35 spreadsheets every week. I need to look at column W and the columns to the right of column W. When I initially display the spreadsheet I see columns A-P. I manually scroll over to column W and begin proofreading the…
CoolBreeze
  • 381
  • 4
  • 14
0
votes
1 answer

How to set text and background color in Spreadsheetgear?

In SpreadsheetGear 2012 I want to set: text color to white. background color of the cell to black. I've tried variations of: Sheet_Obj.Cells(0,0).Style.NumberFormat = "@" Sheet_Obj.Cells(0,0).Interior.Color =…
CoolBreeze
  • 381
  • 4
  • 14
0
votes
1 answer

SpreadsheetGear Format Conditions to a Cell

In my MVC project I'm using SpreadsheetGear to generate an excel document. I've got a column that has a validation rule against it that only allows the user to select from the following options: A,B,C,D. I need to be able to set different background…
Bad Dub
  • 1,503
  • 2
  • 22
  • 52
0
votes
0 answers

Redirect To Route After Response Flush

I'm using Spreadsheet Gear to generate and download an excel document to the clients browser. Using the code below the excel document downloads correctly but I need to browser to then redirect the user away from the current page. Where am I going…
Bad Dub
  • 1,503
  • 2
  • 22
  • 52
0
votes
1 answer

Is it possible to add table to excel using Spreadsheetgear - C# .NET (excel way is INSERT->Table)

Like the title says is it possible? I need a table in my exported excel sheet that will be used with data validation setting.
user2186527
  • 1
0
votes
2 answers

Optimised way for byte array to memory stream

I use the following lines of code byte[] byteInfo = workbook.SaveToMemory(FileFormat.OpenXMLWorkbookMacroEnabled); workStream.Write(byteInfo, 0, byteInfo.Length); workStream.Position = 0; return workStream; to download an excel file from the…
Leo
  • 136
  • 2
  • 2
  • 11
0
votes
1 answer

C# SpreadSheetGear : #NAME? as Text if formula is applied to cell

I am trying to get the text in a cell through spreadsheet gear library. There is a formula applied to a column C1 =GETURL(I2) and it is evaluating text which is something like "https://loremipsum.com/2345/view" I have another column C2 with a…
s7h
  • 51
  • 3
0
votes
1 answer

spreadsheetgear+how to display built in page setup dialog

I tried to select/display the builtin pagesetup dialog highlighting the pagesetup tab in 'spreadsheetgear workbook explorer' window. In the .exe provided by spreadsheetgear, it is shown but not in the sample code provided by them, can anyone from…
Rajendra K Karki
  • 1
0
votes
1 answer

Cannot access a closed file when saving the workbook

I'm trying to save a workbook with some data using SpreadsheetGear.Below is the code for that. public class ExcelExporter { public void Export(System.IO.Stream stream, IEnumerable readings) { using (stream) { …
Lakshitha
  • 128
  • 1
  • 13
1 2 3
…
16 17