How to: Programmatically store and retrieve date values in Excel ranges
Applies to: Visual Studio
Visual Studio for Mac
Visual Studio Code
You can store and retrieve values in a NamedRange control or a native Excel range object.
Applies to: The information in this topic applies to document-level projects and VSTO Add-in projects for Excel. For more information, see Features available by Office application and project type.
If you store a date value that falls on or after 1/1/1900 in a range using Office development tools in Visual Studio, it is stored in OLE Automation (OA) format. You must use the FromOADate method to retrieve the value of OLE Automation (OA) dates. If the date is earlier than 1/1/1900, it is stored as a string.
Note
Excel dates differ from OLE Automation dates for the first two months of 1900. There are also differences if the 1904 date system option is checked. The code examples below do not address these differences.
Use a NamedRange control
- This example is for document-level customizations. The following code must be placed in a sheet class, not in the
ThisWorkbook
class.
To store a date value in a named range
Create a NamedRange control at cell A1.
Set today's date as the value for
NamedRange1
.
To retrieve a date value from a named range
Retrieve the date value from
NamedRange1
.
Use native Excel ranges
To store a date value in a native Excel range object
Create a Range that represents cell A1.
Set today's date as the value for
rng
.
To retrieve a date value from a native Excel range object
Retrieve the date value from
rng
.
See also
Feedback
Submit and view feedback for