Aspose.Tasks for .NET是一款类库,可以使.NET应用程序在没有安装Microsoft Project软件的情况下读取Microsoft Project文件,对Project文件进行读取、修改和写入,支持MS Project 2003, 2007, 2010, 2013 和 2016 MPP格式,这篇文章主要介绍怎么快速在.NET程序中读取Microsoft Project文件,具体可以参考下面的部分代码:
1、从模板读取Project文件
Project project = new Project("d:\\Project1.mpp");
2、从流文件读取Project文件
using(Stream fs = new FileStream("pathToFile.xml", FileMode.Open))
{
project = new Project(fs);
}
3、从Microsoft Project数据库导入Project数据
SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder();
sb.DataSource = "192.168.56.2,1433";
sb.Encrypt = true;
sb.TrustServerCertificate = true;
sb.InitialCatalog = "ProjectServer_Published";
sb.NetworkLibrary = "DBMSSOCN";
sb.UserID = "sa";
sb.Password = "*****";
//use Aspose.Tasks.Connectivity namespace
MspDbSettings settings = new MspDbSettings(sb.ConnectionString, new Guid("E6426C44-D6CB-4B9C-AF16-48910ACE0F54"));
Project project = new Project(settings);
4、从Microsoft MPD文件导入Project数据
DbSettings settings = new MpdSettings(GetConnectionString(), 1);
Project project = new Project(settings);
private string GetConnectionString()
{
return "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=MpdFileToRead.mpd";
}