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

Spreadsheet component with VBA support

I am looking for a .Net spreadsheet component that could also execute the VBA contained in Excel files. I found Spreadsheet Gears to be very nice for manipulating and allowing the user to edit Excel files, but on spreadsheets that use VBA for…
Renaud Bompuis
  • 16,596
  • 4
  • 56
  • 86
2
votes
2 answers

Colour applying to all cells

I am trying to apply colours to certain cells in a spreadsheet generated by Spreadsheet Gear. My current code var workbook = Factory.GetWorkbook(); var worksheet = workbook.Worksheets["Sheet1"]; // Set the new worksheet name …
Sean Forman
  • 400
  • 4
  • 16
2
votes
1 answer

Protecting Excel work book using SpreadsheetGear in C#

What is best possible way to protect Excel work book(read only) and work sheets without using password using SpreadsheetGear dll in c#?
Avinash
  • 173
  • 1
  • 4
  • 17
2
votes
1 answer

Guid in Excel Using SpreadSheetGear

I just need a confirmation/quick info. I feel it's an obvious question but just want to make sure and fully understand what's happening. Couldn't find much detail on the web. I'm using SpreadSheetGear to dump data in spreadsheets from a datatable.…
mathieu.blais06
  • 55
  • 11
2
votes
2 answers

Print excel (generated using Spreadsheetgear) in C#

In c# i am generating an excel in specific format, i have to print the same excel format on click_print. P.s.-Microsoft Office not available,using SpreadSheetGear for this.
Dark Knight
  • 125
  • 2
  • 10
2
votes
1 answer

Protect Excel worksheet while keeping autofilter, using Spreadsheet gear

Would anyone know how to use protect an Excel worksheet while still allowing the use of the Autofilter? Normally it's straightforward, but in the current implementation of the project I'm working on, it has to be done using the Spreadsheetgear…
user1158959
  • 101
  • 1
  • 8
2
votes
0 answers

Is there a way to find out whether an excel 2007/2010 file is password protected using SpreadSheetGear 2012 for C# Asp.net MVC?

Right now we use the exception message to trigger a message dialog when the excel file is password protected, but I was wondering if there is a better way to handle this. We just want to check if the supplied excel file is password protected, not…
Rahul
  • 23
  • 4
2
votes
1 answer

SpreadsheetGear throwing IndexOutOfRangeException inside constructor

We currently use SpreadsheetGear in one of our applications for generating Excel workbooks. I'm trying to reuse some of that functionality in an ASP.NET web application, but so far I'm stumped. I started off by referencing our existing library in…
ChrisPatrick
  • 984
  • 7
  • 19
2
votes
2 answers

Spreadsheetgear - get string representation of a range of cells

I recently started using SpreadsheetGear to parse an Excel file. I needed to go through each row and display the string representation of the first 6 columns. What I did was this: Debug.Print(ssgSheet.Cells(i,0).Text) …
nooblar
  • 399
  • 1
  • 5
  • 12
2
votes
1 answer

Auto filter spreadsheet gear

I have an auto filter set on a range of cells in excel, however i want to be able to choose the drop down criteria too. //Autofilter Cells IRange fundfilter = prodworkbook.Worksheets["Funds"].Cells["A4:L2000"]; fundfilter.AutoFilter(); The auto…
Marc Howard
  • 395
  • 2
  • 6
  • 25
2
votes
2 answers

How to Find ColumnPostion by Text in SpreadsheetGear?

How to find Column Position from Header by using text in Spreadsheet Gear? i.e want to find Remark Text ColumnPosition From SpreadSheet.
Jankya
  • 966
  • 2
  • 12
  • 34
2
votes
1 answer

Spreadsheet Gear returning Empty cells

I've created a program that returns specific columns from an Excel File through Spreadsheet Gear. Here is my While Loop: while (Worksheet.Cells[ExcelRow, 1].Value != null) { //to do code here } When null, my code returns empty cells…
Ricalyn Haboc
  • 75
  • 12
2
votes
1 answer

How to write query to retrieve all columns and distinct for one column?

Here I am using c# code for retrieving the data from the database to spreadsheet when I am writing the query (SqlCommand) to retrieve all columns and distinct for one column it's showing error that Cannot set Column 'date' to be null. Please use…
user123
  • 820
  • 3
  • 14
  • 34
2
votes
1 answer

SpreadsheetGear Range Formula

I am using the Formula property of the Spreadsheet gear but the calculation is not coming. Below is my code "SpreadsheetGear.IRange range = WorkBookViewForData.ActiveWorksheet.Cells["E19"]; range.Font.Name = "MS Gothic"; range.Formula =…
Jankya
  • 966
  • 2
  • 12
  • 34
2
votes
1 answer

Store metadata for a spreadsheetgear cell

Is there a way to store custom metadata for a Cell using the SpreadsheetGear control? I need the metadata to persist when saved to an XLSX file. (I am wanting to store some data binding information which is basically an arbitrary string). I could…
BrokeMyLegBiking
  • 5,898
  • 14
  • 51
  • 66
1 2
3
…
16 17