Hi All ,
I am reaching out to address a critical issue that we are currently facing while utilizing the export method within your software library.
Our team has been using the export functionality to export sizable data sets, and we recently encountered…
We are using NetAdvantage 10.2 CLR2x (build 10.2.10201.1004) and have an UltraGrid displaying data in a usercontrol that is in a dock pane using an UltraWinDock.UltraDockManager
We added a right-click content menu to export the grid to Excel and PDF.
I am currently working on trying to figure out why Custom formatting gets lost when exporting to excel. We use the following formatting:
aBand.Columns[OrderKeys.ContractValue].Format = "C";aBand.Columns[OrderKeys.CancelDate].Format = "MM/dd/yyyy…
Hello,
I am trying to export a grid to excel. It works fine with a flat grid (even only selected lines), or when I export the whole grid.
When I sort the grid by more than one column, and I select a group which is under another group, I have a problem…
I'm using the UltraGridExporter and works great. But I want to start exporting on the Third row of the worksheet. I've seen code for the ExcelStartRow but that appears to be for the WebGrid. It doesn't show up as an option for me. How can I export starting…
Is there anyway after I have exported my grid, and before I save it to insert a new row at the top of the worksheet that has a long description of what my grid is about? I am using 8.3 about to upgrade to 9.2, but have still not found a way to do this…
I have a Ultragir with information and I used a UltraGridExcelExporter to export the grid to a excel and the result of the export is this:
Is there any way to tell the UltraGridExcelExporter to insert text in excel and then after this text the UltraGridExcelExporter…
Hi,
I'm getting an exception for halving a string more than 32767 characters when exporting my data from UltraGrid to Excel. To handle this I am creating another worksheet and setting the value on the new worksheet and breaking up into multiple cells…
I am using UltraGridExcelExporter Export method to data from UltraGrid to Excel. During the export, I am receiving an exception for trying to set a string value with more than 32767 characters into a cell. My work around is to intercept this exception…
is there a way to export multiple grids to the same excel spreadsheet using the ultragridexcelexporter?
Dim uWorkBook As WorkBook = Nothing
Dim sTempFileName As String = "krish.xls"
If uWorkBook Is Nothing Then
If My.Computer.FileSystem.FileExists(sTempFileName) Then
My.Computer.FileSystem.DeleteFile(sTempFileName)
End If
uWorkBook = mExcelExp…
hi,
I am using VS 2010 prof. and Infragistics2.Excel V 10. I am able to export the ultragrid rows and column (including headers) to excel 2003. But i am unable to export the ultragrid rows and columns to excel 2007 (.xslx). I am getting error as IPacageFactory…
Infragistics Version 2011.1
Winforms application built in VS 2010
I have a screen in which the end users can build a query and then the results go to an ultrawingrid. If the users chooses...they can export the grid to Excel using the ultragridexcelexporter…
Hi People,
I'm using UltraGridExcelExporter to export a grid to excel. I give two arguments to it, the Grid and the location, Is there a way to let the user select the location to export the grid? I'm expecting something like the SaveFileDialog in Windows…
I have a table in database with one integer and one varchar column and in both I'm storing number values. while I'm displaying the same in grid I'm getting integer as string type. so while exporting the same to excel sheet(using ultraGridExcelExporter…
I have built a bound grid that has a column called [SALES] and there is a summary with a Key called [TotalSales]
I added an unbound column called [PerOfSales] that uses the following calculation with CalcManager
[SALES] / [TotalSales()] and is formated…
I using the UltraGridExcelExporter to export gird to excel ,but when print the worksheet exported ,the default pagesize is always Letter.While I export with Microsoft.Office.Interop.Excel.Application ,default pagesize is A4.
So,Is there any way to…
how to export data from a ultragrid to an Excel file using UltraGridExcelExporter ???
Thanks
Specifically, I want to export data, with its numeric formatting intact into a new excel spreadsheet. All works fine, however the number formats(#,##0 and $#,##0.00) defined in the WinGrid designer are only exported in the column grand totals. How…
I am using Visual Studio 2010 Prof and Infragistic2.Excel V10.1. I am able to export the ultragrid rows and columns with Column Headers to Excel perfectly (without grouping the columns in ultraGrid). But when the columns are grouped in UltraGrid,…
can someone help me to make the follow:
I 've a grid with data
I want export these to an excelSheet..
But this excelSheet should have a reportHeader and a reportFooter like:
logo date
info clientinfo clientinfo client
gridData gridData gridD…
Can the ultraGridExcelExporter export two grids in the same excel file ?
Hi, I'm trying to export to one excel document some data in a DataTable using Infragistics.Excel, and I would like to export some formulas (for example for the summaries..).
Example:
----------------------------------------------------------------…
I wrote the following code:
Private Sub UltraGridExcelExporter1_CellExporting(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.ExcelExport.CellExportingEventArgs) Handles UltraGridExcelExporter1.CellExporting With e.CurrentWorksheet…