problem in Microsoft.Office.Interop.Excel

Question

problem in Microsoft.Office.Interop.Excel

shahab nassiri 1

Hi

I use the mentioned dll (version 16.0.11029.20079) for generating chart into the excel file from c# program.

I generate the linear chart using this dll successfully. but when we want to create the histogram chart we face with error.

The histogram type is not exist in previous dll, but in corresponding dll, it is exist. However, we face the error in using it.

There is no sample for generating the histogram chart using mentioned dll.

please help me for using this dll

thank you for reading this question.

Jack J Jun 25,316

@shahabnassiri-9754 , which error you get when you want to create the histogram chart? Could you provide the related code you are using?

I also write a code example to create the histogram chart, but it will throw the exception Value does not fall within the expected range.

Therefore, I used the following method to solve it.

    try
    {

        //Add chart 
        var charts = xlWorkSheetDia.ChartObjects() as Excel.ChartObjects;
        var chartObject = charts.Add(60, 10, 300, 300) as Excel.ChartObject;
        var chart = chartObject.Chart;
        //Move Chart
        chartObject.Chart.Location(Where: Excel.XlChartLocation.xlLocationAsObject, Name: xlWorkSheetDia.Name); //already gets created on the right place(first spreadsheet)
                                                                                                                //Set chart range
        chart.SetSourceData(xlWorkSheetData.get_Range("A1", "E5"));//Data on second spreadsheet
                                                                   //Set chart properties.
        Excel.XlChartType myHistogram = (Excel.XlChartType)118;


        chart.ChartType = myHistogram; //<-The exception happens here


    }
    catch(Exception ex)
    {
        Console.WriteLine(ex.Message);
    }
    finally
    {
        xlWorkBook.Save();
        //cleanup
        xlWorkBook.Close(false);
        xlApp.Quit();
    }

Jack J Jun 25,316 Reputation points

2022-05-31T05:26:44.123+00:00

@shahabnassiri-9754, is any update?

Your answer

Jack J Jun 25,316 Reputation points

2022-05-16T06:04:38.467+00:00

@shahabnassiri-9754 , which error you get when you want to create the histogram chart? Could you provide the related code you are using?

I also write a code example to create the histogram chart, but it will throw the exception Value does not fall within the expected range.

Therefore, I used the following method to solve it.

try { //Add chart var charts = xlWorkSheetDia.ChartObjects() as Excel.ChartObjects; var chartObject = charts.Add(60, 10, 300, 300) as Excel.ChartObject; var chart = chartObject.Chart; //Move Chart chartObject.Chart.Location(Where: Excel.XlChartLocation.xlLocationAsObject, Name: xlWorkSheetDia.Name); //already gets created on the right place(first spreadsheet) //Set chart range chart.SetSourceData(xlWorkSheetData.get_Range("A1", "E5"));//Data on second spreadsheet //Set chart properties. Excel.XlChartType myHistogram = (Excel.XlChartType)118; chart.ChartType = myHistogram; //<-The exception happens here } catch(Exception ex) { Console.WriteLine(ex.Message); } finally { xlWorkBook.Save(); //cleanup xlWorkBook.Close(false); xlApp.Quit(); }
Jack J Jun 25,316 Reputation points

2022-05-31T05:26:44.123+00:00

@shahabnassiri-9754, is any update?

Share via

problem in Microsoft.Office.Interop.Excel

Your answer