excel word interop

  1. T

    Resolved Excel Interop Autofilter Range

    I need the following filter to work in C#. Here is the working Macro in Excel VBA: ActiveSheet.Range("$A$1:$XFC$13214").AutoFilter Field:=6, Criteria1:= ">=1/1/2024", Operator:=xlAnd, Criteria2:="<=1/31/2024" Here is what I thought was the C# equivalent: excelRange.AutoFilter(Field: 6...
  2. ThreeNamesGrace

    Problem setting the Text property of a Characters object in Excel Interop using Visual C#

    I'm making ChartSheets in Excel using .NET 7 and the latest update of Office 365; this is the code that I use to change the style of the charts and give them a title: GráficasFrecuenciaGanancia[i - 1].ChartType = XlChartType.xlLineMarkers; GráficasFrecuenciaGanancia[i-1].HasTitle = true...
  3. K

    Read through excel files and creating a csv file

    I am really new to all this and I have have taken on a project that now seems abit out of my depth. I have found snippets of code through browsing and put them in some structure for what I beleive in need as you see below. the excel files have rows of data that I need to read and transfer...
  4. T

    Question How do I modify the link properties of a linked excel spreadsheet

    How do I modify the link properties of a linked excel spreasheet inside a word document (docx) using c#. I tried to find a simple example but to no avail. Just some lines of code would be appreciated. I tried to use Microsoft.Office.Interop.Word but could not figure it out. Thank you in advance.
Top Bottom