spreadsheetgear - Developer IT

Adding filter to Excel sheet columns using SpreadsheetGear?

- by Avinash

How to add filter to excel work sheet columns using SpreadsheetGear?

How can I modify SpreadSheetGear's PrintPreview window (.NET)?

Spreadsheetgear provides ability to create PrintPreview window - using WorkbookView.PrintPreview(). But it seems impossible to modify that window. That function returns void and there are no properties to control the visual content of that window. Please, say me I'm wrong.... Have I missed something?

Read the article

Data validation in excel cell using SpreadSheetGear.

- by Avinash

Hey How to validate integer and float in excel using spreadsheet gear. Thanks in Advance Avinash

Read the article

Hiding cell Contains in MS Excel using SpreadSheetGear?

- by Avinash

Hey any body know how to hide cell contains using spreadsheet gear.

Read the article

Hidind cell Contains in MS Excel using SpreadSheetGear?

- by avinash-nitk

Hey any body know how to hide cell contains using spreadsheet gear.

Read the article

Spreadsheet component with VBA support

- by Renaud Bompuis

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 calculations, well, these don't work. So, apart from Excel itself, are there any other components that can execute VBA?

Read the article

Globalize/Localize Excel Reports Using Spreadsheet

- by mga911

My company has new customers in Brazil and we realized that our excel reports are not working when our Brazilian customers tried to open the reports in their Brazilian versions of excel. For excel output we use spreadsheet gear in our vb.net web application. Our excel worksheets are fairly simple. Mostly outputted text/numbers/dates, a couple of formulas (sum, if) and formatting on the currency and dates. I've tried several methods to get my excel reports to work: First I left the excel workbook in the "en-US" culture and tried simply chaging the number format for Brazil to: _-[$R$-416] * #.##0,00_-;-[$R$-416] * #.##0,00_-;_-[$R$-416] * "-"??_-;_-@_- And this formatted the regular cells but the formulas still failed to show a value. Instead they showed a 0 value. Next I tried changing the workbook to the "pt-BR" culture and that also forced me to translate the formula names (Sum - Soma, If - Se) but they still wouldn't should a value and instead showed a #Name/#Nome error. Interestingly enough the formulas would work if I edited the cell and hit enter. The formula wouldn't change but it would some how fix that cell. I need to be able to out excel reports that can format dates/currencies and apply simple formulas (IF, Sum) for other excel cultures. Anyone have any advice?

Read the article

Parcing formula to put in to excel cell using C# and SpreadSheetGear?

- by Avinash

Hey can any body suggest that how to store excel formula as string, and parse this formula in c# to put it in to dynamically created excel sheet.

Read the article

Excel password removal

- by nkcooke

We receive Excel workbook files every day which are password protected with the same password. We know this password. Is there a utility or method to remove password protection on these workbook files without invoking Excel.exe or the Excel object. Our goal is to take Excel out of the process and utilize SpreadsheetGear in VB.net. However, SpreadsheetGear can only unprotect worksheets not workbooks. Thanks

Read the article

.NET Excel File Parser

- by Russak

So the company I'm working for is looking for a means to verify that a given .xls/.xlsx file is valid. Which means checking columns and rows and other data. He's having me evaluate GrapeCity Spread and SpreadsheetGear, but I'm wondering if anyone else has any other suggestions of external tools to check out. We don't need a means to export .xls files or anything like that, just the ability to import them and verify they are valid based on a set of criteria I create. Thanks.

Developer IT