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
3
votes
1 answer

Using SpreadsheetGear 2012 library in Dynamic CRM Online

I try making a Dynamic CRM Online Plugin that use SpreadsheetGear 2012 dll to process excel file attached as a record's annotation when an update is being done. However, after I register the plugin, I keep getting this: Could not load file or…
Anthony Steven
  • 118
  • 4
  • 27
3
votes
1 answer

Spreadsheet Gear and DateTime Formatting

I'm trying to display date in the format dd/MM/yyyy in an excel file with the Spreadsheet Gear library, but the system and office looks like running an english localization. I've already try to use the Cell.NumberFormat property and directly setting…
Emmanuel Istace
  • 1,209
  • 2
  • 14
  • 32
3
votes
1 answer

Spreadsheetgear chart x-axis text orientation

I am using Spreadsheetgear to create and modify charts. I can create a chart and modify the data easily, however, I cannot seem to modify the orientation of text the way that I want. The text lies on the x-axis and I am trying to get it to…
Null
  • 103
  • 9
3
votes
2 answers

Simple HLOOKUP Failing with Excel 2010

I have an Excel spreadsheet (generated by spreadsheet gear, but it's more an Excel problem) that isn't functioning as i would expect when I use HLOOKUPS. I use a simple HLOOKUP to look up the value at a given percent in a table. For two certain…
David J. Sokol
  • 3,456
  • 3
  • 31
  • 25
2
votes
1 answer

How to combine data and then separate concatenated data?

I would like to combine a range of data into one single cell G5. Then I want to split Value G5 into original form. Thank you so much. https://docs.google.com/spreadsheets/d/1sVrpPvtQPG0Zw2Ar_UxPHXNN0atEdQNX-hkyB2ixUGw/edit?usp=sharing
zongshita
  • 189
  • 1
  • 7
2
votes
2 answers

Adding images to excel header using spreadsheet gear?

I'm using the latest Spreadsheet Gear and C# on .NET 3.5 I'm generating a spreadsheet and adding various formatting to it. One thing I would like to do is add an image to the left header section of my spreadsheet for printing. How do I achieve…
jdylanmc
  • 829
  • 11
  • 24
2
votes
1 answer

Aspose or Spreadsheet gear

Among Aspose and spreadsheet gear which one is best when it comes to transferring data from database to excel and reading data in an excel sheet using C#, or is there any other better suggestion for it. This should also include applying conditional…
Sebastian
  • 27
  • 2
2
votes
1 answer

How to convert all date-formatted cells in IRange to DateTime using Spreadsheet Gear C#?

I'm trying to read the used range of an Excel file with Spreadsheet Gear and I've currently got it set up to do this: var workbook = Factory.GetWorkbookSet().Workbooks.OpenFromStream(fileStreamInput); var sheet = workbook.Worksheets[0]; var values =…
Casey Cummings
  • 53
  • 7
2
votes
1 answer

Returning SpreadsheetGear workbook stream from WebMethod

I would like to provide a web service that lets me download certain Excel workbooks. These Excel workbooks are SpreadsheetGear objects that may be modified with data. I don't want to write them as a file and return the file. Instead, I'd like to…
Somik Raha
  • 171
  • 1
  • 10
2
votes
0 answers

How to set strict date format "DD/MM/YYYY" using SpreadSheetGear 2012

I use spreadsheetgear 2012 version 7.0.5.140 and have problem with date column. The formatting of date after opening generated excel file depends on system culture settings and I would like to enforce date presentation to have specific format…
marcinn
  • 1,879
  • 2
  • 22
  • 46
2
votes
1 answer

Spreadsheetgear - How to set focus on first worksheet

I am working with spreadsheetgear to create excel sheet. I am able to add multiple worksheets. After I add more than 1 worksheet, the focus always remains on last worksheet. How can I set focus on first worksheet after adding multiple sheets.
SharpCoder
  • 18,279
  • 43
  • 153
  • 249
2
votes
3 answers

How to add a Data validation for a cell in excel using Spreadsheetgear - C# .NET

I would like to add a data validation for a cell in an excel to allow ONLY numeric values. My code does the following, SpreadSheetGearHelper hlpr = new SpreadSheetGearHelper(excelFilePath); cells =…
user1234
  • 97
  • 1
  • 9
2
votes
3 answers

Opening a protected workbook with spreadsheetgear

I'm trying to determine the best way to open a protected worksheet, if even possible. I've done a little research in spreadsheetgear's documentation and I haven't really been able to track down a solution yet. I've come across two options that I…
Dom Bavetta
  • 104
  • 2
  • 13
2
votes
1 answer

Import DateTime formated cell using Spreadsheetgear

I am using spreadsheetgear to read an existing Excel file and import the data into a SQL Server database. Everything works fine until I need to import a cell that is formatted as a date - "*3/14/2001". I am trying to import this field into a…
Craig
  • 1,205
  • 2
  • 21
  • 54
2
votes
1 answer

SpreadsheetGear SetArray of double when double.NaN is present

I have a simplified test scenario created where I have a spreadsheet with two cells (C2/C3) having an array formula: {=NaNTest()} My simplified CustomFunction is as follows: public class NaNTest : CustomFunctions.Function { public NaNTest() :…
Terry
  • 2,148
  • 2
  • 32
  • 53
1
2
3
…
16 17