Browse By Tags

  • Load Excel and CSV file

    Hi,

     I want to load Excel(.xls) and CSV file in Silverlight environment.  I have able to load Excel(.xls) file using Infragistics.Excel but CSV is throwing some Format Exception. Could you please providate a sample application showing loading of both Excel…

  • Export to Predefined Excel with multiple headers

    Hi,

    I Have a very complex predefined Excel template. It is having multiple column headers like main headers and sub headers.  But I need to do is export the data from xamgrid to the predefined excel template. 
    The problem is some columns are hidden and…

  • Alternate Color for Excel row using Infragistics Excel is not working


    In My Silverlight application I have created the excel spreadsheet using Infragistics Excel for Export functionality.
    But when I apply the alternate colors is to row is not working. Could you please let me know the steps to achieve this.

    My Code snippet…

  • Currency format In excel column using Infragistics Excel

    Hi ,

    In our application I am using Infragistics.Excel to export the file. But I am not able to apply the Currency format for numeic values.  Please how can i specify the currency format.

    Ex:- 10,235.00 Ex: 0

    Could you please respond soon will be appreciable…

  • Image is not exported to excel using Infragistic Excel

    In my Silverlight application we have to update the data to Predefined excel template and then export the data.
    But our predefined template is having company logo. Which is not appearing in excel when we export the file.

    Steps to achieve  the Export in Silverlight…

  • Want ot set RowHeight of the Excel row.

    Hi,

    I want to set the Row height of the Excel row to some specifc defined value. I have used the below source code. But It didn't work.

        string resourceFile = report.ExportTemplateFilename;
                    StreamResourceInfo sr1 = Application.GetResourceStream…

  • Set Print Area Using Infragistics.Excel

    Hi,

    Is it possible to set the Print Area using the Infragistics.Excel?

    If possible please send me the piece of code.It will be great helpful to me.

    I will appreciate if you Could respond immediately because its immediate requirement to go production…

  • Not creating the excel file for large Datatable throwing error

    Hi,

    I am using INfragistic EXCel to create a Excel file in server folder[Service layer]. It creates a file only if datatable has very few records.
    if dataTable has more records than it throws a Exception "Stream does not support reading". Please let me…

  • Problem with CreateNewWorksheetCellFormat Method

    Hi,

    When I try to create a new CellFormat with the instruction (dataworkbook is a Workbook object) : IWorksheetCellFormat objCellFormat = dataWorkbook.CreateNewWorksheetCellFormat();

    I've got this error : NullReferenceException was unhandled by user…

  • WorkBook Load Issue - Need help

    Hi,

    I worked in the "Importing from Excel" functionality, it is working fine with following code provided we need to set the Properties of the excel file to "Build Actions = Embedded Resource".

     string   resourceName = "ExcelWebGrid…