Comments by Mallesh Shantagiri (Top 12 by date)

@Richard MacCutchan ,
i got this in macro recording ,
ActiveChart.SetSourceData Source = rng("Trend_NCM!$A$2:$AD$7");
and i tried for the solution , but i didn't get the result in c# . if possible please explain it to me.
ChartObjects chartObjs = (ChartObjects)ws.ChartObjects();
ChartObject chartObj = chartObjs.Add(150, 20, 300, 300);
Chart xlChart = chartObj.Chart;
var charts = ws.Charts;
var chart = (Chart)charts.Add();
chart.SetSourceData
chart.SetSourceData(ws.Name + "!" + dataSheet.UsedRange.Address, Excel.XlRowCol.xlColumns);

xlWorkBook = app.Workbooks.Open("E:\\test\\DT", 0, false, 5, "", "", false,
Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, 1, 0); //@"H:\TestFile.xlsx"
sheet = (Excel.Worksheet)xlWorkBook.Sheets.get_Item(1);
// app.Workbooks.Open(@"E:\\test\\DTS-CODE");//Open the work book
// sheet = app.Sheets["Trend NCM"];//Select the sheet the chart is on
chartObj = sheet.ChartObjects("Chart 1");//Select the ChartObject
chart = chartObj.Chart; //Select the Chart from the ChartObject
series = chart.SeriesCollection(1);//Select the series you are changing
//// series.Values = (Excel.Range)sheet.get_Range(sheet.Cells[2, 2], sheet.Cells[4, 5]);
////
series.Values = sheet.Range["A3:A7"];

i tried above but no change in the result.

Hello Richard , I will try make you clear , I just want to update or increase the chart data range , now in my excel the data range for chart is =Trend_NCM!$A$2:$AB$7 , but i want to update that chart through c# , if i updates any new data in AC column , the chart data range should update as
=Trend_NCM!$A$2:$AC$7 , so on .
i'm trying on chart series collections ,but i'm not getting ,how to increase it by c# program . please let me know any idea to solve this.

Hello kenneth ,
Thanks for your response , I'm working on a project and i got the error .i will check the link.

Hi, I have updated the question , Please let me know how can i solve it.

Hi , When i call the method as below
percentile(myarray , K); ,

Error : An object reference required for non -static field ,method,property.

I am Getting Selected columns index name With addition of "#",after that i am splitting each,here is the code.

public void textboxcontents(string hashedstring)
{
string[] unhash = hashedstring.Split('#');
// List<string>datas =new List<string>();
string te="";
richTextBox1.Clear();
ArrayList indexes = new ArrayList();
foreach (string s in unhash)
{
te = te +"\t"+ s+"\t";
int idx = getColumnIndex(s, dataGridView1.Columns);
if (idx != -1)
{
indexes.Add(idx);
}
}

richTextBox1.AppendText("\t" + "My-Reports" + "\n" + "\n");
richTextBox1.AppendText("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"+Environment.NewLine);
richTextBox1.Text = richTextBox1.Text + te + Environment.NewLine;
string data = string.Empty;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
foreach (int idx in indexes)
{
data = data + String.Format("{0}",row.Cells[idx].Value) + "\t" + "\t";
}


richTextBox1.AppendText("\t"+ data + "\n");
data = string.Empty;
}