Visual Studio Tools for Office is a set of development tools available in the form of a Visual Studio add-in and a runtime that allows Microsoft Office 2003 and later versions of Office applications to host the .NET Framework Common Language Runtime to expose their functionality via .NET.
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:Iterate through a single specified row of an excel sheet using vsto in C# code?
Description:I have a excel sheet and I need to create a list containing all the values of the specified row or specified range!
Posted by: Samantha Jones | Posted on: Jan 15, 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