North American Sales: 1-800-231-8588
Global Contacts
My Account
Menu
North American Sales: 1-800-321-8588
My Account
Sign In/Register
Design & Development
Design & Develop
Best Value
Infragistics Ultimate
The complete toolkit for building high performing web, mobile and desktop apps.
Indigo.Design
Use a unified platform for visual design, UX prototyping, code generation and application development.
Web
Ignite UI for Angular
Ignite UI for JavaScript
Ignite UI for React
Ultimate UI for ASP.NET
Indigo.Design
Desktop
Ultimate UI for Windows Forms
Ultimate UI for WPF
Prototyping
Indigo.Design
Mobile
Ultimate UI for Xamarin
Ultimate UI for iOS
Ultimate UI for Android
Automated Testing Tools
Test Automation for Micro Focus UFT: Windows Forms
Test Automation for Micro Focus UFT: WPF
Test Automation for IBM RFT: Windows Forms
UX
Indigo.Design Desktop
Collaborative prototyping and remote usability testing for UX & usability professionals
Indigo.Design
A Unified Platform for Visual Design, UX Prototyping, Code Generation, and App Development
Business Intelligence
Reveal Embedded
Accelerate your time to market with powerful, beautiful dashboards into your apps
Reveal App
Empower everyone in your organization to use data to make smarter business decisions
Team Productivity
Learn & Support
Support
Help & Support Documents
Blogs
Forums
Product Ideas
Reference Applications
Customer Stories
Webinars
eBook & Whitepapers
Events
Free Trials
Pricing
Product Pricing / Buy Online
Renew Existing License
Contact Us
Forums
Ultimate UI for Windows Forms
CREATE NEW POST
Your Privacy Matters
: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use.
Cookie Policy
Close
Selected tags
Excel
Narrow your results
Excel Library
UltraGrid
Workbook
excel export
Excel Exporting
Excel WinGrid
Worksheet
Export to Excel
load
excel import
export
Excel export exporting format
excel formula cell
UltraGridExcelExporter
import to excel
CellFormat
Spreadsheet
excel export grid
Group By
named references
Documents
UltraChart
Comment Indicator
Excel export exporting format cell color bold
Frustration
Most Viewed
WinGrid Performance Guide
over 15 years ago
Multiple Summary Rows in single band
Answered
over 15 years ago
DateTimeEditor error with NetAdvantage 2009 1
Answered
over 15 years ago
Marquee UltraProgressBar
Answered
over 16 years ago
UltraGrid - ConditionAppearanceRow
Answered
over 16 years ago
Tags
More
Cancel
Descending
Ascending
1 - 15 of
55 results
for Ultimate UI for Windows Forms
Not Answered
670
views
1
reply
Does Infragistics support loading Excel Binary files (.xlsb format)?
I am getting an exception "The value of argument 'format' (-1) is invalid for Enum type 'WorkbookFormat'." from the following line of code. Workbook.Load("TestSheet.xlsb") DLL Name: Infragistics4...
Answered
2626
views
13
replies
UltraSpreadsheet Can this be used to retrieve values from entering the data
Trying to see if I use the UltraSpreadsheet to load a formatted Excel sheet to allow a user to add data. Then so I can use the values to insert into a SQL database. I don't care much for saving the data...
Answered
1895
views
5
replies
Document.Excel: how to control outlining after Export of data
Hello, using Infragistics 2016.1's Documents.Excel Reference, I managed to export data from a datatable to a new Excel file and to create outlining. Here's a code snippet: qryGroupHeadersOfCurrentPackage...
Answered
1141
views
3
replies
Formulas do not seem to match on row and columns
I think I may be miss-understanding the way in which formulas work... I have put together a very simple example of what I am trying to do int columnIndex = 1; int rowIndex = 1; decimal value1 = 10.2M;...
Not Answered
1522
views
3
replies
Performance of cell format setting in Infragistics.Documents.Excel.Workbook
Hi, We have some problems with setting the cell formatting on a rather large Excel workbook with multiple worksheets. We are creating a workbook to preview and export data from a model, and the model...
Answered
2344
views
6
replies
Excel Sorting Values With Multiple Decimals
I was wondering if there was a way to read and sort a worksheet with a key column that is formatted in the form of: 1.1 1.1.1 1.2 1.2.1 1.2.1.1 1.10.1.1 Where e.g. 1.10.1.1 should be after...
Not Answered
163
views
0
replies
Cannot load a particular excel worksheet
Hello everyone, I have a big excel files (with some worksheets) I only want to load a particular worksheet. Do you have any idea? Thank you. ------------------------------------------------...
Not Answered
2246
views
2
replies
InfragisticsWorksheetCell.GetText() throws exception for cell with custom format #/#### "SF"
Hello, I wanted to document an exception I am seeing when using the Excel library to read a specific custom cell format. If an Excel cell has the following: Value .001 Custom Format #/#### ...
Answered
5933
views
5
replies
Excel like comment indicator on Cells
Hi, we have requirement to display an Excel like comment corner marker on the ultragrid cells. I know there isn't a built in way and I need to use a draw filter or a creation filter but I am not sure...
Answered
5208
views
5
replies
Mimic Excel Graph
Hello all, I am trying to mimic the Excel graph shown so that the red lines between the 2nd and 3rd lines to show the spread. Is there anyway to do this in UltraChart? Also, I am trying to get the...
Not Answered
2414
views
1
reply
unable to use ' Workbook.Load()'.
Hi , I am using Infragistics2.Excel.v7.1. But still i am unable to use ' Workbook.Load()'. Please help me .I have to open a workbook by using infragisticExcel.
Answered
3939
views
4
replies
Excel Exporter issue, headers formatting
Hi! i've an issue, in the UltraGrid exporter, the headers are exported but without format, i mean, the border bottom, left, right and top, has not borders.. anyone knows, how can i set the format for...
Not Answered
2716
views
3
replies
Modify an Existing Table
I currently have an excel that has a defined Table "Employees" that contains 50 employees. I can get that data easily and process it but after that I want to update the table with additional employees...
Not Answered
3655
views
3
replies
Unable to apply Excel formula to Infragistics
I have a project, which needs to convert many excel spreadsheets to XML files. We are planning to import spreadsheets to Infragistics workbook. Our spereadsheets have many formulas each spreadsheet. Infragistics...
Not Answered
4859
views
6
replies
Parsing Files with Structured References
The following formula: "=SummaryTable[[#This Row],[SampleID]]&"_"&SummaryTable[[#This Row],[SeqNr]]" gives the following error: "The formula has extra expressions after the end of it. Portion...
Loading...
Load More