Browse By Tags

Hello,

I want to export huge data like >10lakh rows (>1crore values). I am not able to fetch this type of data through any API as there are memory constraints for any backend language that is around (10lakh values). How can I download excel values directly…

Hi

I want a small clarification on one of the use case related to Excel Library. (https://www.infragistics.com/products/ignite-ui-react/react/components/excel-library)

We have added GroupDescription and SummaryDescription on the grid.  We want to know how…

Hi

I want a small clarification on one of the use case related to Excel Library. (https://www.infragistics.com/products/ignite-ui-react/react/components/excel-library-using-worksheets)

I want to know how can I align the cell value to center

Hoping…

Hi

I want a small clarification on one of the use case related to Excel Library. 

I want to know how we can Add the GroupedRows functionality for Row, Which we can expand by clicking on + icon.

So, for this I need to know how can we achieve that.

Hoping for…

Hello,

I'm trying to load files into this library via ExcelUtility.load(file), where `file` is an xlsx file.

The application crashes and the following error occurs:

CachedLoadPackagePart.ts:39 Uncaught TypeError: Cannot read properties of null (reading…

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.Documents.Excel.v19…

I want setting page setup in excel "Adjust to ... % normal size" and "fit to ... page(s) wide by ... tall"

Hello, again we have trouble with a generated xlsx file. I already contacted the manufacturer of the component used for generation. According to them the file is fine.
When i open the attached file in excel the result is okay. But when i open it with igSpreadsheet…

Hello,

unfortunatly we're running again into issues with the spreadsheet component. We tested this with our app and your example (https://www.igniteui.com/spreadsheet/loading-data) as well.

When opening an existing xlsx-File the images in that File…

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                 #/#### "SF"
• Excel displays                  1/1000 SF

Then reading…

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…

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.  I can write the data to the correct rows…

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…

I am using Infragistics4.Documents.Excel.v11.2 to create an excel spreadsheet.  I am able to load all of the data correctly.  I then go to format the sheet and set the font.  Using this code:

'Sheet is already populated

Dim sheet As Worksheet

For…

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 every header?..

Thanks in advance,

Alfredo Melo :…

Hi all, I'm fairly new to Infragistics.Excel, so maybe I'm missing something.

I am wanting to load in the first 25 rows of an Excel spreadsheet in order to gain a hueristic understanding of the rest of the data, and display something meaningful…

Hey All,

I'm attempting to set the font for the entire workbook to a monospace font (like Courier for instance) and I'm not quite sure how. I'm using the Infragistics3.Excel.v8.3.dll from the NetAdvantage for .NET 2008 Vol. 3 CLR 2.0 set of libraries…

Hi,

 we r using infragistics excel library for importing data from excel to the ultragrid. When we use VLOOKUP functionality in the cell

 (IFERROR(VLOOKUP(H4,Sheet1!B3:D43,3,),0) 

it fails with "#NAME?".  i have seen other posts where ppl reported…

Hi,

I am new to using  Infragistics.Excel

can anyone explain me with a example using named references ?

I tried searching, i could get very limited information.

TIA

Regards,

Vishnu

If the workbook is in use by excel, I've got an IO.Exception. However I just need to read it. Is there a way to load it for readonly?

Hello,

I would like to know if it is possible to read the value/target of a cell with an hyperlink object ?

The hyperlink object (for me), in not a formula (so i don't read the property Formula to get the info).

Example : it's not  "=HYPERLINK…

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 workbook can not evaluate formula to get…

Using Infragistics3.Excel.v9.1 hotfix 2094, .NET 4.0

I am writing a spreadsheet that can exceed the Excel 2003 limit of 65536. The workbook is set to WorkbookFormat.Excel2007. It has some formulas in it, written like this:

var netDueFormula = Formula.

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 with error: [[#This…