Hi Duane,

thank you for example, but I am working with LightSwitch and I do not know how to add the Infragistics reference to LightSwitch project.

Libor

Hi Duane,

I am not able to create export to excel in LightSwitch project.

Do you have any example (in LightSwitch project) where it si shown how to export data from Infragistics grid to excel in LightSwitch? It would help.

Thank you

Libor

For exporting to excel in Silverlight Class Library I have attached a sample.

Thank you for example.

Maybe I explained it correctly, but I need to export data directly from Infragistics Grid in LighSwitch which is part of the project. This means that I have more LightSwitch forms (screens) and each form using Infragistics grid (in screen designer I have selected Infragistics Grid instead of Data Grid). 

Then I have the button (on the screen) to which I assign the following code:

partial void ExportToExcel_Execute()
        {
            SaveFileDialog saveDialog = new SaveFileDialog();
            saveDialog.DefaultExt = "xlsx";
            saveDialog.Filter = "Excel Workbook (.xlsx)|*.xlsx";

            if (saveDialog.ShowDialog().Value)
            {
                try
                {
                    // Create a Workbook object with one Worksheet
                    Infragistics.Documents.Excel.Workbook workbook = new Infragistics.Documents.Excel.Workbook();
                    Infragistics.Documents.Excel.Worksheet worksheet = workbook.Worksheets.Add("sheet1");
                    workbook.SetCurrentFormat(WorkbookFormat.Excel2007);

                    // Export the xamGrid data to the Workbook object
                   
                    excelExporter.Export(dataGrid, workbook);

                    Stream stream = saveDialog.OpenFile();

                    // Save the file using the Save method of the Workbook object.
                    workbook.Save(stream);
                    stream.Close();
                }
                catch (Exception exc)
                {
                    MessageBox.Show(exc.Message);
                }
            }

        }

My questions are as follows:

=====================
- Is my assumption correct? Can I use this code directly in LightSwitch project without having to refer to any external control (user control with Infragistics Grid inside)? In your attached example you have spatial usercontrol on LightSwitch screen but I would like to have direct reference to Infragistics grid object.

- Which Infragistics library, and where (I assume that the client's project) I have to reference in the project?

- How do I refer to the DataGrid object in this line of code in LightSwitch project? excelExporter.Export (DataGrid, workbook)

Thank you

Libor

Hello Duane,

first of all, thank you for support.

The conclusion is: "Infragistics grid component for LightSwitch" application does not offer the ability to export data to MS Excel, either directly (in the designer) or indirectly by using code.

Did I understand it correctly?

Libor