Change excel sheet to bitmap RRS feed

  • Question

  • User1018163743 posted


    Is there any way to convert Excel sheet to bitmap image by using C#.

    I need to create bitmap image from excel data,  Please help me.



    Wednesday, May 6, 2009 8:57 AM

All replies

  • User-916962509 posted

     You can create bitmap images on the fly using GDI+ and the System.Drawing namespace, there's a lot of tutorials online about how to dynamically create images in .NET. First of all try to get your head around creating a bitmap image looking like what you want, with some sample output without actually talking to an Excel file.

    After that, you'll need to use the same principles but this time instead of using dummy data, actually get the data from Excel. There's a few ways to get data from Excel: A linked data source/server in SQL Server, XSLT if it is Excel 2007 or you could use the good old COM interop to talk to Excel 2003. Again there is plenty of tutorials on the web for this.

    You will be able to do it in .net... I'm very sure about that... People on the forums will be able to help with any specific problems you come across but there is a wealth of information on Google about (1) how to generate a bitmap image and (2) how to talk to Excel. You just need to wire the two together.

    Happy programming

    Thursday, May 7, 2009 8:00 AM