导出excel

Question

silverlight如何将图片到处成excel中

Answer 1

sl在处理图片加裁时，用的是什么方法？可以从这里入手吧

---

okokwukai

Answer 2

           SaveFileDialog sfd = new SaveFileDialog();
                sfd.FilterIndex = 1;

                if (sfd.ShowDialog() == true)
                {
                    using (Stream stream = sfd.OpenFile())
                    {
                        Save(bitmap, stream);
                    }
                }

 

    private void SaveToFile(WriteableBitmap bitmap, Stream fs)
        {

           
            int width = bitmap.PixelWidth;
            int height = bitmap.PixelHeight;
            int bands = 3;
            byte[][,] raster = new byte[bands][,];

            for (int i = 0; i < bands; i++)
            {
                raster[i] = new byte[width, height];
            }

            for (int row = 0; row < height; row++)
            {
                for (int column = 0; column < width; column++)
                {
                    int pixel = bitmap.Pixels[width * row + column];
                    raster[0][column, row] = (byte)(pixel >> 16);
                    raster[1][column, row] = (byte)(pixel >> 8);
                    raster[2][column, row] = (byte)pixel;
                }

            }

            FluxJpeg.Core.ColorModel model = new FluxJpeg.Core.ColorModel { colorspace = FluxJpeg.Core.ColorSpace.RGB };
            FluxJpeg.Core.Image img = new FluxJpeg.Core.Image(model, raster);

           
            //Encode the Image as a JPEG
            MemoryStream stream = new MemoryStream();
            FluxJpeg.Core.Encoder.JpegEncoder encoder = new FluxJpeg.Core.Encoder.JpegEncoder(img, 100, stream);
            encoder.Encode();

       
            stream.Seek(0, SeekOrigin.Begin);

            byte[] binaryData = new Byte[stream.Length];
            long bytesRead = stream.Read(binaryData, 0, (int)stream.Length);
            fs.Write(binaryData, 0, binaryData.Length);

        }

这是生成图片的FluxJpeg这些都是控件 如何生成或者插入excel呢？

是Silverlight3

Answer 3

你好，

     这个用Silverlight4的与com交互的功能来实现的话会比较方便。

     http://forums.silverlight.net/forums/p/160030/359177.aspx   (SL4 例子)

    http://blogs.msdn.com/brada/archive/2009/07/14/business-apps-example-for-silverlight-3-rtm-and-net-ria-services-july-update-part-4-seo-export-to-excel-and-out-of-browser.aspx  

   这个是SL3导入到Excel的例子