Search code examples
c#excelconvertersspire

Convert excel file to jpg in c#


I am trying to use Spire dll to convert excel file to jpg .

so i have a xlsm file like this :

enter image description here

i use this code to convert it to jpg :

    Workbook workbook = new Workbook();
    workbook.LoadFromFile(@"D:\a.xlsm");
    Worksheet sheet = workbook.Worksheets[1];
    sheet.SaveToImage("exceltoimage.jpg");
    System.Diagnostics.Process.Start("exceltoimage.jpg");

but the output is like this some of the cell can't be converted why i mean (#name)?

enter image description here

I have this warning in my page :

enter image description here


Solution

  • I finally use Aspose :

    http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/category1129.aspx

    example :

    http://www.aspose.com/docs/display/cellsnet/Converting+Worksheet+to+Image

    my sample code :

     Workbook workbook = new Workbook(@"D:\a.xlsm");
                //Get the first worksheet.
                Worksheet sheet = workbook.Worksheets[12];
    
                //Define ImageOrPrintOptions
                ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
                //Specify the image format
                imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg;
                //Only one page for the whole sheet would be rendered
                imgOptions.OnePagePerSheet = true;
    
                //Render the sheet with respect to specified image/print options
                SheetRender sr = new SheetRender(sheet, imgOptions);
                //Render the image for the sheet
                Bitmap bitmap = sr.ToImage(0);
    
                //Save the image file specifying its image format.
                bitmap.Save(@"d:\SheetImage.jpg");
    

    It works great for me .