diff --git a/ClosedXML/ClosedXML.sln b/ClosedXML/ClosedXML.sln
index c619cc0..fd10e4a 100644
--- a/ClosedXML/ClosedXML.sln
+++ b/ClosedXML/ClosedXML.sln
@@ -3,25 +3,75 @@
 # Visual Studio 2010
 Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ClosedXML", "ClosedXML\ClosedXML.csproj", "{BD5E6BFE-E837-4A35-BCA9-39667D873A20}"
 EndProject
+Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ClosedXML_Sandbox", "ClosedXML_Sandbox\ClosedXML_Sandbox.csproj", "{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}"
+EndProject
+Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ClosedXML_Test", "ClosedXML_Test\ClosedXML_Test.csproj", "{D41B4F43-AB44-4236-B959-D508D259F4A7}"
+EndProject
+Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "Solution Items", "Solution Items", "{5C94E22C-85AA-48FD-B082-CF929FFC6C31}"
+	ProjectSection(SolutionItems) = preProject
+		ClosedXML.vsmdi = ClosedXML.vsmdi
+		Local.testsettings = Local.testsettings
+		TraceAndTestImpact.testsettings = TraceAndTestImpact.testsettings
+	EndProjectSection
+EndProject
 Global
 	GlobalSection(TeamFoundationVersionControl) = preSolution
-		SccNumberOfProjects = 2
+		SccNumberOfProjects = 4
 		SccEnterpriseProvider = {4CA58AB2-18FA-4F8D-95D4-32DDF27D184C}
 		SccTeamFoundationServer = https://tfs09.codeplex.com/
 		SccLocalPath0 = .
 		SccProjectUniqueName1 = ClosedXML\\ClosedXML.csproj
 		SccProjectName1 = ClosedXML
 		SccLocalPath1 = ClosedXML
+		SccProjectUniqueName2 = ClosedXML_Sandbox\\ClosedXML_Sandbox.csproj
+		SccProjectName2 = ClosedXML_Sandbox
+		SccLocalPath2 = ClosedXML_Sandbox
+		SccProjectUniqueName3 = ClosedXML_Test\\ClosedXML_Test.csproj
+		SccProjectName3 = ClosedXML_Test
+		SccLocalPath3 = ClosedXML_Test
+	EndGlobalSection
+	GlobalSection(TestCaseManagementSettings) = postSolution
+		CategoryFile = ClosedXML.vsmdi
 	EndGlobalSection
 	GlobalSection(SolutionConfigurationPlatforms) = preSolution
 		Debug|Any CPU = Debug|Any CPU
+		Debug|Mixed Platforms = Debug|Mixed Platforms
+		Debug|x86 = Debug|x86
 		Release|Any CPU = Release|Any CPU
+		Release|Mixed Platforms = Release|Mixed Platforms
+		Release|x86 = Release|x86
 	EndGlobalSection
 	GlobalSection(ProjectConfigurationPlatforms) = postSolution
 		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
 		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Debug|Mixed Platforms.ActiveCfg = Debug|Any CPU
+		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Debug|Mixed Platforms.Build.0 = Debug|Any CPU
+		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Debug|x86.ActiveCfg = Debug|Any CPU
 		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Release|Any CPU.ActiveCfg = Release|Any CPU
 		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Release|Any CPU.Build.0 = Release|Any CPU
+		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Release|Mixed Platforms.ActiveCfg = Release|Any CPU
+		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Release|Mixed Platforms.Build.0 = Release|Any CPU
+		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Release|x86.ActiveCfg = Release|Any CPU
+		{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}.Debug|Any CPU.ActiveCfg = Debug|x86
+		{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}.Debug|Mixed Platforms.ActiveCfg = Debug|x86
+		{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}.Debug|Mixed Platforms.Build.0 = Debug|x86
+		{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}.Debug|x86.ActiveCfg = Debug|x86
+		{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}.Debug|x86.Build.0 = Debug|x86
+		{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}.Release|Any CPU.ActiveCfg = Release|x86
+		{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}.Release|Mixed Platforms.ActiveCfg = Release|x86
+		{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}.Release|Mixed Platforms.Build.0 = Release|x86
+		{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}.Release|x86.ActiveCfg = Release|x86
+		{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}.Release|x86.Build.0 = Release|x86
+		{D41B4F43-AB44-4236-B959-D508D259F4A7}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{D41B4F43-AB44-4236-B959-D508D259F4A7}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{D41B4F43-AB44-4236-B959-D508D259F4A7}.Debug|Mixed Platforms.ActiveCfg = Debug|Any CPU
+		{D41B4F43-AB44-4236-B959-D508D259F4A7}.Debug|Mixed Platforms.Build.0 = Debug|Any CPU
+		{D41B4F43-AB44-4236-B959-D508D259F4A7}.Debug|x86.ActiveCfg = Debug|Any CPU
+		{D41B4F43-AB44-4236-B959-D508D259F4A7}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{D41B4F43-AB44-4236-B959-D508D259F4A7}.Release|Any CPU.Build.0 = Release|Any CPU
+		{D41B4F43-AB44-4236-B959-D508D259F4A7}.Release|Mixed Platforms.ActiveCfg = Release|Any CPU
+		{D41B4F43-AB44-4236-B959-D508D259F4A7}.Release|Mixed Platforms.Build.0 = Release|Any CPU
+		{D41B4F43-AB44-4236-B959-D508D259F4A7}.Release|x86.ActiveCfg = Release|Any CPU
 	EndGlobalSection
 	GlobalSection(SolutionProperties) = preSolution
 		HideSolutionNode = FALSE
diff --git a/ClosedXML/ClosedXML.vsmdi b/ClosedXML/ClosedXML.vsmdi
new file mode 100644
index 0000000..2acf62a
--- /dev/null
+++ b/ClosedXML/ClosedXML.vsmdi
@@ -0,0 +1,6 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<TestLists xmlns="http://microsoft.com/schemas/VisualStudio/TeamTest/2010">
+  <TestList name="Lists of Tests" id="8c43106b-9dc1-4907-a29f-aa66a61bf5b6">
+    <RunConfiguration id="3badba87-ca41-4949-8562-2064bf2ea599" name="Local" storage="local.testsettings" type="Microsoft.VisualStudio.TestTools.Common.TestRunConfiguration, Microsoft.VisualStudio.QualityTools.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
+  </TestList>
+</TestLists>
\ No newline at end of file
diff --git a/ClosedXML/ClosedXML/ClosedXML.csproj b/ClosedXML/ClosedXML/ClosedXML.csproj
index 8517855..ba4c496 100644
--- a/ClosedXML/ClosedXML/ClosedXML.csproj
+++ b/ClosedXML/ClosedXML/ClosedXML.csproj
@@ -46,16 +46,21 @@
     <Reference Include="WindowsBase" />
   </ItemGroup>
   <ItemGroup>
-    <Compile Include="Excel\XLCellAddress.cs" />
-    <Compile Include="Properties\AssemblyInfo.cs" />
-    <Compile Include="Excel\XLCell.cs" />
-    <Compile Include="Excel\XLCells.cs" />
+    <Compile Include="Excel\Style\XLAlignment.cs" />
+    <Compile Include="Excel\Style\XLBorder.cs" />
+    <Compile Include="Excel\Style\XLFill.cs" />
+    <Compile Include="Excel\Style\XLFont.cs" />
+    <Compile Include="Excel\Style\XLNumberFormat.cs" />
+    <Compile Include="Excel\XLAddress.cs" />
     <Compile Include="Excel\XLRange.cs" />
-    <Compile Include="Excel\XLSharedStrings.cs" />
+    <Compile Include="Excel\Style\XLStyle.cs" />
     <Compile Include="Excel\XLWorkbook.cs" />
-    <Compile Include="Excel\XLWorksheet.cs" />
+    <Compile Include="Excel\XLWorkbook_Save.cs" />
     <Compile Include="Excel\XLWorksheets.cs" />
+    <Compile Include="Extensions.cs" />
+    <Compile Include="Properties\AssemblyInfo.cs" />
   </ItemGroup>
+  <ItemGroup />
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
   <!-- To modify your build process, add your task inside one of the targets below and uncomment it. 
        Other similar extension points exist, see Microsoft.Common.targets.
diff --git a/ClosedXML/ClosedXML/Excel/Style/XLAlignment.cs b/ClosedXML/ClosedXML/Excel/Style/XLAlignment.cs
new file mode 100644
index 0000000..7701733
--- /dev/null
+++ b/ClosedXML/ClosedXML/Excel/Style/XLAlignment.cs
@@ -0,0 +1,253 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel.Style
+{
+    public enum XLAlignmentReadingOrderValues
+    {
+        ContextDependent,
+        LeftToRight,
+        RightToLeft
+    }
+
+    public enum XLAlignmentHorizontalValues
+    {
+        Center,
+        CenterContinuous,
+        Distributed,
+        Fill,
+        General,
+        Justify,
+        Left,
+        Right
+    }
+
+    public enum XLAlignmentVerticalValues
+    {
+        Bottom,
+        Center,
+        Distributed,
+        Justify,
+        Top
+    }
+
+    public class XLAlignment
+    {
+        #region Properties
+
+        private XLRange range;
+
+        private XLAlignmentHorizontalValues horizontal;
+        public XLAlignmentHorizontalValues Horizontal
+        {
+            get { return horizontal; }
+            set
+            {
+                Boolean updateIndent = !(
+                    value == XLAlignmentHorizontalValues.Left
+                    || value == XLAlignmentHorizontalValues.Right
+                    || value == XLAlignmentHorizontalValues.Distributed
+                    );
+
+                if (updateIndent)
+                    indent = 0;
+
+                horizontal = value;
+
+                if (range != null) range.ProcessCells(c =>
+                {
+                    if (updateIndent)
+                        c.CellStyle.Alignment.indent = 0;
+
+                    c.CellStyle.Alignment.horizontal = value;
+                });
+            }
+        }
+
+        private XLAlignmentVerticalValues vertical;
+        public XLAlignmentVerticalValues Vertical
+        {
+            get { return vertical; }
+            set
+            {
+                vertical = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Alignment.vertical = value);
+            }
+        }
+
+        private UInt32 indent;
+        public UInt32 Indent
+        {
+            get
+            {
+                return indent;
+            }
+            set
+            {
+                if (value > 0 && !(
+                    Horizontal == XLAlignmentHorizontalValues.Left
+                    || Horizontal == XLAlignmentHorizontalValues.Right
+                    || Horizontal == XLAlignmentHorizontalValues.Distributed
+                    ))
+                {
+                    throw new ArgumentException("For indents, only left, right, and distributed horizontal alignments are supported.");
+                }
+                indent = value;
+
+                if (range != null) range.ProcessCells(c =>
+                {
+                    if (value > 0 && !(
+                        c.CellStyle.Alignment.horizontal == XLAlignmentHorizontalValues.Left
+                        || c.CellStyle.Alignment.horizontal == XLAlignmentHorizontalValues.Right
+                        || c.CellStyle.Alignment.horizontal == XLAlignmentHorizontalValues.Distributed
+                        ))
+                    {
+                        throw new ArgumentException("For indents, only left, right, and distributed horizontal alignments are supported. Change the horizontal alignment for all cells in the range.");
+                    }
+
+                    c.CellStyle.Alignment.indent = value;
+                });
+            }
+        }
+
+        private Boolean justifyLastLine;
+        public Boolean JustifyLastLine
+        {
+            get { return justifyLastLine; }
+            set
+            {
+                justifyLastLine = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Alignment.justifyLastLine = value);
+            }
+        }
+
+        private XLAlignmentReadingOrderValues readingOrder;
+        public XLAlignmentReadingOrderValues ReadingOrder
+        {
+            get { return readingOrder; }
+            set
+            {
+                readingOrder = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Alignment.readingOrder = value);
+            }
+        }
+
+        private Int32 relativeIndent;
+        public Int32 RelativeIndent
+        {
+            get { return relativeIndent; }
+            set
+            {
+                relativeIndent = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Alignment.relativeIndent = value);
+            }
+        }
+
+        private Boolean shrinkToFit;
+        public Boolean ShrinkToFit
+        {
+            get { return shrinkToFit; }
+            set
+            {
+                shrinkToFit = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Alignment.shrinkToFit = value);
+            }
+        }
+
+        private UInt32 textRotation;
+        public UInt32 TextRotation
+        {
+            get
+            {
+                return textRotation;
+            }
+            set
+            {
+                if (value > 180)
+                    throw new ArgumentException("TextRotation degree cannot be greater than 180.");
+                else
+                {
+                    textRotation = value;
+                    if (range != null) range.ProcessCells(c => c.CellStyle.Alignment.textRotation = value);
+                }
+            }
+        }
+
+        private Boolean wrapText;
+        public Boolean WrapText
+        {
+            get { return wrapText; }
+            set
+            {
+                wrapText = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Alignment.wrapText = value);
+            }
+        }
+
+        public Boolean TopToBottom
+        {
+            get
+            {
+                return textRotation == 255;
+            }
+            set
+            {
+                if (value)
+                {
+                    textRotation = 255;
+                    if (range != null) range.ProcessCells(c => c.CellStyle.Alignment.textRotation = 255);
+                }
+                else
+                {
+                    textRotation = 0;
+                    if (range != null) range.ProcessCells(c => c.CellStyle.Alignment.textRotation = 0);
+                }
+
+            }
+        }
+
+        #endregion
+
+        #region Constructors
+
+        public XLAlignment(XLAlignment defaultAlignment, XLRange range)
+        {
+            this.range = range;
+            if (defaultAlignment != null)
+            {
+                horizontal = defaultAlignment.horizontal;
+                Vertical = defaultAlignment.Vertical;
+                indent = defaultAlignment.indent;
+                JustifyLastLine = defaultAlignment.JustifyLastLine;
+                ReadingOrder = defaultAlignment.ReadingOrder;
+                RelativeIndent = defaultAlignment.RelativeIndent;
+                ShrinkToFit = defaultAlignment.ShrinkToFit;
+                textRotation = defaultAlignment.textRotation;
+                WrapText = defaultAlignment.WrapText;
+            }
+        }
+
+        #endregion
+
+        #region Overridden
+
+        public override string ToString()
+        {
+            return
+                Horizontal.ToString()
+                + "-" + Vertical.ToString()
+                + "-" + Indent.ToString()
+                + "-" + JustifyLastLine.ToString()
+                + "-" + ReadingOrder.ToString()
+                + "-" + RelativeIndent.ToString()
+                + "-" + ShrinkToFit.ToString()
+                + "-" + textRotation.ToString()
+                + "-" + WrapText.ToString()
+                ;
+        }
+
+        #endregion
+    }
+}
diff --git a/ClosedXML/ClosedXML/Excel/Style/XLBorder.cs b/ClosedXML/ClosedXML/Excel/Style/XLBorder.cs
new file mode 100644
index 0000000..eb785a4
--- /dev/null
+++ b/ClosedXML/ClosedXML/Excel/Style/XLBorder.cs
@@ -0,0 +1,212 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel.Style
+{
+    public enum XLBorderStyleValues
+    {
+        DashDot,
+        DashDotDot,
+        Dashed,
+        Dotted,
+        Double,
+        Hair,
+        Medium,
+        MediumDashDot,
+        MediumDashDotDot,
+        MediumDashed,
+        None,
+        SlantDashDot,
+        Thick,
+        Thin
+    }
+
+    public class XLBorder
+    {
+        #region Properties
+
+        private XLRange range;
+
+        private XLBorderStyleValues leftBorder;
+        public XLBorderStyleValues LeftBorder
+        {
+            get { return leftBorder; }
+            set
+            {
+                leftBorder = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Border.leftBorder = value);
+            }
+        }
+
+        private String leftBorderColor;
+        public String LeftBorderColor
+        {
+            get { return leftBorderColor; }
+            set
+            {
+                leftBorderColor = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Border.leftBorderColor = value);
+            }
+        }
+
+        private XLBorderStyleValues rightBorder;
+        public XLBorderStyleValues RightBorder
+        {
+            get { return rightBorder; }
+            set
+            {
+                rightBorder = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Border.rightBorder = value);
+            }
+        }
+
+        private String rightBorderColor;
+        public String RightBorderColor
+        {
+            get { return rightBorderColor; }
+            set
+            {
+                rightBorderColor = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Border.rightBorderColor = value);
+            }
+        }
+
+        private XLBorderStyleValues topBorder;
+        public XLBorderStyleValues TopBorder
+        {
+            get { return topBorder; }
+            set
+            {
+                topBorder = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Border.topBorder = value);
+            }
+        }
+
+        private String topBorderColor;
+        public String TopBorderColor
+        {
+            get { return topBorderColor; }
+            set
+            {
+                topBorderColor = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Border.topBorderColor = value);
+            }
+        }
+
+        private XLBorderStyleValues bottomBorder;
+        public XLBorderStyleValues BottomBorder
+        {
+            get { return bottomBorder; }
+            set
+            {
+                bottomBorder = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Border.bottomBorder = value);
+            }
+        }
+
+        private String bottomBorderColor;
+        public String BottomBorderColor
+        {
+            get { return bottomBorderColor; }
+            set
+            {
+                bottomBorderColor = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Border.bottomBorderColor = value);
+            }
+        }
+
+        private Boolean diagonalUp;
+        public Boolean DiagonalUp
+        {
+            get { return diagonalUp; }
+            set
+            {
+                diagonalUp = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Border.diagonalUp = value);
+            }
+        }
+
+        private Boolean diagonalDown;
+        public Boolean DiagonalDown
+        {
+            get { return diagonalDown; }
+            set
+            {
+                diagonalDown = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Border.diagonalDown = value);
+            }
+        }
+
+        private XLBorderStyleValues diagonalBorder;
+        public XLBorderStyleValues DiagonalBorder
+        {
+            get { return diagonalBorder; }
+            set
+            {
+                diagonalBorder = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Border.diagonalBorder = value);
+            }
+        }
+
+        private String diagonalBorderColor;
+        public String DiagonalBorderColor
+        {
+            get { return diagonalBorderColor; }
+            set
+            {
+                diagonalBorderColor = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Border.diagonalBorderColor = value);
+            }
+        }
+
+        #endregion
+
+        #region Constructors
+
+        public XLBorder(XLBorder defaultBorder, XLRange range)
+        {
+            this.range = range;
+            if (defaultBorder != null)
+            {
+                LeftBorder = defaultBorder.LeftBorder;
+                LeftBorderColor = defaultBorder.LeftBorderColor;
+                RightBorder = defaultBorder.RightBorder;
+                RightBorderColor = defaultBorder.RightBorderColor;
+                TopBorder = defaultBorder.TopBorder;
+                TopBorderColor = defaultBorder.TopBorderColor;
+                BottomBorder = defaultBorder.BottomBorder;
+                BottomBorderColor = defaultBorder.BottomBorderColor;
+                DiagonalBorder = defaultBorder.DiagonalBorder;
+                DiagonalBorderColor = defaultBorder.DiagonalBorderColor;
+                DiagonalUp = defaultBorder.DiagonalUp;
+                DiagonalDown = defaultBorder.DiagonalDown;
+            }
+        }
+
+        #endregion
+
+        #region Overridden
+
+        public override string ToString()
+        {
+            return
+                LeftBorder.ToString() + "-" +
+                LeftBorderColor.ToString() + "-" +
+                RightBorder.ToString() + "-" +
+                RightBorderColor.ToString() + "-" +
+                TopBorder.ToString() + "-" +
+                TopBorderColor.ToString() + "-" +
+                BottomBorder.ToString() + "-" +
+                BottomBorderColor.ToString() + "-" +
+                DiagonalBorder.ToString() + "-" +
+                DiagonalBorderColor.ToString() + "-" +
+                DiagonalUp.ToString() + "-" +
+                DiagonalDown.ToString();
+
+        }
+
+        #endregion
+    }
+}
diff --git a/ClosedXML/ClosedXML/Excel/Style/XLFill.cs b/ClosedXML/ClosedXML/Excel/Style/XLFill.cs
new file mode 100644
index 0000000..e35dc2f
--- /dev/null
+++ b/ClosedXML/ClosedXML/Excel/Style/XLFill.cs
@@ -0,0 +1,126 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel.Style
+{
+    public enum XLFillPatternValues
+    {
+        DarkDown,
+        DarkGray,
+        DarkGrid,
+        DarkHorizontal,
+        DarkTrellis,
+        DarkUp,
+        DarkVertical,
+        Gray0625,
+        Gray125,
+        LightDown,
+        LightGray,
+        LightGrid,
+        LightHorizontal,
+        LightTrellis,
+        LightUp,
+        LightVertical,
+        MediumGray,
+        None,
+        Solid
+    }
+
+    public class XLFill
+    {
+        #region Properties
+
+        private XLRange range;
+
+        public String BackgroundColor
+        {
+            get
+            {
+                return patternColor;
+            }
+            set
+            {
+                patternType = XLFillPatternValues.Solid;
+                patternColor = value;
+                patternBackgroundColor = value;
+                if (range != null) range.ProcessCells(c =>
+                {
+                    c.CellStyle.Fill.patternType = XLFillPatternValues.Solid;
+                    c.CellStyle.Fill.patternColor = value;
+                    c.CellStyle.Fill.patternBackgroundColor = value;
+                });
+            }
+        }
+
+
+        private String patternColor;
+        public String PatternColor
+        {
+            get
+            {
+                return patternColor;
+            }
+            set
+            {
+                this.patternColor = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Fill.patternColor = value);
+            }
+        }
+
+        private String patternBackgroundColor;
+        public String PatternBackgroundColor
+        {
+            get
+            {
+                return patternBackgroundColor;
+            }
+            set
+            {
+                this.patternBackgroundColor = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Fill.patternBackgroundColor = value);
+            }
+        }
+
+        private XLFillPatternValues patternType;
+        public XLFillPatternValues PatternType
+        {
+            get
+            {
+                return patternType;
+            }
+            set
+            {
+                this.patternType = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Fill.patternType = value);
+            }
+        }
+
+        #endregion
+
+        #region Constructors
+
+        public XLFill(XLFill defaultFill, XLRange range)
+        {
+            this.range = range;
+            if (defaultFill != null)
+            {
+                PatternType = defaultFill.PatternType;
+                PatternColor = defaultFill.PatternColor;
+                PatternBackgroundColor = defaultFill.PatternBackgroundColor;
+            }
+        }
+
+        #endregion
+
+        #region Overridden
+
+        public override string ToString()
+        {
+            return BackgroundColor.ToString() + "-" + PatternType.ToString() + "-" + PatternColor.ToString();
+        }
+
+        #endregion
+    }
+}
diff --git a/ClosedXML/ClosedXML/Excel/Style/XLFont.cs b/ClosedXML/ClosedXML/Excel/Style/XLFont.cs
new file mode 100644
index 0000000..7b33f0d
--- /dev/null
+++ b/ClosedXML/ClosedXML/Excel/Style/XLFont.cs
@@ -0,0 +1,214 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel.Style
+{
+    public enum XLFontUnderlineValues
+    {
+        Double,
+        DoubleAccounting,
+        None,
+        Single,
+        SingleAccounting
+    }
+
+    public enum XLFontVerticalTextAlignmentValues
+    {
+        Baseline,
+        Subscript,
+        Superscript
+    }
+
+    public class XLFont
+    {
+        #region Properties
+
+        private XLRange range;
+
+        private Boolean bold;
+        public Boolean Bold
+        {
+            get
+            {
+                return bold;
+            }
+            set
+            {
+                this.bold = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Font.bold = value);
+            }
+        }
+
+        private Boolean italic;
+        public Boolean Italic
+        {
+            get
+            {
+                return italic;
+            }
+            set
+            {
+                this.italic = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Font.italic = value);
+            }
+        }
+
+        private XLFontUnderlineValues underline;
+        public XLFontUnderlineValues Underline
+        {
+            get
+            {
+                return underline;
+            }
+            set
+            {
+                this.underline = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Font.underline = value);
+            }
+        }
+
+        private Boolean strikethrough;
+        public Boolean Strikethrough
+        {
+            get
+            {
+                return strikethrough;
+            }
+            set
+            {
+                this.strikethrough = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Font.strikethrough = value);
+            }
+        }
+
+        private XLFontVerticalTextAlignmentValues verticalAlignment;
+        public XLFontVerticalTextAlignmentValues VerticalAlignment
+        {
+            get
+            {
+                return verticalAlignment;
+            }
+            set
+            {
+                this.verticalAlignment = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Font.verticalAlignment = value);
+            }
+        }
+
+        private Boolean shadow;
+        public Boolean Shadow
+        {
+            get
+            {
+                return shadow;
+            }
+            set
+            {
+                this.shadow = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Font.shadow = value);
+            }
+        }
+
+        private Double fontSize;
+        public Double FontSize
+        {
+            get
+            {
+                return fontSize;
+            }
+            set
+            {
+                this.fontSize = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Font.fontSize = value);
+            }
+        }
+
+        private String color;
+        public String Color
+        {
+            get
+            {
+                return color;
+            }
+            set
+            {
+                this.color = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Font.color = value);
+
+            }
+        }
+
+        private String fontName;
+        public String FontName
+        {
+            get
+            {
+                return fontName;
+            }
+            set
+            {
+                this.fontName = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Font.fontName = value);
+            }
+        }
+
+        private Int32 fontFamilyNumbering;
+        public Int32 FontFamilyNumbering
+        {
+            get
+            {
+                return fontFamilyNumbering;
+            }
+            set
+            {
+                this.fontFamilyNumbering = value;
+                if (range != null) range.ProcessCells(c => c.CellStyle.Font.fontFamilyNumbering = value);
+            }
+        }
+
+        #endregion
+
+        #region Constructors
+
+        public XLFont(XLFont defaultFont, XLRange range)
+        {
+            this.range = range;
+            if (defaultFont != null)
+            {
+                Bold = defaultFont.Bold;
+                Italic = defaultFont.Italic;
+                Underline = defaultFont.Underline;
+                Strikethrough = defaultFont.Strikethrough;
+                VerticalAlignment = defaultFont.VerticalAlignment;
+                Shadow = defaultFont.Shadow;
+                FontFamilyNumbering = defaultFont.FontFamilyNumbering;
+                FontName = defaultFont.FontName;
+                FontSize = defaultFont.FontSize;
+                Color = defaultFont.Color;
+            }
+        }
+
+        #endregion
+
+        #region Overridden
+
+        public override string ToString()
+        {
+            StringBuilder sb = new StringBuilder();
+            sb.Append(Bold.ToString());
+            sb.Append("-");
+            sb.Append(FontSize.ToString());
+            sb.Append("-");
+            sb.Append(Color);
+            sb.Append("-");
+            sb.Append(FontName);
+            sb.Append("-");
+            sb.Append(FontFamilyNumbering.ToString());
+            return sb.ToString();
+        }
+
+        #endregion
+    }
+}
diff --git a/ClosedXML/ClosedXML/Excel/Style/XLNumberFormat.cs b/ClosedXML/ClosedXML/Excel/Style/XLNumberFormat.cs
new file mode 100644
index 0000000..bd61b3d
--- /dev/null
+++ b/ClosedXML/ClosedXML/Excel/Style/XLNumberFormat.cs
@@ -0,0 +1,74 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML.Excel.Style
+{
+    public class XLNumberFormat
+    {
+        #region Properties
+
+        private XLRange range;
+
+        private UInt32? numberFormatId;
+        public UInt32? NumberFormatId
+        {
+            get { return numberFormatId; }
+            set
+            {
+                numberFormatId = value;
+                format = String.Empty;
+                if (range != null) range.ProcessCells(c =>
+                {
+                    c.CellStyle.NumberFormat.numberFormatId = value;
+                    c.CellStyle.NumberFormat.format = String.Empty;
+                });
+            }
+        }
+
+        private String format = String.Empty;
+        public String Format
+        {
+            get { return format; }
+            set
+            {
+                format = value;
+                numberFormatId = null;
+                if (range != null) range.ProcessCells(c =>
+                {
+                    c.CellStyle.NumberFormat.numberFormatId = null;
+                    c.CellStyle.NumberFormat.format = value;
+                });
+            }
+        }
+
+        #endregion
+
+        #region Constructors
+
+        public XLNumberFormat(XLNumberFormat numberFormat, XLRange range)
+        {
+            this.range = range;
+            if (numberFormat != null)
+            {
+                if (numberFormat.numberFormatId.HasValue)
+                    NumberFormatId = numberFormat.NumberFormatId.Value;
+                else
+                    Format = numberFormat.Format;
+            }
+        }
+
+        #endregion
+
+        #region Overridden
+
+        public override string ToString()
+        {
+            String numberFormatIdString = numberFormatId.HasValue ? numberFormatId.Value.ToString() : "n/a";
+            return numberFormatIdString + "-" + format.ToString();
+        }
+
+        #endregion
+    }
+}
diff --git a/ClosedXML/ClosedXML/Excel/Style/XLStyle.cs b/ClosedXML/ClosedXML/Excel/Style/XLStyle.cs
new file mode 100644
index 0000000..162b6c2
--- /dev/null
+++ b/ClosedXML/ClosedXML/Excel/Style/XLStyle.cs
@@ -0,0 +1,50 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using DocumentFormat.OpenXml.Spreadsheet;
+
+namespace ClosedXML.Excel.Style
+{
+    public class XLStyle
+    {
+        XLRange range;
+        public XLStyle(XLStyle initialStyle, XLRange range)
+        {
+            this.range = range;
+            if (initialStyle != null)
+            {
+                Font = new XLFont(initialStyle.Font, range);
+                Fill = new XLFill(initialStyle.Fill, range);
+                Border = new XLBorder(initialStyle.Border, range);
+                NumberFormat = new XLNumberFormat(initialStyle.NumberFormat, range);
+                Alignment = new XLAlignment(initialStyle.Alignment, range);
+            }
+            else
+            {
+                Font = new XLFont(null, range);
+                Fill = new XLFill(null, range);
+                Border = new XLBorder(null, range);
+                NumberFormat = new XLNumberFormat(null, range);
+                Alignment = new XLAlignment(null, range);
+            }
+        }
+
+        public XLFont Font { get; set; }
+        public XLFill Fill { get; set; }
+        public XLBorder Border { get; set; }
+        public XLNumberFormat NumberFormat { get; set; }
+        public XLAlignment Alignment { get; set; }
+
+        public override string ToString()
+        {
+            return
+                "Font:" + Font.ToString()
+                + " Fill:" + Fill.ToString()
+                + " Border:" + Border.ToString()
+                + " NumberFormat: " + NumberFormat.ToString()
+                + " Alignment: " + Alignment.ToString();
+        }
+
+    }
+}
\ No newline at end of file
diff --git a/ClosedXML/ClosedXML/Excel/XLAddress.cs b/ClosedXML/ClosedXML/Excel/XLAddress.cs
new file mode 100644
index 0000000..48cfde4
--- /dev/null
+++ b/ClosedXML/ClosedXML/Excel/XLAddress.cs
@@ -0,0 +1,228 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Text.RegularExpressions;
+
+namespace ClosedXML.Excel
+{
+    public struct XLAddress : IEqualityComparer<XLAddress>, IEquatable<XLAddress>, IComparable, IComparable<XLAddress>
+    {
+        #region Constructors
+        public XLAddress(UInt32 row, UInt32 column)
+        {
+            this.row = row;
+            this.column = column;
+            this.columnLetter = ColumnNumberToLetter(column);
+        }
+
+        public XLAddress(UInt32 row, String columnLetter)
+        {
+            this.row = row;
+            this.column = ColumnLetterToNumber(columnLetter);
+            this.columnLetter = columnLetter;
+        }
+
+        public XLAddress(String cellAddressString)
+        {
+            Match m = Regex.Match(cellAddressString, @"^([a-zA-Z]+)(\d+)$");
+            columnLetter = m.Groups[1].Value;
+            this.row = UInt32.Parse(m.Groups[2].Value);
+            this.column = ColumnLetterToNumber(columnLetter);
+        }
+        #endregion
+
+        private UInt32 row;
+        public UInt32 Row
+        {
+            get { return row; }
+            private set { row = value; }
+        }
+
+        private UInt32 column;
+        public UInt32 Column
+        {
+            get { return column; }
+            private set { column = value; }
+        }
+
+        private String columnLetter;
+        public String ColumnLetter
+        {
+            get { return columnLetter; }
+            private set { columnLetter = value; }
+        }
+
+        public static UInt32 ColumnLetterToNumber(String column)
+        {
+            Int32 intColumnLetterLength = column.Length;
+            Int32 retVal = 0;
+            for (Int32 intCount = 0; intCount < intColumnLetterLength; intCount++)
+            {
+                retVal = retVal * 26 + (column.Substring(intCount, 1).ToUpper().ToCharArray()[0] - 64);
+            }
+            return (UInt32)retVal;
+        }
+
+        public static String ColumnNumberToLetter(UInt32 column)
+        {
+            String s = String.Empty;
+            for (
+                Int32 i = Convert.ToInt32(
+                    Math.Log(
+                        Convert.ToDouble(
+                            25 * (
+                                Convert.ToDouble(column)
+                                + 1
+                            )
+                         )
+                     ) / Math.Log(26)
+                 ) - 1
+                ; i >= 0
+                ; i--
+                )
+            {
+                Int32 x = Convert.ToInt32(Math.Pow(26, i + 1) - 1) / 25 - 1;
+                if (column > x)
+                {
+                    s += (Char)(((column - x - 1) / Convert.ToInt32(Math.Pow(26, i))) % 26 + 65);
+                }
+            }
+            return s;
+        }
+
+        public override String ToString()
+        {
+            return ColumnLetter + Row.ToString();
+        }
+
+        #region Operator Overloads
+
+        public static XLAddress operator +(XLAddress xlCellAddressLeft, XLAddress xlCellAddressRight)
+        {
+            return new XLAddress(xlCellAddressLeft.Row + xlCellAddressRight.Row, xlCellAddressLeft.Column + xlCellAddressRight.Column);
+        }
+
+        public static XLAddress operator -(XLAddress xlCellAddressLeft, XLAddress xlCellAddressRight)
+        {
+            return new XLAddress(xlCellAddressLeft.Row - xlCellAddressRight.Row, xlCellAddressLeft.Column - xlCellAddressRight.Column);
+        }
+
+        public static XLAddress operator +(XLAddress xlCellAddressLeft, UInt32 right)
+        {
+            return new XLAddress(xlCellAddressLeft.Row + right, xlCellAddressLeft.Column + right);
+        }
+
+        public static XLAddress operator -(XLAddress xlCellAddressLeft, UInt32 right)
+        {
+            return new XLAddress(xlCellAddressLeft.Row - right, xlCellAddressLeft.Column - right);
+        }
+
+        public static Boolean operator ==(XLAddress xlCellAddressLeft, XLAddress xlCellAddressRight)
+        {
+            return
+                xlCellAddressLeft.Row == xlCellAddressRight.Row
+                && xlCellAddressLeft.Column == xlCellAddressRight.Column;
+        }
+
+        public static Boolean operator !=(XLAddress xlCellAddressLeft, XLAddress xlCellAddressRight)
+        {
+            return !(xlCellAddressLeft == xlCellAddressRight);
+        }
+
+        public static Boolean operator >(XLAddress xlCellAddressLeft, XLAddress xlCellAddressRight)
+        {
+            return !(xlCellAddressLeft == xlCellAddressRight)
+                && (xlCellAddressLeft.Row > xlCellAddressRight.Row || xlCellAddressLeft.Column > xlCellAddressRight.Column);
+        }
+
+        public static Boolean operator <(XLAddress xlCellAddressLeft, XLAddress xlCellAddressRight)
+        {
+            return !(xlCellAddressLeft == xlCellAddressRight)
+                && (xlCellAddressLeft.Row < xlCellAddressRight.Row || xlCellAddressLeft.Column < xlCellAddressRight.Column);
+        }
+
+        public static Boolean operator >=(XLAddress xlCellAddressLeft, XLAddress xlCellAddressRight)
+        {
+            return xlCellAddressLeft == xlCellAddressRight || xlCellAddressLeft > xlCellAddressRight;
+        }
+
+        public static Boolean operator <=(XLAddress xlCellAddressLeft, XLAddress xlCellAddressRight)
+        {
+            return xlCellAddressLeft == xlCellAddressRight || xlCellAddressLeft < xlCellAddressRight;
+        }
+
+        #endregion
+
+        #region Interface Requirements
+
+        #region IEqualityComparer<XLCellAddress> Members
+
+        public Boolean Equals(XLAddress x, XLAddress y)
+        {
+            return x == y;
+        }
+
+        public Int32 GetHashCode(XLAddress obj)
+        {
+            return obj.GetHashCode();
+        }
+
+        new public Boolean Equals(Object x, Object y)
+        {
+            return x == y;
+        }
+
+        public Int32 GetHashCode(Object obj)
+        {
+            return obj.GetHashCode();
+        }
+
+        public override Int32 GetHashCode()
+        {
+            return this.ToString().GetHashCode();
+        }
+
+        #endregion
+
+        #region IEquatable<XLCellAddress> Members
+
+        public Boolean Equals(XLAddress other)
+        {
+            return this == other;
+        }
+
+        public override Boolean Equals(Object other)
+        {
+            return this == (XLAddress)other;
+        }
+
+        #endregion
+
+        #region IComparable Members
+
+        public Int32 CompareTo(object obj)
+        {
+            var other = (XLAddress)obj;
+            if (this == other)
+                return 0;
+            else if (this > other)
+                return 1;
+            else
+                return -1;
+        }
+
+        #endregion
+
+        #region IComparable<XLCellAddress> Members
+
+        public int CompareTo(XLAddress other)
+        {
+            throw new NotImplementedException();
+        }
+
+        #endregion
+
+        #endregion
+    }
+}
diff --git a/ClosedXML/ClosedXML/Excel/XLRange.cs b/ClosedXML/ClosedXML/Excel/XLRange.cs
index b6bc1a1..b862259 100644
--- a/ClosedXML/ClosedXML/Excel/XLRange.cs
+++ b/ClosedXML/ClosedXML/Excel/XLRange.cs
@@ -2,197 +2,288 @@
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
+using ClosedXML.Excel.Style;
 
 namespace ClosedXML.Excel
 {
-    public enum CellContent { All, WithValues }
+    public enum XLCellValues { SharedString, Number, Boolean, DateTime }
+
     public class XLRange
     {
-        private XLCell firstCell { get; set; }
-        public XLCell FirstCell()
-        {
-            return FirstCell(CellContent.All);
-        }
-        public XLCell FirstCell(CellContent cellContent)
-        {
-            if (cellContent == CellContent.WithValues)
-            {
-                var cellsWithValues = Cells(cellContent);
-                var minAddress = cellsWithValues.Min(c => c.CellAddress);
-                return new XLCell(this.workbook, minAddress);
-            }
-            else
-            {
-                return firstCell;
-            }
-        }
-
-        private XLCell lastCell { get; set; }
-        public XLCell LastCell()
-        {
-            return LastCell(CellContent.All);
-        }
-        public XLCell LastCell(CellContent cellContent)
-        {
-            if (cellContent == CellContent.WithValues)
-            {
-                var cellsWithValues = Cells(cellContent);
-                var maxAddress = cellsWithValues.Max(c => c.CellAddress);
-                return new XLCell(this.workbook, maxAddress);
-            }
-            else
-            {
-                return lastCell;
-            }
-        }
-
-        private XLCells cellData;
+        private Dictionary<XLAddress, XLRange> worksheetCells;
+        public Boolean IsWorksheet { get; private set; }
+        public Boolean IsCell { get; private set; }
+        private XLRange Worksheet { get; set; }
         public XLRange ParentRange { get; private set; }
-        protected XLWorkbook workbook;
-
-        internal XLRange(XLCell firstCell, XLCell lastCell, XLCells cellData, XLRange parentRange)
+        private String worksheetName;
+        public String Name { get { return ToString(); } }
+        private Boolean isInitializing;
+        private XLWorkbook workbook;
+        public XLRange(XLAddress firstCellAddress, XLAddress lastCellAddress, XLRange parentRange, XLRange worksheet, String name = "", XLWorkbook workbook=null)
         {
-            this.cellData = cellData;
-            this.firstCell = firstCell;
-            this.lastCell = lastCell;
-            this.ParentRange = parentRange;
-            this.workbook = parentRange == null ? null : parentRange.workbook;
-        }
+            isInitializing = true;
+            this.worksheetName = name;
+            this.workbook = workbook;
+            FirstCellAddress = firstCellAddress;
+            LastCellAddress = lastCellAddress;
+            IsCell = firstCellAddress == lastCellAddress;
 
-        public XLCell Cell(UInt32 row, String column)
-        {
-            return Cell(column + row.ToString());
-        }
-
-        public XLCell Cell(UInt32 row, UInt32 column)
-        {
-            XLCellAddress cellAddress = new XLCellAddress(row-1, column-1) + firstCell.CellAddress;
-            return cellData[cellAddress];
-        }
-
-        public XLCell Cell(String cellAddressString)
-        {
-            XLCellAddress cellAddress = new XLCellAddress(cellAddressString);
-            return cellData[cellAddress];
-        }
-
-        public XLRange Range(XLCell firstCell, XLCell lastCell)
-        {
-            return new XLRange(firstCell, lastCell, cellData, this);
-        }
-
-        public XLRange Range(String range)
-        {
-            String[] ranges = range.Split(':');
-            XLCell firstCell = new XLCell(workbook, ranges[0] );
-            XLCell lastCell = new XLCell(workbook, ranges[1] );
-            return Range(firstCell, lastCell);
-        }
-
-        public Boolean HasData { get { return cellData.Any(); } }
-
-
-        public UInt32 CellCount()
-        {
-            return CellCount(CellContent.All);
-        }
-        public UInt32 CellCount(CellContent cellContent)
-        {
-            return (UInt32)Cells(cellContent).Count;
-        }
-
-        public UInt32 Row { get { return firstCell.Row; } }
-        public List<XLRange> Rows()
-        {
-            return Rows(CellContent.All);
-        }
-        public List<XLRange> Rows(CellContent cellContent)
-        {
-            if (cellContent == CellContent.WithValues)
+            ParentRange = parentRange;
+            if (worksheet != null)
             {
-                var cellsWithValues = Cells(CellContent.WithValues);
-                var distinct = cellsWithValues.Select(c => c.Row).Distinct();
-                var rows = from d in distinct
-                           select new XLRange(
-                                  new XLCell(workbook, new XLCellAddress(d, 1))
-                                , new XLCell(workbook, new XLCellAddress(d, XLWorksheet.MaxNumberOfColumns))
-                                , cellData, this);
-                return rows.ToList();
+                IsWorksheet = false;
+                Worksheet = worksheet;
+                CellStyle = new XLStyle(parentRange.CellStyle, this);
             }
             else
             {
-                var distinct = Cells().Select(c => c.Row).Distinct();
-                var rows = from d in distinct
-                           select new XLRange(
-                                  new XLCell(workbook, new XLCellAddress(d, 1))
-                                , new XLCell(workbook, new XLCellAddress(d, XLWorksheet.MaxNumberOfColumns))
-                                , cellData, this);
-                return rows.ToList();
+                IsWorksheet = true;
+                worksheetCells = new Dictionary<XLAddress, XLRange>();
+                Worksheet = this;
+                var defaultStyle = new XLStyle(workbook.WorkbookStyle, this);
+
+                CellStyle = defaultStyle;
             }
+            isInitializing = false;
         }
-        public UInt32 RowCount()
+
+        public XLAddress Address { get { return FirstCellAddress; } }
+
+        private XLAddress FirstCellAddress { get; set; }
+        public XLRange FirstCell
         {
-            return RowCount(CellContent.All);
-        }
-        public UInt32 RowCount(CellContent cellContent)
-        {
-            if (cellContent == CellContent.WithValues)
+            get
             {
-                var cellsWithValues = Cells(CellContent.WithValues);
-                var distinct = cellsWithValues.Select(c => c.Row).Distinct();
-                return (UInt32)(distinct.Count());
-            }
-            else
-            {
-                return (lastCell.CellAddress - firstCell.CellAddress).Row + 1;
+                return Cell(FirstCellAddress);
             }
         }
 
-        public UInt32 Column { get { return firstCell.Column; } }
-        public UInt32 ColumnCount()
+        private XLAddress LastCellAddress { get; set; }
+        public XLRange LastCell
         {
-            return ColumnCount(CellContent.All);
-        }
-        public UInt32 ColumnCount(CellContent cellContent)
-        {
-            if (cellContent == CellContent.WithValues)
+            get
             {
-                var cellsWithValues = Cells(CellContent.WithValues);
-                var distinct = cellsWithValues.Select(c => c.Column).Distinct();
-                return (UInt32)(distinct.Count());
-            }
-            else
-            {
-                return (lastCell.CellAddress - firstCell.CellAddress).Column + 1;
+                return Cell(LastCellAddress);
             }
         }
 
-        public virtual List<XLCell> Cells()
+        public XLAddress AddressInWorksheet { get { return FirstCellAddressInWorksheet; } }
+
+        private XLAddress FirstCellAddressInWorksheet
         {
-            return Cells(CellContent.All);
+            get
+            {
+                if (IsWorksheet || ParentRange.IsWorksheet)
+                    return FirstCellAddress;
+                else
+                    return FirstCellAddress + ParentRange.FirstCellAddressInWorksheet - 1;
+            }
         }
 
-        public virtual List<XLCell> Cells(CellContent cellContent)
+        private XLAddress LastCellAddressAbsolute
         {
-            if (cellContent == CellContent.WithValues)
+            get
             {
-                return cellData
-                        .Where(c => c.HasValue && c.CellAddress >= this.firstCell.CellAddress && c.CellAddress <= lastCell.CellAddress)
-                        .OrderBy(x => x.CellAddress)
-                        .ToList();
+                if (IsWorksheet || ParentRange.IsWorksheet)
+                    return LastCellAddress;
+                else
+                    return ParentRange.FirstCellAddressInWorksheet + LastCellAddress - 1;
             }
+        }
+
+        public XLRange Range(XLAddress firstCellAddress, XLAddress lastCellAddress)
+        {
+            if (lastCellAddress > (LastCellAddress - FirstCellAddress + 1))
+                throw new IndexOutOfRangeException("Cell addresses must be within parent range.");
+
+            return new XLRange(firstCellAddress, lastCellAddress, this, Worksheet);
+        }
+
+        public XLRange Range(String firstCellAddress, String lastCellAddress)
+        {
+            return Range(new XLAddress(firstCellAddress), new XLAddress(lastCellAddress));
+        }
+
+        public XLRange Cell(XLAddress address)
+        {
+            XLAddress absoluteCellAddress;
+            if (IsWorksheet || ParentRange.IsWorksheet)
+                absoluteCellAddress = address;
             else
+                absoluteCellAddress = ParentRange.FirstCellAddressInWorksheet + address - 1;
+
+            var cell = Worksheet.GetCell(absoluteCellAddress);
+            return cell;
+        }
+
+        public XLRange Cell(String addressString)
+        {
+            var cellAddress = new XLAddress(addressString);
+            return Cell(cellAddress);
+        }
+
+        public XLRange Cell(UInt32 row, UInt32 column)
+        {
+            var cellAddress = new XLAddress(row, column);
+            return Cell(cellAddress);
+        }
+
+        protected XLRange GetCell(XLAddress cellAddress)
+        {
+            if (!worksheetCells.ContainsKey(cellAddress))
             {
-                List<XLCell> retVal = new List<XLCell>();
-                for (UInt32 row = firstCell.Row; row <= lastCell.Row; row++)
+                worksheetCells.Add(cellAddress, new XLRange(cellAddress, cellAddress, this, this));
+            }
+
+            return worksheetCells[cellAddress];
+        }
+
+        public Boolean HasValue { get; private set; }
+
+        public XLCellValues DataType { get; set; }
+
+        private String cellValue;
+        public String Value 
+        {
+            get
+            {
+                return Worksheet.GetCell(FirstCellAddressInWorksheet).cellValue;
+            }
+            set
+            {
+                String val = value;
+
+                Double dTest;
+                DateTime dtTest;
+                Boolean bTest;
+                if (Double.TryParse(val, out dTest))
                 {
-                    for (UInt32 column = firstCell.Column; column <= lastCell.Column; column++)
+                    DataType = XLCellValues.Number;
+                }
+                else if (DateTime.TryParse(val, out dtTest))
+                {
+                    DataType = XLCellValues.DateTime;
+                    String dateSerial = GetSerialFromDateTime(dtTest).ToString();
+                    Style.NumberFormat.NumberFormatId = 14;
+                    val = dateSerial;
+                }
+                else if (Boolean.TryParse(val, out bTest))
+                {
+                    DataType = XLCellValues.Boolean;
+                    val = bTest ? "1" : "0";
+                }
+                else
+                {
+                    DataType = XLCellValues.SharedString;
+                }
+
+                Worksheet.GetCell(FirstCellAddressInWorksheet).cellValue = val;
+                Worksheet.GetCell(FirstCellAddressInWorksheet).HasValue = !val.Equals(String.Empty);
+            }
+        }
+
+
+        internal XLStyle CellStyle;
+        public XLStyle Style
+        {
+            get
+            {
+                CellStyle = new XLStyle(Worksheet.GetCell(FirstCellAddressInWorksheet).CellStyle, this);
+                return CellStyle;
+            }
+            set
+            {
+                Cells().ForEach(c => c.CellStyle = new XLStyle(value, this));
+            }
+        }
+
+        public IEnumerable<XLRange> Cells()
+        {
+            if (IsWorksheet)
+            {
+                foreach (var cell in worksheetCells.Where(c=>c.Key != LastCellAddress).Select(c=>c.Value))
+                {
+                    yield return cell;
+                }
+            }
+            else
+            {
+                for (UInt32 row = FirstCellAddressInWorksheet.Row; row <= LastCellAddressAbsolute.Row; row++)
+                {
+                    for (UInt32 column = FirstCellAddressInWorksheet.Column; column <= LastCellAddressAbsolute.Column; column++)
                     {
-                        retVal.Add(Cell(row, column));
+                        yield return Worksheet.GetCell(new XLAddress(row, column));
                     }
                 }
-                return retVal;
             }
         }
+
+        private DateTime GetDateTimeFromSerial(Double serialDate)
+        {
+            String sDate = serialDate.ToString();
+            Int32 datePart = Int32.Parse(sDate.Split('.').First());
+            Double timePart = serialDate - (Double)datePart;
+            if (datePart > 59) datePart -= 1; //Excel/Lotus 2/29/1900 bug   
+
+            TimeSpan maxTime = new TimeSpan(0, 23, 59, 59, 999);
+            Double totalMilliseconds = maxTime.TotalMilliseconds * timePart;
+
+            return new DateTime(1899, 12, 31).AddDays(datePart).AddMilliseconds(totalMilliseconds);
+        }
+
+        private Double GetSerialFromDateTime(DateTime dateTime)
+        {
+            Int32 nDay = dateTime.Day;
+            Int32 nMonth = dateTime.Month;
+            Int32 nYear = dateTime.Year;
+
+            // Excel/Lotus 123 have a bug with 29-02-1900. 1900 is not a
+            // leap year, but Excel/Lotus 123 think it is...
+            if (nDay == 29 && nMonth == 02 && nYear == 1900)
+                return 60;
+
+            // DMY to Modified Julian calculatie with an extra substraction of 2415019.
+            long nSerialDate =
+                    (int)((1461 * (nYear + 4800 + (int)((nMonth - 14) / 12))) / 4) +
+                    (int)((367 * (nMonth - 2 - 12 * ((nMonth - 14) / 12))) / 12) -
+                    (int)((3 * ((int)((nYear + 4900 + (int)((nMonth - 14) / 12)) / 100))) / 4) +
+                    nDay - 2415019 - 32075;
+
+            if (nSerialDate < 60)
+            {
+                // Because of the 29-02-1900 bug, any serial date 
+                // under 60 is one off... Compensate.
+                nSerialDate--;
+            }
+
+            TimeSpan timePart = new TimeSpan(dateTime.Hour, dateTime.Minute, dateTime.Second);
+            TimeSpan maxTime = new TimeSpan(0, 23, 59, 59, 999);
+            Double timeRatio = timePart.TotalMilliseconds / maxTime.TotalMilliseconds;
+
+            return (Double)nSerialDate + timeRatio;
+        }
+
+
+
+        internal void ProcessCells(Action<XLRange> action)
+        {
+            if (!(IsWorksheet || isInitializing)) //(IsCell && ParentRange.IsWorksheet)))
+            {
+                Cells().ForEach(c => action(c));
+            }  
+        }
+
+        #region Overridden
+
+        public override string ToString()
+        {
+            if (IsWorksheet)
+                return worksheetName;
+            else
+                return FirstCellAddress.ToString();
+        }
+
+        #endregion
+
     }
 }
diff --git a/ClosedXML/ClosedXML/Excel/XLWorkbook.cs b/ClosedXML/ClosedXML/Excel/XLWorkbook.cs
index 6a81772..7dc9f79 100644
--- a/ClosedXML/ClosedXML/Excel/XLWorkbook.cs
+++ b/ClosedXML/ClosedXML/Excel/XLWorkbook.cs
@@ -3,927 +3,141 @@
 using System.Linq;
 using System.Text;
 using System.IO;
-using DocumentFormat.OpenXml.Packaging;
-using Ap = DocumentFormat.OpenXml.ExtendedProperties;
-using Vt = DocumentFormat.OpenXml.VariantTypes;
-using DocumentFormat.OpenXml;
-using DocumentFormat.OpenXml.Spreadsheet;
-using A = DocumentFormat.OpenXml.Drawing;
-
+using ClosedXML.Excel.Style;
 
 namespace ClosedXML.Excel
 {
-    public class XLWorkbook
+    /// <summary>
+    /// Represents an Excel Workbook file
+    /// </summary>
+    public partial class XLWorkbook
     {
-        public XLWorksheets Worksheets; 
-        public XLSharedStrings SharedStrings = new XLSharedStrings();
+        #region Properties
 
-        public XLWorkbook(String file)
-        {
-            FileInfo fi = new FileInfo(file);
-            workbookName = fi.Name;
-            workbookFullName = fi.FullName;
-            Worksheets = new XLWorksheets(this);
-        }
+        /// <summary>
+        /// Gets an instance of the <see cref="XLWorksheets"/> class.
+        /// It allows you to add, access, and remove worksheets from the workbook.
+        /// </summary>
+        public XLWorksheets Worksheets { get; private set; }
 
-        private String workbookName;
-        public String Name
-        {
-            get { return workbookName; }
-        }
+        /// <summary>
+        /// Gets the file name of the workbook.
+        /// </summary>
+        public String Name { get; private set; }
 
-        private String workbookFullName;
-        public String FullName
-        {
-            get { return workbookFullName; }
-        }
+        /// <summary>
+        /// Gets the file name of the workbook including its full directory.
+        /// </summary>
+        public String FullName { get; private set; }
 
-        public void Save()
-        {
-            if (File.Exists(FullName)) File.Delete(FullName);
-
-            using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(FullName, SpreadsheetDocumentType.Workbook))
-            {
-                CreateParts(spreadsheetDocument);
-            }
-        }
-
-        #region CreateParts
-        // Adds child parts and generates content of the specified part.
-        private void CreateParts(SpreadsheetDocument document)
-        {
-            ExtendedFilePropertiesPart extendedFilePropertiesPart = document.AddNewPart<ExtendedFilePropertiesPart>("rId1");
-            GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart);
-
-            WorkbookPart workbookPart1 = document.AddWorkbookPart();
-            GenerateWorkbookPart1Content(workbookPart1);
-
-            UInt32Value sheetId = 0;
-            foreach (var worksheet in Worksheets)
-            {
-                sheetId++;
-                WorksheetPart worksheetPart1 = workbookPart1.AddNewPart<WorksheetPart>("rId" + sheetId.ToString());
-                GenerateWorksheetPart3Content(worksheetPart1, worksheet);
-            }
-
-            SharedStringTablePart sharedStringTablePart1 = workbookPart1.AddNewPart<SharedStringTablePart>();
-            GenerateSharedStringTablePart1Content(sharedStringTablePart1);
-
-            WorkbookStylesPart workbookStylesPart1 = workbookPart1.AddNewPart<WorkbookStylesPart>();
-            GenerateWorkbookStylesPart1Content(workbookStylesPart1);
-
-            ThemePart themePart1 = workbookPart1.AddNewPart<ThemePart>();
-            GenerateThemePart1Content(themePart1);
-
-            SetPackageProperties(document);
-        }
-
-        // Generates content of extendedFilePropertiesPart1.
-        private void GenerateExtendedFilePropertiesPart1Content(ExtendedFilePropertiesPart extendedFilePropertiesPart1)
-        {
-            Ap.Properties properties1 = new Ap.Properties();
-            properties1.AddNamespaceDeclaration("vt", "http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes");
-            Ap.Application application1 = new Ap.Application();
-            application1.Text = "Microsoft Excel";
-            Ap.DocumentSecurity documentSecurity1 = new Ap.DocumentSecurity();
-            documentSecurity1.Text = "0";
-            Ap.ScaleCrop scaleCrop1 = new Ap.ScaleCrop();
-            scaleCrop1.Text = "false";
-
-            Ap.HeadingPairs headingPairs1 = new Ap.HeadingPairs();
-
-            Vt.VTVector vTVector1 = new Vt.VTVector() { BaseType = Vt.VectorBaseValues.Variant, Size = (UInt32Value)2U };
-
-            Vt.Variant variant1 = new Vt.Variant();
-            Vt.VTLPSTR vTLPSTR1 = new Vt.VTLPSTR();
-            vTLPSTR1.Text = "Worksheets";
-
-            variant1.Append(vTLPSTR1);
-
-            Vt.Variant variant2 = new Vt.Variant();
-            Vt.VTInt32 vTInt321 = new Vt.VTInt32();
-            vTInt321.Text = Worksheets.Count.ToString();
-
-            variant2.Append(vTInt321);
-
-            vTVector1.Append(variant1);
-            vTVector1.Append(variant2);
-
-            headingPairs1.Append(vTVector1);
-
-            Ap.TitlesOfParts titlesOfParts1 = new Ap.TitlesOfParts();
-
-            Vt.VTVector vTVector2 = new Vt.VTVector() { BaseType = Vt.VectorBaseValues.Lpstr, Size = (UInt32Value)Worksheets.Count };
-            foreach (var sheet in Worksheets)
-            {
-                Vt.VTLPSTR vTLPSTR = new Vt.VTLPSTR();
-                vTLPSTR.Text = sheet.Name;
-                vTVector2.Append(vTLPSTR);
-            }
-
-
-            titlesOfParts1.Append(vTVector2);
-            Ap.LinksUpToDate linksUpToDate1 = new Ap.LinksUpToDate();
-            linksUpToDate1.Text = "false";
-            Ap.SharedDocument sharedDocument1 = new Ap.SharedDocument();
-            sharedDocument1.Text = "false";
-            Ap.HyperlinksChanged hyperlinksChanged1 = new Ap.HyperlinksChanged();
-            hyperlinksChanged1.Text = "false";
-            Ap.ApplicationVersion applicationVersion1 = new Ap.ApplicationVersion();
-            applicationVersion1.Text = "12.0000";
-
-            properties1.Append(application1);
-            properties1.Append(documentSecurity1);
-            properties1.Append(scaleCrop1);
-            properties1.Append(headingPairs1);
-            properties1.Append(titlesOfParts1);
-            properties1.Append(linksUpToDate1);
-            properties1.Append(sharedDocument1);
-            properties1.Append(hyperlinksChanged1);
-            properties1.Append(applicationVersion1);
-
-            extendedFilePropertiesPart1.Properties = properties1;
-        }
-
-
-        // Generates content of workbookPart1.
-        private void GenerateWorkbookPart1Content(WorkbookPart workbookPart1)
-        {
-            Workbook workbook1 = new Workbook();
-            workbook1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
-            FileVersion fileVersion1 = new FileVersion() { ApplicationName = "xl", LastEdited = "5", LowestEdited = "5", BuildVersion = "9114" };
-            WorkbookProperties workbookProperties1 = new WorkbookProperties() { DefaultThemeVersion = (UInt32Value)124226U };
-
-            BookViews bookViews1 = new BookViews();
-            WorkbookView workbookView1 = new WorkbookView() { XWindow = 360, YWindow = 45, WindowWidth = (UInt32Value)14355U, WindowHeight = (UInt32Value)8250U };
-
-            bookViews1.Append(workbookView1);
-
-            UInt32 sheetCount = 0;
-            Sheets sheets1 = new Sheets();
-            foreach (var worksheet in Worksheets)
-            {
-                sheetCount++;
-                Sheet sheet = new Sheet() { Name = worksheet.Name, SheetId = (UInt32Value)sheetCount, Id = "rId" + sheetCount.ToString() };
-                sheets1.Append(sheet);
-            }
-
-            CalculationProperties calculationProperties1 = new CalculationProperties() { CalculationId = (UInt32Value)144315U, ReferenceMode = ReferenceModeValues.R1C1 };
-
-            workbook1.Append(fileVersion1);
-            workbook1.Append(workbookProperties1);
-            workbook1.Append(bookViews1);
-            workbook1.Append(sheets1);
-            workbook1.Append(calculationProperties1);
-
-            workbookPart1.Workbook = workbook1;
-        }
-
-        // Generates content of worksheetPart3.
-        private void GenerateWorksheetPart3Content(WorksheetPart worksheetPart3, XLWorksheet worksheet)
-        {
-            Worksheet worksheet3 = new Worksheet();
-            worksheet3.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
-            SheetDimension sheetDimension3 = new SheetDimension() { Reference = "A1" };
-
-            SheetViews sheetViews3 = new SheetViews();
-
-            SheetView sheetView3;
-            if (worksheet.Name != "SheetName1")
-            {
-                sheetView3 = new SheetView() { WorkbookViewId = (UInt32Value)0U };
-            }
-            else
-            {
-                sheetView3 = new SheetView() { TabSelected = true, WorkbookViewId = (UInt32Value)0U };
-            }
-            
-            sheetViews3.Append(sheetView3);
-            SheetFormatProperties sheetFormatProperties3 = new SheetFormatProperties() { DefaultRowHeight = 15D, DyDescent = 0.25D };
-
-            SheetData sheetData3 = new SheetData();
-
-            #region Insert Rows/Cells
-            if (worksheet.HasData)
-            {
-                foreach (var xlRow in worksheet.Rows(CellContent.WithValues))
-                {
-                    Row row = new Row() { RowIndex = (UInt32Value)xlRow.Row, Spans = new ListValue<StringValue>() { InnerText = xlRow.Column.ToString() + ":" + xlRow.LastCell(CellContent.WithValues).Column }, DyDescent = 0.25D };
-                    foreach (var xlCell in xlRow.Cells(CellContent.WithValues))
-                    {
-                        Cell cell;
-                        String address = xlCell.CellAddress.ToString();
-                        if (xlCell.DataType == CellValues.Date)
-                            cell = new Cell() { CellReference = address, StyleIndex = (UInt32Value)1U };
-                        else if (xlCell.DataType == CellValues.SharedString)
-                            cell = new Cell() { CellReference = address, DataType = CellValues.SharedString };
-                        else if (xlCell.DataType == CellValues.Boolean)
-                            cell = new Cell() { CellReference = address, DataType = CellValues.Boolean };
-                        else
-                            cell = new Cell() { CellReference = address };
-
-                        CellValue cellValue = new CellValue();
-                        cellValue.Text = xlCell.InnerValue;
-
-                        cell.Append(cellValue);
-                        row.Append(cell);
-                    }
-
-                    sheetData3.Append(row);
-                }
-            }
-            #endregion
-
-            PageMargins pageMargins3 = new PageMargins() { Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };
-
-            worksheet3.Append(sheetDimension3);
-            worksheet3.Append(sheetViews3);
-            worksheet3.Append(sheetFormatProperties3);
-            worksheet3.Append(sheetData3);
-            worksheet3.Append(pageMargins3);
-
-            worksheetPart3.Worksheet = worksheet3;
-        }
-
-        
-
-        // Generates content of sharedStringTablePart1.
-        private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
-        {
-            SharedStringTable sharedStringTable = new SharedStringTable() { Count = (UInt32Value)SharedStrings.Count, UniqueCount = (UInt32Value)SharedStrings.Count };
-
-            foreach (String sharedString in SharedStrings)
-            {
-                SharedStringItem sharedStringItem = new SharedStringItem();
-                Text text = new Text();
-                text.Text = sharedString;
-                sharedStringItem.Append(text);
-                sharedStringTable.Append(sharedStringItem);
-            }
-
-            sharedStringTablePart1.SharedStringTable = sharedStringTable;
-        }
-
-        // Generates content of workbookStylesPart1.
-        private void GenerateWorkbookStylesPart1Content(WorkbookStylesPart workbookStylesPart1)
-        {
-            Stylesheet stylesheet1 = new Stylesheet();
-
-            Fonts fonts1 = new Fonts() { Count = (UInt32Value)1U };
-
-            Font font1 = new Font();
-            FontSize fontSize1 = new FontSize() { Val = 11D };
-            Color color1 = new Color() { Theme = (UInt32Value)1U };
-            FontName fontName1 = new FontName() { Val = "Calibri" };
-            FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering() { Val = 2 };
-            FontScheme fontScheme1 = new FontScheme() { Val = FontSchemeValues.Minor };
-
-            font1.Append(fontSize1);
-            font1.Append(color1);
-            font1.Append(fontName1);
-            font1.Append(fontFamilyNumbering1);
-            font1.Append(fontScheme1);
-
-            fonts1.Append(font1);
-
-            Fills fills1 = new Fills() { Count = (UInt32Value)2U };
-
-            Fill fill1 = new Fill();
-            PatternFill patternFill1 = new PatternFill() { PatternType = PatternValues.None };
-
-            fill1.Append(patternFill1);
-
-            Fill fill2 = new Fill();
-            PatternFill patternFill2 = new PatternFill() { PatternType = PatternValues.Gray125 };
-
-            fill2.Append(patternFill2);
-
-            fills1.Append(fill1);
-            fills1.Append(fill2);
-
-            Borders borders1 = new Borders() { Count = (UInt32Value)1U };
-
-            Border border1 = new Border();
-            LeftBorder leftBorder1 = new LeftBorder();
-            RightBorder rightBorder1 = new RightBorder();
-            TopBorder topBorder1 = new TopBorder();
-            BottomBorder bottomBorder1 = new BottomBorder();
-            DiagonalBorder diagonalBorder1 = new DiagonalBorder();
-
-            border1.Append(leftBorder1);
-            border1.Append(rightBorder1);
-            border1.Append(topBorder1);
-            border1.Append(bottomBorder1);
-            border1.Append(diagonalBorder1);
-
-            borders1.Append(border1);
-
-            CellStyleFormats cellStyleFormats1 = new CellStyleFormats() { Count = (UInt32Value)1U };
-            CellFormat cellFormat1 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U };
-
-            cellStyleFormats1.Append(cellFormat1);
-
-            CellFormats cellFormats1 = new CellFormats() { Count = (UInt32Value)2U };
-            CellFormat cellFormat2 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U };
-            CellFormat cellFormat3 = new CellFormat() { NumberFormatId = (UInt32Value)14U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true };
-
-            cellFormats1.Append(cellFormat2);
-            cellFormats1.Append(cellFormat3);
-
-            CellStyles cellStyles1 = new CellStyles() { Count = (UInt32Value)1U };
-            CellStyle cellStyle1 = new CellStyle() { Name = "Normal", FormatId = (UInt32Value)0U, BuiltinId = (UInt32Value)0U };
-
-            cellStyles1.Append(cellStyle1);
-            DifferentialFormats differentialFormats1 = new DifferentialFormats() { Count = (UInt32Value)0U };
-            TableStyles tableStyles1 = new TableStyles() { Count = (UInt32Value)0U, DefaultTableStyle = "TableStyleMedium9", DefaultPivotStyle = "PivotStyleLight16" };
-
-            stylesheet1.Append(fonts1);
-            stylesheet1.Append(fills1);
-            stylesheet1.Append(borders1);
-            stylesheet1.Append(cellStyleFormats1);
-            stylesheet1.Append(cellFormats1);
-            stylesheet1.Append(cellStyles1);
-            stylesheet1.Append(differentialFormats1);
-            stylesheet1.Append(tableStyles1);
-
-            workbookStylesPart1.Stylesheet = stylesheet1;
-        }
-
-        // Generates content of themePart1.
-        private void GenerateThemePart1Content(ThemePart themePart1)
-        {
-            A.Theme theme1 = new A.Theme() { Name = "Office Theme" };
-            theme1.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");
-
-            A.ThemeElements themeElements1 = new A.ThemeElements();
-
-            A.ColorScheme colorScheme1 = new A.ColorScheme() { Name = "Office" };
-
-            A.Dark1Color dark1Color1 = new A.Dark1Color();
-            A.SystemColor systemColor1 = new A.SystemColor() { Val = A.SystemColorValues.WindowText, LastColor = "000000" };
-
-            dark1Color1.Append(systemColor1);
-
-            A.Light1Color light1Color1 = new A.Light1Color();
-            A.SystemColor systemColor2 = new A.SystemColor() { Val = A.SystemColorValues.Window, LastColor = "FFFFFF" };
-
-            light1Color1.Append(systemColor2);
-
-            A.Dark2Color dark2Color1 = new A.Dark2Color();
-            A.RgbColorModelHex rgbColorModelHex1 = new A.RgbColorModelHex() { Val = "1F497D" };
-
-            dark2Color1.Append(rgbColorModelHex1);
-
-            A.Light2Color light2Color1 = new A.Light2Color();
-            A.RgbColorModelHex rgbColorModelHex2 = new A.RgbColorModelHex() { Val = "EEECE1" };
-
-            light2Color1.Append(rgbColorModelHex2);
-
-            A.Accent1Color accent1Color1 = new A.Accent1Color();
-            A.RgbColorModelHex rgbColorModelHex3 = new A.RgbColorModelHex() { Val = "4F81BD" };
-
-            accent1Color1.Append(rgbColorModelHex3);
-
-            A.Accent2Color accent2Color1 = new A.Accent2Color();
-            A.RgbColorModelHex rgbColorModelHex4 = new A.RgbColorModelHex() { Val = "C0504D" };
-
-            accent2Color1.Append(rgbColorModelHex4);
-
-            A.Accent3Color accent3Color1 = new A.Accent3Color();
-            A.RgbColorModelHex rgbColorModelHex5 = new A.RgbColorModelHex() { Val = "9BBB59" };
-
-            accent3Color1.Append(rgbColorModelHex5);
-
-            A.Accent4Color accent4Color1 = new A.Accent4Color();
-            A.RgbColorModelHex rgbColorModelHex6 = new A.RgbColorModelHex() { Val = "8064A2" };
-
-            accent4Color1.Append(rgbColorModelHex6);
-
-            A.Accent5Color accent5Color1 = new A.Accent5Color();
-            A.RgbColorModelHex rgbColorModelHex7 = new A.RgbColorModelHex() { Val = "4BACC6" };
-
-            accent5Color1.Append(rgbColorModelHex7);
-
-            A.Accent6Color accent6Color1 = new A.Accent6Color();
-            A.RgbColorModelHex rgbColorModelHex8 = new A.RgbColorModelHex() { Val = "F79646" };
-
-            accent6Color1.Append(rgbColorModelHex8);
-
-            A.Hyperlink hyperlink1 = new A.Hyperlink();
-            A.RgbColorModelHex rgbColorModelHex9 = new A.RgbColorModelHex() { Val = "0000FF" };
-
-            hyperlink1.Append(rgbColorModelHex9);
-
-            A.FollowedHyperlinkColor followedHyperlinkColor1 = new A.FollowedHyperlinkColor();
-            A.RgbColorModelHex rgbColorModelHex10 = new A.RgbColorModelHex() { Val = "800080" };
-
-            followedHyperlinkColor1.Append(rgbColorModelHex10);
-
-            colorScheme1.Append(dark1Color1);
-            colorScheme1.Append(light1Color1);
-            colorScheme1.Append(dark2Color1);
-            colorScheme1.Append(light2Color1);
-            colorScheme1.Append(accent1Color1);
-            colorScheme1.Append(accent2Color1);
-            colorScheme1.Append(accent3Color1);
-            colorScheme1.Append(accent4Color1);
-            colorScheme1.Append(accent5Color1);
-            colorScheme1.Append(accent6Color1);
-            colorScheme1.Append(hyperlink1);
-            colorScheme1.Append(followedHyperlinkColor1);
-
-            A.FontScheme fontScheme2 = new A.FontScheme() { Name = "Office" };
-
-            A.MajorFont majorFont1 = new A.MajorFont();
-            A.LatinFont latinFont1 = new A.LatinFont() { Typeface = "Cambria" };
-            A.EastAsianFont eastAsianFont1 = new A.EastAsianFont() { Typeface = "" };
-            A.ComplexScriptFont complexScriptFont1 = new A.ComplexScriptFont() { Typeface = "" };
-            A.SupplementalFont supplementalFont1 = new A.SupplementalFont() { Script = "Jpan", Typeface = "ＭＳ Ｐゴシック" };
-            A.SupplementalFont supplementalFont2 = new A.SupplementalFont() { Script = "Hang", Typeface = "맑은 고딕" };
-            A.SupplementalFont supplementalFont3 = new A.SupplementalFont() { Script = "Hans", Typeface = "宋体" };
-            A.SupplementalFont supplementalFont4 = new A.SupplementalFont() { Script = "Hant", Typeface = "新細明體" };
-            A.SupplementalFont supplementalFont5 = new A.SupplementalFont() { Script = "Arab", Typeface = "Times New Roman" };
-            A.SupplementalFont supplementalFont6 = new A.SupplementalFont() { Script = "Hebr", Typeface = "Times New Roman" };
-            A.SupplementalFont supplementalFont7 = new A.SupplementalFont() { Script = "Thai", Typeface = "Tahoma" };
-            A.SupplementalFont supplementalFont8 = new A.SupplementalFont() { Script = "Ethi", Typeface = "Nyala" };
-            A.SupplementalFont supplementalFont9 = new A.SupplementalFont() { Script = "Beng", Typeface = "Vrinda" };
-            A.SupplementalFont supplementalFont10 = new A.SupplementalFont() { Script = "Gujr", Typeface = "Shruti" };
-            A.SupplementalFont supplementalFont11 = new A.SupplementalFont() { Script = "Khmr", Typeface = "MoolBoran" };
-            A.SupplementalFont supplementalFont12 = new A.SupplementalFont() { Script = "Knda", Typeface = "Tunga" };
-            A.SupplementalFont supplementalFont13 = new A.SupplementalFont() { Script = "Guru", Typeface = "Raavi" };
-            A.SupplementalFont supplementalFont14 = new A.SupplementalFont() { Script = "Cans", Typeface = "Euphemia" };
-            A.SupplementalFont supplementalFont15 = new A.SupplementalFont() { Script = "Cher", Typeface = "Plantagenet Cherokee" };
-            A.SupplementalFont supplementalFont16 = new A.SupplementalFont() { Script = "Yiii", Typeface = "Microsoft Yi Baiti" };
-            A.SupplementalFont supplementalFont17 = new A.SupplementalFont() { Script = "Tibt", Typeface = "Microsoft Himalaya" };
-            A.SupplementalFont supplementalFont18 = new A.SupplementalFont() { Script = "Thaa", Typeface = "MV Boli" };
-            A.SupplementalFont supplementalFont19 = new A.SupplementalFont() { Script = "Deva", Typeface = "Mangal" };
-            A.SupplementalFont supplementalFont20 = new A.SupplementalFont() { Script = "Telu", Typeface = "Gautami" };
-            A.SupplementalFont supplementalFont21 = new A.SupplementalFont() { Script = "Taml", Typeface = "Latha" };
-            A.SupplementalFont supplementalFont22 = new A.SupplementalFont() { Script = "Syrc", Typeface = "Estrangelo Edessa" };
-            A.SupplementalFont supplementalFont23 = new A.SupplementalFont() { Script = "Orya", Typeface = "Kalinga" };
-            A.SupplementalFont supplementalFont24 = new A.SupplementalFont() { Script = "Mlym", Typeface = "Kartika" };
-            A.SupplementalFont supplementalFont25 = new A.SupplementalFont() { Script = "Laoo", Typeface = "DokChampa" };
-            A.SupplementalFont supplementalFont26 = new A.SupplementalFont() { Script = "Sinh", Typeface = "Iskoola Pota" };
-            A.SupplementalFont supplementalFont27 = new A.SupplementalFont() { Script = "Mong", Typeface = "Mongolian Baiti" };
-            A.SupplementalFont supplementalFont28 = new A.SupplementalFont() { Script = "Viet", Typeface = "Times New Roman" };
-            A.SupplementalFont supplementalFont29 = new A.SupplementalFont() { Script = "Uigh", Typeface = "Microsoft Uighur" };
-
-            majorFont1.Append(latinFont1);
-            majorFont1.Append(eastAsianFont1);
-            majorFont1.Append(complexScriptFont1);
-            majorFont1.Append(supplementalFont1);
-            majorFont1.Append(supplementalFont2);
-            majorFont1.Append(supplementalFont3);
-            majorFont1.Append(supplementalFont4);
-            majorFont1.Append(supplementalFont5);
-            majorFont1.Append(supplementalFont6);
-            majorFont1.Append(supplementalFont7);
-            majorFont1.Append(supplementalFont8);
-            majorFont1.Append(supplementalFont9);
-            majorFont1.Append(supplementalFont10);
-            majorFont1.Append(supplementalFont11);
-            majorFont1.Append(supplementalFont12);
-            majorFont1.Append(supplementalFont13);
-            majorFont1.Append(supplementalFont14);
-            majorFont1.Append(supplementalFont15);
-            majorFont1.Append(supplementalFont16);
-            majorFont1.Append(supplementalFont17);
-            majorFont1.Append(supplementalFont18);
-            majorFont1.Append(supplementalFont19);
-            majorFont1.Append(supplementalFont20);
-            majorFont1.Append(supplementalFont21);
-            majorFont1.Append(supplementalFont22);
-            majorFont1.Append(supplementalFont23);
-            majorFont1.Append(supplementalFont24);
-            majorFont1.Append(supplementalFont25);
-            majorFont1.Append(supplementalFont26);
-            majorFont1.Append(supplementalFont27);
-            majorFont1.Append(supplementalFont28);
-            majorFont1.Append(supplementalFont29);
-
-            A.MinorFont minorFont1 = new A.MinorFont();
-            A.LatinFont latinFont2 = new A.LatinFont() { Typeface = "Calibri" };
-            A.EastAsianFont eastAsianFont2 = new A.EastAsianFont() { Typeface = "" };
-            A.ComplexScriptFont complexScriptFont2 = new A.ComplexScriptFont() { Typeface = "" };
-            A.SupplementalFont supplementalFont30 = new A.SupplementalFont() { Script = "Jpan", Typeface = "ＭＳ Ｐゴシック" };
-            A.SupplementalFont supplementalFont31 = new A.SupplementalFont() { Script = "Hang", Typeface = "맑은 고딕" };
-            A.SupplementalFont supplementalFont32 = new A.SupplementalFont() { Script = "Hans", Typeface = "宋体" };
-            A.SupplementalFont supplementalFont33 = new A.SupplementalFont() { Script = "Hant", Typeface = "新細明體" };
-            A.SupplementalFont supplementalFont34 = new A.SupplementalFont() { Script = "Arab", Typeface = "Arial" };
-            A.SupplementalFont supplementalFont35 = new A.SupplementalFont() { Script = "Hebr", Typeface = "Arial" };
-            A.SupplementalFont supplementalFont36 = new A.SupplementalFont() { Script = "Thai", Typeface = "Tahoma" };
-            A.SupplementalFont supplementalFont37 = new A.SupplementalFont() { Script = "Ethi", Typeface = "Nyala" };
-            A.SupplementalFont supplementalFont38 = new A.SupplementalFont() { Script = "Beng", Typeface = "Vrinda" };
-            A.SupplementalFont supplementalFont39 = new A.SupplementalFont() { Script = "Gujr", Typeface = "Shruti" };
-            A.SupplementalFont supplementalFont40 = new A.SupplementalFont() { Script = "Khmr", Typeface = "DaunPenh" };
-            A.SupplementalFont supplementalFont41 = new A.SupplementalFont() { Script = "Knda", Typeface = "Tunga" };
-            A.SupplementalFont supplementalFont42 = new A.SupplementalFont() { Script = "Guru", Typeface = "Raavi" };
-            A.SupplementalFont supplementalFont43 = new A.SupplementalFont() { Script = "Cans", Typeface = "Euphemia" };
-            A.SupplementalFont supplementalFont44 = new A.SupplementalFont() { Script = "Cher", Typeface = "Plantagenet Cherokee" };
-            A.SupplementalFont supplementalFont45 = new A.SupplementalFont() { Script = "Yiii", Typeface = "Microsoft Yi Baiti" };
-            A.SupplementalFont supplementalFont46 = new A.SupplementalFont() { Script = "Tibt", Typeface = "Microsoft Himalaya" };
-            A.SupplementalFont supplementalFont47 = new A.SupplementalFont() { Script = "Thaa", Typeface = "MV Boli" };
-            A.SupplementalFont supplementalFont48 = new A.SupplementalFont() { Script = "Deva", Typeface = "Mangal" };
-            A.SupplementalFont supplementalFont49 = new A.SupplementalFont() { Script = "Telu", Typeface = "Gautami" };
-            A.SupplementalFont supplementalFont50 = new A.SupplementalFont() { Script = "Taml", Typeface = "Latha" };
-            A.SupplementalFont supplementalFont51 = new A.SupplementalFont() { Script = "Syrc", Typeface = "Estrangelo Edessa" };
-            A.SupplementalFont supplementalFont52 = new A.SupplementalFont() { Script = "Orya", Typeface = "Kalinga" };
-            A.SupplementalFont supplementalFont53 = new A.SupplementalFont() { Script = "Mlym", Typeface = "Kartika" };
-            A.SupplementalFont supplementalFont54 = new A.SupplementalFont() { Script = "Laoo", Typeface = "DokChampa" };
-            A.SupplementalFont supplementalFont55 = new A.SupplementalFont() { Script = "Sinh", Typeface = "Iskoola Pota" };
-            A.SupplementalFont supplementalFont56 = new A.SupplementalFont() { Script = "Mong", Typeface = "Mongolian Baiti" };
-            A.SupplementalFont supplementalFont57 = new A.SupplementalFont() { Script = "Viet", Typeface = "Arial" };
-            A.SupplementalFont supplementalFont58 = new A.SupplementalFont() { Script = "Uigh", Typeface = "Microsoft Uighur" };
-
-            minorFont1.Append(latinFont2);
-            minorFont1.Append(eastAsianFont2);
-            minorFont1.Append(complexScriptFont2);
-            minorFont1.Append(supplementalFont30);
-            minorFont1.Append(supplementalFont31);
-            minorFont1.Append(supplementalFont32);
-            minorFont1.Append(supplementalFont33);
-            minorFont1.Append(supplementalFont34);
-            minorFont1.Append(supplementalFont35);
-            minorFont1.Append(supplementalFont36);
-            minorFont1.Append(supplementalFont37);
-            minorFont1.Append(supplementalFont38);
-            minorFont1.Append(supplementalFont39);
-            minorFont1.Append(supplementalFont40);
-            minorFont1.Append(supplementalFont41);
-            minorFont1.Append(supplementalFont42);
-            minorFont1.Append(supplementalFont43);
-            minorFont1.Append(supplementalFont44);
-            minorFont1.Append(supplementalFont45);
-            minorFont1.Append(supplementalFont46);
-            minorFont1.Append(supplementalFont47);
-            minorFont1.Append(supplementalFont48);
-            minorFont1.Append(supplementalFont49);
-            minorFont1.Append(supplementalFont50);
-            minorFont1.Append(supplementalFont51);
-            minorFont1.Append(supplementalFont52);
-            minorFont1.Append(supplementalFont53);
-            minorFont1.Append(supplementalFont54);
-            minorFont1.Append(supplementalFont55);
-            minorFont1.Append(supplementalFont56);
-            minorFont1.Append(supplementalFont57);
-            minorFont1.Append(supplementalFont58);
-
-            fontScheme2.Append(majorFont1);
-            fontScheme2.Append(minorFont1);
-
-            A.FormatScheme formatScheme1 = new A.FormatScheme() { Name = "Office" };
-
-            A.FillStyleList fillStyleList1 = new A.FillStyleList();
-
-            A.SolidFill solidFill1 = new A.SolidFill();
-            A.SchemeColor schemeColor1 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-
-            solidFill1.Append(schemeColor1);
-
-            A.GradientFill gradientFill1 = new A.GradientFill() { RotateWithShape = true };
-
-            A.GradientStopList gradientStopList1 = new A.GradientStopList();
-
-            A.GradientStop gradientStop1 = new A.GradientStop() { Position = 0 };
-
-            A.SchemeColor schemeColor2 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-            A.Tint tint1 = new A.Tint() { Val = 50000 };
-            A.SaturationModulation saturationModulation1 = new A.SaturationModulation() { Val = 300000 };
-
-            schemeColor2.Append(tint1);
-            schemeColor2.Append(saturationModulation1);
-
-            gradientStop1.Append(schemeColor2);
-
-            A.GradientStop gradientStop2 = new A.GradientStop() { Position = 35000 };
-
-            A.SchemeColor schemeColor3 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-            A.Tint tint2 = new A.Tint() { Val = 37000 };
-            A.SaturationModulation saturationModulation2 = new A.SaturationModulation() { Val = 300000 };
-
-            schemeColor3.Append(tint2);
-            schemeColor3.Append(saturationModulation2);
-
-            gradientStop2.Append(schemeColor3);
-
-            A.GradientStop gradientStop3 = new A.GradientStop() { Position = 100000 };
-
-            A.SchemeColor schemeColor4 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-            A.Tint tint3 = new A.Tint() { Val = 15000 };
-            A.SaturationModulation saturationModulation3 = new A.SaturationModulation() { Val = 350000 };
-
-            schemeColor4.Append(tint3);
-            schemeColor4.Append(saturationModulation3);
-
-            gradientStop3.Append(schemeColor4);
-
-            gradientStopList1.Append(gradientStop1);
-            gradientStopList1.Append(gradientStop2);
-            gradientStopList1.Append(gradientStop3);
-            A.LinearGradientFill linearGradientFill1 = new A.LinearGradientFill() { Angle = 16200000, Scaled = true };
-
-            gradientFill1.Append(gradientStopList1);
-            gradientFill1.Append(linearGradientFill1);
-
-            A.GradientFill gradientFill2 = new A.GradientFill() { RotateWithShape = true };
-
-            A.GradientStopList gradientStopList2 = new A.GradientStopList();
-
-            A.GradientStop gradientStop4 = new A.GradientStop() { Position = 0 };
-
-            A.SchemeColor schemeColor5 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-            A.Shade shade1 = new A.Shade() { Val = 51000 };
-            A.SaturationModulation saturationModulation4 = new A.SaturationModulation() { Val = 130000 };
-
-            schemeColor5.Append(shade1);
-            schemeColor5.Append(saturationModulation4);
-
-            gradientStop4.Append(schemeColor5);
-
-            A.GradientStop gradientStop5 = new A.GradientStop() { Position = 80000 };
-
-            A.SchemeColor schemeColor6 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-            A.Shade shade2 = new A.Shade() { Val = 93000 };
-            A.SaturationModulation saturationModulation5 = new A.SaturationModulation() { Val = 130000 };
-
-            schemeColor6.Append(shade2);
-            schemeColor6.Append(saturationModulation5);
-
-            gradientStop5.Append(schemeColor6);
-
-            A.GradientStop gradientStop6 = new A.GradientStop() { Position = 100000 };
-
-            A.SchemeColor schemeColor7 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-            A.Shade shade3 = new A.Shade() { Val = 94000 };
-            A.SaturationModulation saturationModulation6 = new A.SaturationModulation() { Val = 135000 };
-
-            schemeColor7.Append(shade3);
-            schemeColor7.Append(saturationModulation6);
-
-            gradientStop6.Append(schemeColor7);
-
-            gradientStopList2.Append(gradientStop4);
-            gradientStopList2.Append(gradientStop5);
-            gradientStopList2.Append(gradientStop6);
-            A.LinearGradientFill linearGradientFill2 = new A.LinearGradientFill() { Angle = 16200000, Scaled = false };
-
-            gradientFill2.Append(gradientStopList2);
-            gradientFill2.Append(linearGradientFill2);
-
-            fillStyleList1.Append(solidFill1);
-            fillStyleList1.Append(gradientFill1);
-            fillStyleList1.Append(gradientFill2);
-
-            A.LineStyleList lineStyleList1 = new A.LineStyleList();
-
-            A.Outline outline1 = new A.Outline() { Width = 9525, CapType = A.LineCapValues.Flat, CompoundLineType = A.CompoundLineValues.Single, Alignment = A.PenAlignmentValues.Center };
-
-            A.SolidFill solidFill2 = new A.SolidFill();
-
-            A.SchemeColor schemeColor8 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-            A.Shade shade4 = new A.Shade() { Val = 95000 };
-            A.SaturationModulation saturationModulation7 = new A.SaturationModulation() { Val = 105000 };
-
-            schemeColor8.Append(shade4);
-            schemeColor8.Append(saturationModulation7);
-
-            solidFill2.Append(schemeColor8);
-            A.PresetDash presetDash1 = new A.PresetDash() { Val = A.PresetLineDashValues.Solid };
-
-            outline1.Append(solidFill2);
-            outline1.Append(presetDash1);
-
-            A.Outline outline2 = new A.Outline() { Width = 25400, CapType = A.LineCapValues.Flat, CompoundLineType = A.CompoundLineValues.Single, Alignment = A.PenAlignmentValues.Center };
-
-            A.SolidFill solidFill3 = new A.SolidFill();
-            A.SchemeColor schemeColor9 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-
-            solidFill3.Append(schemeColor9);
-            A.PresetDash presetDash2 = new A.PresetDash() { Val = A.PresetLineDashValues.Solid };
-
-            outline2.Append(solidFill3);
-            outline2.Append(presetDash2);
-
-            A.Outline outline3 = new A.Outline() { Width = 38100, CapType = A.LineCapValues.Flat, CompoundLineType = A.CompoundLineValues.Single, Alignment = A.PenAlignmentValues.Center };
-
-            A.SolidFill solidFill4 = new A.SolidFill();
-            A.SchemeColor schemeColor10 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-
-            solidFill4.Append(schemeColor10);
-            A.PresetDash presetDash3 = new A.PresetDash() { Val = A.PresetLineDashValues.Solid };
-
-            outline3.Append(solidFill4);
-            outline3.Append(presetDash3);
-
-            lineStyleList1.Append(outline1);
-            lineStyleList1.Append(outline2);
-            lineStyleList1.Append(outline3);
-
-            A.EffectStyleList effectStyleList1 = new A.EffectStyleList();
-
-            A.EffectStyle effectStyle1 = new A.EffectStyle();
-
-            A.EffectList effectList1 = new A.EffectList();
-
-            A.OuterShadow outerShadow1 = new A.OuterShadow() { BlurRadius = 40000L, Distance = 20000L, Direction = 5400000, RotateWithShape = false };
-
-            A.RgbColorModelHex rgbColorModelHex11 = new A.RgbColorModelHex() { Val = "000000" };
-            A.Alpha alpha1 = new A.Alpha() { Val = 38000 };
-
-            rgbColorModelHex11.Append(alpha1);
-
-            outerShadow1.Append(rgbColorModelHex11);
-
-            effectList1.Append(outerShadow1);
-
-            effectStyle1.Append(effectList1);
-
-            A.EffectStyle effectStyle2 = new A.EffectStyle();
-
-            A.EffectList effectList2 = new A.EffectList();
-
-            A.OuterShadow outerShadow2 = new A.OuterShadow() { BlurRadius = 40000L, Distance = 23000L, Direction = 5400000, RotateWithShape = false };
-
-            A.RgbColorModelHex rgbColorModelHex12 = new A.RgbColorModelHex() { Val = "000000" };
-            A.Alpha alpha2 = new A.Alpha() { Val = 35000 };
-
-            rgbColorModelHex12.Append(alpha2);
-
-            outerShadow2.Append(rgbColorModelHex12);
-
-            effectList2.Append(outerShadow2);
-
-            effectStyle2.Append(effectList2);
-
-            A.EffectStyle effectStyle3 = new A.EffectStyle();
-
-            A.EffectList effectList3 = new A.EffectList();
-
-            A.OuterShadow outerShadow3 = new A.OuterShadow() { BlurRadius = 40000L, Distance = 23000L, Direction = 5400000, RotateWithShape = false };
-
-            A.RgbColorModelHex rgbColorModelHex13 = new A.RgbColorModelHex() { Val = "000000" };
-            A.Alpha alpha3 = new A.Alpha() { Val = 35000 };
-
-            rgbColorModelHex13.Append(alpha3);
-
-            outerShadow3.Append(rgbColorModelHex13);
-
-            effectList3.Append(outerShadow3);
-
-            A.Scene3DType scene3DType1 = new A.Scene3DType();
-
-            A.Camera camera1 = new A.Camera() { Preset = A.PresetCameraValues.OrthographicFront };
-            A.Rotation rotation1 = new A.Rotation() { Latitude = 0, Longitude = 0, Revolution = 0 };
-
-            camera1.Append(rotation1);
-
-            A.LightRig lightRig1 = new A.LightRig() { Rig = A.LightRigValues.ThreePoints, Direction = A.LightRigDirectionValues.Top };
-            A.Rotation rotation2 = new A.Rotation() { Latitude = 0, Longitude = 0, Revolution = 1200000 };
-
-            lightRig1.Append(rotation2);
-
-            scene3DType1.Append(camera1);
-            scene3DType1.Append(lightRig1);
-
-            A.Shape3DType shape3DType1 = new A.Shape3DType();
-            A.BevelTop bevelTop1 = new A.BevelTop() { Width = 63500L, Height = 25400L };
-
-            shape3DType1.Append(bevelTop1);
-
-            effectStyle3.Append(effectList3);
-            effectStyle3.Append(scene3DType1);
-            effectStyle3.Append(shape3DType1);
-
-            effectStyleList1.Append(effectStyle1);
-            effectStyleList1.Append(effectStyle2);
-            effectStyleList1.Append(effectStyle3);
-
-            A.BackgroundFillStyleList backgroundFillStyleList1 = new A.BackgroundFillStyleList();
-
-            A.SolidFill solidFill5 = new A.SolidFill();
-            A.SchemeColor schemeColor11 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-
-            solidFill5.Append(schemeColor11);
-
-            A.GradientFill gradientFill3 = new A.GradientFill() { RotateWithShape = true };
-
-            A.GradientStopList gradientStopList3 = new A.GradientStopList();
-
-            A.GradientStop gradientStop7 = new A.GradientStop() { Position = 0 };
-
-            A.SchemeColor schemeColor12 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-            A.Tint tint4 = new A.Tint() { Val = 40000 };
-            A.SaturationModulation saturationModulation8 = new A.SaturationModulation() { Val = 350000 };
-
-            schemeColor12.Append(tint4);
-            schemeColor12.Append(saturationModulation8);
-
-            gradientStop7.Append(schemeColor12);
-
-            A.GradientStop gradientStop8 = new A.GradientStop() { Position = 40000 };
-
-            A.SchemeColor schemeColor13 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-            A.Tint tint5 = new A.Tint() { Val = 45000 };
-            A.Shade shade5 = new A.Shade() { Val = 99000 };
-            A.SaturationModulation saturationModulation9 = new A.SaturationModulation() { Val = 350000 };
-
-            schemeColor13.Append(tint5);
-            schemeColor13.Append(shade5);
-            schemeColor13.Append(saturationModulation9);
-
-            gradientStop8.Append(schemeColor13);
-
-            A.GradientStop gradientStop9 = new A.GradientStop() { Position = 100000 };
-
-            A.SchemeColor schemeColor14 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-            A.Shade shade6 = new A.Shade() { Val = 20000 };
-            A.SaturationModulation saturationModulation10 = new A.SaturationModulation() { Val = 255000 };
-
-            schemeColor14.Append(shade6);
-            schemeColor14.Append(saturationModulation10);
-
-            gradientStop9.Append(schemeColor14);
-
-            gradientStopList3.Append(gradientStop7);
-            gradientStopList3.Append(gradientStop8);
-            gradientStopList3.Append(gradientStop9);
-
-            A.PathGradientFill pathGradientFill1 = new A.PathGradientFill() { Path = A.PathShadeValues.Circle };
-            A.FillToRectangle fillToRectangle1 = new A.FillToRectangle() { Left = 50000, Top = -80000, Right = 50000, Bottom = 180000 };
-
-            pathGradientFill1.Append(fillToRectangle1);
-
-            gradientFill3.Append(gradientStopList3);
-            gradientFill3.Append(pathGradientFill1);
-
-            A.GradientFill gradientFill4 = new A.GradientFill() { RotateWithShape = true };
-
-            A.GradientStopList gradientStopList4 = new A.GradientStopList();
-
-            A.GradientStop gradientStop10 = new A.GradientStop() { Position = 0 };
-
-            A.SchemeColor schemeColor15 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-            A.Tint tint6 = new A.Tint() { Val = 80000 };
-            A.SaturationModulation saturationModulation11 = new A.SaturationModulation() { Val = 300000 };
-
-            schemeColor15.Append(tint6);
-            schemeColor15.Append(saturationModulation11);
-
-            gradientStop10.Append(schemeColor15);
-
-            A.GradientStop gradientStop11 = new A.GradientStop() { Position = 100000 };
-
-            A.SchemeColor schemeColor16 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
-            A.Shade shade7 = new A.Shade() { Val = 30000 };
-            A.SaturationModulation saturationModulation12 = new A.SaturationModulation() { Val = 200000 };
-
-            schemeColor16.Append(shade7);
-            schemeColor16.Append(saturationModulation12);
-
-            gradientStop11.Append(schemeColor16);
-
-            gradientStopList4.Append(gradientStop10);
-            gradientStopList4.Append(gradientStop11);
-
-            A.PathGradientFill pathGradientFill2 = new A.PathGradientFill() { Path = A.PathShadeValues.Circle };
-            A.FillToRectangle fillToRectangle2 = new A.FillToRectangle() { Left = 50000, Top = 50000, Right = 50000, Bottom = 50000 };
-
-            pathGradientFill2.Append(fillToRectangle2);
-
-            gradientFill4.Append(gradientStopList4);
-            gradientFill4.Append(pathGradientFill2);
-
-            backgroundFillStyleList1.Append(solidFill5);
-            backgroundFillStyleList1.Append(gradientFill3);
-            backgroundFillStyleList1.Append(gradientFill4);
-
-            formatScheme1.Append(fillStyleList1);
-            formatScheme1.Append(lineStyleList1);
-            formatScheme1.Append(effectStyleList1);
-            formatScheme1.Append(backgroundFillStyleList1);
-
-            themeElements1.Append(colorScheme1);
-            themeElements1.Append(fontScheme2);
-            themeElements1.Append(formatScheme1);
-            A.ObjectDefaults objectDefaults1 = new A.ObjectDefaults();
-            A.ExtraColorSchemeList extraColorSchemeList1 = new A.ExtraColorSchemeList();
-
-            theme1.Append(themeElements1);
-            theme1.Append(objectDefaults1);
-            theme1.Append(extraColorSchemeList1);
-
-            themePart1.Theme = theme1;
-        }
-
-        private void SetPackageProperties(OpenXmlPackage document)
-        {
-            document.PackageProperties.Creator = "";
-            document.PackageProperties.Created = System.Xml.XmlConvert.ToDateTime("2009-08-12T20:10:16Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind);
-            document.PackageProperties.Modified = System.Xml.XmlConvert.ToDateTime("2010-05-10T20:23:10Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind);
-            document.PackageProperties.LastModifiedBy = "";
-        }
-
+        /// <summary>
+        /// Gets the default style for new cells in this workbook.
+        /// </summary>
+        public XLStyle WorkbookStyle { get; private set; }
 
         #endregion
+
+        #region Static
+
+        private static XLStyle defaultStyle;
+        /// <summary>
+        /// Gets the default style for new workbooks.
+        /// </summary>
+        public static XLStyle DefaultStyle
+        {
+            get
+            {
+                if (defaultStyle == null)
+                {
+                    defaultStyle = new XLStyle(null, null)
+                    {
+                        Font = new XLFont(null, null)
+                        {
+                            Bold = false,
+                            Italic = false,
+                            Underline = XLFontUnderlineValues.None,
+                            Strikethrough = false,
+                            VerticalAlignment = XLFontVerticalTextAlignmentValues.Baseline,
+                            FontSize = 11,
+                            Color = "FF000000",
+                            FontName = "Calibri",
+                            FontFamilyNumbering = 2
+                        },
+                        Fill = new XLFill(null, null)
+                        {
+                            BackgroundColor = "FFFFFFFF",
+                            PatternType = XLFillPatternValues.None
+                        },
+                        Border = new XLBorder(null, null)
+                        {
+                            BottomBorder = XLBorderStyleValues.None,
+                            DiagonalBorder = XLBorderStyleValues.None,
+                            DiagonalDown = false,
+                            DiagonalUp = false,
+                            LeftBorder = XLBorderStyleValues.None,
+                            RightBorder = XLBorderStyleValues.None,
+                            TopBorder = XLBorderStyleValues.None,
+                            BottomBorderColor = "000000",
+                            DiagonalBorderColor = "000000",
+                            LeftBorderColor = "000000",
+                            RightBorderColor = "000000",
+                            TopBorderColor = "000000"
+                        },
+                        NumberFormat = new XLNumberFormat(null, null),
+                        Alignment = new XLAlignment(null, null)
+                        {
+                            Horizontal = XLAlignmentHorizontalValues.General,
+                            Indent = 0,
+                            JustifyLastLine = false,
+                            ReadingOrder = XLAlignmentReadingOrderValues.ContextDependent,
+                            RelativeIndent = 0,
+                            ShrinkToFit = false,
+                            TextRotation = 0,
+                            Vertical = XLAlignmentVerticalValues.Bottom,
+                            WrapText = false
+                        }
+                    };
+                }
+                return defaultStyle;
+            }
+        }
+
+        #endregion
+
+        #region Constructors
+
+        /// <summary>
+        /// Initializes a new instance of the <see cref="XLWorkbook"/> class.
+        /// </summary>
+        /// <param name="file">New Excel file to be created.</param>
+        public XLWorkbook(String file)
+        {
+            if (File.Exists(file))
+                throw new ArgumentException("File already exists.");
+
+            FileInfo fi = new FileInfo(file);
+            this.Name = fi.Name;
+            this.FullName = fi.FullName;
+            Worksheets = new XLWorksheets(this);
+
+            WorkbookStyle = new XLStyle(XLWorkbook.DefaultStyle, null);
+        }
+
+        #endregion
+
+        #region Methods
+
+        /// <summary>
+        /// Saves the current workbook to disk.
+        /// </summary>
+        public void Save()
+        {
+            // For maintainability reasons the XLWorkbook class was divided into two files.
+            // The method CreatePackage can be located in the file XLWorkbook_Save.cs
+            CreatePackage(this.FullName);
+        }
+
+        #endregion
+
     }
 }
diff --git a/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs
new file mode 100644
index 0000000..571ab35
--- /dev/null
+++ b/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs
@@ -0,0 +1,1230 @@
+using DocumentFormat.OpenXml.Packaging;
+using Ap = DocumentFormat.OpenXml.ExtendedProperties;
+using Vt = DocumentFormat.OpenXml.VariantTypes;
+using DocumentFormat.OpenXml;
+using DocumentFormat.OpenXml.Spreadsheet;
+using A = DocumentFormat.OpenXml.Drawing;
+using Xdr = DocumentFormat.OpenXml.Drawing.Spreadsheet;
+using C = DocumentFormat.OpenXml.Drawing.Charts;
+
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.IO;
+using ClosedXML.Excel.Style;
+
+
+namespace ClosedXML.Excel
+{
+    public partial class XLWorkbook
+    {
+        
+        private Dictionary<String, UInt32> sharedStrings = new Dictionary<string, UInt32>();
+        private struct FontInfo { public UInt32 FontId; public XLFont Font; };
+        private struct FillInfo { public UInt32 FillId; public XLFill Fill; };
+        private struct BorderInfo { public UInt32 BorderId; public XLBorder Border; };
+        private struct NumberFormatInfo { public UInt32 NumberFormatId; public XLNumberFormat NumberFormat; };
+      
+
+        private struct StyleInfo 
+        { 
+            public UInt32 StyleId; 
+            public UInt32 FontId; 
+            public UInt32 FillId;
+            public UInt32 BorderId;
+            public UInt32 NumberFormatId;
+            public XLStyle Style; 
+        };
+
+        private Dictionary<String, StyleInfo> sharedStyles = new Dictionary<String, StyleInfo>();
+
+        private CellValues GetCellValue(XLCellValues xlCellValue)
+        { 
+            switch (xlCellValue)
+            {
+                case XLCellValues.Boolean: return CellValues.Boolean;
+                case XLCellValues.DateTime: return CellValues.Date;
+                case XLCellValues.Number: return CellValues.Number;
+                case XLCellValues.SharedString: return CellValues.SharedString;
+                default: throw new NotImplementedException();
+            }
+        }
+
+        private UnderlineValues GetUnderlineValue(XLFontUnderlineValues xlFontUnderlineValue)
+        {
+            switch (xlFontUnderlineValue)
+            {
+                case XLFontUnderlineValues.Double: return UnderlineValues.Double;
+                case XLFontUnderlineValues.DoubleAccounting: return UnderlineValues.DoubleAccounting;
+                case XLFontUnderlineValues.None: return UnderlineValues.None;
+                case XLFontUnderlineValues.Single: return UnderlineValues.Single;
+                case XLFontUnderlineValues.SingleAccounting: return UnderlineValues.SingleAccounting;
+                default: throw new NotImplementedException();
+            }
+        }
+
+        private VerticalAlignmentRunValues GetVerticalAlignmentRunValue(XLFontVerticalTextAlignmentValues xlFontVerticalTextAlignmentValue)
+        {
+            switch (xlFontVerticalTextAlignmentValue)
+            {
+                case XLFontVerticalTextAlignmentValues.Baseline: return VerticalAlignmentRunValues.Baseline;
+                case XLFontVerticalTextAlignmentValues.Subscript: return VerticalAlignmentRunValues.Subscript;
+                case XLFontVerticalTextAlignmentValues.Superscript: return VerticalAlignmentRunValues.Superscript;
+                default: throw new NotImplementedException();
+            }
+        }
+
+        private PatternValues GetPatternValue(XLFillPatternValues xlFillPatternValue)
+        {
+            switch (xlFillPatternValue)
+            {
+                case XLFillPatternValues.DarkDown: return PatternValues.DarkDown;
+                case XLFillPatternValues.DarkGray: return PatternValues.DarkGray;
+                case XLFillPatternValues.DarkGrid: return PatternValues.DarkGrid;
+                case XLFillPatternValues.DarkHorizontal: return PatternValues.DarkHorizontal;
+                case XLFillPatternValues.DarkTrellis: return PatternValues.DarkTrellis;
+                case XLFillPatternValues.DarkUp: return PatternValues.DarkUp;
+                case XLFillPatternValues.DarkVertical: return PatternValues.DarkVertical;
+                case XLFillPatternValues.Gray0625: return PatternValues.Gray0625;
+                case XLFillPatternValues.Gray125: return PatternValues.Gray125;
+                case XLFillPatternValues.LightDown: return PatternValues.LightDown;
+                case XLFillPatternValues.LightGray: return PatternValues.LightGray;
+                case XLFillPatternValues.LightGrid: return PatternValues.LightGrid;
+                case XLFillPatternValues.LightHorizontal: return PatternValues.LightHorizontal;
+                case XLFillPatternValues.LightTrellis: return PatternValues.LightTrellis;
+                case XLFillPatternValues.LightUp: return PatternValues.LightUp;
+                case XLFillPatternValues.LightVertical: return PatternValues.LightVertical;
+                case XLFillPatternValues.MediumGray: return PatternValues.MediumGray;
+                case XLFillPatternValues.None: return PatternValues.None;
+                case XLFillPatternValues.Solid: return PatternValues.Solid;
+                default: throw new NotImplementedException();
+            }
+        }
+
+        private BorderStyleValues GetBorderStyleValue(XLBorderStyleValues xlBorderStyleValue)
+        {
+            switch (xlBorderStyleValue)
+            {
+                case XLBorderStyleValues.DashDot: return BorderStyleValues.DashDot;
+                case XLBorderStyleValues.DashDotDot: return BorderStyleValues.DashDotDot;
+                case XLBorderStyleValues.Dashed: return BorderStyleValues.Dashed;
+                case XLBorderStyleValues.Dotted: return BorderStyleValues.Dotted;
+                case XLBorderStyleValues.Double: return BorderStyleValues.Double;
+                case XLBorderStyleValues.Hair: return BorderStyleValues.Hair;
+                case XLBorderStyleValues.Medium: return BorderStyleValues.Medium;
+                case XLBorderStyleValues.MediumDashDot: return BorderStyleValues.MediumDashDot;
+                case XLBorderStyleValues.MediumDashDotDot: return BorderStyleValues.MediumDashDotDot;
+                case XLBorderStyleValues.MediumDashed: return BorderStyleValues.MediumDashed;
+                case XLBorderStyleValues.None: return BorderStyleValues.None;
+                case XLBorderStyleValues.SlantDashDot: return BorderStyleValues.SlantDashDot;
+                case XLBorderStyleValues.Thick: return BorderStyleValues.Thick;
+                case XLBorderStyleValues.Thin: return BorderStyleValues.Thin;
+                default: throw new NotImplementedException();
+            }
+        }
+
+        private HorizontalAlignmentValues GetHorizontalAlignmentValue(XLAlignmentHorizontalValues xlAlignmentHorizontalValue)
+        {
+            switch (xlAlignmentHorizontalValue)
+            {
+                case XLAlignmentHorizontalValues.Center: return HorizontalAlignmentValues.Center;
+                case XLAlignmentHorizontalValues.CenterContinuous: return HorizontalAlignmentValues.CenterContinuous;
+                case XLAlignmentHorizontalValues.Distributed: return HorizontalAlignmentValues.Distributed;
+                case XLAlignmentHorizontalValues.Fill: return HorizontalAlignmentValues.Fill;
+                case XLAlignmentHorizontalValues.General: return HorizontalAlignmentValues.General;
+                case XLAlignmentHorizontalValues.Justify: return HorizontalAlignmentValues.Justify;
+                case XLAlignmentHorizontalValues.Left: return HorizontalAlignmentValues.Left;
+                case XLAlignmentHorizontalValues.Right: return HorizontalAlignmentValues.Right;
+                default: throw new NotImplementedException();
+            }
+        }
+
+        private VerticalAlignmentValues GetVerticalAlignmentValue(XLAlignmentVerticalValues xlAlignmentVerticalValue)
+        {
+            switch (xlAlignmentVerticalValue)
+            {
+                case XLAlignmentVerticalValues.Bottom: return VerticalAlignmentValues.Bottom;
+                case XLAlignmentVerticalValues.Center: return VerticalAlignmentValues.Center;
+                case XLAlignmentVerticalValues.Distributed: return VerticalAlignmentValues.Distributed;
+                case XLAlignmentVerticalValues.Justify: return VerticalAlignmentValues.Justify;
+                case XLAlignmentVerticalValues.Top: return VerticalAlignmentValues.Top;
+                default: throw new NotImplementedException();
+            }
+        }
+
+        // Creates a SpreadsheetDocument.
+        private void CreatePackage(String filePath)
+        {
+            using (SpreadsheetDocument package = SpreadsheetDocument.Create(filePath, SpreadsheetDocumentType.Workbook))
+            {
+                CreateParts(package);
+            }
+        }
+
+        // Adds child parts and generates content of the specified part.
+        private void CreateParts(SpreadsheetDocument document)
+        {
+            ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart<ExtendedFilePropertiesPart>("rId3");
+            GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1);
+
+            WorkbookPart workbookPart = document.AddWorkbookPart();
+            GenerateWorkbookPartContent(workbookPart);
+
+            SharedStringTablePart sharedStringTablePart = workbookPart.AddNewPart<SharedStringTablePart>("rId6");
+            GenerateSharedStringTablePartContent(sharedStringTablePart);
+
+            WorkbookStylesPart workbookStylesPart = workbookPart.AddNewPart<WorkbookStylesPart>("rId5");
+            GenerateWorkbookStylesPartContent(workbookStylesPart);
+
+            UInt32 sheetId = 0;
+            foreach (var xlWorksheet in this.Worksheets)
+            {
+                sheetId++;
+                WorksheetPart worksheetPart = workbookPart.AddNewPart<WorksheetPart>("rId" + sheetId.ToString());
+                GenerateWorksheetPartContent(worksheetPart, xlWorksheet);
+
+            }            
+
+            ThemePart themePart1 = workbookPart.AddNewPart<ThemePart>("rId4");
+            GenerateThemePart1Content(themePart1);
+
+            SetPackageProperties(document);
+        }
+
+        // Generates content of extendedFilePropertiesPart1.
+        private void GenerateExtendedFilePropertiesPart1Content(ExtendedFilePropertiesPart extendedFilePropertiesPart1)
+        {
+            Ap.Properties properties1 = new Ap.Properties();
+            properties1.AddNamespaceDeclaration("vt", "http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes");
+            Ap.Application application1 = new Ap.Application();
+            application1.Text = "Microsoft Excel";
+            Ap.DocumentSecurity documentSecurity1 = new Ap.DocumentSecurity();
+            documentSecurity1.Text = "0";
+            Ap.ScaleCrop scaleCrop1 = new Ap.ScaleCrop();
+            scaleCrop1.Text = "false";
+
+            Ap.HeadingPairs headingPairs1 = new Ap.HeadingPairs();
+
+            Vt.VTVector vTVector1 = new Vt.VTVector() { BaseType = Vt.VectorBaseValues.Variant, Size = (UInt32Value)2U };
+
+            Vt.Variant variant1 = new Vt.Variant();
+            Vt.VTLPSTR vTLPSTR1 = new Vt.VTLPSTR();
+            vTLPSTR1.Text = "Worksheets";
+
+            variant1.Append(vTLPSTR1);
+
+            Vt.Variant variant2 = new Vt.Variant();
+            Vt.VTInt32 vTInt321 = new Vt.VTInt32();
+            vTInt321.Text = "3";
+
+            variant2.Append(vTInt321);
+
+            vTVector1.Append(variant1);
+            vTVector1.Append(variant2);
+
+            headingPairs1.Append(vTVector1);
+
+            Ap.TitlesOfParts titlesOfParts1 = new Ap.TitlesOfParts();
+
+            UInt32 sheetCount = (UInt32)this.Worksheets.Count;
+            Vt.VTVector vTVector2 = new Vt.VTVector() { BaseType = Vt.VectorBaseValues.Lpstr, Size = (UInt32Value)sheetCount };
+            foreach (var xlWorksheet in this.Worksheets)
+            {
+                Vt.VTLPSTR vTLPSTR2 = new Vt.VTLPSTR();
+                vTLPSTR2.Text = xlWorksheet.Name;
+                vTVector2.Append(vTLPSTR2);
+            }
+
+            titlesOfParts1.Append(vTVector2);
+            Ap.Company company1 = new Ap.Company();
+            company1.Text = "NSI";
+            Ap.LinksUpToDate linksUpToDate1 = new Ap.LinksUpToDate();
+            linksUpToDate1.Text = "false";
+            Ap.SharedDocument sharedDocument1 = new Ap.SharedDocument();
+            sharedDocument1.Text = "false";
+            Ap.HyperlinksChanged hyperlinksChanged1 = new Ap.HyperlinksChanged();
+            hyperlinksChanged1.Text = "false";
+            Ap.ApplicationVersion applicationVersion1 = new Ap.ApplicationVersion();
+            applicationVersion1.Text = "12.0000";
+
+            properties1.Append(application1);
+            properties1.Append(documentSecurity1);
+            properties1.Append(scaleCrop1);
+            properties1.Append(headingPairs1);
+            properties1.Append(titlesOfParts1);
+            properties1.Append(company1);
+            properties1.Append(linksUpToDate1);
+            properties1.Append(sharedDocument1);
+            properties1.Append(hyperlinksChanged1);
+            properties1.Append(applicationVersion1);
+
+            extendedFilePropertiesPart1.Properties = properties1;
+        }
+
+        // Generates content of workbookPart1.
+        private void GenerateWorkbookPartContent(WorkbookPart workbookPart1)
+        {
+            Workbook workbook1 = new Workbook();
+            workbook1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
+            FileVersion fileVersion1 = new FileVersion() { ApplicationName = "xl", LastEdited = "4", LowestEdited = "4", BuildVersion = "4506" };
+            WorkbookProperties workbookProperties1 = new WorkbookProperties() { CodeName = "ThisWorkbook", DefaultThemeVersion = (UInt32Value)124226U };
+
+            BookViews bookViews1 = new BookViews();
+            WorkbookView workbookView1 = new WorkbookView() { XWindow = 0, YWindow = 30, WindowWidth = (UInt32Value)14160U, WindowHeight = (UInt32Value)11580U };
+
+            bookViews1.Append(workbookView1);
+
+            UInt32 sheetId = 0;
+            Sheets sheets = new Sheets();
+            foreach (var xlWorksheet in this.Worksheets)
+            {
+                sheetId++;
+                Sheet sheet = new Sheet() { Name = xlWorksheet.Name, SheetId = (UInt32Value)sheetId, Id = "rId" + sheetId.ToString() };
+                sheets.Append(sheet);
+            }
+
+            CalculationProperties calculationProperties1 = new CalculationProperties() { CalculationId = (UInt32Value)125725U, CalculationMode = CalculateModeValues.Manual };
+
+            workbook1.Append(fileVersion1);
+            workbook1.Append(workbookProperties1);
+            workbook1.Append(bookViews1);
+            workbook1.Append(sheets);
+            workbook1.Append(calculationProperties1);
+
+            workbookPart1.Workbook = workbook1;
+        }
+
+        // Generates content of worksheetPart3.
+        private void GenerateWorksheetPartContent(WorksheetPart worksheetPart, XLRange xlWorksheet)
+        {
+            Worksheet worksheet = new Worksheet();
+            worksheet.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
+            SheetProperties sheetProperties = new SheetProperties() { CodeName = xlWorksheet.Name };
+
+            UInt32 maxColumn = 0;
+            UInt32 maxRow = 0;
+
+            String sheetDimensionReference = "A1";
+            if (xlWorksheet.Cells().Count() > 0)
+            {
+                maxColumn = xlWorksheet.Cells().Select(c => c.Address.Column).Max();
+                maxRow = xlWorksheet.Cells().Select(c => c.Address.Row).Max();
+                sheetDimensionReference = "A1:" + new XLAddress(maxRow, maxColumn).ToString();
+            }
+            
+            SheetDimension sheetDimension = new SheetDimension() { Reference = sheetDimensionReference };
+
+            Boolean tabSelected = xlWorksheet.Name == this.Worksheets.First().Name;
+
+            SheetViews sheetViews = new SheetViews();
+            SheetView sheetView = new SheetView() { TabSelected = tabSelected, WorkbookViewId = (UInt32Value)0U };
+
+            sheetViews.Append(sheetView);
+            SheetFormatProperties sheetFormatProperties3 = new SheetFormatProperties() { DefaultRowHeight = 15D };
+
+            SheetData sheetData = new SheetData();
+
+            var distinctRows = xlWorksheet.Cells().Select(c => c.Address.Row).Distinct();
+            foreach (var distinctRow in distinctRows.OrderBy(r=>r))
+            {
+                Row row = new Row() { RowIndex = (UInt32Value)distinctRow, Spans = new ListValue<StringValue>() { InnerText = "1:" + maxColumn.ToString() } };
+                foreach (XLRange opCell in xlWorksheet.Cells().Where(c => c.Address.Row == distinctRow).Select(c => c))
+                {
+                    var styleId = sharedStyles[opCell.Style.ToString()].StyleId;
+                    Cell cell;
+                    var dataType = opCell.DataType;
+                    var cellReference = opCell.Address.ToString();
+                    if (opCell.DataType == XLCellValues.DateTime)
+                    {
+                        cell = new Cell()
+                        {
+                            CellReference = cellReference,
+                            StyleIndex = styleId
+                        };
+                    }
+                    else if (styleId == 0)
+                    {
+                        cell = new Cell()
+                        {
+                            CellReference = cellReference,
+                            DataType = GetCellValue(dataType)
+                        };
+                    }
+                    else
+                    {
+                        cell = new Cell()
+                        {
+                            CellReference = cellReference,
+                            DataType = GetCellValue(dataType),
+                            StyleIndex = styleId
+                        };
+                    }
+                    CellValue cellValue = new CellValue();
+                    if (!opCell.HasValue)
+                    {
+                        cellValue.Text = String.Empty;
+                    }
+                    else if (dataType == XLCellValues.SharedString)
+                    {
+                        cellValue.Text = sharedStrings[opCell.Value].ToString();
+                    }
+                    else
+                    {
+                        cellValue.Text = opCell.Value;
+                    }
+
+                    cell.Append(cellValue);
+                    row.Append(cell);
+                }
+                sheetData.Append(row);
+            }
+            
+            PageMargins pageMargins = new PageMargins() { Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };
+            Drawing drawing1 = new Drawing() { Id = "rId1" };
+            worksheet.Append(sheetProperties);
+            worksheet.Append(sheetDimension);
+            worksheet.Append(sheetViews);
+            worksheet.Append(sheetFormatProperties3);
+            worksheet.Append(sheetData);
+            worksheet.Append(pageMargins);
+            //worksheet.Append(drawing1);
+
+            worksheetPart.Worksheet = worksheet;
+        }
+
+        // Generates content of sharedStringTablePart1.
+        private void GenerateSharedStringTablePartContent(SharedStringTablePart sharedStringTablePart)
+        {
+            List<String> combined = new List<String>();
+            this.Worksheets.ForEach(w => combined.AddRange(w.Cells().Where(c => c.DataType == XLCellValues.SharedString && c.HasValue).Select(c => c.Value).Distinct()));
+            var distinctStrings = combined.Distinct();
+            UInt32 stringCount = (UInt32)distinctStrings.Count();
+            SharedStringTable sharedStringTable = new SharedStringTable() { Count = (UInt32Value)stringCount, UniqueCount = (UInt32Value)stringCount };
+
+            UInt32 stringId = 0;
+            foreach (var s in distinctStrings)
+            {
+                sharedStrings.Add(s, stringId++);
+
+                SharedStringItem sharedStringItem = new SharedStringItem();
+                Text text = new Text();
+                text.Text = s;
+                sharedStringItem.Append(text);
+                sharedStringTable.Append(sharedStringItem);
+            }
+
+            sharedStringTablePart.SharedStringTable = sharedStringTable;
+        }
+
+        // Generates content of workbookStylesPart1.
+        private void GenerateWorkbookStylesPartContent(WorkbookStylesPart workbookStylesPart)
+        {
+            var defaultStyle = this.WorkbookStyle;
+            Dictionary<String, FontInfo> sharedFonts = new Dictionary<String, FontInfo>();
+            sharedFonts.Add(defaultStyle.Font.ToString(), new FontInfo() { FontId = 0, Font = defaultStyle.Font });
+
+            Dictionary<String, FillInfo> sharedFills = new Dictionary<String, FillInfo>();
+            sharedFills.Add(defaultStyle.Fill.ToString(), new FillInfo() { FillId = 2, Fill = defaultStyle.Fill });
+
+            Dictionary<String, BorderInfo> sharedBorders = new Dictionary<String, BorderInfo>();
+            sharedBorders.Add(defaultStyle.Border.ToString(), new BorderInfo() { BorderId = 0, Border = defaultStyle.Border });
+
+            Dictionary<String, NumberFormatInfo> sharedNumberFormats = new Dictionary<String, NumberFormatInfo>();
+            sharedNumberFormats.Add(defaultStyle.NumberFormat.ToString(), new NumberFormatInfo() { NumberFormatId = 0, NumberFormat = defaultStyle.NumberFormat });
+
+            sharedStyles.Add(defaultStyle.ToString(),
+                new StyleInfo()
+                {
+                    StyleId = 0,
+                    Style = defaultStyle,
+                    FontId = 0,
+                    FillId = 0,
+                    BorderId = 0,
+                    NumberFormatId = 0
+                });
+
+            UInt32 styleCount = 1;
+            UInt32 fontCount = 1;
+            UInt32 fillCount = 3;
+            UInt32 borderCount = 1;
+            UInt32 numberFormatCount = 1;
+            
+            foreach (var worksheet in this.Worksheets)
+            {
+                foreach (var cell in worksheet.Cells())
+                {
+                    if (!sharedFonts.ContainsKey(cell.Style.Font.ToString()))
+                    {
+                        sharedFonts.Add(cell.Style.Font.ToString(), new FontInfo() { FontId = fontCount++, Font = cell.Style.Font });
+                    }
+
+                    if (!sharedFills.ContainsKey(cell.Style.Fill.ToString()))
+                    {
+                        sharedFills.Add(cell.Style.Fill.ToString(), new FillInfo() { FillId = fillCount++, Fill = cell.Style.Fill });
+                    }
+
+                    if (!sharedBorders.ContainsKey(cell.Style.Border.ToString()))
+                    {
+                        sharedBorders.Add(cell.Style.Border.ToString(), new BorderInfo() { BorderId = borderCount++, Border = cell.Style.Border });
+                    }
+
+                    if (!cell.Style.NumberFormat.NumberFormatId.HasValue && !sharedNumberFormats.ContainsKey(cell.Style.NumberFormat.ToString()))
+                    {
+                        sharedNumberFormats.Add(cell.Style.NumberFormat.ToString(), new NumberFormatInfo() { NumberFormatId = numberFormatCount + 164, NumberFormat = cell.Style.NumberFormat });
+                        numberFormatCount++;
+                    }
+
+                    if (!sharedStyles.ContainsKey(cell.Style.ToString()))
+                    {
+                        UInt32 numberFormatId;
+                        if (cell.Style.NumberFormat.NumberFormatId.HasValue)
+                            numberFormatId = cell.Style.NumberFormat.NumberFormatId.Value;
+                        else
+                            numberFormatId = sharedNumberFormats[cell.Style.NumberFormat.ToString()].NumberFormatId;
+
+                        sharedStyles.Add(cell.Style.ToString(),
+                            new StyleInfo()
+                            {
+                                StyleId = styleCount++,
+                                Style = cell.Style,
+                                FontId = sharedFonts[cell.Style.Font.ToString()].FontId,
+                                FillId = sharedFills[cell.Style.Fill.ToString()].FillId,
+                                BorderId = sharedBorders[cell.Style.Border.ToString()].BorderId,
+                                NumberFormatId = numberFormatId
+                            });
+                    }
+                }
+            }
+
+            Stylesheet stylesheet1 = new Stylesheet();
+
+            NumberingFormats numberingFormats = new NumberingFormats() { Count = (UInt32Value)numberFormatCount };
+            foreach (var numberFormatInfo in sharedNumberFormats.Values)
+            {
+                NumberingFormat numberingFormat = new NumberingFormat() { NumberFormatId = (UInt32Value)numberFormatInfo.NumberFormatId, FormatCode = numberFormatInfo.NumberFormat.Format };
+                numberingFormats.Append(numberingFormat);
+            }
+
+            Fonts fonts = new Fonts() { Count = (UInt32Value)fontCount };
+
+            foreach (var fontInfo in sharedFonts.Values)
+            {
+                Bold bold = new Bold() { Val = fontInfo.Font.Bold };
+                Italic italic = new Italic() { Val = fontInfo.Font.Italic };
+                Underline underline = new Underline() { Val = GetUnderlineValue(fontInfo.Font.Underline) };
+                Strike strike = new Strike() { Val = fontInfo.Font.Strikethrough };
+                VerticalTextAlignment verticalAlignment = new VerticalTextAlignment() { Val = GetVerticalAlignmentRunValue(fontInfo.Font.VerticalAlignment)};
+                Font font = new Font();
+                FontSize fontSize = new FontSize() { Val = fontInfo.Font.FontSize };
+                Color color = new Color() { Rgb = fontInfo.Font.Color };
+                FontName fontName = new FontName() { Val = fontInfo.Font.FontName };
+                FontFamilyNumbering fontFamilyNumbering = new FontFamilyNumbering() { Val = fontInfo.Font.FontFamilyNumbering };
+                FontScheme fontScheme = new FontScheme() { Val = FontSchemeValues.Minor };
+
+                font.Append(bold);
+                font.Append(italic);
+                font.Append(underline);
+                font.Append(strike);
+                font.Append(verticalAlignment);
+                font.Append(fontSize);
+                font.Append(color);
+                font.Append(fontName);
+                font.Append(fontFamilyNumbering);
+                font.Append(fontScheme);
+
+                fonts.Append(font);
+            }
+
+            Fills fills = new Fills() { Count = (UInt32Value)fillCount };
+
+            Fill fill1 = new Fill();
+            PatternFill patternFill1 = new PatternFill() { PatternType = PatternValues.None };
+            fill1.Append(patternFill1);
+            fills.Append(fill1);
+
+            Fill fill2 = new Fill();
+            PatternFill patternFill2 = new PatternFill() { PatternType = PatternValues.Gray125 };
+            fill2.Append(patternFill2);
+            fills.Append(fill2);
+
+            foreach (var fillInfo in sharedFills.Values)
+            {
+                Fill fill = new Fill();
+                PatternFill patternFill = new PatternFill() { PatternType = GetPatternValue(fillInfo.Fill.PatternType) };
+                ForegroundColor foregroundColor = new ForegroundColor() { Rgb = fillInfo.Fill.PatternColor };
+                BackgroundColor backgroundColor = new BackgroundColor() { Rgb = fillInfo.Fill.PatternBackgroundColor };
+
+                patternFill.Append(foregroundColor);
+                patternFill.Append(backgroundColor);
+
+                fill.Append(patternFill);
+                fills.Append(fill);
+            }
+
+            Borders borders = new Borders() { Count = (UInt32Value)borderCount };
+
+            foreach (var borderInfo in sharedBorders.Values)
+            {
+                Border border = new Border() { DiagonalUp = borderInfo.Border.DiagonalUp, DiagonalDown = borderInfo.Border.DiagonalDown };
+
+                LeftBorder leftBorder = new LeftBorder() { Style = GetBorderStyleValue(borderInfo.Border.LeftBorder) };
+                Color leftBorderColor = new Color() { Rgb = borderInfo.Border.LeftBorderColor };
+                leftBorder.Append(leftBorderColor);
+                border.Append(leftBorder);
+
+                RightBorder rightBorder = new RightBorder() { Style = GetBorderStyleValue(borderInfo.Border.RightBorder) };
+                Color rightBorderColor = new Color() { Rgb = borderInfo.Border.RightBorderColor };
+                rightBorder.Append(rightBorderColor);
+                border.Append(rightBorder);
+
+                TopBorder topBorder = new TopBorder() { Style = GetBorderStyleValue(borderInfo.Border.TopBorder) };
+                Color topBorderColor = new Color() { Rgb = borderInfo.Border.TopBorderColor };
+                topBorder.Append(topBorderColor);
+                border.Append(topBorder);
+
+                BottomBorder bottomBorder = new BottomBorder() { Style = GetBorderStyleValue(borderInfo.Border.BottomBorder) };
+                Color bottomBorderColor = new Color() { Rgb = borderInfo.Border.BottomBorderColor };
+                bottomBorder.Append(bottomBorderColor);
+                border.Append(bottomBorder);
+
+                DiagonalBorder diagonalBorder = new DiagonalBorder() { Style = GetBorderStyleValue(borderInfo.Border.DiagonalBorder) };
+                Color diagonalBorderColor = new Color() { Rgb = borderInfo.Border.DiagonalBorderColor };
+                diagonalBorder.Append(diagonalBorderColor);
+                border.Append(diagonalBorder);
+
+                borders.Append(border);
+            }
+
+            
+
+            // Cell style formats = Formats to be used by the cells and named styles
+            CellStyleFormats cellStyleFormats = new CellStyleFormats() { Count = (UInt32Value)styleCount };
+            // Cell formats = Any kind of formatting applied to a cell
+            CellFormats cellFormats = new CellFormats() { Count = (UInt32Value)styleCount };
+            foreach (var styleInfo in sharedStyles.Values)
+            {
+                var formatId = styleInfo.StyleId;
+                var numberFormatId = styleInfo.NumberFormatId;
+                var fontId = styleInfo.FontId;
+                var fillId = styleInfo.FillId;
+                var borderId = styleInfo.BorderId;
+                Boolean applyFill = styleInfo.Style.Fill.PatternType == XLFillPatternValues.None;
+                XLBorder opBorder = styleInfo.Style.Border;
+                Boolean applyBorder = (
+                       opBorder.BottomBorder != XLBorderStyleValues.None 
+                    || opBorder.DiagonalBorder != XLBorderStyleValues.None 
+                    || opBorder.RightBorder != XLBorderStyleValues.None
+                    || opBorder.LeftBorder != XLBorderStyleValues.None 
+                    || opBorder.TopBorder != XLBorderStyleValues.None);
+
+                CellFormat cellStyleFormat = new CellFormat() { NumberFormatId = (UInt32Value)numberFormatId, FontId = (UInt32Value)fontId, FillId = (UInt32Value)fillId, BorderId = (UInt32Value)borderId, ApplyNumberFormat = false, ApplyFill = applyFill, ApplyBorder = applyBorder, ApplyAlignment = false, ApplyProtection = false };
+                cellStyleFormats.Append(cellStyleFormat);
+
+                CellFormat cellFormat = new CellFormat() { NumberFormatId = (UInt32Value)numberFormatId, FontId = (UInt32Value)fontId, FillId = (UInt32Value)fillId, BorderId = (UInt32Value)borderId, FormatId = (UInt32Value)formatId, ApplyNumberFormat = false, ApplyFill = applyFill, ApplyBorder = applyBorder, ApplyAlignment = false, ApplyProtection = false };
+                Alignment alignment = new Alignment() { Horizontal = GetHorizontalAlignmentValue(styleInfo.Style.Alignment.Horizontal), Vertical = GetVerticalAlignmentValue(styleInfo.Style.Alignment.Vertical), Indent = styleInfo.Style.Alignment.Indent, ReadingOrder = (UInt32)styleInfo.Style.Alignment.ReadingOrder, WrapText = styleInfo.Style.Alignment.WrapText, TextRotation = styleInfo.Style.Alignment.TextRotation, ShrinkToFit = styleInfo.Style.Alignment.ShrinkToFit, RelativeIndent = styleInfo.Style.Alignment.RelativeIndent, JustifyLastLine = styleInfo.Style.Alignment.JustifyLastLine };
+                cellFormat.Append(alignment);
+
+                cellFormats.Append(cellFormat);
+            }
+
+            
+
+            // Cell styles = Named styles
+            CellStyles cellStyles1 = new CellStyles() { Count = (UInt32Value)1U };
+            var defaultFormatId = sharedStyles.Values.Where(s => s.Style.ToString() == this.WorkbookStyle.ToString()).Single().StyleId;
+            CellStyle cellStyle1 = new CellStyle() { Name = "Normal", FormatId = (UInt32Value)defaultFormatId, BuiltinId = (UInt32Value)0U };
+            cellStyles1.Append(cellStyle1);
+
+            DifferentialFormats differentialFormats1 = new DifferentialFormats() { Count = (UInt32Value)0U };
+            TableStyles tableStyles1 = new TableStyles() { Count = (UInt32Value)0U, DefaultTableStyle = "TableStyleMedium9", DefaultPivotStyle = "PivotStyleLight16" };
+
+            stylesheet1.Append(numberingFormats);
+            stylesheet1.Append(fonts);
+            stylesheet1.Append(fills);
+            stylesheet1.Append(borders);
+            stylesheet1.Append(cellStyleFormats);
+            stylesheet1.Append(cellFormats);
+            stylesheet1.Append(cellStyles1);
+            stylesheet1.Append(differentialFormats1);
+            stylesheet1.Append(tableStyles1);
+
+            workbookStylesPart.Stylesheet = stylesheet1;
+        }
+
+        // Generates content of themePart1.
+        private void GenerateThemePart1Content(ThemePart themePart1)
+        {
+            A.Theme theme1 = new A.Theme() { Name = "Office Theme" };
+            theme1.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");
+
+            A.ThemeElements themeElements1 = new A.ThemeElements();
+
+            A.ColorScheme colorScheme1 = new A.ColorScheme() { Name = "Office" };
+
+            A.Dark1Color dark1Color1 = new A.Dark1Color();
+            A.SystemColor systemColor1 = new A.SystemColor() { Val = A.SystemColorValues.WindowText, LastColor = "000000" };
+
+            dark1Color1.Append(systemColor1);
+
+            A.Light1Color light1Color1 = new A.Light1Color();
+            A.SystemColor systemColor2 = new A.SystemColor() { Val = A.SystemColorValues.Window, LastColor = "FFFFFF" };
+
+            light1Color1.Append(systemColor2);
+
+            A.Dark2Color dark2Color1 = new A.Dark2Color();
+            A.RgbColorModelHex rgbColorModelHex1 = new A.RgbColorModelHex() { Val = "1F497D" };
+
+            dark2Color1.Append(rgbColorModelHex1);
+
+            A.Light2Color light2Color1 = new A.Light2Color();
+            A.RgbColorModelHex rgbColorModelHex2 = new A.RgbColorModelHex() { Val = "EEECE1" };
+
+            light2Color1.Append(rgbColorModelHex2);
+
+            A.Accent1Color accent1Color1 = new A.Accent1Color();
+            A.RgbColorModelHex rgbColorModelHex3 = new A.RgbColorModelHex() { Val = "4F81BD" };
+
+            accent1Color1.Append(rgbColorModelHex3);
+
+            A.Accent2Color accent2Color1 = new A.Accent2Color();
+            A.RgbColorModelHex rgbColorModelHex4 = new A.RgbColorModelHex() { Val = "C0504D" };
+
+            accent2Color1.Append(rgbColorModelHex4);
+
+            A.Accent3Color accent3Color1 = new A.Accent3Color();
+            A.RgbColorModelHex rgbColorModelHex5 = new A.RgbColorModelHex() { Val = "9BBB59" };
+
+            accent3Color1.Append(rgbColorModelHex5);
+
+            A.Accent4Color accent4Color1 = new A.Accent4Color();
+            A.RgbColorModelHex rgbColorModelHex6 = new A.RgbColorModelHex() { Val = "8064A2" };
+
+            accent4Color1.Append(rgbColorModelHex6);
+
+            A.Accent5Color accent5Color1 = new A.Accent5Color();
+            A.RgbColorModelHex rgbColorModelHex7 = new A.RgbColorModelHex() { Val = "4BACC6" };
+
+            accent5Color1.Append(rgbColorModelHex7);
+
+            A.Accent6Color accent6Color1 = new A.Accent6Color();
+            A.RgbColorModelHex rgbColorModelHex8 = new A.RgbColorModelHex() { Val = "F79646" };
+
+            accent6Color1.Append(rgbColorModelHex8);
+
+            A.Hyperlink hyperlink1 = new A.Hyperlink();
+            A.RgbColorModelHex rgbColorModelHex9 = new A.RgbColorModelHex() { Val = "0000FF" };
+
+            hyperlink1.Append(rgbColorModelHex9);
+
+            A.FollowedHyperlinkColor followedHyperlinkColor1 = new A.FollowedHyperlinkColor();
+            A.RgbColorModelHex rgbColorModelHex10 = new A.RgbColorModelHex() { Val = "800080" };
+
+            followedHyperlinkColor1.Append(rgbColorModelHex10);
+
+            colorScheme1.Append(dark1Color1);
+            colorScheme1.Append(light1Color1);
+            colorScheme1.Append(dark2Color1);
+            colorScheme1.Append(light2Color1);
+            colorScheme1.Append(accent1Color1);
+            colorScheme1.Append(accent2Color1);
+            colorScheme1.Append(accent3Color1);
+            colorScheme1.Append(accent4Color1);
+            colorScheme1.Append(accent5Color1);
+            colorScheme1.Append(accent6Color1);
+            colorScheme1.Append(hyperlink1);
+            colorScheme1.Append(followedHyperlinkColor1);
+
+            A.FontScheme fontScheme2 = new A.FontScheme() { Name = "Office" };
+
+            A.MajorFont majorFont1 = new A.MajorFont();
+            A.LatinFont latinFont1 = new A.LatinFont() { Typeface = "Cambria" };
+            A.EastAsianFont eastAsianFont1 = new A.EastAsianFont() { Typeface = "" };
+            A.ComplexScriptFont complexScriptFont1 = new A.ComplexScriptFont() { Typeface = "" };
+            A.SupplementalFont supplementalFont1 = new A.SupplementalFont() { Script = "Jpan", Typeface = "ＭＳ Ｐゴシック" };
+            A.SupplementalFont supplementalFont2 = new A.SupplementalFont() { Script = "Hang", Typeface = "맑은 고딕" };
+            A.SupplementalFont supplementalFont3 = new A.SupplementalFont() { Script = "Hans", Typeface = "宋体" };
+            A.SupplementalFont supplementalFont4 = new A.SupplementalFont() { Script = "Hant", Typeface = "新細明體" };
+            A.SupplementalFont supplementalFont5 = new A.SupplementalFont() { Script = "Arab", Typeface = "Times New Roman" };
+            A.SupplementalFont supplementalFont6 = new A.SupplementalFont() { Script = "Hebr", Typeface = "Times New Roman" };
+            A.SupplementalFont supplementalFont7 = new A.SupplementalFont() { Script = "Thai", Typeface = "Tahoma" };
+            A.SupplementalFont supplementalFont8 = new A.SupplementalFont() { Script = "Ethi", Typeface = "Nyala" };
+            A.SupplementalFont supplementalFont9 = new A.SupplementalFont() { Script = "Beng", Typeface = "Vrinda" };
+            A.SupplementalFont supplementalFont10 = new A.SupplementalFont() { Script = "Gujr", Typeface = "Shruti" };
+            A.SupplementalFont supplementalFont11 = new A.SupplementalFont() { Script = "Khmr", Typeface = "MoolBoran" };
+            A.SupplementalFont supplementalFont12 = new A.SupplementalFont() { Script = "Knda", Typeface = "Tunga" };
+            A.SupplementalFont supplementalFont13 = new A.SupplementalFont() { Script = "Guru", Typeface = "Raavi" };
+            A.SupplementalFont supplementalFont14 = new A.SupplementalFont() { Script = "Cans", Typeface = "Euphemia" };
+            A.SupplementalFont supplementalFont15 = new A.SupplementalFont() { Script = "Cher", Typeface = "Plantagenet Cherokee" };
+            A.SupplementalFont supplementalFont16 = new A.SupplementalFont() { Script = "Yiii", Typeface = "Microsoft Yi Baiti" };
+            A.SupplementalFont supplementalFont17 = new A.SupplementalFont() { Script = "Tibt", Typeface = "Microsoft Himalaya" };
+            A.SupplementalFont supplementalFont18 = new A.SupplementalFont() { Script = "Thaa", Typeface = "MV Boli" };
+            A.SupplementalFont supplementalFont19 = new A.SupplementalFont() { Script = "Deva", Typeface = "Mangal" };
+            A.SupplementalFont supplementalFont20 = new A.SupplementalFont() { Script = "Telu", Typeface = "Gautami" };
+            A.SupplementalFont supplementalFont21 = new A.SupplementalFont() { Script = "Taml", Typeface = "Latha" };
+            A.SupplementalFont supplementalFont22 = new A.SupplementalFont() { Script = "Syrc", Typeface = "Estrangelo Edessa" };
+            A.SupplementalFont supplementalFont23 = new A.SupplementalFont() { Script = "Orya", Typeface = "Kalinga" };
+            A.SupplementalFont supplementalFont24 = new A.SupplementalFont() { Script = "Mlym", Typeface = "Kartika" };
+            A.SupplementalFont supplementalFont25 = new A.SupplementalFont() { Script = "Laoo", Typeface = "DokChampa" };
+            A.SupplementalFont supplementalFont26 = new A.SupplementalFont() { Script = "Sinh", Typeface = "Iskoola Pota" };
+            A.SupplementalFont supplementalFont27 = new A.SupplementalFont() { Script = "Mong", Typeface = "Mongolian Baiti" };
+            A.SupplementalFont supplementalFont28 = new A.SupplementalFont() { Script = "Viet", Typeface = "Times New Roman" };
+            A.SupplementalFont supplementalFont29 = new A.SupplementalFont() { Script = "Uigh", Typeface = "Microsoft Uighur" };
+
+            majorFont1.Append(latinFont1);
+            majorFont1.Append(eastAsianFont1);
+            majorFont1.Append(complexScriptFont1);
+            majorFont1.Append(supplementalFont1);
+            majorFont1.Append(supplementalFont2);
+            majorFont1.Append(supplementalFont3);
+            majorFont1.Append(supplementalFont4);
+            majorFont1.Append(supplementalFont5);
+            majorFont1.Append(supplementalFont6);
+            majorFont1.Append(supplementalFont7);
+            majorFont1.Append(supplementalFont8);
+            majorFont1.Append(supplementalFont9);
+            majorFont1.Append(supplementalFont10);
+            majorFont1.Append(supplementalFont11);
+            majorFont1.Append(supplementalFont12);
+            majorFont1.Append(supplementalFont13);
+            majorFont1.Append(supplementalFont14);
+            majorFont1.Append(supplementalFont15);
+            majorFont1.Append(supplementalFont16);
+            majorFont1.Append(supplementalFont17);
+            majorFont1.Append(supplementalFont18);
+            majorFont1.Append(supplementalFont19);
+            majorFont1.Append(supplementalFont20);
+            majorFont1.Append(supplementalFont21);
+            majorFont1.Append(supplementalFont22);
+            majorFont1.Append(supplementalFont23);
+            majorFont1.Append(supplementalFont24);
+            majorFont1.Append(supplementalFont25);
+            majorFont1.Append(supplementalFont26);
+            majorFont1.Append(supplementalFont27);
+            majorFont1.Append(supplementalFont28);
+            majorFont1.Append(supplementalFont29);
+
+            A.MinorFont minorFont1 = new A.MinorFont();
+            A.LatinFont latinFont2 = new A.LatinFont() { Typeface = "Calibri" };
+            A.EastAsianFont eastAsianFont2 = new A.EastAsianFont() { Typeface = "" };
+            A.ComplexScriptFont complexScriptFont2 = new A.ComplexScriptFont() { Typeface = "" };
+            A.SupplementalFont supplementalFont30 = new A.SupplementalFont() { Script = "Jpan", Typeface = "ＭＳ Ｐゴシック" };
+            A.SupplementalFont supplementalFont31 = new A.SupplementalFont() { Script = "Hang", Typeface = "맑은 고딕" };
+            A.SupplementalFont supplementalFont32 = new A.SupplementalFont() { Script = "Hans", Typeface = "宋体" };
+            A.SupplementalFont supplementalFont33 = new A.SupplementalFont() { Script = "Hant", Typeface = "新細明體" };
+            A.SupplementalFont supplementalFont34 = new A.SupplementalFont() { Script = "Arab", Typeface = "Arial" };
+            A.SupplementalFont supplementalFont35 = new A.SupplementalFont() { Script = "Hebr", Typeface = "Arial" };
+            A.SupplementalFont supplementalFont36 = new A.SupplementalFont() { Script = "Thai", Typeface = "Tahoma" };
+            A.SupplementalFont supplementalFont37 = new A.SupplementalFont() { Script = "Ethi", Typeface = "Nyala" };
+            A.SupplementalFont supplementalFont38 = new A.SupplementalFont() { Script = "Beng", Typeface = "Vrinda" };
+            A.SupplementalFont supplementalFont39 = new A.SupplementalFont() { Script = "Gujr", Typeface = "Shruti" };
+            A.SupplementalFont supplementalFont40 = new A.SupplementalFont() { Script = "Khmr", Typeface = "DaunPenh" };
+            A.SupplementalFont supplementalFont41 = new A.SupplementalFont() { Script = "Knda", Typeface = "Tunga" };
+            A.SupplementalFont supplementalFont42 = new A.SupplementalFont() { Script = "Guru", Typeface = "Raavi" };
+            A.SupplementalFont supplementalFont43 = new A.SupplementalFont() { Script = "Cans", Typeface = "Euphemia" };
+            A.SupplementalFont supplementalFont44 = new A.SupplementalFont() { Script = "Cher", Typeface = "Plantagenet Cherokee" };
+            A.SupplementalFont supplementalFont45 = new A.SupplementalFont() { Script = "Yiii", Typeface = "Microsoft Yi Baiti" };
+            A.SupplementalFont supplementalFont46 = new A.SupplementalFont() { Script = "Tibt", Typeface = "Microsoft Himalaya" };
+            A.SupplementalFont supplementalFont47 = new A.SupplementalFont() { Script = "Thaa", Typeface = "MV Boli" };
+            A.SupplementalFont supplementalFont48 = new A.SupplementalFont() { Script = "Deva", Typeface = "Mangal" };
+            A.SupplementalFont supplementalFont49 = new A.SupplementalFont() { Script = "Telu", Typeface = "Gautami" };
+            A.SupplementalFont supplementalFont50 = new A.SupplementalFont() { Script = "Taml", Typeface = "Latha" };
+            A.SupplementalFont supplementalFont51 = new A.SupplementalFont() { Script = "Syrc", Typeface = "Estrangelo Edessa" };
+            A.SupplementalFont supplementalFont52 = new A.SupplementalFont() { Script = "Orya", Typeface = "Kalinga" };
+            A.SupplementalFont supplementalFont53 = new A.SupplementalFont() { Script = "Mlym", Typeface = "Kartika" };
+            A.SupplementalFont supplementalFont54 = new A.SupplementalFont() { Script = "Laoo", Typeface = "DokChampa" };
+            A.SupplementalFont supplementalFont55 = new A.SupplementalFont() { Script = "Sinh", Typeface = "Iskoola Pota" };
+            A.SupplementalFont supplementalFont56 = new A.SupplementalFont() { Script = "Mong", Typeface = "Mongolian Baiti" };
+            A.SupplementalFont supplementalFont57 = new A.SupplementalFont() { Script = "Viet", Typeface = "Arial" };
+            A.SupplementalFont supplementalFont58 = new A.SupplementalFont() { Script = "Uigh", Typeface = "Microsoft Uighur" };
+
+            minorFont1.Append(latinFont2);
+            minorFont1.Append(eastAsianFont2);
+            minorFont1.Append(complexScriptFont2);
+            minorFont1.Append(supplementalFont30);
+            minorFont1.Append(supplementalFont31);
+            minorFont1.Append(supplementalFont32);
+            minorFont1.Append(supplementalFont33);
+            minorFont1.Append(supplementalFont34);
+            minorFont1.Append(supplementalFont35);
+            minorFont1.Append(supplementalFont36);
+            minorFont1.Append(supplementalFont37);
+            minorFont1.Append(supplementalFont38);
+            minorFont1.Append(supplementalFont39);
+            minorFont1.Append(supplementalFont40);
+            minorFont1.Append(supplementalFont41);
+            minorFont1.Append(supplementalFont42);
+            minorFont1.Append(supplementalFont43);
+            minorFont1.Append(supplementalFont44);
+            minorFont1.Append(supplementalFont45);
+            minorFont1.Append(supplementalFont46);
+            minorFont1.Append(supplementalFont47);
+            minorFont1.Append(supplementalFont48);
+            minorFont1.Append(supplementalFont49);
+            minorFont1.Append(supplementalFont50);
+            minorFont1.Append(supplementalFont51);
+            minorFont1.Append(supplementalFont52);
+            minorFont1.Append(supplementalFont53);
+            minorFont1.Append(supplementalFont54);
+            minorFont1.Append(supplementalFont55);
+            minorFont1.Append(supplementalFont56);
+            minorFont1.Append(supplementalFont57);
+            minorFont1.Append(supplementalFont58);
+
+            fontScheme2.Append(majorFont1);
+            fontScheme2.Append(minorFont1);
+
+            A.FormatScheme formatScheme1 = new A.FormatScheme() { Name = "Office" };
+
+            A.FillStyleList fillStyleList1 = new A.FillStyleList();
+
+            A.SolidFill solidFill1 = new A.SolidFill();
+            A.SchemeColor schemeColor1 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+
+            solidFill1.Append(schemeColor1);
+
+            A.GradientFill gradientFill1 = new A.GradientFill() { RotateWithShape = true };
+
+            A.GradientStopList gradientStopList1 = new A.GradientStopList();
+
+            A.GradientStop gradientStop1 = new A.GradientStop() { Position = 0 };
+
+            A.SchemeColor schemeColor2 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+            A.Tint tint1 = new A.Tint() { Val = 50000 };
+            A.SaturationModulation saturationModulation1 = new A.SaturationModulation() { Val = 300000 };
+
+            schemeColor2.Append(tint1);
+            schemeColor2.Append(saturationModulation1);
+
+            gradientStop1.Append(schemeColor2);
+
+            A.GradientStop gradientStop2 = new A.GradientStop() { Position = 35000 };
+
+            A.SchemeColor schemeColor3 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+            A.Tint tint2 = new A.Tint() { Val = 37000 };
+            A.SaturationModulation saturationModulation2 = new A.SaturationModulation() { Val = 300000 };
+
+            schemeColor3.Append(tint2);
+            schemeColor3.Append(saturationModulation2);
+
+            gradientStop2.Append(schemeColor3);
+
+            A.GradientStop gradientStop3 = new A.GradientStop() { Position = 100000 };
+
+            A.SchemeColor schemeColor4 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+            A.Tint tint3 = new A.Tint() { Val = 15000 };
+            A.SaturationModulation saturationModulation3 = new A.SaturationModulation() { Val = 350000 };
+
+            schemeColor4.Append(tint3);
+            schemeColor4.Append(saturationModulation3);
+
+            gradientStop3.Append(schemeColor4);
+
+            gradientStopList1.Append(gradientStop1);
+            gradientStopList1.Append(gradientStop2);
+            gradientStopList1.Append(gradientStop3);
+            A.LinearGradientFill linearGradientFill1 = new A.LinearGradientFill() { Angle = 16200000, Scaled = true };
+
+            gradientFill1.Append(gradientStopList1);
+            gradientFill1.Append(linearGradientFill1);
+
+            A.GradientFill gradientFill2 = new A.GradientFill() { RotateWithShape = true };
+
+            A.GradientStopList gradientStopList2 = new A.GradientStopList();
+
+            A.GradientStop gradientStop4 = new A.GradientStop() { Position = 0 };
+
+            A.SchemeColor schemeColor5 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+            A.Shade shade1 = new A.Shade() { Val = 51000 };
+            A.SaturationModulation saturationModulation4 = new A.SaturationModulation() { Val = 130000 };
+
+            schemeColor5.Append(shade1);
+            schemeColor5.Append(saturationModulation4);
+
+            gradientStop4.Append(schemeColor5);
+
+            A.GradientStop gradientStop5 = new A.GradientStop() { Position = 80000 };
+
+            A.SchemeColor schemeColor6 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+            A.Shade shade2 = new A.Shade() { Val = 93000 };
+            A.SaturationModulation saturationModulation5 = new A.SaturationModulation() { Val = 130000 };
+
+            schemeColor6.Append(shade2);
+            schemeColor6.Append(saturationModulation5);
+
+            gradientStop5.Append(schemeColor6);
+
+            A.GradientStop gradientStop6 = new A.GradientStop() { Position = 100000 };
+
+            A.SchemeColor schemeColor7 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+            A.Shade shade3 = new A.Shade() { Val = 94000 };
+            A.SaturationModulation saturationModulation6 = new A.SaturationModulation() { Val = 135000 };
+
+            schemeColor7.Append(shade3);
+            schemeColor7.Append(saturationModulation6);
+
+            gradientStop6.Append(schemeColor7);
+
+            gradientStopList2.Append(gradientStop4);
+            gradientStopList2.Append(gradientStop5);
+            gradientStopList2.Append(gradientStop6);
+            A.LinearGradientFill linearGradientFill2 = new A.LinearGradientFill() { Angle = 16200000, Scaled = false };
+
+            gradientFill2.Append(gradientStopList2);
+            gradientFill2.Append(linearGradientFill2);
+
+            fillStyleList1.Append(solidFill1);
+            fillStyleList1.Append(gradientFill1);
+            fillStyleList1.Append(gradientFill2);
+
+            A.LineStyleList lineStyleList1 = new A.LineStyleList();
+
+            A.Outline outline1 = new A.Outline() { Width = 9525, CapType = A.LineCapValues.Flat, CompoundLineType = A.CompoundLineValues.Single, Alignment = A.PenAlignmentValues.Center };
+
+            A.SolidFill solidFill2 = new A.SolidFill();
+
+            A.SchemeColor schemeColor8 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+            A.Shade shade4 = new A.Shade() { Val = 95000 };
+            A.SaturationModulation saturationModulation7 = new A.SaturationModulation() { Val = 105000 };
+
+            schemeColor8.Append(shade4);
+            schemeColor8.Append(saturationModulation7);
+
+            solidFill2.Append(schemeColor8);
+            A.PresetDash presetDash1 = new A.PresetDash() { Val = A.PresetLineDashValues.Solid };
+
+            outline1.Append(solidFill2);
+            outline1.Append(presetDash1);
+
+            A.Outline outline2 = new A.Outline() { Width = 25400, CapType = A.LineCapValues.Flat, CompoundLineType = A.CompoundLineValues.Single, Alignment = A.PenAlignmentValues.Center };
+
+            A.SolidFill solidFill3 = new A.SolidFill();
+            A.SchemeColor schemeColor9 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+
+            solidFill3.Append(schemeColor9);
+            A.PresetDash presetDash2 = new A.PresetDash() { Val = A.PresetLineDashValues.Solid };
+
+            outline2.Append(solidFill3);
+            outline2.Append(presetDash2);
+
+            A.Outline outline3 = new A.Outline() { Width = 38100, CapType = A.LineCapValues.Flat, CompoundLineType = A.CompoundLineValues.Single, Alignment = A.PenAlignmentValues.Center };
+
+            A.SolidFill solidFill4 = new A.SolidFill();
+            A.SchemeColor schemeColor10 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+
+            solidFill4.Append(schemeColor10);
+            A.PresetDash presetDash3 = new A.PresetDash() { Val = A.PresetLineDashValues.Solid };
+
+            outline3.Append(solidFill4);
+            outline3.Append(presetDash3);
+
+            lineStyleList1.Append(outline1);
+            lineStyleList1.Append(outline2);
+            lineStyleList1.Append(outline3);
+
+            A.EffectStyleList effectStyleList1 = new A.EffectStyleList();
+
+            A.EffectStyle effectStyle1 = new A.EffectStyle();
+
+            A.EffectList effectList1 = new A.EffectList();
+
+            A.OuterShadow outerShadow1 = new A.OuterShadow() { BlurRadius = 40000L, Distance = 20000L, Direction = 5400000, RotateWithShape = false };
+
+            A.RgbColorModelHex rgbColorModelHex11 = new A.RgbColorModelHex() { Val = "000000" };
+            A.Alpha alpha1 = new A.Alpha() { Val = 38000 };
+
+            rgbColorModelHex11.Append(alpha1);
+
+            outerShadow1.Append(rgbColorModelHex11);
+
+            effectList1.Append(outerShadow1);
+
+            effectStyle1.Append(effectList1);
+
+            A.EffectStyle effectStyle2 = new A.EffectStyle();
+
+            A.EffectList effectList2 = new A.EffectList();
+
+            A.OuterShadow outerShadow2 = new A.OuterShadow() { BlurRadius = 40000L, Distance = 23000L, Direction = 5400000, RotateWithShape = false };
+
+            A.RgbColorModelHex rgbColorModelHex12 = new A.RgbColorModelHex() { Val = "000000" };
+            A.Alpha alpha2 = new A.Alpha() { Val = 35000 };
+
+            rgbColorModelHex12.Append(alpha2);
+
+            outerShadow2.Append(rgbColorModelHex12);
+
+            effectList2.Append(outerShadow2);
+
+            effectStyle2.Append(effectList2);
+
+            A.EffectStyle effectStyle3 = new A.EffectStyle();
+
+            A.EffectList effectList3 = new A.EffectList();
+
+            A.OuterShadow outerShadow3 = new A.OuterShadow() { BlurRadius = 40000L, Distance = 23000L, Direction = 5400000, RotateWithShape = false };
+
+            A.RgbColorModelHex rgbColorModelHex13 = new A.RgbColorModelHex() { Val = "000000" };
+            A.Alpha alpha3 = new A.Alpha() { Val = 35000 };
+
+            rgbColorModelHex13.Append(alpha3);
+
+            outerShadow3.Append(rgbColorModelHex13);
+
+            effectList3.Append(outerShadow3);
+
+            A.Scene3DType scene3DType1 = new A.Scene3DType();
+
+            A.Camera camera1 = new A.Camera() { Preset = A.PresetCameraValues.OrthographicFront };
+            A.Rotation rotation1 = new A.Rotation() { Latitude = 0, Longitude = 0, Revolution = 0 };
+
+            camera1.Append(rotation1);
+
+            A.LightRig lightRig1 = new A.LightRig() { Rig = A.LightRigValues.ThreePoints, Direction = A.LightRigDirectionValues.Top };
+            A.Rotation rotation2 = new A.Rotation() { Latitude = 0, Longitude = 0, Revolution = 1200000 };
+
+            lightRig1.Append(rotation2);
+
+            scene3DType1.Append(camera1);
+            scene3DType1.Append(lightRig1);
+
+            A.Shape3DType shape3DType1 = new A.Shape3DType();
+            A.BevelTop bevelTop1 = new A.BevelTop() { Width = 63500L, Height = 25400L };
+
+            shape3DType1.Append(bevelTop1);
+
+            effectStyle3.Append(effectList3);
+            effectStyle3.Append(scene3DType1);
+            effectStyle3.Append(shape3DType1);
+
+            effectStyleList1.Append(effectStyle1);
+            effectStyleList1.Append(effectStyle2);
+            effectStyleList1.Append(effectStyle3);
+
+            A.BackgroundFillStyleList backgroundFillStyleList1 = new A.BackgroundFillStyleList();
+
+            A.SolidFill solidFill5 = new A.SolidFill();
+            A.SchemeColor schemeColor11 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+
+            solidFill5.Append(schemeColor11);
+
+            A.GradientFill gradientFill3 = new A.GradientFill() { RotateWithShape = true };
+
+            A.GradientStopList gradientStopList3 = new A.GradientStopList();
+
+            A.GradientStop gradientStop7 = new A.GradientStop() { Position = 0 };
+
+            A.SchemeColor schemeColor12 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+            A.Tint tint4 = new A.Tint() { Val = 40000 };
+            A.SaturationModulation saturationModulation8 = new A.SaturationModulation() { Val = 350000 };
+
+            schemeColor12.Append(tint4);
+            schemeColor12.Append(saturationModulation8);
+
+            gradientStop7.Append(schemeColor12);
+
+            A.GradientStop gradientStop8 = new A.GradientStop() { Position = 40000 };
+
+            A.SchemeColor schemeColor13 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+            A.Tint tint5 = new A.Tint() { Val = 45000 };
+            A.Shade shade5 = new A.Shade() { Val = 99000 };
+            A.SaturationModulation saturationModulation9 = new A.SaturationModulation() { Val = 350000 };
+
+            schemeColor13.Append(tint5);
+            schemeColor13.Append(shade5);
+            schemeColor13.Append(saturationModulation9);
+
+            gradientStop8.Append(schemeColor13);
+
+            A.GradientStop gradientStop9 = new A.GradientStop() { Position = 100000 };
+
+            A.SchemeColor schemeColor14 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+            A.Shade shade6 = new A.Shade() { Val = 20000 };
+            A.SaturationModulation saturationModulation10 = new A.SaturationModulation() { Val = 255000 };
+
+            schemeColor14.Append(shade6);
+            schemeColor14.Append(saturationModulation10);
+
+            gradientStop9.Append(schemeColor14);
+
+            gradientStopList3.Append(gradientStop7);
+            gradientStopList3.Append(gradientStop8);
+            gradientStopList3.Append(gradientStop9);
+
+            A.PathGradientFill pathGradientFill1 = new A.PathGradientFill() { Path = A.PathShadeValues.Circle };
+            A.FillToRectangle fillToRectangle1 = new A.FillToRectangle() { Left = 50000, Top = -80000, Right = 50000, Bottom = 180000 };
+
+            pathGradientFill1.Append(fillToRectangle1);
+
+            gradientFill3.Append(gradientStopList3);
+            gradientFill3.Append(pathGradientFill1);
+
+            A.GradientFill gradientFill4 = new A.GradientFill() { RotateWithShape = true };
+
+            A.GradientStopList gradientStopList4 = new A.GradientStopList();
+
+            A.GradientStop gradientStop10 = new A.GradientStop() { Position = 0 };
+
+            A.SchemeColor schemeColor15 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+            A.Tint tint6 = new A.Tint() { Val = 80000 };
+            A.SaturationModulation saturationModulation11 = new A.SaturationModulation() { Val = 300000 };
+
+            schemeColor15.Append(tint6);
+            schemeColor15.Append(saturationModulation11);
+
+            gradientStop10.Append(schemeColor15);
+
+            A.GradientStop gradientStop11 = new A.GradientStop() { Position = 100000 };
+
+            A.SchemeColor schemeColor16 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
+            A.Shade shade7 = new A.Shade() { Val = 30000 };
+            A.SaturationModulation saturationModulation12 = new A.SaturationModulation() { Val = 200000 };
+
+            schemeColor16.Append(shade7);
+            schemeColor16.Append(saturationModulation12);
+
+            gradientStop11.Append(schemeColor16);
+
+            gradientStopList4.Append(gradientStop10);
+            gradientStopList4.Append(gradientStop11);
+
+            A.PathGradientFill pathGradientFill2 = new A.PathGradientFill() { Path = A.PathShadeValues.Circle };
+            A.FillToRectangle fillToRectangle2 = new A.FillToRectangle() { Left = 50000, Top = 50000, Right = 50000, Bottom = 50000 };
+
+            pathGradientFill2.Append(fillToRectangle2);
+
+            gradientFill4.Append(gradientStopList4);
+            gradientFill4.Append(pathGradientFill2);
+
+            backgroundFillStyleList1.Append(solidFill5);
+            backgroundFillStyleList1.Append(gradientFill3);
+            backgroundFillStyleList1.Append(gradientFill4);
+
+            formatScheme1.Append(fillStyleList1);
+            formatScheme1.Append(lineStyleList1);
+            formatScheme1.Append(effectStyleList1);
+            formatScheme1.Append(backgroundFillStyleList1);
+
+            themeElements1.Append(colorScheme1);
+            themeElements1.Append(fontScheme2);
+            themeElements1.Append(formatScheme1);
+            A.ObjectDefaults objectDefaults1 = new A.ObjectDefaults();
+            A.ExtraColorSchemeList extraColorSchemeList1 = new A.ExtraColorSchemeList();
+
+            theme1.Append(themeElements1);
+            theme1.Append(objectDefaults1);
+            theme1.Append(extraColorSchemeList1);
+
+            themePart1.Theme = theme1;
+        }
+
+        private void SetPackageProperties(OpenXmlPackage document)
+        {
+            document.PackageProperties.Creator = "";
+            document.PackageProperties.Created = System.Xml.XmlConvert.ToDateTime("2010-05-20T13:20:55Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind);
+            document.PackageProperties.Modified = System.Xml.XmlConvert.ToDateTime("2010-05-20T13:21:22Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind);
+            document.PackageProperties.LastModifiedBy = "";
+        }
+
+    }
+}
diff --git a/ClosedXML/ClosedXML/Excel/XLWorksheets.cs b/ClosedXML/ClosedXML/Excel/XLWorksheets.cs
index fb89db1..982423d 100644
--- a/ClosedXML/ClosedXML/Excel/XLWorksheets.cs
+++ b/ClosedXML/ClosedXML/Excel/XLWorksheets.cs
@@ -5,32 +5,40 @@
 
 namespace ClosedXML.Excel
 {
-    public class XLWorksheets : IEnumerable<XLWorksheet>
+    /// <summary>
+    /// Allows you to add, access, and remove worksheets from the workbook.
+    /// </summary>
+    public class XLWorksheets: IEnumerable<XLRange>
     {
-        private Dictionary<String, XLWorksheet> worksheets = new Dictionary<String, XLWorksheet>();
+        #region Constants
 
-        private XLWorkbook workbook;
+        private const UInt32 MaxNumberOfRows = 1048576;
+        private const UInt32 MaxNumberOfColumns = 16384;
 
+        #endregion
+
+        #region Constructors
+
+        /// <summary>
+        /// Initializes a new instance of the <see cref="XLWorksheets"/> class.
+        /// </summary>
+        /// <param name="workbook">The workbook which will contain the worksheets.</param>
         public XLWorksheets(XLWorkbook workbook)
         {
             this.workbook = workbook;
         }
 
-        public XLWorksheet this[String sheetName]
-        {
-            get
-            {
-                return worksheets[sheetName];
-            }
-        }
+        #endregion
 
-        public XLWorksheet Add(String name)
-        {
-            XLWorksheet worksheet = new XLWorksheet(workbook,  name, new XLCells(workbook));
-            worksheets.Add(name, worksheet);
-            return worksheet;
-        }
+        #region Properties
 
+        private Dictionary<String, XLRange> worksheets = new Dictionary<String, XLRange>();
+
+        private XLWorkbook workbook;
+
+        /// <summary>
+        /// Gets the number of worksheets in the workbook.
+        /// </summary>
         public UInt32 Count
         {
             get
@@ -39,17 +47,52 @@
             }
         }
 
-        private Int32 nextWorksheetId = 1;
-        private Int32 GetNextWorksheetId()
+        /// <summary>
+        /// Gets the worksheet (as an XLRange) with the specified sheet name.
+        /// </summary>
+        /// <value></value>
+        public XLRange this[String sheetName]
         {
-            return nextWorksheetId++;
+            get
+            {
+                return worksheets[sheetName];
+            }
         }
 
-        #region IEnumerable<XLWorksheet> Members
+        #endregion
 
-        public IEnumerator<XLWorksheet> GetEnumerator()
+        #region Methods
+
+        /// <summary>
+        /// Adds a new worksheet to the workbook.
+        /// </summary>
+        /// <param name="name">The name of the worksheet to be added.</param>
+        public XLRange Add(String name)
         {
-            return worksheets.Values.AsEnumerable().GetEnumerator();
+            var firstCellAddress = new XLAddress(1, 1);
+            var lastCellAddress = new XLAddress(MaxNumberOfRows, MaxNumberOfColumns);
+            XLRange worksheet = new XLRange(firstCellAddress, lastCellAddress, null, null, name, workbook);
+            worksheets.Add(name, worksheet);
+            return worksheet;
+        }
+
+        /// <summary>
+        /// Deletes the specified worksheet from the workbook.
+        /// </summary>
+        /// <param name="name">The name of the worksheet to be deleted.</param>
+        public void Delete(String name)
+        {
+            worksheets.Remove(name);
+        }
+
+        #endregion
+
+
+        #region IEnumerable<XLRange> Members
+
+        public IEnumerator<XLRange> GetEnumerator()
+        {
+            return worksheets.Values.GetEnumerator();
         }
 
         #endregion
@@ -58,7 +101,7 @@
 
         System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
         {
-            return this.GetEnumerator();
+            return GetEnumerator();
         }
 
         #endregion
diff --git a/ClosedXML/ClosedXML/Extensions.cs b/ClosedXML/ClosedXML/Extensions.cs
new file mode 100644
index 0000000..57e2604
--- /dev/null
+++ b/ClosedXML/ClosedXML/Extensions.cs
@@ -0,0 +1,17 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ClosedXML
+{
+    public static class Extensions
+    {
+        // Adds the .ForEach method to all IEnumerables
+        public static void ForEach<T>(this IEnumerable<T> source, Action<T> action)
+        {
+            foreach (T item in source)
+                action(item);
+        }
+    }
+}
diff --git a/ClosedXML/ClosedXML_Sandbox/ClosedXML_Sandbox.csproj b/ClosedXML/ClosedXML_Sandbox/ClosedXML_Sandbox.csproj
new file mode 100644
index 0000000..ff83f9e
--- /dev/null
+++ b/ClosedXML/ClosedXML_Sandbox/ClosedXML_Sandbox.csproj
@@ -0,0 +1,67 @@
+<?xml version="1.0" encoding="utf-8"?>
+<Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+  <PropertyGroup>
+    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
+    <Platform Condition=" '$(Platform)' == '' ">x86</Platform>
+    <ProductVersion>8.0.30703</ProductVersion>
+    <SchemaVersion>2.0</SchemaVersion>
+    <ProjectGuid>{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}</ProjectGuid>
+    <OutputType>Exe</OutputType>
+    <AppDesignerFolder>Properties</AppDesignerFolder>
+    <RootNamespace>ClosedXML_Sandbox</RootNamespace>
+    <AssemblyName>ClosedXML_Sandbox</AssemblyName>
+    <TargetFrameworkVersion>v4.0</TargetFrameworkVersion>
+    <TargetFrameworkProfile>Client</TargetFrameworkProfile>
+    <FileAlignment>512</FileAlignment>
+    <SccProjectName>SAK</SccProjectName>
+    <SccLocalPath>SAK</SccLocalPath>
+    <SccAuxPath>SAK</SccAuxPath>
+    <SccProvider>SAK</SccProvider>
+  </PropertyGroup>
+  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|x86' ">
+    <PlatformTarget>x86</PlatformTarget>
+    <DebugSymbols>true</DebugSymbols>
+    <DebugType>full</DebugType>
+    <Optimize>false</Optimize>
+    <OutputPath>bin\Debug\</OutputPath>
+    <DefineConstants>DEBUG;TRACE</DefineConstants>
+    <ErrorReport>prompt</ErrorReport>
+    <WarningLevel>4</WarningLevel>
+  </PropertyGroup>
+  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|x86' ">
+    <PlatformTarget>x86</PlatformTarget>
+    <DebugType>pdbonly</DebugType>
+    <Optimize>true</Optimize>
+    <OutputPath>bin\Release\</OutputPath>
+    <DefineConstants>TRACE</DefineConstants>
+    <ErrorReport>prompt</ErrorReport>
+    <WarningLevel>4</WarningLevel>
+  </PropertyGroup>
+  <ItemGroup>
+    <Reference Include="System" />
+    <Reference Include="System.Core" />
+    <Reference Include="System.Xml.Linq" />
+    <Reference Include="System.Data.DataSetExtensions" />
+    <Reference Include="Microsoft.CSharp" />
+    <Reference Include="System.Data" />
+    <Reference Include="System.Xml" />
+  </ItemGroup>
+  <ItemGroup>
+    <Compile Include="Program.cs" />
+    <Compile Include="Properties\AssemblyInfo.cs" />
+  </ItemGroup>
+  <ItemGroup>
+    <ProjectReference Include="..\ClosedXML\ClosedXML.csproj">
+      <Project>{BD5E6BFE-E837-4A35-BCA9-39667D873A20}</Project>
+      <Name>ClosedXML</Name>
+    </ProjectReference>
+  </ItemGroup>
+  <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
+  <!-- To modify your build process, add your task inside one of the targets below and uncomment it. 
+       Other similar extension points exist, see Microsoft.Common.targets.
+  <Target Name="BeforeBuild">
+  </Target>
+  <Target Name="AfterBuild">
+  </Target>
+  -->
+</Project>
\ No newline at end of file
diff --git a/ClosedXML/ClosedXML_Sandbox/ClosedXML_Sandbox.csproj.vspscc b/ClosedXML/ClosedXML_Sandbox/ClosedXML_Sandbox.csproj.vspscc
new file mode 100644
index 0000000..feffdec
--- /dev/null
+++ b/ClosedXML/ClosedXML_Sandbox/ClosedXML_Sandbox.csproj.vspscc
@@ -0,0 +1,10 @@
+""
+{
+"FILE_VERSION" = "9237"
+"ENLISTMENT_CHOICE" = "NEVER"
+"PROJECT_FILE_RELATIVE_PATH" = ""
+"NUMBER_OF_EXCLUDED_FILES" = "0"
+"ORIGINAL_PROJECT_FILE_PATH" = ""
+"NUMBER_OF_NESTED_PROJECTS" = "0"
+"SOURCE_CONTROL_SETTINGS_PROVIDER" = "PROVIDER"
+}
diff --git a/ClosedXML/ClosedXML_Sandbox/Program.cs b/ClosedXML/ClosedXML_Sandbox/Program.cs
new file mode 100644
index 0000000..c77b7ec
--- /dev/null
+++ b/ClosedXML/ClosedXML_Sandbox/Program.cs
@@ -0,0 +1,27 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using ClosedXML.Excel;
+
+namespace ClosedXML_Sandbox
+{
+    class Program
+    {
+        static void Main(string[] args)
+        {
+            var wbExample = new XLWorkbook(@"c:\Example.xlsx");
+            var wsWorld = wbExample.Worksheets.Add("World");
+            var wsNameList = wbExample.Worksheets.Add("Name List");
+            var wsDeleteMe = wbExample.Worksheets.Add("Delete Me");
+
+            
+
+            var a1 = wsNameList.Cell("A1");
+            var a2 = wsNameList.Cell("A2");
+            a1.Value = "Hello!";
+            wbExample.Save();
+            // a2.Font.Bold = true;
+        }
+    }
+}
diff --git a/ClosedXML/ClosedXML_Sandbox/Properties/AssemblyInfo.cs b/ClosedXML/ClosedXML_Sandbox/Properties/AssemblyInfo.cs
new file mode 100644
index 0000000..942db94
--- /dev/null
+++ b/ClosedXML/ClosedXML_Sandbox/Properties/AssemblyInfo.cs
@@ -0,0 +1,36 @@
+using System.Reflection;
+using System.Runtime.CompilerServices;
+using System.Runtime.InteropServices;
+
+// General Information about an assembly is controlled through the following 
+// set of attributes. Change these attribute values to modify the information
+// associated with an assembly.
+[assembly: AssemblyTitle("ClosedXML_Sandbox")]
+[assembly: AssemblyDescription("")]
+[assembly: AssemblyConfiguration("")]
+[assembly: AssemblyCompany("Microsoft")]
+[assembly: AssemblyProduct("ClosedXML_Sandbox")]
+[assembly: AssemblyCopyright("Copyright © Microsoft 2010")]
+[assembly: AssemblyTrademark("")]
+[assembly: AssemblyCulture("")]
+
+// Setting ComVisible to false makes the types in this assembly not visible 
+// to COM components.  If you need to access a type in this assembly from 
+// COM, set the ComVisible attribute to true on that type.
+[assembly: ComVisible(false)]
+
+// The following GUID is for the ID of the typelib if this project is exposed to COM
+[assembly: Guid("7a3783fd-4e1b-4c17-a745-e6bbb593bd45")]
+
+// Version information for an assembly consists of the following four values:
+//
+//      Major Version
+//      Minor Version 
+//      Build Number
+//      Revision
+//
+// You can specify all the values or you can default the Build and Revision Numbers 
+// by using the '*' as shown below:
+// [assembly: AssemblyVersion("1.0.*")]
+[assembly: AssemblyVersion("1.0.0.0")]
+[assembly: AssemblyFileVersion("1.0.0.0")]
diff --git a/ClosedXML/ClosedXML_Test/ClosedXML_Test.csproj b/ClosedXML/ClosedXML_Test/ClosedXML_Test.csproj
new file mode 100644
index 0000000..4872842
--- /dev/null
+++ b/ClosedXML/ClosedXML_Test/ClosedXML_Test.csproj
@@ -0,0 +1,77 @@
+<?xml version="1.0" encoding="utf-8"?>
+<Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+  <PropertyGroup>
+    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
+    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
+    <ProductVersion>
+    </ProductVersion>
+    <SchemaVersion>2.0</SchemaVersion>
+    <ProjectGuid>{D41B4F43-AB44-4236-B959-D508D259F4A7}</ProjectGuid>
+    <OutputType>Library</OutputType>
+    <AppDesignerFolder>Properties</AppDesignerFolder>
+    <RootNamespace>ClosedXML_Test</RootNamespace>
+    <AssemblyName>ClosedXML_Test</AssemblyName>
+    <TargetFrameworkVersion>v4.0</TargetFrameworkVersion>
+    <FileAlignment>512</FileAlignment>
+    <ProjectTypeGuids>{3AC096D0-A1C2-E12C-1390-A8335801FDAB};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids>
+    <SccProjectName>SAK</SccProjectName>
+    <SccLocalPath>SAK</SccLocalPath>
+    <SccAuxPath>SAK</SccAuxPath>
+    <SccProvider>SAK</SccProvider>
+  </PropertyGroup>
+  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
+    <DebugSymbols>true</DebugSymbols>
+    <DebugType>full</DebugType>
+    <Optimize>false</Optimize>
+    <OutputPath>bin\Debug\</OutputPath>
+    <DefineConstants>DEBUG;TRACE</DefineConstants>
+    <ErrorReport>prompt</ErrorReport>
+    <WarningLevel>4</WarningLevel>
+  </PropertyGroup>
+  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
+    <DebugType>pdbonly</DebugType>
+    <Optimize>true</Optimize>
+    <OutputPath>bin\Release\</OutputPath>
+    <DefineConstants>TRACE</DefineConstants>
+    <ErrorReport>prompt</ErrorReport>
+    <WarningLevel>4</WarningLevel>
+  </PropertyGroup>
+  <ItemGroup>
+    <Reference Include="DocumentFormat.OpenXml, Version=2.0.5022.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL" />
+    <Reference Include="Microsoft.CSharp" />
+    <Reference Include="Microsoft.VisualStudio.QualityTools.UnitTestFramework, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL" />
+    <Reference Include="System" />
+    <Reference Include="System.Core">
+      <RequiredTargetFramework>3.5</RequiredTargetFramework>
+    </Reference>
+    <Reference Include="System.Data" />
+    <Reference Include="System.Data.DataSetExtensions" />
+    <Reference Include="System.Xml" />
+    <Reference Include="System.Xml.Linq" />
+    <Reference Include="WindowsBase" />
+  </ItemGroup>
+  <ItemGroup>
+    <CodeAnalysisDependentAssemblyPaths Condition=" '$(VS100COMNTOOLS)' != '' " Include="$(VS100COMNTOOLS)..\IDE\PrivateAssemblies">
+      <Visible>False</Visible>
+    </CodeAnalysisDependentAssemblyPaths>
+  </ItemGroup>
+  <ItemGroup>
+    <Compile Include="Properties\AssemblyInfo.cs" />
+    <Compile Include="XLWorkbookTest.cs" />
+    <Compile Include="XLWorksheetsTest.cs" />
+  </ItemGroup>
+  <ItemGroup>
+    <ProjectReference Include="..\ClosedXML\ClosedXML.csproj">
+      <Project>{BD5E6BFE-E837-4A35-BCA9-39667D873A20}</Project>
+      <Name>ClosedXML</Name>
+    </ProjectReference>
+  </ItemGroup>
+  <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
+  <!-- To modify your build process, add your task inside one of the targets below and uncomment it. 
+       Other similar extension points exist, see Microsoft.Common.targets.
+  <Target Name="BeforeBuild">
+  </Target>
+  <Target Name="AfterBuild">
+  </Target>
+  -->
+</Project>
\ No newline at end of file
diff --git a/ClosedXML/ClosedXML_Test/ClosedXML_Test.csproj.vspscc b/ClosedXML/ClosedXML_Test/ClosedXML_Test.csproj.vspscc
new file mode 100644
index 0000000..feffdec
--- /dev/null
+++ b/ClosedXML/ClosedXML_Test/ClosedXML_Test.csproj.vspscc
@@ -0,0 +1,10 @@
+""
+{
+"FILE_VERSION" = "9237"
+"ENLISTMENT_CHOICE" = "NEVER"
+"PROJECT_FILE_RELATIVE_PATH" = ""
+"NUMBER_OF_EXCLUDED_FILES" = "0"
+"ORIGINAL_PROJECT_FILE_PATH" = ""
+"NUMBER_OF_NESTED_PROJECTS" = "0"
+"SOURCE_CONTROL_SETTINGS_PROVIDER" = "PROVIDER"
+}
diff --git a/ClosedXML/ClosedXML_Test/Properties/AssemblyInfo.cs b/ClosedXML/ClosedXML_Test/Properties/AssemblyInfo.cs
new file mode 100644
index 0000000..7a3a012
--- /dev/null
+++ b/ClosedXML/ClosedXML_Test/Properties/AssemblyInfo.cs
@@ -0,0 +1,35 @@
+using System.Reflection;
+using System.Runtime.CompilerServices;
+using System.Runtime.InteropServices;
+
+// General Information about an assembly is controlled through the following 
+// set of attributes. Change these attribute values to modify the information
+// associated with an assembly.
+[assembly: AssemblyTitle("ClosedXML_Test")]
+[assembly: AssemblyDescription("")]
+[assembly: AssemblyConfiguration("")]
+[assembly: AssemblyCompany("Microsoft")]
+[assembly: AssemblyProduct("ClosedXML_Test")]
+[assembly: AssemblyCopyright("Copyright © Microsoft 2010")]
+[assembly: AssemblyTrademark("")]
+[assembly: AssemblyCulture("")]
+
+// Setting ComVisible to false makes the types in this assembly not visible 
+// to COM components.  If you need to access a type in this assembly from 
+// COM, set the ComVisible attribute to true on that type.
+[assembly: ComVisible(false)]
+
+// The following GUID is for the ID of the typelib if this project is exposed to COM
+[assembly: Guid("6acc873b-86e7-4c3d-89e6-3e409183c5ec")]
+
+// Version information for an assembly consists of the following four values:
+//
+//      Major Version
+//      Minor Version 
+//      Build Number
+//      Revision
+//
+// You can specify all the values or you can default the Build and Revision Numbers 
+// by using the '*' as shown below:
+[assembly: AssemblyVersion("1.0.0.0")]
+[assembly: AssemblyFileVersion("1.0.0.0")]
diff --git a/ClosedXML/ClosedXML_Test/XLWorkbookTest.cs b/ClosedXML/ClosedXML_Test/XLWorkbookTest.cs
new file mode 100644
index 0000000..b939215
--- /dev/null
+++ b/ClosedXML/ClosedXML_Test/XLWorkbookTest.cs
@@ -0,0 +1,81 @@
+using ClosedXML.Excel;
+using Microsoft.VisualStudio.TestTools.UnitTesting;
+using System;
+using System.IO;
+
+namespace ClosedXML_Test
+{
+    
+    
+    /// <summary>
+    ///This is a test class for XLWorkbookTest and is intended
+    ///to contain all XLWorkbookTest Unit Tests
+    ///</summary>
+    [TestClass()]
+    public class XLWorkbookTest
+    {
+
+
+        private TestContext testContextInstance;
+
+        /// <summary>
+        ///Gets or sets the test context which provides
+        ///information about and functionality for the current test run.
+        ///</summary>
+        public TestContext TestContext
+        {
+            get
+            {
+                return testContextInstance;
+            }
+            set
+            {
+                testContextInstance = value;
+            }
+        }
+
+        #region Additional test attributes
+        // 
+        //You can use the following additional attributes as you write your tests:
+        //
+        //Use ClassInitialize to run code before running the first test in the class
+        //[ClassInitialize()]
+        //public static void MyClassInitialize(TestContext testContext)
+        //{
+        //}
+        //
+        //Use ClassCleanup to run code after all tests in a class have run
+        //[ClassCleanup()]
+        //public static void MyClassCleanup()
+        //{
+        //}
+        //
+        //Use TestInitialize to run code before running each test
+        //[TestInitialize()]
+        //public void MyTestInitialize()
+        //{
+        //}
+        //
+        //Use TestCleanup to run code after each test has run
+        //[TestCleanup()]
+        //public void MyTestCleanup()
+        //{
+        //}
+        //
+        #endregion
+
+
+        /// <summary>
+        ///A test for XLWorkbook Constructor
+        ///</summary>
+        [TestMethod()]
+        public void XLWorkbookConstructorTest()
+        {
+            FileInfo fi = new FileInfo("Test.xlsx");
+            XLWorkbook target = new XLWorkbook(fi.FullName);
+
+            Assert.AreEqual(target.Name, fi.Name);
+            Assert.AreEqual(target.FullName, fi.FullName);
+        }
+    }
+}
diff --git a/ClosedXML/ClosedXML_Test/XLWorksheetsTest.cs b/ClosedXML/ClosedXML_Test/XLWorksheetsTest.cs
new file mode 100644
index 0000000..d349068
--- /dev/null
+++ b/ClosedXML/ClosedXML_Test/XLWorksheetsTest.cs
@@ -0,0 +1,99 @@
+using ClosedXML.Excel;
+using Microsoft.VisualStudio.TestTools.UnitTesting;
+using System;
+
+namespace ClosedXML_Test
+{
+    
+    /// <summary>
+    ///This is a test class for XLWorksheetsTest and is intended
+    ///to contain all XLWorksheetsTest Unit Tests
+    ///</summary>
+    [TestClass()]
+    public class XLWorksheetsTest
+    {
+
+
+        private TestContext testContextInstance;
+
+        /// <summary>
+        ///Gets or sets the test context which provides
+        ///information about and functionality for the current test run.
+        ///</summary>
+        public TestContext TestContext
+        {
+            get
+            {
+                return testContextInstance;
+            }
+            set
+            {
+                testContextInstance = value;
+            }
+        }
+
+        #region Additional test attributes
+        // 
+        //You can use the following additional attributes as you write your tests:
+        //
+        //Use ClassInitialize to run code before running the first test in the class
+        //[ClassInitialize()]
+        //public static void MyClassInitialize(TestContext testContext)
+        //{
+        //}
+        //
+        //Use ClassCleanup to run code after all tests in a class have run
+        //[ClassCleanup()]
+        //public static void MyClassCleanup()
+        //{
+        //}
+        //
+        //Use TestInitialize to run code before running each test
+        //[TestInitialize()]
+        //public void MyTestInitialize()
+        //{
+        //}
+        //
+        //Use TestCleanup to run code after each test has run
+        //[TestCleanup()]
+        //public void MyTestCleanup()
+        //{
+        //}
+        //
+        #endregion
+
+
+        /// <summary>
+        ///A test for XLWorksheets Constructor
+        ///</summary>
+        [TestMethod()]
+        public void XLWorksheets_Constructor_Test()
+        {
+            var wbExample = new XLWorkbook(@"c:\Example.xlsx");
+            XLWorksheets target = new XLWorksheets(wbExample);
+
+        }
+
+        [TestMethod()]
+        public void XLWorksheets_Count0_Add1_Add2_Delete1_Count1_Test()
+        {
+            var wbExample = new XLWorkbook(@"c:\Example.xlsx");
+            XLWorksheets target = new XLWorksheets(wbExample);
+
+            Assert.AreEqual(target.Count, 0U);
+
+            target.Add("Sheet1");
+
+            Assert.AreEqual(target.Count, 1U);
+
+            target.Add("Sheet2");
+
+            Assert.AreEqual(target.Count, 2U);
+
+            target.Delete("Sheet2");
+
+            Assert.AreEqual(target.Count, 1U);
+
+        }
+    }
+}
diff --git a/ClosedXML/Local.testsettings b/ClosedXML/Local.testsettings
new file mode 100644
index 0000000..49edf89
--- /dev/null
+++ b/ClosedXML/Local.testsettings
@@ -0,0 +1,10 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<TestSettings name="Local" id="3badba87-ca41-4949-8562-2064bf2ea599" xmlns="http://microsoft.com/schemas/VisualStudio/TeamTest/2010">
+  <Description>These are default test settings for a local test run.</Description>
+  <Deployment enabled="false" />
+  <Execution>
+    <TestTypeSpecific />
+    <AgentRule name="Execution Agents">
+    </AgentRule>
+  </Execution>
+</TestSettings>
\ No newline at end of file
diff --git a/ClosedXML/TraceAndTestImpact.testsettings b/ClosedXML/TraceAndTestImpact.testsettings
new file mode 100644
index 0000000..0792b9b
--- /dev/null
+++ b/ClosedXML/TraceAndTestImpact.testsettings
@@ -0,0 +1,21 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<TestSettings name="Trace and Test Impact" id="835e45cf-bd5b-46dc-a9c1-a737e8a7aaba" xmlns="http://microsoft.com/schemas/VisualStudio/TeamTest/2010">
+  <Description>These are test settings for Trace and Test Impact.</Description>
+  <Execution>
+    <TestTypeSpecific />
+    <AgentRule name="Execution Agents">
+      <DataCollectors>
+        <DataCollector uri="datacollector://microsoft/SystemInfo/1.0" assemblyQualifiedName="Microsoft.VisualStudio.TestTools.DataCollection.SystemInfo.SystemInfoDataCollector, Microsoft.VisualStudio.TestTools.DataCollection.SystemInfo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" friendlyName="System Information">
+        </DataCollector>
+        <DataCollector uri="datacollector://microsoft/ActionLog/1.0" assemblyQualifiedName="Microsoft.VisualStudio.TestTools.ManualTest.ActionLog.ActionLogPlugin, Microsoft.VisualStudio.TestTools.ManualTest.ActionLog, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" friendlyName="Actions">
+        </DataCollector>
+        <DataCollector uri="datacollector://microsoft/HttpProxy/1.0" assemblyQualifiedName="Microsoft.VisualStudio.TraceCollector.HttpProxyCollector, Microsoft.VisualStudio.TraceCollector, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" friendlyName="ASP.NET Client Proxy for IntelliTrace and Test Impact">
+        </DataCollector>
+        <DataCollector uri="datacollector://microsoft/TestImpact/1.0" assemblyQualifiedName="Microsoft.VisualStudio.TraceCollector.TestImpactDataCollector, Microsoft.VisualStudio.TraceCollector, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" friendlyName="Test Impact">
+        </DataCollector>
+        <DataCollector uri="datacollector://microsoft/TraceDebugger/1.0" assemblyQualifiedName="Microsoft.VisualStudio.TraceCollector.TraceDebuggerDataCollector, Microsoft.VisualStudio.TraceCollector, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" friendlyName="IntelliTrace">
+        </DataCollector>
+      </DataCollectors>
+    </AgentRule>
+  </Execution>
+</TestSettings>
\ No newline at end of file