Office Excel API (三) Worksheet

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Reflection;
using Microsoft.Office.Interop.Excel;

namespace OfficeUtility
{
    /// <summary>
    /// Worksheet related
    /// </summary>
    public class ExcelWorksheetUtil : IDisposable
    {
        /// <summary>
        /// Get Worksheet accoring to the worksheet name
        /// </summary>
        /// <param name="name"></param>
        /// <param name="workbook"></param>
        /// <returns></returns>
        public static Worksheet GetWorksheet(string name, Workbook workbook)
        {
            foreach (Worksheet ws in workbook.Worksheets)
            {
                if (ws.Name == name)
                {
                    return ws;
                }
            }
            return null;
        }

        /// <summary>
        /// Get the last used row number
        /// </summary>
        /// <param name="worksheet">The worksheet which is working on</param>
        /// <returns>The last uesed row number</returns>
        public int GetLastUsedRow(Worksheet worksheet)
        {
            return worksheet.UsedRange.Row + worksheet.UsedRange.Rows.Count - 1;
        }

        /// <summary>
        /// Get the last used column number
        /// </summary>
        /// <param name="worksheet">The worksheet which is working on</param>
        /// <returns>The last used column number</returns>
        public int GetLastUsedCol(Worksheet worksheet)
        {
            return worksheet.UsedRange.Column + worksheet.UsedRange.Columns.Count - 1;
        }

        /// <summary>
        /// Print excel worksheet
        /// </summary>
        /// <param name="worksheet">The worksheet which will be printed</param>
        /// <param name="printerName">The printer which will be used to print the worksheet</param>
        /// <param name="pageOrientation">The page orientation</param>
        public static void PrintWorksheet(Worksheet worksheet, string printerName, XlPageOrientation pageOrientation)
        {
            worksheet.Activate();
            if (!string.IsNullOrEmpty(printerName))
            {
                worksheet.PageSetup.Orientation = pageOrientation;
                worksheet.PrintOut(Missing.Value,
                                     Missing.Value,
                                     1,
                                     Missing.Value,
                                     printerName,
                                     Missing.Value,
                                     Missing.Value,
                                     Missing.Value);
            }
        }

        #region IDisposable Members

        public void Dispose()
        {
        }

        #endregion
    }
}