diff --git a/ClosedXML/ClosedXML.sln b/ClosedXML/ClosedXML.sln
deleted file mode 100644
index c619cc0..0000000
--- a/ClosedXML/ClosedXML.sln
+++ /dev/null
@@ -1,29 +0,0 @@
-
-Microsoft Visual Studio Solution File, Format Version 11.00
-# Visual Studio 2010
-Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ClosedXML", "ClosedXML\ClosedXML.csproj", "{BD5E6BFE-E837-4A35-BCA9-39667D873A20}"
-EndProject
-Global
- GlobalSection(TeamFoundationVersionControl) = preSolution
- SccNumberOfProjects = 2
- SccEnterpriseProvider = {4CA58AB2-18FA-4F8D-95D4-32DDF27D184C}
- SccTeamFoundationServer = https://tfs09.codeplex.com/
- SccLocalPath0 = .
- SccProjectUniqueName1 = ClosedXML\\ClosedXML.csproj
- SccProjectName1 = ClosedXML
- SccLocalPath1 = ClosedXML
- EndGlobalSection
- GlobalSection(SolutionConfigurationPlatforms) = preSolution
- Debug|Any CPU = Debug|Any CPU
- Release|Any CPU = Release|Any CPU
- 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}.Release|Any CPU.ActiveCfg = Release|Any CPU
- {BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Release|Any CPU.Build.0 = Release|Any CPU
- EndGlobalSection
- GlobalSection(SolutionProperties) = preSolution
- HideSolutionNode = FALSE
- EndGlobalSection
-EndGlobal
diff --git a/ClosedXML/ClosedXML.vssscc b/ClosedXML/ClosedXML.vssscc
deleted file mode 100644
index 794f014..0000000
--- a/ClosedXML/ClosedXML.vssscc
+++ /dev/null
@@ -1,10 +0,0 @@
-""
-{
-"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" = "PROJECT"
-}
diff --git a/ClosedXML/ClosedXML/ClosedXML.csproj b/ClosedXML/ClosedXML/ClosedXML.csproj
deleted file mode 100644
index 8517855..0000000
--- a/ClosedXML/ClosedXML/ClosedXML.csproj
+++ /dev/null
@@ -1,67 +0,0 @@
-
-
-
- Debug
- AnyCPU
- 8.0.30703
- 2.0
- {BD5E6BFE-E837-4A35-BCA9-39667D873A20}
- Library
- Properties
- ClosedXML
- ClosedXML
- v4.0
- 512
- SAK
- SAK
- SAK
- SAK
-
-
- true
- full
- false
- bin\Debug\
- DEBUG;TRACE
- prompt
- 4
-
-
- pdbonly
- true
- bin\Release\
- TRACE
- prompt
- 4
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
\ No newline at end of file
diff --git a/ClosedXML/ClosedXML/ClosedXML.csproj.vspscc b/ClosedXML/ClosedXML/ClosedXML.csproj.vspscc
deleted file mode 100644
index feffdec..0000000
--- a/ClosedXML/ClosedXML/ClosedXML.csproj.vspscc
+++ /dev/null
@@ -1,10 +0,0 @@
-""
-{
-"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/Excel/XLCell.cs b/ClosedXML/ClosedXML/Excel/XLCell.cs
deleted file mode 100644
index 64f25f0..0000000
--- a/ClosedXML/ClosedXML/Excel/XLCell.cs
+++ /dev/null
@@ -1,124 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Text.RegularExpressions;
-using DocumentFormat.OpenXml.Spreadsheet;
-
-namespace ClosedXML.Excel
-{
-
- public class XLCell
- {
- public XLCellAddress CellAddress { get; private set; }
- private XLWorkbook workbook;
- public XLCell(XLWorkbook workbook, XLCellAddress cellAddress)
- {
- this.CellAddress = cellAddress;
- this.workbook = workbook;
- }
-
- public XLCell(XLWorkbook workbook, String cellAddressString)
- {
- this.CellAddress = new XLCellAddress(cellAddressString);
- this.workbook = workbook;
- }
-
- public UInt32 Row { get { return CellAddress.Row; } }
- public UInt32 Column { get { return CellAddress.Column; } }
- public String ColumnLetter { get { return XLWorksheet.ColumnNumberToLetter(this.Column); } }
-
- public CellValues DataType { get; private set; }
- public String InnerValue { get; private set; }
- public String Value {
- get
- {
- if (DataType == CellValues.Boolean)
- {
- return (InnerValue == "1").ToString();
- }
- else if (DataType == CellValues.SharedString)
- {
- return workbook.SharedStrings.GetString(UInt32.Parse(InnerValue));
- }
- else if (DataType == CellValues.Date)
- {
- return GetDateTimeFromSerial(Int32.Parse(InnerValue)).ToString();
- }
- else
- {
- return InnerValue;
- }
- }
- set
- {
- String val = value;
-
- Double dTest;
- DateTime dtTest;
- Boolean bTest;
- if (Double.TryParse(val, out dTest))
- {
- DataType = CellValues.Number;
- }
- else if (DateTime.TryParse(val, out dtTest))
- {
- DataType = CellValues.Date;
- String datePart = GetSerialFromDateTime(dtTest.Day, dtTest.Month, dtTest.Year).ToString();
- val = datePart;
- }
- else if (Boolean.TryParse(val, out bTest))
- {
- DataType = CellValues.Boolean;
- val = bTest ? "1" : "0";
- }
- else
- {
- DataType = CellValues.SharedString;
- val = workbook.SharedStrings.Add(val).ToString();
- }
- InnerValue = val;
- HasValue = !value.Equals(String.Empty);
- }
- }
-
- public Boolean HasValue { get; private set; }
-
- private DateTime GetDateTimeFromSerial(Int32 SerialDate)
- {
- if (SerialDate > 59) SerialDate -= 1; //Excel/Lotus 2/29/1900 bug
- return new DateTime(1899, 12, 31).AddDays(SerialDate);
- }
-
- private Int32 GetSerialFromDateTime(Int32 nDay, Int32 nMonth, Int32 nYear)
- {
- // 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--;
- }
-
- return (int)nSerialDate;
- }
-
-
- }
-}
diff --git a/ClosedXML/ClosedXML/Excel/XLCellAddress.cs b/ClosedXML/ClosedXML/Excel/XLCellAddress.cs
deleted file mode 100644
index 5caee90..0000000
--- a/ClosedXML/ClosedXML/Excel/XLCellAddress.cs
+++ /dev/null
@@ -1,151 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Text.RegularExpressions;
-
-namespace ClosedXML.Excel
-{
- public struct XLCellAddress : IEqualityComparer, IEquatable, IComparable
- {
-
- public XLCellAddress(UInt32 row, UInt32 column)
- {
- this.row = row;
- this.column = column;
- }
-
- public XLCellAddress(String cellAddressString)
- {
- Match m = Regex.Match(cellAddressString, @"^([a-zA-Z]+)(\d+)$");
- String columnLetter = m.Groups[1].Value;
- this.row = UInt32.Parse(m.Groups[2].Value);
- this.column = XLWorksheet.ColumnLetterToNumber(columnLetter);
- }
-
- 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; }
- }
-
- public static XLCellAddress operator +(XLCellAddress cellAddress1, XLCellAddress cellAddress2)
- {
- return new XLCellAddress() { Row = cellAddress1.Row + cellAddress2.Row, Column = cellAddress1.Column + cellAddress2.Column };
- }
-
- public static XLCellAddress operator -(XLCellAddress cellAddress1, XLCellAddress cellAddress2)
- {
- return new XLCellAddress() { Row = cellAddress1.Row - cellAddress2.Row, Column = cellAddress1.Column - cellAddress2.Column };
- }
-
- public static Boolean operator ==(XLCellAddress cellAddress1, XLCellAddress cellAddress2)
- {
- return
- cellAddress1.Row == cellAddress2.Row
- && cellAddress1.Column == cellAddress2.Column;
- }
-
- public static Boolean operator !=(XLCellAddress cellAddress1, XLCellAddress cellAddress2)
- {
- return !(cellAddress1 == cellAddress2);
- }
-
- public static Boolean operator >(XLCellAddress cellAddress1, XLCellAddress cellAddress2)
- {
- return !(cellAddress1 == cellAddress2)
- && cellAddress1.Row >= cellAddress2.Row && cellAddress1.Column >= cellAddress2.Column;
- }
-
- public static Boolean operator <(XLCellAddress cellAddress1, XLCellAddress cellAddress2)
- {
- return !(cellAddress1 == cellAddress2)
- && cellAddress1.Row <= cellAddress2.Row && cellAddress1.Column <= cellAddress2.Column;
- }
-
- public static Boolean operator >=(XLCellAddress cellAddress1, XLCellAddress cellAddress2)
- {
- return
- cellAddress1.Row >= cellAddress2.Row
- && cellAddress1.Column >= cellAddress2.Column;
- }
-
- public static Boolean operator <=(XLCellAddress cellAddress1, XLCellAddress cellAddress2)
- {
- return
- cellAddress1.Row <= cellAddress2.Row
- && cellAddress1.Column <= cellAddress2.Column;
- }
-
- public override String ToString()
- {
- return XLWorksheet.ColumnNumberToLetter(Column) + Row.ToString();
- }
-
- #region IEqualityComparer Members
-
- public Boolean Equals(XLCellAddress x, XLCellAddress y)
- {
- return x == y;
- }
-
- public Int32 GetHashCode(XLCellAddress 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 Members
-
- public Boolean Equals(XLCellAddress other)
- {
- return this == other;
- }
-
- public override Boolean Equals(Object other)
- {
- return this == (XLCellAddress)other;
- }
-
- #endregion
-
- #region IComparable Members
-
- public Int32 CompareTo(object obj)
- {
- var other = (XLCellAddress)obj;
- if (this == other)
- return 0;
- else if (this > other)
- return 1;
- else
- return -1;
- }
-
- #endregion
- }
-}
diff --git a/ClosedXML/ClosedXML/Excel/XLCells.cs b/ClosedXML/ClosedXML/Excel/XLCells.cs
deleted file mode 100644
index 66a4a49..0000000
--- a/ClosedXML/ClosedXML/Excel/XLCells.cs
+++ /dev/null
@@ -1,50 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-
-namespace ClosedXML.Excel
-{
- public class XLCells: IEnumerable
- {
- private Dictionary cells = new Dictionary();
- private XLWorkbook workbook;
- public XLCells(XLWorkbook workbook)
- {
- this.workbook = workbook;
- }
-
- public XLCell this[XLCellAddress cellAddress]
- {
- get
- {
- Add(cellAddress);
- return cells[cellAddress];
- }
- }
-
- public void Add(XLCellAddress cellAddress)
- {
- if (!cells.ContainsKey(cellAddress))
- cells.Add(cellAddress, new XLCell(workbook, cellAddress));
- }
-
- #region IEnumerable Members
-
- public IEnumerator GetEnumerator()
- {
- return cells.Values.AsEnumerable().GetEnumerator();
- }
-
- #endregion
-
- #region IEnumerable Members
-
- System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
- {
- return this.GetEnumerator();
- }
-
- #endregion
- }
-}
diff --git a/ClosedXML/ClosedXML/Excel/XLRange.cs b/ClosedXML/ClosedXML/Excel/XLRange.cs
deleted file mode 100644
index b6bc1a1..0000000
--- a/ClosedXML/ClosedXML/Excel/XLRange.cs
+++ /dev/null
@@ -1,198 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-
-namespace ClosedXML.Excel
-{
- public enum CellContent { All, WithValues }
- 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;
- public XLRange ParentRange { get; private set; }
- protected XLWorkbook workbook;
-
- internal XLRange(XLCell firstCell, XLCell lastCell, XLCells cellData, XLRange parentRange)
- {
- this.cellData = cellData;
- this.firstCell = firstCell;
- this.lastCell = lastCell;
- this.ParentRange = parentRange;
- this.workbook = parentRange == null ? null : parentRange.workbook;
- }
-
- 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 Rows()
- {
- return Rows(CellContent.All);
- }
- public List Rows(CellContent cellContent)
- {
- if (cellContent == CellContent.WithValues)
- {
- 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();
- }
- 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();
- }
- }
- public UInt32 RowCount()
- {
- return RowCount(CellContent.All);
- }
- public UInt32 RowCount(CellContent cellContent)
- {
- if (cellContent == CellContent.WithValues)
- {
- 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;
- }
- }
-
- public UInt32 Column { get { return firstCell.Column; } }
- public UInt32 ColumnCount()
- {
- return ColumnCount(CellContent.All);
- }
- public UInt32 ColumnCount(CellContent cellContent)
- {
- if (cellContent == CellContent.WithValues)
- {
- 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;
- }
- }
-
- public virtual List Cells()
- {
- return Cells(CellContent.All);
- }
-
- public virtual List Cells(CellContent cellContent)
- {
- if (cellContent == CellContent.WithValues)
- {
- return cellData
- .Where(c => c.HasValue && c.CellAddress >= this.firstCell.CellAddress && c.CellAddress <= lastCell.CellAddress)
- .OrderBy(x => x.CellAddress)
- .ToList();
- }
- else
- {
- List retVal = new List();
- for (UInt32 row = firstCell.Row; row <= lastCell.Row; row++)
- {
- for (UInt32 column = firstCell.Column; column <= lastCell.Column; column++)
- {
- retVal.Add(Cell(row, column));
- }
- }
- return retVal;
- }
- }
- }
-}
diff --git a/ClosedXML/ClosedXML/Excel/XLSharedStrings.cs b/ClosedXML/ClosedXML/Excel/XLSharedStrings.cs
deleted file mode 100644
index 57e3cef..0000000
--- a/ClosedXML/ClosedXML/Excel/XLSharedStrings.cs
+++ /dev/null
@@ -1,64 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-
-namespace ClosedXML.Excel
-{
- public class XLSharedStrings: IEnumerable
- {
- internal class SharedStringInfo
- {
- public UInt32 Position { get; set; }
- public UInt32 Count { get; set; }
- }
-
- private Dictionary sharedStrings = new Dictionary();
-
- private UInt32 lastPosition = 0;
- public UInt32 Add(String sharedString)
- {
- SharedStringInfo stringInfo;
- if(sharedStrings.ContainsKey(sharedString))
- {
- stringInfo = sharedStrings[sharedString];
- stringInfo.Count++;
- }
- else
- {
- stringInfo = new SharedStringInfo() { Position = lastPosition, Count = 1 };
- sharedStrings.Add(sharedString, stringInfo);
- lastPosition++;
- }
- return stringInfo.Position;
- }
-
- public String GetString(UInt32 position)
- {
- return sharedStrings.Where(s => s.Value.Position == position).Single().Key;
- }
-
- public UInt32 Count
- {
- get { return (UInt32)sharedStrings.Count; }
- }
-
- #region IEnumerable Members
-
- public IEnumerator GetEnumerator()
- {
- return sharedStrings.Keys.GetEnumerator();
- }
-
- #endregion
-
- #region IEnumerable Members
-
- System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
- {
- return GetEnumerator();
- }
-
- #endregion
- }
-}
diff --git a/ClosedXML/ClosedXML/Excel/XLWorkbook.cs b/ClosedXML/ClosedXML/Excel/XLWorkbook.cs
deleted file mode 100644
index 9965123..0000000
--- a/ClosedXML/ClosedXML/Excel/XLWorkbook.cs
+++ /dev/null
@@ -1,929 +0,0 @@
-using System;
-using System.Collections.Generic;
-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;
-
-
-namespace ClosedXML.Excel
-{
- public class XLWorkbook
- {
- public XLWorksheets Worksheets;
- public XLSharedStrings SharedStrings = new XLSharedStrings();
-
- public XLWorkbook(String file)
- {
- FileInfo fi = new FileInfo(file);
- workbookName = fi.Name;
- workbookFullName = fi.FullName;
- Worksheets = new XLWorksheets(this);
- }
-
- private String workbookName;
- public String Name
- {
- get { return workbookName; }
- }
-
- private String workbookFullName;
- public String FullName
- {
- get { return workbookFullName; }
- }
-
- 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("rId1");
- GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart);
-
- WorkbookPart workbookPart1 = document.AddWorkbookPart();
- GenerateWorkbookPart1Content(workbookPart1);
-
- UInt32Value sheetId = 0;
- foreach (var worksheet in Worksheets)
- {
- sheetId++;
- WorksheetPart worksheetPart1 = workbookPart1.AddNewPart("rId" + sheetId.ToString());
- GenerateWorksheetPart3Content(worksheetPart1, worksheet);
- }
-
- SharedStringTablePart sharedStringTablePart1 = workbookPart1.AddNewPart();
- GenerateSharedStringTablePart1Content(sharedStringTablePart1);
-
- WorkbookStylesPart workbookStylesPart1 = workbookPart1.AddNewPart();
- GenerateWorkbookStylesPart1Content(workbookStylesPart1);
-
- ThemePart themePart1 = workbookPart1.AddNewPart();
- 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() { 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 = "manleon";
- 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 = "manleon";
- }
-
-
- #endregion
- }
-}
diff --git a/ClosedXML/ClosedXML/Excel/XLWorksheet.cs b/ClosedXML/ClosedXML/Excel/XLWorksheet.cs
deleted file mode 100644
index 6229ca3..0000000
--- a/ClosedXML/ClosedXML/Excel/XLWorksheet.cs
+++ /dev/null
@@ -1,91 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-
-namespace ClosedXML.Excel
-{
- public class XLWorksheet: XLRange
- {
- public const UInt32 MaxNumberOfRows = 1048576;
- public const UInt32 MaxNumberOfColumns = 16384;
-
- public XLWorksheet(XLWorkbook workbook, String sheetName, XLCells cells)
- : base(
- new XLCell(workbook, new XLCellAddress(1,1))
- , new XLCell(workbook, new XLCellAddress(MaxNumberOfRows, MaxNumberOfColumns))
- , cells, null)
- {
- this.name = sheetName;
- }
-
- public override List Cells()
- {
- return Cells(CellContent.All);
- }
-
- public override List Cells(CellContent cellContent)
- {
- if (cellContent == CellContent.WithValues)
- {
- return base.Cells(cellContent);
- }
- else
- {
- String errorText = "Cannot load entire worksheet into memory. Please use a range (eg. XLWorksheet.Range(\"A1:D5\")) or retrieve cells with values (eg. XLWorksheet.Cells(CellContent.WithValues)).";
- throw new InvalidOperationException(errorText);
- }
- }
-
- private String name;
- public String Name
- {
- get
- {
- return name;
- }
- set
- {
- name = value;
- }
- }
-
- 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 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;
- }
- }
-}
diff --git a/ClosedXML/ClosedXML/Excel/XLWorksheets.cs b/ClosedXML/ClosedXML/Excel/XLWorksheets.cs
deleted file mode 100644
index fb89db1..0000000
--- a/ClosedXML/ClosedXML/Excel/XLWorksheets.cs
+++ /dev/null
@@ -1,66 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-
-namespace ClosedXML.Excel
-{
- public class XLWorksheets : IEnumerable
- {
- private Dictionary worksheets = new Dictionary();
-
- private XLWorkbook workbook;
-
- public XLWorksheets(XLWorkbook workbook)
- {
- this.workbook = workbook;
- }
-
- public XLWorksheet this[String sheetName]
- {
- get
- {
- return worksheets[sheetName];
- }
- }
-
- public XLWorksheet Add(String name)
- {
- XLWorksheet worksheet = new XLWorksheet(workbook, name, new XLCells(workbook));
- worksheets.Add(name, worksheet);
- return worksheet;
- }
-
- public UInt32 Count
- {
- get
- {
- return (UInt32)worksheets.Count;
- }
- }
-
- private Int32 nextWorksheetId = 1;
- private Int32 GetNextWorksheetId()
- {
- return nextWorksheetId++;
- }
-
- #region IEnumerable Members
-
- public IEnumerator GetEnumerator()
- {
- return worksheets.Values.AsEnumerable().GetEnumerator();
- }
-
- #endregion
-
- #region IEnumerable Members
-
- System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
- {
- return this.GetEnumerator();
- }
-
- #endregion
- }
-}
diff --git a/ClosedXML/ClosedXML/Properties/AssemblyInfo.cs b/ClosedXML/ClosedXML/Properties/AssemblyInfo.cs
deleted file mode 100644
index 367a544..0000000
--- a/ClosedXML/ClosedXML/Properties/AssemblyInfo.cs
+++ /dev/null
@@ -1,36 +0,0 @@
-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")]
-[assembly: AssemblyDescription("")]
-[assembly: AssemblyConfiguration("")]
-[assembly: AssemblyCompany("Microsoft")]
-[assembly: AssemblyProduct("ClosedXML")]
-[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("8747331d-de58-4621-8c7f-a7d57ca3467a")]
-
-// 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")]