Worksheet.get_Range Method

最新推荐文章于 2025-04-10 14:18:01 发布

转载最新推荐文章于 2025-04-10 14:18:01 发布 · 589 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/anchenjie007/archive/2013/03/15/2961446.html

文章标签：

#c#

本文介绍如何使用 Worksheet.get_Range 方法获取 Microsoft Office Interop Excel 中的单元格或单元格范围。此方法已被 Range 属性替代，但了解其用法对于理解早期代码或特定需求仍有帮助。

[转自:http://technet.microsoft.com/zh-cn/library/microsoft.office.tools.excel.worksheet.get_range(de-de).aspx]

Worksheet.get_Range Method

Gets a Microsoft.Office.Interop.Excel.Range object that represents a cell or a range of cells. Use the Range property instead of this method.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

C#：

Range get_Range(
	Object Cell1,
	Object Cell2
)

Parameters

Cell1

Type: System.Object
The name of the range in A1-style notation in the language of the application.It can include the range operator (a colon), the intersection operator (a space), or the union operator (a comma).It can also include dollar signs, but they are ignored.You can use a local defined name in any part of the range.If you use a name, the name is assumed to be in the language of the application.This parameter is required.

Cell2

Type: System.Object
The cell in the lower-right corner of the range.Can be a Microsoft.Office.Interop.Excel.Range that contains a single cell, an entire column, an entire row, or it can be a string that names a single cell in the language of the application.This parameter is optional.

Return Value

Type: Microsoft.Office.Interop.Excel.Range
A Microsoft.Office.Interop.Excel.Range that represents a cell or a range of cells.

.NET Framework Security

.Net Framework Security

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

转载于:https://www.cnblogs.com/anchenjie007/archive/2013/03/15/2961446.html