--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/sysperfana/heapanalyser/Libraries/Engine/HeapComparisonLib/CSV/Excel/CSVExcelExporterTwoDataSets.cs Tue Jun 15 12:47:20 2010 +0300
@@ -0,0 +1,275 @@
+/*
+* Copyright (c) 2010 Nokia Corporation and/or its subsidiary(-ies).
+* All rights reserved.
+*
+* Redistribution and use in source and binary forms, with or without
+* modification, are permitted provided that the following conditions are met:
+*
+* - Redistributions of source code must retain the above copyright notice,
+* this list of conditions and the following disclaimer.
+* - Redistributions in binary form must reproduce the above copyright notice,
+* this list of conditions and the following disclaimer in the documentation
+* and/or other materials provided with the distribution.
+* - Neither the name of Nokia Corporation nor the names of its contributors
+* may be used to endorse or promote products derived from this software
+* without specific prior written permission.
+*
+* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+* ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+* LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+* POSSIBILITY OF SUCH DAMAGE.
+*
+* Initial Contributors:
+* Nokia Corporation - initial contribution.
+*
+* Contributors:
+*
+* Description:
+*
+*/
+
+using System;
+using System.IO;
+using System.Threading;
+using System.Runtime.InteropServices;
+using Excel = Microsoft.Office.Interop.Excel;
+using System.Reflection;
+using SymbianExcelUtils;
+using SymbianUtils;
+
+namespace HeapComparisonLib.CSV
+{
+ internal class CSVExcelExporterTwoDataSets : DisposableObject
+ {
+ #region Constructors & destructor
+ public CSVExcelExporterTwoDataSets( string aOutputFileName, string aCol1FileName, string aCol2FileName )
+ {
+ iFileName = aOutputFileName;
+ iCol1FileName = aCol1FileName;
+ iCol2FileName = aCol2FileName;
+ //
+ iExcelApp = new Excel.Application();
+ if ( iExcelApp != null )
+ {
+ iExcelApp.Visible = false;
+ iExcelApp.DisplayAlerts = false;
+
+ // Prepare sheets
+ PrepareWorksheetReadyForData();
+ }
+ else
+ {
+ throw new Exception( "Microsoft Excel not available" );
+ }
+ }
+ #endregion
+
+ #region API
+ public void CompareThread( CSVThread aThread1, CSVThread aThread2 )
+ {
+ // Do comparison
+ iComparerHeapSize.Compare( aThread1, aThread2 );
+ iComparerCellCounts.Compare( aThread1, aThread2 );
+ iComparerLargestCells.Compare( aThread1, aThread2 );
+ iComparerFragmentation.Compare( aThread1, aThread2 );
+ iComparerSlackSpace.Compare( aThread1, aThread2 );
+ }
+ #endregion
+
+ #region From DisposableObject
+ protected override void CleanupManagedResources()
+ {
+ try
+ {
+ if ( iExcelApp != null )
+ {
+ // We're finished
+ PrepareWorsheetForSaving();
+
+ // Save excel workbook
+ SaveWorkbook();
+
+ // Close app
+ Utils.CloseExcel( iExcelApp );
+ }
+
+ iExcelApp = null;
+ }
+ finally
+ {
+ base.CleanupManagedResources();
+ }
+ }
+ #endregion
+
+ #region Internal methods
+ private void PrepareWorksheetReadyForData()
+ {
+ Excel.Workbooks workbooks = iExcelApp.Workbooks;
+ workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
+ Excel.Workbook workbook = workbooks.get_Item(workbooks.Count);
+ Excel.Sheets sheets = workbook.Worksheets;
+
+ Excel.Worksheet sheet = null;
+ //
+ sheet = (Excel.Worksheet)sheets.Add(Type.Missing, sheets.get_Item(sheets.Count), 1, Excel.XlSheetType.xlWorksheet);
+ iComparerHeapSize = new Comparers.HeapSize( sheet, iCol1FileName, iCol2FileName );
+ iComparerHeapSize.PrepareWorksheetReadyForData();
+ //
+ sheet = (Excel.Worksheet)sheets.Add(Type.Missing, sheets.get_Item(sheets.Count), 1, Excel.XlSheetType.xlWorksheet);
+ iComparerCellCounts = new Comparers.CellCounts( sheet, iCol1FileName, iCol2FileName );
+ iComparerCellCounts.PrepareWorksheetReadyForData();
+ //
+ sheet = (Excel.Worksheet)sheets.Add(Type.Missing, sheets.get_Item(sheets.Count), 1, Excel.XlSheetType.xlWorksheet);
+ iComparerLargestCells = new Comparers.LargestCells( sheet, iCol1FileName, iCol2FileName );
+ iComparerLargestCells.PrepareWorksheetReadyForData();
+ //
+ sheet = (Excel.Worksheet)sheets.Add(Type.Missing, sheets.get_Item(sheets.Count), 1, Excel.XlSheetType.xlWorksheet);
+ iComparerFragmentation = new Comparers.Fragmentation( sheet, iCol1FileName, iCol2FileName );
+ iComparerFragmentation.PrepareWorksheetReadyForData();
+ //
+ sheet = (Excel.Worksheet)sheets.Add(Type.Missing, sheets.get_Item(sheets.Count), 1, Excel.XlSheetType.xlWorksheet);
+ iComparerSlackSpace = new Comparers.SlackSpace( sheet, iCol1FileName, iCol2FileName );
+ iComparerSlackSpace.PrepareWorksheetReadyForData();
+ }
+
+ private void PrepareWorsheetForSaving()
+ {
+ // Finalise comparison sheets
+ iComparerHeapSize.FinaliseWorksheet();
+ iComparerCellCounts.FinaliseWorksheet();
+ iComparerLargestCells.FinaliseWorksheet();
+ iComparerFragmentation.FinaliseWorksheet();
+ iComparerSlackSpace.FinaliseWorksheet();
+
+ // Create summary sheet
+ Excel.Workbooks workbooks = iExcelApp.Workbooks;
+ Excel.Workbook workbook = workbooks.get_Item(workbooks.Count);
+ Excel.Sheets sheets = workbook.Worksheets;
+ Excel.Worksheet sheet = (Excel.Worksheet)sheets.get_Item(1);
+ CreateSummary( sheet );
+ sheet.Activate();
+ }
+
+ private void CreateSummary( Microsoft.Office.Interop.Excel.Worksheet aSheet )
+ {
+ aSheet.Name = "Summary";
+ //
+ int row = 1;
+ Utils.SetValue( row, 2, aSheet, "Delta" );
+ Utils.MakeBoxedTitleRow( row, 2, aSheet, 0xFF0000 );
+ row++;
+ //
+ row++;
+ Utils.SetValue( row, 1, aSheet, "File 1:" );
+ Utils.SetValue( row, 2, aSheet, iCol1FileName );
+ //
+ row++;
+ Utils.SetValue( row, 1, aSheet, "File 2:" );
+ Utils.SetValue( row, 2, aSheet, iCol2FileName );
+ //
+ row++;
+ Utils.SetValue( row, 1, aSheet, "Heap size:" );
+ Utils.SetValue( row, 2, aSheet, iComparerHeapSize.DeltaFormula( 0 ) );
+ //
+ row++;
+ Utils.SetValue( row, 1, aSheet, "Free space:" );
+ Utils.SetValue( row, 2, aSheet, iComparerHeapSize.DeltaFormula( 1 ) );
+ //
+ row++;
+ Utils.SetValue( row, 1, aSheet, "Alloc space:" );
+ Utils.SetValue( row, 2, aSheet, iComparerHeapSize.DeltaFormula( 2 ) );
+ //
+ row++;
+ Utils.SetValue( row, 1, aSheet, "Heap size:" );
+ Utils.SetValue( row, 2, aSheet, iComparerHeapSize.DeltaFormula( 0 ) );
+ //
+ row++;
+ Utils.SetValue( row, 1, aSheet, "Free cell count:" );
+ Utils.SetValue( row, 2, aSheet, iComparerCellCounts.DeltaFormula( 0 ) );
+ //
+ row++;
+ Utils.SetValue( row, 1, aSheet, "Allocated cell count:" );
+ Utils.SetValue( row, 2, aSheet, iComparerCellCounts.DeltaFormula( 1 ) );
+ //
+ row++;
+ Utils.SetValue( row, 1, aSheet, "Fragmentation:" );
+ Utils.SetValue( row, 2, aSheet, iComparerFragmentation.DeltaFormula( 0 ) );
+ //
+ row++;
+ Utils.SetValue( row, 1, aSheet, "Slack space:" );
+ Utils.SetValue( row, 2, aSheet, iComparerSlackSpace.DeltaFormula( 0 ) );
+ Utils.BoldColumn( 1, aSheet );
+
+ // Calculate column sizes
+ Utils.AutoFitColumn( 1, aSheet );
+ Utils.AutoFitColumn( 2, aSheet );
+ }
+
+ private void SaveWorkbook()
+ {
+ string path = Path.GetDirectoryName( iFileName );
+ System.IO.DirectoryInfo dirInfo = new System.IO.DirectoryInfo( path );
+ if ( !dirInfo.Exists )
+ {
+ dirInfo.Create();
+ }
+
+ System.IO.FileInfo fileInfo = new System.IO.FileInfo( iFileName );
+ if ( fileInfo.Exists )
+ {
+ try
+ {
+ fileInfo.Delete();
+ }
+ catch ( Exception )
+ {
+ }
+ }
+
+ Microsoft.Office.Interop.Excel.Workbooks workbooks = iExcelApp.Workbooks;
+ Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.get_Item( workbooks.Count );
+
+ try
+ {
+ workbook.SaveAs( iFileName,
+ Excel.XlFileFormat.xlExcel9795,
+ Type.Missing,
+ Type.Missing,
+ Type.Missing,
+ Type.Missing,
+ Excel.XlSaveAsAccessMode.xlNoChange,
+ Type.Missing,
+ Type.Missing,
+ Type.Missing,
+ Type.Missing,
+ Type.Missing );
+ }
+ catch ( System.IO.IOException )
+ {
+ }
+
+ workbook.Close( false, Type.Missing, Type.Missing );
+ }
+ #endregion
+
+ #region Data members
+ private readonly string iFileName;
+ private readonly string iCol1FileName;
+ private readonly string iCol2FileName;
+ private Excel.Application iExcelApp;
+ private Comparers.HeapSize iComparerHeapSize;
+ private Comparers.CellCounts iComparerCellCounts;
+ private Comparers.LargestCells iComparerLargestCells;
+ private Comparers.Fragmentation iComparerFragmentation;
+ private Comparers.SlackSpace iComparerSlackSpace;
+ #endregion
+ }
+}