Browse By Tags

Hi,

We are currently using Winforms NetAdvantage 8.2.20082.2204 and our solution targets the 3.5 version of the .NET framework. We need to export to excel version 2007 since we are hitting the 64k row limit.

The problem is, since this is a CAB module…

Hi,

I'm trying to open an excel file with external references, modify some cells and then save as a new file on disk. When doing this, formulas with external references get modified with a bad path/filename.

You'll see attached a sample project…

Hi,

I am trying to change the color of a font when creating a worksheet and am using the command

cell(x).cellformat.font.color = color.red, which results in a warning but seems to work.

Warning 2 'Public Property Color As System.Drawing.Color' is obsolete…

Recently I began seeing corrupted excel files coming from a production grid exports.  When attempting to open the file you are greeted with everyone's favorite error:

"Excel found unreadable content in '<filename>.xlsx'. Do you want to recover the…

Hello,

I wanna export a winGrid in a extern excelTemplate, is that possible?

In other words: I have an excelSheet with a layout(report) and I want my winGrid in the center of my excelLayout...

Hello,

I need to export data from a grid to excel. I did this several times, but this time the template file has a pivot table in the second worksheet. I export data to the first worksheet, and the pivot table should use this data in the second worksheet…

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:

----------------------------------------------------------------…

Hi!

I have a process which uses the Excel object to create worksheets in a workbook. (I'm using Infragistics v.8.1).  I created the data in the worksheets from a DataTable.  I tried exporting the data 2 ways.  The first way I manually exported the data…

Hi,

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…

Just wondering how to open excel sheet or workbook genrated by the gridexcel exporter, I only see the option to save the grid contents to local disk. I want to be able to open the excel on the fly without saving it.

Thanks,

Hi,

I'm exporting my ultragrid manually and everything works great, but how can  I change the datatype of the targetcells in excel, so dates are datetime and numbers numbers?

 regards,

Gabriel 

I'm using the Infragistics.Excel namespace in order to create an excel workbook with the information I have on a Ultragrid grid. I can't use the Exporter you have because of some special look & feel the users need on the exported sheets.

Hi,

I have a grid with a cell value of double.NaN, showing as "n. def" (german locale). Thats correct and works as expected.

Now I export this grid to excel, and I would expect a result of  #NV (e.g. also shown when you add a formula =NV()…

Hello,

I created an Excel file with the following code:

 Workbook exportWorkbook = new Workbook();

Worksheet exportWorksheet=exportWorkbook.Worksheets.Add("Export");

Hi all,

 Is there any way to customize the Excel header or footer when exporting a grid?  To have, for example, a title on the sheet, or your company name with Confidential in the footer.

 TIA!

I modified the ultrawingrid using a drawfilter and added functionality to add comments to the cells similar as in Excel. Now I want to export this grid to an Excel file, for the data this is no problem, but how can I associate comments to the cells in…

Hi All,

 Is there a way that we can set AutoFilter options for a Worksheet ? I am trying to export a datatable to a Worksheet and set the first row to have AutoFilter.

Dear Team,

Could you please tell me about any suitable control available in our libraray to export the whole page (.aspx) in Excel as it is? I want to export the complete page to excel not only specific part of page like Grid etc.

I attached…

I can't find a way of programatically setting a header row to repeat on every printed page?  This seams to be a missing feature of the Excel's PrintOptions class, or am I missing something?  I'm using version 2008 vol 2.

I want try this sub from 

http://forums.infragistics.com/forums/t/19898.aspx 

protected void ExportToExcel(object sender, EventArgs e)
    {
        Infragistics.Excel.Workbook workbook = new Infragistics.Excel.Workbook();
        workbook.Worksheets.Add("Sheet1…

Good morning.

I have a simple, but a big problem.
We have a project that use the Infragistcs V6.2 and we are using the Excell classes to export a simple GridView to a .xls file.

However, the problem is that we need to mix diferent font colors (black 

Running the following code will not protect my worksheet. Am I doing something wrong or is this a bug?

Dim ms As New MemoryStream()
Dim wb as new Workbook()

wb.SetCurrentFormat(WorkbookFormat.Excel2007)
wb.Worksheets.Add("TEST WORKSHEET")
wb…

I'm exporting data from a 'Grouped by' grid into Excel.
When I open Excel, the GroupedBy columns are shown as in the grid, with the '+' .
But I would like to know if it  is possible to show the data in Excel fully expanded automatically…

Hi

Urgent help would be appreciated.

I am using Infragistics.excel to export the data to Excel 2003. While exporting 85000 records from a

 datatable I am getting following exception:

Exception of type 'System.OutOfMemoryException' was thrown at Infragistics…

Hi all

My Excel.Export version is"Infragistics2.WebUI.UltraWebGrid.ExcelExport.v8.3, Version=8.3.20083.2039"

It kindly asked for a reference to "Infragistics2.Excel.v8.3, Version=8.3.20083.2068"

As you can see the versions don't…