The equivalent statement in earlier versions of C# requires a placeholder argument: (Type.Missing).Īdd the following code at the end of DisplayInExcel.
The code inserts values into the first two columns of the first row of the worksheet.Īdd the following code at the end of DisplayInExcel.
The foreach loop puts the information from the list of accounts into the first two columns of successive rows of the worksheet.Īdd the following code at the end of DisplayInExcel to adjust the column widths to fit the content.Įarlier versions of C# require explicit casting for these operations because ExcelApp.Columns returns an Object, and AutoFit is an Excel xref.Range method.
The following lines show the casting.Ĭ# 4, and later versions, converts the returned Object to dynamic automatically if the assembly is referenced by the EmbedInteropTypes compiler option or, equivalently, if the Excel Embed Interop Types property is set to true. True is the default value for this property.Īdd the following line at the end of Main.Īn Excel worksheet appears that contains the data from the two accounts. To illustrate additional ways in which C# 4, and later versions, enhances Office programming, the following code opens a Word application and creates an icon that links to the Excel worksheet. #.NET OFFICE INTEROP COPY WORD TABLE TO EXCEL CODE# Paste method CreateIconInWordDoc, provided later in this step, into the Program class. These calls incorporate two other new features introduced in C# 4 that simplify calls to COM methods that have reference parameters.ĬreateIconInWordDoc uses named and optional arguments to reduce the complexity of the method calls to %2A and %2A. That is, you can send values directly, without creating a variable for each reference parameter.įirst, you can send arguments to the reference parameters as if they were value parameters. The compiler generates temporary variables to hold the argument values, and discards the variables when you return from the call. Second, you can omit the ref keyword in the argument list. The Add method has four reference parameters, all of which are optional. In C# 4.0 and later versions, you can omit arguments for any or all of the parameters if you want to use their default values.
0 kommentar(er)
