Download MPP_Viewer_Source.zip - 130.55 KB

Introduction

MPP Viewer is a simple viewer for Microsoft Project files. It allows you to perform open, export to excel. It works fine with Project 2000/2003/2007 files. I have used MPXJ open source library to read project files. More details of the same is available from http://mpxj.sourceforge.net/. You will need to download and add the reference to mpxj library to run MPP Viewer. I could not upload the all these referenced files due to size constraint. MPXJ distribution also contains a native .Net DLL version of MPXJ and its library dependencies.

I have published MPP Viewer on sourceforge.net at http://sourceforge.net/projects/mppviewer. You can download the latest version of MPP Viewer executable and source from the above link. I am yet to upload the source code into Sourceforge.net. I am planning to do this soon.

I have used TreeListView control shared here. Its very clean implementation of WPF Tree List view and much easier to use.

MPP Viewer allows you to do the following

1. View tasks in hierarchy
2. View Details of the task
3. View resources with associated tasks
4. View Details of Resources
5. Export the project task and resource information to
6. Allows multiple project documents to be open at the same
7. Allows printing tasks in the project file
8. Filter tasks by Completed, Not Complete, Completing Today, Completing today
9. Highlight tasks not complete passed due dateView Tasks with hierarch
10. Supports MS Project 2000, 2003, 2007.
I have to create set of class / wrapper classes in .Net to leverage databinding and other capabilities in .net and WPF.

I have not validated with other versions of MS Project. MPXJ at sourceforge claims it works with 98 and 2010 also.

Class Diagram

I have tried to follow MVVM throughout. You can read more about MVVM at

http://en.wikipedia.org/wiki/Model_View_ViewModel

http://msdn.microsoft.com/en-us/magazine/dd419663.aspx

Points of Interest

To perform Export to excel I have used Open XML SDK 2.0. I did not use the SDK tool to generate and use the template. So the excel that is created is not nicely formated. I have created a re-usable class that can export dataset into excel file. Each DataTable is exported on to a separate file. Export functionality is performed using the following code:

Step 1: Create the SpreadsheetDocument, this represents an excel document package.

private void GenerateExcelDocument()
{
     using (SpreadsheetDocument spreadsheetDocument = 
SpreadsheetDocument.Create(FilePath, SpreadsheetDocumentType.Workbook))
     {
          InitilizeParts(spreadsheetDocument);
     }
}

Step 2: Create the main WorkbookPart that contains the worksheets.

        private void InitilizeParts(SpreadsheetDocument package)
        {
            WorkbookPart workbookPart = package.AddWorkbookPart();
            workbookPart.Workbook = new Workbook();

            Sheets sheets = new Sheets();

            for (int i = 0; i < Data.Tables.Count; i++)
            {
                WorksheetPart worksheetPart = workbookPart.AddNewPart<worksheetpart>();
                InitilizeParts(worksheetPart, Data.Tables[i]);

                Sheet sheet = 
                    new Sheet() 
                    { 
                        Name = Data.Tables[i].TableName,
                        SheetId = sheets.HasChildren ? sheets.Elements<sheet>().Select(s => s.SheetId.Value).Max() + 1 : 1,
                        Id = workbookPart.GetIdOfPart(worksheetPart) 
                    };
                
                sheets.Append(sheet);
            }

            workbookPart.Workbook.Append(sheets);
            workbookPart.Workbook.Save();
        }

Step 3: Create a blank Worksheet and add it to the WorkbookPart.

Step 4: Create a blank Sheet and add it to the WorkbookPart. Id of the Sheet should be same as that of the Worksheet to create a relationship between them.

        private void InitilizeParts(WorksheetPart worksheetPart, DataTable dataTable)
        {
            Worksheet worksheet = new Worksheet();

            SheetData sheetData = new SheetData();

            Row header = new Row();
            header.RowIndex = (UInt32)1;

            foreach (DataColumn column in dataTable.Columns)
            {
                Cell headerCell = InitilizeParts(column.ColumnName, dataTable.Columns.IndexOf(column) + 1, 1);

                header.AppendChild(headerCell);
            }
            sheetData.AppendChild(header);

            DataRow contentRow;
            for (int i = 0; i < dataTable.Rows.Count; i++)
            {
                contentRow = dataTable.Rows[i];
                sheetData.AppendChild(InitilizeParts(contentRow, i + 2));
            }

            worksheet.Append(sheetData);
            worksheetPart.Worksheet = worksheet;
        }

Step 5: Create SheetData for each Worksheet.

Step 6: Create Rows and Cells into SheetData with appropriate CellReference.

        private Row InitilizeParts(DataRow dataRow, int rowIndex)
        {
            Row row = new Row { RowIndex = (UInt32)rowIndex };

            for (int i = 0; i < dataRow.Table.Columns.Count; i++)
            {
                Cell dataCell = InitilizeParts(dataRow[i], i + 1, rowIndex);
                row.AppendChild(dataCell);
            }

            return row;
        }

        private Cell InitilizeParts(object cellValue, int columnIndex, int rowIndex)
        {
            Cell cell = new Cell();
            cell.DataType = CellValues.InlineString;
            cell.CellReference = getExcelCellReference(columnIndex) + rowIndex;

            InlineString inlineString = new InlineString();
            Text t = new Text();
            
            t.Text = cellValue.ToString();
            inlineString.AppendChild(t);
            cell.AppendChild(inlineString);

            return cell;
        }

ComboBox does not implement command interface. One of the options to develop a new combobox extending the ComboBox and implementing the ICommandSource interface. The other alternate is to use Interaction from System.Windows.Interactivity namespace. This assembly is availabe with BlendSDK. It makes it very simple to attach commands to SelectionChange event.

             <ComboBox Name="filterComboBox" VerticalAlignment="Center" >
                <i:Interaction.Triggers>
                    <i:EventTrigger EventName="SelectionChanged">
                        <i:InvokeCommandAction Command="{Binding FilterChangedCommand}"
                                               CommandParameter="{Binding Path=SelectedItem.Content, ElementName=filterComboBox}"/>
                    </i:EventTrigger>
                </i:Interaction.Triggers>
                <ComboBoxItem Content="All" IsSelected="True" />
                <ComboBoxItem Content="Completed" />
                <ComboBoxItem Content="In Complete" />
                <ComboBoxItem Content="To Complete Today" />
                <ComboBoxItem Content="To Complete Tomorrow" />
            </ComboBox>

Some of the items I am looking to add in future are:

1. Viewer for Gantt Chart.

2. Well formatted excel is generated from the tool.