Skip to main content

Posts

Recent posts

Create Excel chart using C# winforms application

Create Excel chart using C#  winforms application     For Create chart using C# .net dynamically just Follow 6 steps Step 1 :  Create Worksheet,WorkBook,Worksheet object  private void btnEXLChart_Click(object sender, EventArgs e)         {             Excel.Application xlApp = null;             Excel.Workbook xlWorkBook = null;             Excel.Worksheet xlWorkSheet = null;         }  object misValue = System.Reflection.Missing.Value;  xlApp = new Excel.ApplicationClass();                     xlWorkBook = xlApp.Workbooks.Add(misValue);                     xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);                     xlWorkSheet.Name = " Name of sheet ";                     Excel.Range chartRange; Step 2 :  Set TITLE for Chart                    xlWorkSheet.get_Range("C2", "G2").Merge(false);                     chartRange = xlWorkSheet.get_Range("C2", "G2")