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

Having trouble getting color scale conditional formatting from Excel file to show up in embedded spreadsheet in Windows Form

I have a Windows Form that currently displays a spreadsheet that is editable. I have functionality to allow the user to browse for an Excel file to import to the spreadsheet in the Form view. It is important that an Excel file with a Color Scale…
Jake Smith
  • 2,332
  • 1
  • 30
  • 68
0
votes
1 answer

Spreadsheetgear - how to control tab bar

When I create a workbook in Spreadsheetgear with multiple worksheets, save it to a file, and open it - the tab bar displays only the last sheet added. I have to click on the tab bar navigation arrows to get all 4 of the tabs to display. Does…
Mark Hansen
  • 1,044
  • 10
  • 15
0
votes
1 answer

How to define the borders for an entire column with spreadsheetgear?

I know how to define the style of the border for a Cell, like that for example: Dim border As SpreadsheetGear.IBorder border = sheet.Cells(1, column).Borders(SpreadsheetGear.BordersIndex.EdgeRight) border.Color =…
Samuel Rossille
  • 18,940
  • 18
  • 62
  • 90
-1
votes
2 answers

dynamically generate the headers in excel using spreadsheet gear

Example: Let say A,B,C are columns and 1,2,3 are rows in a sheet.For A column 1,2,3 rows need to merge display as single rows how using spreadsheet gear A B C 1 2 3
kumar
  • 1,117
  • 13
  • 34
  • 58
-1
votes
1 answer

Save Excel file

I have a problem, because I am trying to save and excel Workbook in a determinate file path. I am using Universal windows and SpreadsheetGear to create the excel. I know to open the excel project but i dont know to save it :( Somebody knows to save…
ProgramacionFJ
  • 1
-1
votes
1 answer

Formula One (Tidestone) question

At work we're stuck with using Formula One Excel components. The problem is that I can't find anywhere to post questions so I thought I try here. What I'm trying to achieve is reading workbooks into sheets. I have multiple vts workbooks that consist…
duraid
  • 614
  • 7
  • 16
-1
votes
1 answer

Reinstall SpreadsheetGear on new server

We use SpreadsheetGear with c# scripts. Currently it's installed on Windows 2008 R2. We need to move it to another server running Windows 2016. How do I go about the installation so that our scripts keep running without interruption. Thank you.
Techie
  • 3
  • 1
-1
votes
1 answer

Place .net control on the sheet

I am using spreadsheetgear, and I want to place the combobox (ComponentOne) into 1 cell. I want that when the user go to this cell, this combobox will activate and show the list to user. After user chose item on the list, it will place this item…
Duyet Le
  • 1
  • 1
-1
votes
1 answer

Merging rows into single using spreadsheet gear while exporting to Excel

I have to merge the rows of excel using spreadsheet gear controls is it possible. Only specific rows of single column All detail is being included in this screencast The changes that has been done by me is DataTable dt =…
Sanjay Chaudhary
  • 9
  • 7
-1
votes
1 answer

reading excel data

How to read Excel data having Number format ;;; ie hidden value in C# using spreadsheet gear.
Avinash
  • 173
  • 1
  • 4
  • 17
-1
votes
2 answers

SpreadSheetGear - How to convert thousand separator with decimal and decimal seperator with comma?

I've failed to find the NumberFormat to convert the thousand separator with decimal to decimal separator with comma. Worksheet.Range(NumberRange).NumberFormat = "#.##0,00" This is not working for me. Please help. Thanks
Ramesh
  • 13
  • 6
-2
votes
1 answer

How do you create a checkbox using Spreadsheet Gear in C#?

I need to add a checkbox in Excel using Spreadsheet gear. The documentation for Spreadsheet Gear is terrible and doesn't include any methods or info on how to initialize these properly. How do you: Create the checkbox object using correct…
William Faulkner
  • 1
  • 1
-2
votes
1 answer

Spreadsheetgear in parallel

I am trying to generate an excel file using spreadsheetgear, along with Parallel.ForEach, for writing in cells and I get sometimes, null reference exception. Is there any setup that I need to do, or config?
George Barbulescu
  • 131
  • 1
  • 8
-4
votes
1 answer

FormatNumber replace Decimal with Comma using SpreadsheetGear dll

I want to apply Format Number to a Excel Cell from VB.net using SpreadsheetGear dll as below This number 2,22,222.00 needs to convert to 2.22.222,00 My work: worksheet.Range(NumberRange).NumberFormat = "[=0]0;###,###.00" I am applying this format…
Ramesh
  • 13
  • 6
1 2 3
…
16
17