Stefaniya,

That worked fine.

Thanks, Konstantinos.

Hi,

 The reason for this exception is that you close the memory stream. You could try the following which will allow you to use Jpeg format with memory stream:

            Infragistics.Excel.Workbook MyWorkbook = new Infragistics.Excel.Workbook(Infragistics.Excel.WorkbookFormat.Excel97To2003);

            Infragistics.Excel.Worksheet ChartWorksheet = MyWorkbook.Worksheets.Add("Sheet1");

            using (MemoryStream MemStream = new MemoryStream())

            {

                ultraChart1.SaveTo(MemStream, System.Drawing.Imaging.ImageFormat.Jpeg);

                MemStream.Flush();

                Image ChartImage = Image.FromStream(MemStream); 

                WorksheetImage ChartShape = new WorksheetImage(ChartImage);

                ChartShape.TopLeftCornerCell = ChartWorksheet.Rows[0].Cells[0];

                ChartShape.TopLeftCornerPosition = new PointF(0.0f, 0.0f);

                ChartShape.BottomRightCornerCell = ChartWorksheet.Rows[30].Cells[30];

                ChartShape.BottomRightCornerPosition = new PointF(100.0f, 100.0f);

                ChartWorksheet.Shapes.Add(ChartShape);

                MyWorkbook.Save("test.xls");

            }

Let me know if this works for you.

Regards,

Stefaniya

No, this did not work, same exception.
What I found out though is that when I export the chart with a Png image format by calling:
MyChart.SaveTo(MemStream, System.Drawing.Imaging.ImageFormat.Png);
instead of
MyChart.SaveTo(MemStream, System.Drawing.Imaging.ImageFormat.Jpeg); 
the export succeeds.

Actually the Png image format is the only one that succeeds. Maybe this has something to do with the image having transparent items like legends ect.