实现1904日期系统
Contents
[
Hide
]
Microsoft Excel支持两种日期系统:1900日期系统(Excel for Windows 中实施的默认日期系统)和1904日期系统。1904日期系统通常用于与Macintosh Excel文件兼容,并且是在使用Excel for Macintosh时的默认系统。您可以使用 Aspose.Cells 设置Excel文件的1904日期系统。
在 Microsoft Excel 中实现1904日期系统(例如 Microsoft Excel 2003):
- 从“工具”菜单中选择“选项”,并选择“计算”选项卡。
- 选择“1904日期系统”选项。
- 点击确定。
在Microsoft Excel中选择1904日期系统 |
---|
![]() |
请参阅以下示例代码,了解如何使用Aspose.Cells API 实现此功能。 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Initialize a new Workbook | |
// Open an excel file | |
Workbook workbook = new Workbook(dataDir+ "book1.xlsx"); | |
// Implement 1904 date system | |
workbook.Settings.Date1904 = true; | |
// Save the excel file | |
workbook.Save(dataDir+ "Mybook.out.xlsx"); |