An add-in is a software program that expands the capabilities of bigger programs. It is a term commonly used by Microsoft and other platforms which have additional functions that can be added to primary programs. An add-in has specific but limited features that require only minimal memory resources.
Question:how to get the last column used/last column that has some data in a excel file programmatically by using C#?
Description:I need to iterate through a single row where I don’t know the end range as I have a dynamically generated excel file which might have different number of columns used every time. I am using following code, taken from reference code List<string> myValue = new List<string>(); //unknown end Range //need to get the Last data filled column or Last Column used in the following line string endRange="D1"; foreach (Range row in sheet.Cells.Rows.Range["A1", endRange]) { Range cell = (Range)row.Cells[1, 1]; if (cell.Value2 != null) { myValue.Add(Convert.ToString(cell.Value2)); } }
Posted by: Peter Andre | Posted on: Jan 22, 2020
Question:How to get the list of all available powerpoint control’s ids?
Description:I need all available powerpoint (currently i am using office 2016) control ids as I have to utilize them for development purpose. it will be good if i can have ids for older versions of powerpoint which might be useful to avoid any compatibility issues.
Posted by: Samantha Jones | Posted on: Jan 21, 2020
Question:How to update Legend / series text of powerpoint chart using VSTO in C#?
Description:I am dynamically adding series items but the series/Legend items always showing text as series1,series2 and so on… but let say I want to update them as my series 1, my series 2, and so on. I am clueless as there is very less information available regarding the topic.
Posted by: Samantha Jones | Posted on: Jan 10, 2020