// Generates content of fontTablePart1.
private void GenerateFontTablePart1Content(FontTablePart fontTablePart1)
{
Fonts fonts1 = new Fonts(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "w14 w15" } };
fonts1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
fonts1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
fonts1.AddNamespaceDeclaration("w", "http://schemas.openxmlformats.org/wordprocessingml/2006/main");
fonts1.AddNamespaceDeclaration("w14", "http://schemas.microsoft.com/office/word/2010/wordml");
fonts1.AddNamespaceDeclaration("w15", "http://schemas.microsoft.com/office/word/2010/11/wordml");
Font font1 = new Font(){ Name = "Century" };
Panose1Number panose1Number1 = new Panose1Number(){ Val = "02040604050505020304" };
FontCharSet fontCharSet1 = new FontCharSet(){ Val = "00" };
FontFamily fontFamily1 = new FontFamily(){ Val = FontFamilyValues.Roman };
Pitch pitch1 = new Pitch(){ Val = FontPitchValues.Variable };
FontSignature fontSignature1 = new FontSignature(){ UnicodeSignature0 = "00000287", UnicodeSignature1 = "00000000", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000009F", CodePageSignature1 = "00000000" };
font1.Append(panose1Number1);
font1.Append(fontCharSet1);
font1.Append(fontFamily1);
font1.Append(pitch1);
font1.Append(fontSignature1);
Font font2 = new Font(){ Name = "ＭＳ 明朝" };
AltName altName1 = new AltName(){ Val = "MS Mincho" };
Panose1Number panose1Number2 = new Panose1Number(){ Val = "02020609040205080304" };
FontCharSet fontCharSet2 = new FontCharSet(){ Val = "80" };
FontFamily fontFamily2 = new FontFamily(){ Val = FontFamilyValues.Roman };
Pitch pitch2 = new Pitch(){ Val = FontPitchValues.Fixed };
FontSignature fontSignature2 = new FontSignature(){ UnicodeSignature0 = "E00002FF", UnicodeSignature1 = "6AC7FDFB", UnicodeSignature2 = "00000012", UnicodeSignature3 = "00000000", CodePageSignature0 = "0002009F", CodePageSignature1 = "00000000" };
font2.Append(altName1);
font2.Append(panose1Number2);
font2.Append(fontCharSet2);
font2.Append(fontFamily2);
font2.Append(pitch2);
font2.Append(fontSignature2);
Font font3 = new Font(){ Name = "Times New Roman" };
Panose1Number panose1Number3 = new Panose1Number(){ Val = "02020603050405020304" };
FontCharSet fontCharSet3 = new FontCharSet(){ Val = "00" };
FontFamily fontFamily3 = new FontFamily(){ Val = FontFamilyValues.Roman };
Pitch pitch3 = new Pitch(){ Val = FontPitchValues.Variable };
FontSignature fontSignature3 = new FontSignature(){ UnicodeSignature0 = "E0002AFF", UnicodeSignature1 = "C0007841", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font3.Append(panose1Number3);
font3.Append(fontCharSet3);
font3.Append(fontFamily3);
font3.Append(pitch3);
font3.Append(fontSignature3);
Font font4 = new Font(){ Name = "ＭＳ ゴシック" };
AltName altName2 = new AltName(){ Val = "MS Gothic" };
Panose1Number panose1Number4 = new Panose1Number(){ Val = "020B0609070205080204" };
FontCharSet fontCharSet4 = new FontCharSet(){ Val = "80" };
FontFamily fontFamily4 = new FontFamily(){ Val = FontFamilyValues.Modern };
Pitch pitch4 = new Pitch(){ Val = FontPitchValues.Fixed };
FontSignature fontSignature4 = new FontSignature(){ UnicodeSignature0 = "E00002FF", UnicodeSignature1 = "6AC7FDFB", UnicodeSignature2 = "00000012", UnicodeSignature3 = "00000000", CodePageSignature0 = "0002009F", CodePageSignature1 = "00000000" };
font4.Append(altName2);
font4.Append(panose1Number4);
font4.Append(fontCharSet4);
font4.Append(fontFamily4);
font4.Append(pitch4);
font4.Append(fontSignature4);
Font font5 = new Font(){ Name = "Arial" };
Panose1Number panose1Number5 = new Panose1Number(){ Val = "020B0604020202020204" };
FontCharSet fontCharSet5 = new FontCharSet(){ Val = "00" };
FontFamily fontFamily5 = new FontFamily(){ Val = FontFamilyValues.Swiss };
Pitch pitch5 = new Pitch(){ Val = FontPitchValues.Variable };
FontSignature fontSignature5 = new FontSignature(){ UnicodeSignature0 = "E0002AFF", UnicodeSignature1 = "C0007843", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font5.Append(panose1Number5);
font5.Append(fontCharSet5);
font5.Append(fontFamily5);
font5.Append(pitch5);
font5.Append(fontSignature5);
fonts1.Append(font1);
fonts1.Append(font2);
fonts1.Append(font3);
fonts1.Append(font4);
fonts1.Append(font5);
fontTablePart1.Fonts = fonts1;
}
public LogFont(FontCharSet charSet) : this(string.Empty, charSet)
{
}
/// <summary>
/// Renders the <see cref="Duality.Resources.Font"/> based on its embedded TrueType representation.
/// <param name="extendedSet">Extended set of characters for renderning.</param>
/// </summary>
private RenderedFontData RenderGlyphs(byte[] trueTypeFontData, float emSize, FontStyle style, FontCharSet extendedSet, bool antialiasing, bool monospace)
{
if (this.fontManagers == null)
{
this.fontManagers = new Dictionary <int, PrivateFontCollection>();
}
// Allocate one PrivateFontCollection for each embedded TrueType Font
// This is an unfortunate requirement to keep track of which Font is which,
// since a byte[] doesn't give it away, and a Font collection won't tell us
// which one we just added.
PrivateFontCollection manager;
int fontId = trueTypeFontData.GetHashCode();
if (!this.fontManagers.TryGetValue(fontId, out manager))
{
manager = new PrivateFontCollection();
this.fontManagers.Add(fontId, manager);
}
// Load custom font family using System.Drawing
if (manager.Families.Length == 0)
{
IntPtr fontBuffer = Marshal.AllocCoTaskMem(trueTypeFontData.Length);
Marshal.Copy(trueTypeFontData, 0, fontBuffer, trueTypeFontData.Length);
manager.AddMemoryFont(fontBuffer, trueTypeFontData.Length);
}
// Render the font's glyphs
return(this.RenderGlyphs(
manager.Families.FirstOrDefault(),
emSize,
style,
extendedSet,
antialiasing,
monospace));
// Yes, we have a minor memory leak here - both the Font buffer and the private
// Font collection. Unfortunately though, GDI+ won't let us dispose them
// properly due to aggressive Font caching, see here:
//
// http://stackoverflow.com/questions/25583394/privatefontcollection-addmemoryfont-producing-random-errors-on-windows-server-20
//
// "Standard GDI+ lossage, disposing a Font does not actually destroy it.
// It gets put back into a cache, with the assumption that it will be used again.
// An important perf optimization, creating fonts is pretty expensive. That ends
// poorly for private fonts when you destroy their home, the font will use
// released memory. Producing bewildering results, including hard crashes. You'll
// need to keep the collection around, as well as the IntPtr."
// – Hans Passant Aug 30 '14 at 16:13
}
/// <summary>
/// Renders the <see cref="Duality.Resources.Font"/> using the specified system font.
/// This method assumes that the system font's size and style match the one specified in
/// the specified Duality font.
/// </summary>
private RenderedFontData RenderGlyphs(SysDrawFont internalFont, FontCharSet charSet, bool antialiazing, bool monospace)
{
DualityFont.GlyphData[] glyphs = new DualityFont.GlyphData[charSet.Chars.Length];
for (int i = 0; i < glyphs.Length; i++)
{
glyphs[i].Glyph = charSet.Chars[i];
}
int bodyAscent = 0;
int baseLine = 0;
int descent = 0;
int ascent = 0;
TextRenderingHint textRenderingHint;
if (antialiazing)
{
textRenderingHint = TextRenderingHint.AntiAliasGridFit;
}
else
{
textRenderingHint = TextRenderingHint.SingleBitPerPixelGridFit;
}
int cols;
int rows;
cols = rows = (int)Math.Ceiling(Math.Sqrt(glyphs.Length));
PixelData pixelLayer = new PixelData(
MathF.RoundToInt(cols * internalFont.Size * 1.2f),
MathF.RoundToInt(rows * internalFont.Height * 1.2f),
ColorRgba.TransparentBlack);
PixelData glyphTemp;
PixelData glyphTempTypo;
Bitmap bm;
Bitmap measureBm = new Bitmap(1, 1);
Rect[] atlas = new Rect[glyphs.Length];
using (Graphics measureGraphics = Graphics.FromImage(measureBm))
{
Brush fntBrush = new SolidBrush(Color.Black);
StringFormat formatDef = StringFormat.GenericDefault;
formatDef.LineAlignment = StringAlignment.Near;
formatDef.FormatFlags = 0;
StringFormat formatTypo = StringFormat.GenericTypographic;
formatTypo.LineAlignment = StringAlignment.Near;
int x = 1;
int y = 1;
for (int i = 0; i < glyphs.Length; ++i)
{
string str = glyphs[i].Glyph.ToString(CultureInfo.InvariantCulture);
bool isSpace = str == " ";
SizeF charSize = measureGraphics.MeasureString(str, internalFont, pixelLayer.Width, formatDef);
// Rasterize a single glyph for rendering
bm = new Bitmap((int)Math.Ceiling(Math.Max(1, charSize.Width)), internalFont.Height + 1);
using (Graphics glyphGraphics = Graphics.FromImage(bm))
{
glyphGraphics.Clear(Color.Transparent);
glyphGraphics.TextRenderingHint = textRenderingHint;
glyphGraphics.DrawString(str, internalFont, fntBrush, new RectangleF(0, 0, bm.Width, bm.Height), formatDef);
}
glyphTemp = new PixelData();
glyphTemp.FromBitmap(bm);
// Rasterize a single glyph in typographic mode for metric analysis
if (!isSpace)
{
Point2 glyphTempOpaqueTopLeft;
Point2 glyphTempOpaqueSize;
glyphTemp.GetOpaqueBoundaries(out glyphTempOpaqueTopLeft, out glyphTempOpaqueSize);
glyphTemp.SubImage(glyphTempOpaqueTopLeft.X, 0, glyphTempOpaqueSize.X, glyphTemp.Height);
if (charSet.CharBodyAscentRef.Contains(glyphs[i].Glyph))
{
bodyAscent += glyphTempOpaqueSize.Y;
}
if (charSet.CharBaseLineRef.Contains(glyphs[i].Glyph))
{
baseLine += glyphTempOpaqueTopLeft.Y + glyphTempOpaqueSize.Y;
}
if (charSet.CharDescentRef.Contains(glyphs[i].Glyph))
{
descent += glyphTempOpaqueTopLeft.Y + glyphTempOpaqueSize.Y;
}
bm = new Bitmap((int)Math.Ceiling(Math.Max(1, charSize.Width)), internalFont.Height + 1);
using (Graphics glyphGraphics = Graphics.FromImage(bm))
{
glyphGraphics.Clear(Color.Transparent);
glyphGraphics.TextRenderingHint = textRenderingHint;
glyphGraphics.DrawString(str, internalFont, fntBrush, new RectangleF(0, 0, bm.Width, bm.Height), formatTypo);
}
glyphTempTypo = new PixelData();
glyphTempTypo.FromBitmap(bm);
glyphTempTypo.Crop(true, false);
}
else
{
glyphTempTypo = glyphTemp;
}
// Update xy values if it doesn't fit anymore
if (x + glyphTemp.Width + 2 > pixelLayer.Width)
{
x = 1;
y += internalFont.Height + MathF.Clamp((int)MathF.Ceiling(internalFont.Height * 0.1875f), 3, 10);
}
// Memorize atlas coordinates & glyph data
glyphs[i].Width = glyphTemp.Width;
glyphs[i].Height = glyphTemp.Height;
glyphs[i].OffsetX = glyphTemp.Width - glyphTempTypo.Width;
glyphs[i].OffsetY = 0; // ttf fonts are rendered on blocks that are the whole size of the height - so no need for offset
if (isSpace)
{
glyphs[i].Width /= 2;
glyphs[i].OffsetX /= 2;
}
atlas[i].X = x;
atlas[i].Y = y;
atlas[i].W = glyphTemp.Width;
atlas[i].H = (internalFont.Height + 1);
// Draw it onto the font surface
glyphTemp.DrawOnto(pixelLayer, BlendMode.Solid, x, y);
x += glyphTemp.Width + MathF.Clamp((int)MathF.Ceiling(internalFont.Height * 0.125f), 2, 10);
}
}
// White out texture except alpha channel.
for (int i = 0; i < pixelLayer.Data.Length; i++)
{
pixelLayer.Data[i].R = 255;
pixelLayer.Data[i].G = 255;
pixelLayer.Data[i].B = 255;
}
// Monospace offset adjustments
if (monospace)
{
int maxGlyphWidth = 0;
for (int i = 0; i < glyphs.Length; i++)
{
maxGlyphWidth = Math.Max(maxGlyphWidth, glyphs[i].Width);
}
for (int i = 0; i < glyphs.Length; ++i)
{
glyphs[i].OffsetX -= (int)Math.Round((maxGlyphWidth - glyphs[i].Width) / 2.0f);
}
}
// Determine Font properties
{
float lineSpacing = internalFont.FontFamily.GetLineSpacing(internalFont.Style);
float emHeight = internalFont.FontFamily.GetEmHeight(internalFont.Style);
float cellAscent = internalFont.FontFamily.GetCellAscent(internalFont.Style);
float cellDescent = internalFont.FontFamily.GetCellDescent(internalFont.Style);
ascent = (int)Math.Round(cellAscent * internalFont.Size / emHeight);
bodyAscent /= charSet.CharBodyAscentRef.Length;
baseLine /= charSet.CharBaseLineRef.Length;
descent = (int)Math.Round(((float)descent / charSet.CharDescentRef.Length) - (float)baseLine);
}
// Aggregate rendered and generated data into our return value
FontMetrics metrics = new FontMetrics(
size: internalFont.SizeInPoints,
height: (int)internalFont.Height,
ascent: ascent,
bodyAscent: bodyAscent,
descent: descent,
baseLine: baseLine,
monospace: monospace);
return(new RenderedFontData
{
Bitmap = pixelLayer,
Atlas = atlas,
GlyphData = glyphs,
Metrics = metrics
});
}
private void SetFontTablePart(FontTablePart fontTablePart1)
{
Fonts fonts1 = new Fonts()
{
MCAttributes = new MarkupCompatibilityAttributes()
{
Ignorable = "w14 w15"
}
};
fonts1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
fonts1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
fonts1.AddNamespaceDeclaration("w", "http://schemas.openxmlformats.org/wordprocessingml/2006/main");
fonts1.AddNamespaceDeclaration("w14", "http://schemas.microsoft.com/office/word/2010/wordml");
fonts1.AddNamespaceDeclaration("w15", "http://schemas.microsoft.com/office/word/2012/wordml");
Font font1 = new Font()
{
Name = "Calibri"
};
Panose1Number panose1Number1 = new Panose1Number()
{
Val = "020F0502020204030204"
};
FontCharSet fontCharSet1 = new FontCharSet()
{
Val = "00"
};
FontFamily fontFamily1 = new FontFamily()
{
Val = FontFamilyValues.Swiss
};
Pitch pitch1 = new Pitch()
{
Val = FontPitchValues.Variable
};
FontSignature fontSignature1 = new FontSignature()
{
UnicodeSignature0 = "E0002AFF", UnicodeSignature1 = "C000247B", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000"
};
font1.Append(panose1Number1);
font1.Append(fontCharSet1);
font1.Append(fontFamily1);
font1.Append(pitch1);
font1.Append(fontSignature1);
Font font2 = new Font()
{
Name = "Times New Roman"
};
Panose1Number panose1Number2 = new Panose1Number()
{
Val = "02020603050405020304"
};
FontCharSet fontCharSet2 = new FontCharSet()
{
Val = "00"
};
FontFamily fontFamily2 = new FontFamily()
{
Val = FontFamilyValues.Roman
};
Pitch pitch2 = new Pitch()
{
Val = FontPitchValues.Variable
};
FontSignature fontSignature2 = new FontSignature()
{
UnicodeSignature0 = "E0002EFF", UnicodeSignature1 = "C000785B", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000"
};
font2.Append(panose1Number2);
font2.Append(fontCharSet2);
font2.Append(fontFamily2);
font2.Append(pitch2);
font2.Append(fontSignature2);
Font font3 = new Font()
{
Name = "Calibri Light"
};
Panose1Number panose1Number3 = new Panose1Number()
{
Val = "020F0302020204030204"
};
FontCharSet fontCharSet3 = new FontCharSet()
{
Val = "00"
};
FontFamily fontFamily3 = new FontFamily()
{
Val = FontFamilyValues.Swiss
};
Pitch pitch3 = new Pitch()
{
Val = FontPitchValues.Variable
};
FontSignature fontSignature3 = new FontSignature()
{
UnicodeSignature0 = "E0002AFF", UnicodeSignature1 = "C000247B", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000"
};
font3.Append(panose1Number3);
font3.Append(fontCharSet3);
font3.Append(fontFamily3);
font3.Append(pitch3);
font3.Append(fontSignature3);
fonts1.Append(font1);
fonts1.Append(font2);
fonts1.Append(font3);
fontTablePart1.Fonts = fonts1;
}
public static void GenerateFontTablePart1Content(FontTablePart fontTablePart1)
{
Fonts fonts1 = new Fonts()
{
MCAttributes = new MarkupCompatibilityAttributes()
{
Ignorable = "w14 w15 w16se w16cid"
}
};
fonts1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
fonts1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
fonts1.AddNamespaceDeclaration("w", "http://schemas.openxmlformats.org/wordprocessingml/2006/main");
fonts1.AddNamespaceDeclaration("w14", "http://schemas.microsoft.com/office/word/2010/wordml");
fonts1.AddNamespaceDeclaration("w15", "http://schemas.microsoft.com/office/word/2012/wordml");
fonts1.AddNamespaceDeclaration("w16cid", "http://schemas.microsoft.com/office/word/2016/wordml/cid");
fonts1.AddNamespaceDeclaration("w16se", "http://schemas.microsoft.com/office/word/2015/wordml/symex");
Font font1 = new Font()
{
Name = "Arial"
};
Panose1Number panose1Number1 = new Panose1Number()
{
Val = "020B0604020202020204"
};
FontCharSet fontCharSet1 = new FontCharSet()
{
Val = "BA"
};
FontFamily fontFamily1 = new FontFamily()
{
Val = FontFamilyValues.Swiss
};
Pitch pitch1 = new Pitch()
{
Val = FontPitchValues.Variable
};
FontSignature fontSignature1 = new FontSignature()
{
UnicodeSignature0 = "E0002EFF", UnicodeSignature1 = "C000785B", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000"
};
font1.Append(panose1Number1);
font1.Append(fontCharSet1);
font1.Append(fontFamily1);
font1.Append(pitch1);
font1.Append(fontSignature1);
Font font2 = new Font()
{
Name = "Times New Roman"
};
Panose1Number panose1Number2 = new Panose1Number()
{
Val = "02020603050405020304"
};
FontCharSet fontCharSet2 = new FontCharSet()
{
Val = "BA"
};
FontFamily fontFamily2 = new FontFamily()
{
Val = FontFamilyValues.Roman
};
Pitch pitch2 = new Pitch()
{
Val = FontPitchValues.Variable
};
FontSignature fontSignature2 = new FontSignature()
{
UnicodeSignature0 = "E0002EFF", UnicodeSignature1 = "C000785B", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000"
};
font2.Append(panose1Number2);
font2.Append(fontCharSet2);
font2.Append(fontFamily2);
font2.Append(pitch2);
font2.Append(fontSignature2);
Font font3 = new Font()
{
Name = "Wingdings"
};
Panose1Number panose1Number3 = new Panose1Number()
{
Val = "05000000000000000000"
};
FontCharSet fontCharSet3 = new FontCharSet()
{
Val = "02"
};
FontFamily fontFamily3 = new FontFamily()
{
Val = FontFamilyValues.Auto
};
Pitch pitch3 = new Pitch()
{
Val = FontPitchValues.Variable
};
FontSignature fontSignature3 = new FontSignature()
{
UnicodeSignature0 = "00000000", UnicodeSignature1 = "10000000", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "80000000", CodePageSignature1 = "00000000"
};
font3.Append(panose1Number3);
font3.Append(fontCharSet3);
font3.Append(fontFamily3);
font3.Append(pitch3);
font3.Append(fontSignature3);
Font font4 = new Font()
{
Name = "Cambria"
};
Panose1Number panose1Number4 = new Panose1Number()
{
Val = "02040503050406030204"
};
FontCharSet fontCharSet4 = new FontCharSet()
{
Val = "BA"
};
FontFamily fontFamily4 = new FontFamily()
{
Val = FontFamilyValues.Roman
};
Pitch pitch4 = new Pitch()
{
Val = FontPitchValues.Variable
};
FontSignature fontSignature4 = new FontSignature()
{
UnicodeSignature0 = "E00006FF", UnicodeSignature1 = "420024FF", UnicodeSignature2 = "02000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000019F", CodePageSignature1 = "00000000"
};
font4.Append(panose1Number4);
font4.Append(fontCharSet4);
font4.Append(fontFamily4);
font4.Append(pitch4);
font4.Append(fontSignature4);
Font font5 = new Font()
{
Name = "Calibri"
};
Panose1Number panose1Number5 = new Panose1Number()
{
Val = "020F0502020204030204"
};
FontCharSet fontCharSet5 = new FontCharSet()
{
Val = "BA"
};
FontFamily fontFamily5 = new FontFamily()
{
Val = FontFamilyValues.Swiss
};
Pitch pitch5 = new Pitch()
{
Val = FontPitchValues.Variable
};
FontSignature fontSignature5 = new FontSignature()
{
UnicodeSignature0 = "E0002AFF", UnicodeSignature1 = "C000247B", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000"
};
font5.Append(panose1Number5);
font5.Append(fontCharSet5);
font5.Append(fontFamily5);
font5.Append(pitch5);
font5.Append(fontSignature5);
fonts1.Append(font1);
fonts1.Append(font2);
fonts1.Append(font3);
fonts1.Append(font4);
fonts1.Append(font5);
fontTablePart1.Fonts = fonts1;
}
/// <summary>
/// Gets a collection of fonts based on the specified criteria.
/// </summary>
/// <param name="families">Bit Field representing which font families to retrieve.</param>
/// <param name="pitch">Specify the desired pitch.</param>
/// <param name="charset">Specify the desired character set.</param>
/// <param name="weight">Specify the desired weight.</param>
/// <param name="Script">Specify the desired script(s) (this can be a String or an array of Strings).</param>
/// <param name="Style">Specify the desired style(s) (this can be a String or an array of Strings).</param>
/// <returns></returns>
public static FontCollection GetFonts(FontFamilies families = FontFamilies.DontCare, FontPitch pitch = FontPitch.Default, FontCharSet charset = FontCharSet.Default, FontWeight weight = FontWeight.DontCare, object Script = null, object Style = null)
{
IntPtr hdc;
var fonts = new List <ENUMLOGFONTEX>();
var lf = new LOGFONT();
string s;
MemPtr mm = new MemPtr();
string[] wscript;
string[] wstyle;
if (Script is null)
{
wscript = new[] { "Western" };
}
else if (Script is string)
{
wscript = new[] { (string)(Script) };
}
else if (Script is string[])
{
wscript = (string[])Script;
}
else
{
throw new ArgumentException("Invalid parameter type for Script");
}
if (Style is null)
{
wstyle = new[] { "", "Normal", "Regular" };
}
else if (Style is string)
{
wstyle = new[] { (string)(Style) };
}
else if (Style is string[])
{
wstyle = (string[])Style;
}
else
{
throw new ArgumentException("Invalid parameter type for Style");
}
lf.lfCharSet = (byte)charset;
lf.lfFaceName = "";
mm.Alloc(Marshal.SizeOf(lf));
mm.FromStruct(lf);
hdc = User32.CreateDC("DISPLAY", null, IntPtr.Zero, IntPtr.Zero);
int e;
bool bo = false;
e = EnumFontFamiliesEx(hdc, mm, (ref ENUMLOGFONTEX lpelfe, IntPtr lpntme, uint FontType, IntPtr lParam) =>
{
int z;
if (fonts is null)
{
z = 0;
}
else
{
z = fonts.Count;
}
// make sure it's the normal, regular version
bo = false;
foreach (var y in wstyle)
{
if ((y.ToLower() ?? "") == (lpelfe.elfStyle.ToLower() ?? ""))
{
bo = true;
break;
}
}
if (bo == false)
{
return(1);
}
bo = false;
foreach (var y in wscript)
{
if ((y.ToLower() ?? "") == (lpelfe.elfScript.ToLower() ?? ""))
{
bo = true;
break;
}
}
if (bo == false)
{
return(1);
}
bo = false;
if (weight != FontWeight.DontCare && lpelfe.elfLogFont.lfWeight != (int)weight)
{
return(1);
}
// we don't really need two of the same font.
if (z > 0)
{
if ((lpelfe.elfFullName ?? "") == (fonts[z - 1].elfFullName ?? ""))
{
return(1);
}
}
// the @ indicates a vertical writing font which we definitely do not want.
if (lpelfe.elfFullName.Substring(0, 1) == "@")
{
return(1);
}
if (!CheckFamily(lpelfe.elfLogFont, families))
{
return(1);
}
// lpelfe.elfLogFont.lfCharSet = charset
// If (lpelfe.elfLogFont.lfCharSet <> charset) Then Return 1
if (pitch != FontPitch.Default && (lpelfe.elfLogFont.lfPitchAndFamily & 3) != (int)pitch)
{
return(1);
}
fonts.Add(lpelfe);
return(1);
}, IntPtr.Zero, 0U);
User32.DeleteDC(hdc);
mm.Free();
if (e == 0)
{
e = User32.GetLastError();
s = NativeError.Message;
}
FontInfo nf;
var ccol = new FontCollection();
foreach (var f in fonts)
{
nf = new FontInfo(f);
ccol.Add(nf);
}
ccol.Sort();
return(ccol);
}
//описвывает форматы ячеек
protected void GenWorkbookStylesPart(WorkbookStylesPart workbookStylesPart)
{
Stylesheet stylesheet = new Stylesheet();
Fonts fonts1 = new Fonts();
Font font1 = new Font();
Font font2 = new Font();
FontSize fontSize2 = new FontSize()
{
Val = 11D
};
Color color1 = new Color()
{
Rgb = "FF00B050"
};
FontName fontName2 = new FontName()
{
Val = "Calibri"
};
FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering()
{
Val = 2
};
FontCharSet fontCharSet1 = new FontCharSet()
{
Val = 204
};
font2.Append(fontSize2);
font2.Append(color1);
font2.Append(fontName2);
font2.Append(fontFamilyNumbering1);
font2.Append(fontCharSet1);
//fonts1.Append(font2);
fonts1.Append(font1);
Fills fills1 = new Fills();
Fill fill1 = new Fill();
Fill fill2 = new Fill();
Fill fill3 = new Fill();
PatternFill patternFill3 = new PatternFill()
{
PatternType = PatternValues.Solid
};
ForegroundColor foregroundColor1 = new ForegroundColor()
{
Rgb = "0000FF"
};
patternFill3.Append(foregroundColor1);
fill3.Append(patternFill3);
fills1.Append(fill1);
fills1.Append(fill2);
fills1.Append(fill3);
Borders borders1 = new Borders();
Border border1 = new Border();
borders1.Append(border1);
//Переопределяем номера формата 164U, 166U, 167U, 168U,
NumberingFormats numberingFormats1 = new NumberingFormats()
{
Count = (UInt32Value)3U
};
NumberingFormat numberingFormat1 = new NumberingFormat()
{
NumberFormatId = (UInt32Value)164U, FormatCode = "[$-F800]dddd\\,\\ mmmm\\ dd\\,\\ yyyy"
};
NumberingFormat numberingFormat2 = new NumberingFormat()
{
NumberFormatId = (UInt32Value)166U, FormatCode = "#,##0.000\"р.\""
};
NumberingFormat numberingFormat3 = new NumberingFormat()
{
NumberFormatId = (UInt32Value)167U, FormatCode = "#,##0\"р.\""
}; //"#,##0.00\"р.\"" };
NumberingFormat numberingFormat4 = new NumberingFormat()
{
NumberFormatId = (UInt32Value)168U, FormatCode = "#,##0.00\"р.\""
};
numberingFormats1.Append(numberingFormat1);
numberingFormats1.Append(numberingFormat2);
numberingFormats1.Append(numberingFormat3);
numberingFormats1.Append(numberingFormat4);
CellFormats cellFormats1 = new CellFormats()
{
Count = (UInt32Value)6U
};
CellFormat cellFormat2 = new CellFormat()
{
NumberFormatId = (UInt32Value)0U
}; // Формат № 0 по умолчанию общий
CellFormat cellFormat3 = new CellFormat()
{
NumberFormatId = (UInt32Value)164U
}; // Формат № 1 для дат FormatCode = "[$-F800]dddd\\,\\ mmmm\\ dd\\,\\ yyyy"
CellFormat cellFormat4 = new CellFormat()
{
NumberFormatId = (UInt32Value)166U
}; //формат № 2 для денег по тысяч. ###,### <-- (number/ 1000)
CellFormat cellFormat5 = new CellFormat()
{
NumberFormatId = (UInt32Value)14U
}; //формат № 3 для дат * 14.03.2015
CellFormat cellFormat6 = new CellFormat()
{
NumberFormatId = (UInt32Value)2U
}; //формат № 4 для чисел
CellFormat cellFormat7 = new CellFormat()
{
NumberFormatId = (UInt32Value)1U
}; //более подходящий формат № 5U для чисел (5U)
CellFormat cellFormat8 = new CellFormat()
{
NumberFormatId = (UInt32Value)165U
}; //формат №6U для денег по умолчанию
CellFormat cellFormat9 = new CellFormat()
{
NumberFormatId = (UInt32Value)167U
}; // формат №7U для денег(переопределенный) по три разряда ### ### р.
CellFormat cellFormat10 = new CellFormat()
{
NumberFormatId = (UInt32Value)168U
}; // формат №8U для денег(переопределенный) ### ###,00 р.
cellFormats1.Append(cellFormat2);
cellFormats1.Append(cellFormat3);
cellFormats1.Append(cellFormat4);
cellFormats1.Append(cellFormat5);
cellFormats1.Append(cellFormat6);
cellFormats1.Append(cellFormat7);
cellFormats1.Append(cellFormat8);
cellFormats1.Append(cellFormat9);
cellFormats1.Append(cellFormat10);
stylesheet.Append(numberingFormats1);
stylesheet.Append(fonts1);
stylesheet.Append(fills1);
stylesheet.Append(borders1);
stylesheet.Append(cellFormats1);
workbookStylesPart.Stylesheet = stylesheet;
}
// Generates content of workbookStylesPart1.
private void GenerateWorkbookStylesPart1Content(WorkbookStylesPart workbookStylesPart1)
{
Stylesheet stylesheet1 = new Stylesheet() { MCAttributes = new MarkupCompatibilityAttributes() { Ignorable = "x14ac" } };
stylesheet1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
stylesheet1.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
Fonts fonts1 = new Fonts() { Count = (UInt32Value)5U, KnownFonts = true };
Font font1 = new Font();
FontSize fontSize3 = new FontSize() { Val = 11D };
Color color3 = new Color() { Theme = (UInt32Value)1U };
FontName fontName1 = new FontName() { Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering() { Val = 2 };
FontScheme fontScheme2 = new FontScheme() { Val = FontSchemeValues.Minor };
font1.Append(fontSize3);
font1.Append(color3);
font1.Append(fontName1);
font1.Append(fontFamilyNumbering1);
font1.Append(fontScheme2);
Font font2 = new Font();
Bold bold2 = new Bold();
Underline underline1 = new Underline();
FontSize fontSize4 = new FontSize() { Val = 11D };
Color color4 = new Color() { Rgb = "FFFF0000" };
FontName fontName2 = new FontName() { Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering2 = new FontFamilyNumbering() { Val = 2 };
FontScheme fontScheme3 = new FontScheme() { Val = FontSchemeValues.Minor };
font2.Append(bold2);
font2.Append(underline1);
font2.Append(fontSize4);
font2.Append(color4);
font2.Append(fontName2);
font2.Append(fontFamilyNumbering2);
font2.Append(fontScheme3);
Font font3 = new Font();
Underline underline2 = new Underline();
FontSize fontSize5 = new FontSize() { Val = 11D };
Color color5 = new Color() { Theme = (UInt32Value)10U };
FontName fontName3 = new FontName() { Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering3 = new FontFamilyNumbering() { Val = 2 };
FontScheme fontScheme4 = new FontScheme() { Val = FontSchemeValues.Minor };
font3.Append(underline2);
font3.Append(fontSize5);
font3.Append(color5);
font3.Append(fontName3);
font3.Append(fontFamilyNumbering3);
font3.Append(fontScheme4);
Font font4 = new Font();
FontSize fontSize6 = new FontSize() { Val = 9D };
Color color6 = new Color() { Indexed = (UInt32Value)81U };
FontName fontName4 = new FontName() { Val = "Tahoma" };
FontCharSet fontCharSet1 = new FontCharSet() { Val = 1 };
font4.Append(fontSize6);
font4.Append(color6);
font4.Append(fontName4);
font4.Append(fontCharSet1);
Font font5 = new Font();
Bold bold3 = new Bold();
FontSize fontSize7 = new FontSize() { Val = 9D };
Color color7 = new Color() { Indexed = (UInt32Value)81U };
FontName fontName5 = new FontName() { Val = "Tahoma" };
FontCharSet fontCharSet2 = new FontCharSet() { Val = 1 };
font5.Append(bold3);
font5.Append(fontSize7);
font5.Append(color7);
font5.Append(fontName5);
font5.Append(fontCharSet2);
fonts1.Append(font1);
fonts1.Append(font2);
fonts1.Append(font3);
fonts1.Append(font4);
fonts1.Append(font5);
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)2U };
CellFormat cellFormat1 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U };
CellFormat cellFormat2 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, ApplyNumberFormat = false, ApplyFill = false, ApplyBorder = false, ApplyAlignment = false, ApplyProtection = false };
cellStyleFormats1.Append(cellFormat1);
cellStyleFormats1.Append(cellFormat2);
CellFormats cellFormats1 = new CellFormats() { Count = (UInt32Value)4U };
CellFormat cellFormat3 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U };
CellFormat cellFormat4 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true };
CellFormat cellFormat5 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyAlignment = true };
Alignment alignment1 = new Alignment() { WrapText = true };
cellFormat5.Append(alignment1);
CellFormat cellFormat6 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)1U };
cellFormats1.Append(cellFormat3);
cellFormats1.Append(cellFormat4);
cellFormats1.Append(cellFormat5);
cellFormats1.Append(cellFormat6);
CellStyles cellStyles1 = new CellStyles() { Count = (UInt32Value)2U };
CellStyle cellStyle1 = new CellStyle() { Name = "Hyperlink", FormatId = (UInt32Value)1U, BuiltinId = (UInt32Value)8U };
CellStyle cellStyle2 = new CellStyle() { Name = "Normal", FormatId = (UInt32Value)0U, BuiltinId = (UInt32Value)0U };
cellStyles1.Append(cellStyle1);
cellStyles1.Append(cellStyle2);
DifferentialFormats differentialFormats1 = new DifferentialFormats() { Count = (UInt32Value)0U };
TableStyles tableStyles1 = new TableStyles() { Count = (UInt32Value)0U, DefaultTableStyle = "TableStyleMedium2", DefaultPivotStyle = "PivotStyleMedium9" };
StylesheetExtensionList stylesheetExtensionList1 = new StylesheetExtensionList();
StylesheetExtension stylesheetExtension1 = new StylesheetExtension() { Uri = "{EB79DEF2-80B8-43e5-95BD-54CBDDF9020C}" };
stylesheetExtension1.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.SlicerStyles slicerStyles1 = new X14.SlicerStyles() { DefaultSlicerStyle = "SlicerStyleLight1" };
stylesheetExtension1.Append(slicerStyles1);
StylesheetExtension stylesheetExtension2 = new StylesheetExtension() { Uri = "{9260A510-F301-46a8-8635-F512D64BE5F5}" };
stylesheetExtension2.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");
X15.TimelineStyles timelineStyles1 = new X15.TimelineStyles() { DefaultTimelineStyle = "TimeSlicerStyleLight1" };
stylesheetExtension2.Append(timelineStyles1);
stylesheetExtensionList1.Append(stylesheetExtension1);
stylesheetExtensionList1.Append(stylesheetExtension2);
stylesheet1.Append(fonts1);
stylesheet1.Append(fills1);
stylesheet1.Append(borders1);
stylesheet1.Append(cellStyleFormats1);
stylesheet1.Append(cellFormats1);
stylesheet1.Append(cellStyles1);
stylesheet1.Append(differentialFormats1);
stylesheet1.Append(tableStyles1);
stylesheet1.Append(stylesheetExtensionList1);
workbookStylesPart1.Stylesheet = stylesheet1;
}
// Creates an Stylesheet instance and adds its children.
public static Stylesheet GenerateStylesheet()
{
var stylesheet1 = new Stylesheet {MCAttributes = new MarkupCompatibilityAttributes {Ignorable = "x14ac"}};
stylesheet1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
stylesheet1.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
var fonts1 = new Fonts {Count = 7U, KnownFonts = true};
var font1 = new Font();
var fontSize1 = new FontSize {Val = 11D};
var color1 = new Color {Theme = 1U};
var fontName1 = new FontName {Val = "Calibri"};
var fontFamilyNumbering1 = new FontFamilyNumbering {Val = 2};
var fontCharSet1 = new FontCharSet {Val = 204};
var fontScheme1 = new FontScheme {Val = FontSchemeValues.Minor};
font1.Append(fontSize1);
font1.Append(color1);
font1.Append(fontName1);
font1.Append(fontFamilyNumbering1);
font1.Append(fontCharSet1);
font1.Append(fontScheme1);
var font2 = new Font();
var bold1 = new Bold();
var fontSize2 = new FontSize {Val = 11D};
var color2 = new Color {Theme = 1U};
var fontName2 = new FontName {Val = "Calibri"};
var fontFamilyNumbering2 = new FontFamilyNumbering {Val = 2};
var fontCharSet2 = new FontCharSet {Val = 204};
var fontScheme2 = new FontScheme {Val = FontSchemeValues.Minor};
font2.Append(bold1);
font2.Append(fontSize2);
font2.Append(color2);
font2.Append(fontName2);
font2.Append(fontFamilyNumbering2);
font2.Append(fontCharSet2);
font2.Append(fontScheme2);
var font3 = new Font();
var bold2 = new Bold();
var italic1 = new Italic();
var fontSize3 = new FontSize {Val = 11D};
var color3 = new Color {Theme = 1U};
var fontName3 = new FontName {Val = "Calibri"};
var fontFamilyNumbering3 = new FontFamilyNumbering {Val = 2};
var fontCharSet3 = new FontCharSet {Val = 204};
var fontScheme3 = new FontScheme {Val = FontSchemeValues.Minor};
font3.Append(bold2);
font3.Append(italic1);
font3.Append(fontSize3);
font3.Append(color3);
font3.Append(fontName3);
font3.Append(fontFamilyNumbering3);
font3.Append(fontCharSet3);
font3.Append(fontScheme3);
var font4 = new Font();
var bold3 = new Bold();
var fontSize4 = new FontSize {Val = 18D};
var color4 = new Color {Theme = 1U};
var fontName4 = new FontName {Val = "Calibri"};
var fontFamilyNumbering4 = new FontFamilyNumbering {Val = 2};
var fontCharSet4 = new FontCharSet {Val = 204};
var fontScheme4 = new FontScheme {Val = FontSchemeValues.Minor};
font4.Append(bold3);
font4.Append(fontSize4);
font4.Append(color4);
font4.Append(fontName4);
font4.Append(fontFamilyNumbering4);
font4.Append(fontCharSet4);
font4.Append(fontScheme4);
var font5 = new Font();
var bold4 = new Bold();
var fontSize5 = new FontSize {Val = 11D};
var fontName5 = new FontName {Val = "Calibri"};
var fontFamilyNumbering5 = new FontFamilyNumbering {Val = 2};
var fontCharSet5 = new FontCharSet {Val = 204};
var fontScheme5 = new FontScheme {Val = FontSchemeValues.Minor};
font5.Append(bold4);
font5.Append(fontSize5);
font5.Append(fontName5);
font5.Append(fontFamilyNumbering5);
font5.Append(fontCharSet5);
font5.Append(fontScheme5);
var font6 = new Font();
var fontSize6 = new FontSize {Val = 11D};
var fontName6 = new FontName {Val = "Calibri"};
var fontFamilyNumbering6 = new FontFamilyNumbering {Val = 2};
var fontCharSet6 = new FontCharSet {Val = 204};
var fontScheme6 = new FontScheme {Val = FontSchemeValues.Minor};
font6.Append(fontSize6);
font6.Append(fontName6);
font6.Append(fontFamilyNumbering6);
font6.Append(fontCharSet6);
font6.Append(fontScheme6);
var font7 = new Font();
var bold5 = new Bold();
var fontSize7 = new FontSize {Val = 12D};
var color5 = new Color {Theme = 1U};
var fontName7 = new FontName {Val = "Calibri"};
var fontFamilyNumbering7 = new FontFamilyNumbering {Val = 2};
var fontCharSet7 = new FontCharSet {Val = 204};
var fontScheme7 = new FontScheme {Val = FontSchemeValues.Minor};
font7.Append(bold5);
font7.Append(fontSize7);
font7.Append(color5);
font7.Append(fontName7);
font7.Append(fontFamilyNumbering7);
font7.Append(fontCharSet7);
font7.Append(fontScheme7);
fonts1.Append(font1);
fonts1.Append(font2);
fonts1.Append(font3);
fonts1.Append(font4);
fonts1.Append(font5);
fonts1.Append(font6);
fonts1.Append(font7);
var fills1 = new Fills {Count = 2U};
var fill1 = new Fill();
var patternFill1 = new PatternFill {PatternType = PatternValues.None};
fill1.Append(patternFill1);
var fill2 = new Fill();
var patternFill2 = new PatternFill {PatternType = PatternValues.Gray125};
fill2.Append(patternFill2);
fills1.Append(fill1);
fills1.Append(fill2);
var borders1 = new Borders {Count = 2U};
var border1 = new Border();
var leftBorder1 = new LeftBorder();
var rightBorder1 = new RightBorder();
var topBorder1 = new TopBorder();
var bottomBorder1 = new BottomBorder();
var diagonalBorder1 = new DiagonalBorder();
border1.Append(leftBorder1);
border1.Append(rightBorder1);
border1.Append(topBorder1);
border1.Append(bottomBorder1);
border1.Append(diagonalBorder1);
var border2 = new Border();
var leftBorder2 = new LeftBorder {Style = BorderStyleValues.Thin};
var color6 = new Color {Indexed = 64U};
leftBorder2.Append(color6);
var rightBorder2 = new RightBorder {Style = BorderStyleValues.Thin};
var color7 = new Color {Indexed = 64U};
rightBorder2.Append(color7);
var topBorder2 = new TopBorder {Style = BorderStyleValues.Thin};
var color8 = new Color {Indexed = 64U};
topBorder2.Append(color8);
var bottomBorder2 = new BottomBorder {Style = BorderStyleValues.Thin};
var color9 = new Color {Indexed = 64U};
bottomBorder2.Append(color9);
var diagonalBorder2 = new DiagonalBorder();
border2.Append(leftBorder2);
border2.Append(rightBorder2);
border2.Append(topBorder2);
border2.Append(bottomBorder2);
border2.Append(diagonalBorder2);
borders1.Append(border1);
borders1.Append(border2);
var cellStyleFormats1 = new CellStyleFormats {Count = 4U};
var cellFormat1 = new CellFormat {NumberFormatId = 0U, FontId = 0U, FillId = 0U, BorderId = 0U};
var cellFormat2 = new CellFormat
{
NumberFormatId = 0U,
FontId = 5U,
FillId = 0U,
BorderId = 1U,
ApplyNumberFormat = false,
ApplyAlignment = false,
ApplyProtection = false
};
var cellFormat3 = new CellFormat
{
NumberFormatId = 0U,
FontId = 4U,
FillId = 0U,
BorderId = 1U,
ApplyNumberFormat = false,
ApplyAlignment = false,
ApplyProtection = false
};
var cellFormat4 = new CellFormat {NumberFormatId = 0U, FontId = 6U, FillId = 0U, BorderId = 1U};
cellStyleFormats1.Append(cellFormat1);
cellStyleFormats1.Append(cellFormat2);
cellStyleFormats1.Append(cellFormat3);
cellStyleFormats1.Append(cellFormat4);
var cellFormats1 = new CellFormats {Count = 5U};
var cellFormat5 = new CellFormat
{
NumberFormatId = 0U,
FontId = 0U,
FillId = 0U,
BorderId = 0U,
FormatId = 0U
};
var cellFormat6 = new CellFormat
{
NumberFormatId = 0U,
FontId = 1U,
FillId = 0U,
BorderId = 0U,
FormatId = 0U,
ApplyFont = true
};
var cellFormat7 = new CellFormat
{
NumberFormatId = 0U,
FontId = 2U,
FillId = 0U,
BorderId = 0U,
FormatId = 0U,
ApplyFont = true,
ApplyBorder = true
};
var cellFormat8 = new CellFormat
{
NumberFormatId = 0U,
FontId = 0U,
FillId = 0U,
BorderId = 0U,
FormatId = 0U,
ApplyAlignment = true
};
var cellFormat9 = new CellFormat
{
NumberFormatId = 0U,
FontId = 3U,
FillId = 0U,
BorderId = 0U,
FormatId = 0U,
ApplyFont = true,
ApplyAlignment = true
};
var alignment1 = new Alignment {Horizontal = HorizontalAlignmentValues.Center};
cellFormat9.Append(alignment1);
cellFormats1.Append(cellFormat5);
cellFormats1.Append(cellFormat6);
cellFormats1.Append(cellFormat7);
cellFormats1.Append(cellFormat8);
cellFormats1.Append(cellFormat9);
var cellStyles1 = new CellStyles {Count = 4U};
var cellStyle1 = new CellStyle {Name = "Custom", FormatId = 3U};
var cellStyle2 = new CellStyle {Name = "Нейтральный", FormatId = 2U, BuiltinId = 28U, CustomBuiltin = true};
var cellStyle3 = new CellStyle {Name = "Обычный", FormatId = 0U, BuiltinId = 0U};
var cellStyle4 = new CellStyle {Name = "Плохой", FormatId = 1U, BuiltinId = 27U, CustomBuiltin = true};
cellStyles1.Append(cellStyle1);
cellStyles1.Append(cellStyle2);
cellStyles1.Append(cellStyle3);
cellStyles1.Append(cellStyle4);
var differentialFormats1 = new DifferentialFormats {Count = 0U};
var tableStyles1 = new TableStyles
{
Count = 0U,
DefaultTableStyle = "TableStyleMedium2",
DefaultPivotStyle = "PivotStyleLight16"
};
var stylesheetExtensionList1 = new StylesheetExtensionList();
var stylesheetExtension1 = new StylesheetExtension {Uri = "{EB79DEF2-80B8-43e5-95BD-54CBDDF9020C}"};
stylesheetExtension1.AddNamespaceDeclaration("x14",
"http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
var slicerStyles1 = new X14.SlicerStyles {DefaultSlicerStyle = "SlicerStyleLight1"};
stylesheetExtension1.Append(slicerStyles1);
stylesheetExtensionList1.Append(stylesheetExtension1);
stylesheet1.Append(fonts1);
stylesheet1.Append(fills1);
stylesheet1.Append(borders1);
stylesheet1.Append(cellStyleFormats1);
stylesheet1.Append(cellFormats1);
stylesheet1.Append(cellStyles1);
stylesheet1.Append(differentialFormats1);
stylesheet1.Append(tableStyles1);
stylesheet1.Append(stylesheetExtensionList1);
return stylesheet1;
}
// Generates content of workbookStylesPart1.
private void GenerateWorkbookStylesPart1Content(WorkbookStylesPart workbookStylesPart1)
{
Stylesheet stylesheet1 = new Stylesheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" } };
stylesheet1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
stylesheet1.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
NumberingFormats numberingFormats1 = new NumberingFormats(){ Count = (UInt32Value)1U };
NumberingFormat numberingFormat11 = new NumberingFormat(){ NumberFormatId = (UInt32Value)164U, FormatCode = "\"¥\"#,##0" };
numberingFormats1.Append(numberingFormat11);
Fonts fonts1 = new Fonts(){ Count = (UInt32Value)2U };
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);
Font font2 = new Font();
FontSize fontSize2 = new FontSize(){ Val = 6D };
FontName fontName2 = new FontName(){ Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering2 = new FontFamilyNumbering(){ Val = 3 };
FontCharSet fontCharSet1 = new FontCharSet(){ Val = 128 };
FontScheme fontScheme2 = new FontScheme(){ Val = FontSchemeValues.Minor };
font2.Append(fontSize2);
font2.Append(fontName2);
font2.Append(fontFamilyNumbering2);
font2.Append(fontCharSet1);
font2.Append(fontScheme2);
fonts1.Append(font1);
fonts1.Append(font2);
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)8U };
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)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyAlignment = true };
Alignment alignment1 = new Alignment(){ Vertical = VerticalAlignmentValues.Center };
cellFormat3.Append(alignment1);
CellFormat cellFormat4 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyAlignment = true };
Alignment alignment2 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center };
cellFormat4.Append(alignment2);
CellFormat cellFormat5 = new CellFormat(){ NumberFormatId = (UInt32Value)14U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyAlignment = true };
Alignment alignment3 = new Alignment(){ Vertical = VerticalAlignmentValues.Center };
cellFormat5.Append(alignment3);
CellFormat cellFormat6 = new CellFormat(){ NumberFormatId = (UInt32Value)164U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyAlignment = true };
Alignment alignment4 = new Alignment(){ Vertical = VerticalAlignmentValues.Center };
cellFormat6.Append(alignment4);
CellFormat cellFormat7 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, PivotButton = true };
CellFormat cellFormat8 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyAlignment = true };
Alignment alignment5 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Left };
cellFormat8.Append(alignment5);
CellFormat cellFormat9 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true };
cellFormats1.Append(cellFormat2);
cellFormats1.Append(cellFormat3);
cellFormats1.Append(cellFormat4);
cellFormats1.Append(cellFormat5);
cellFormats1.Append(cellFormat6);
cellFormats1.Append(cellFormat7);
cellFormats1.Append(cellFormat8);
cellFormats1.Append(cellFormat9);
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)14U };
DifferentialFormat differentialFormat1 = new DifferentialFormat();
Alignment alignment6 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center, TextRotation = (UInt32Value)0U, WrapText = false, Indent = (UInt32Value)0U, JustifyLastLine = false, ShrinkToFit = false, ReadingOrder = (UInt32Value)0U };
differentialFormat1.Append(alignment6);
DifferentialFormat differentialFormat2 = new DifferentialFormat();
NumberingFormat numberingFormat12 = new NumberingFormat(){ NumberFormatId = (UInt32Value)164U, FormatCode = "\"¥\"#,##0" };
differentialFormat2.Append(numberingFormat12);
DifferentialFormat differentialFormat3 = new DifferentialFormat();
Alignment alignment7 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center, TextRotation = (UInt32Value)0U, WrapText = false, Indent = (UInt32Value)0U, JustifyLastLine = false, ShrinkToFit = false, ReadingOrder = (UInt32Value)0U };
differentialFormat3.Append(alignment7);
DifferentialFormat differentialFormat4 = new DifferentialFormat();
NumberingFormat numberingFormat13 = new NumberingFormat(){ NumberFormatId = (UInt32Value)0U, FormatCode = "General" };
differentialFormat4.Append(numberingFormat13);
DifferentialFormat differentialFormat5 = new DifferentialFormat();
NumberingFormat numberingFormat14 = new NumberingFormat(){ NumberFormatId = (UInt32Value)165U, FormatCode = "yyyy/mm/dd" };
differentialFormat5.Append(numberingFormat14);
DifferentialFormat differentialFormat6 = new DifferentialFormat();
NumberingFormat numberingFormat15 = new NumberingFormat(){ NumberFormatId = (UInt32Value)0U, FormatCode = "General" };
differentialFormat6.Append(numberingFormat15);
DifferentialFormat differentialFormat7 = new DifferentialFormat();
NumberingFormat numberingFormat16 = new NumberingFormat(){ NumberFormatId = (UInt32Value)0U, FormatCode = "General" };
differentialFormat7.Append(numberingFormat16);
DifferentialFormat differentialFormat8 = new DifferentialFormat();
NumberingFormat numberingFormat17 = new NumberingFormat(){ NumberFormatId = (UInt32Value)0U, FormatCode = "General" };
differentialFormat8.Append(numberingFormat17);
DifferentialFormat differentialFormat9 = new DifferentialFormat();
NumberingFormat numberingFormat18 = new NumberingFormat(){ NumberFormatId = (UInt32Value)165U, FormatCode = "yyyy/mm/dd" };
differentialFormat9.Append(numberingFormat18);
DifferentialFormat differentialFormat10 = new DifferentialFormat();
Alignment alignment8 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center, TextRotation = (UInt32Value)0U, WrapText = false, Indent = (UInt32Value)0U, JustifyLastLine = false, ShrinkToFit = false, ReadingOrder = (UInt32Value)0U };
differentialFormat10.Append(alignment8);
DifferentialFormat differentialFormat11 = new DifferentialFormat();
NumberingFormat numberingFormat19 = new NumberingFormat(){ NumberFormatId = (UInt32Value)164U, FormatCode = "\"¥\"#,##0" };
differentialFormat11.Append(numberingFormat19);
DifferentialFormat differentialFormat12 = new DifferentialFormat();
Alignment alignment9 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center, TextRotation = (UInt32Value)0U, WrapText = false, Indent = (UInt32Value)0U, JustifyLastLine = false, ShrinkToFit = false, ReadingOrder = (UInt32Value)0U };
differentialFormat12.Append(alignment9);
DifferentialFormat differentialFormat13 = new DifferentialFormat();
NumberingFormat numberingFormat20 = new NumberingFormat(){ NumberFormatId = (UInt32Value)165U, FormatCode = "yyyy/mm/dd" };
differentialFormat13.Append(numberingFormat20);
DifferentialFormat differentialFormat14 = new DifferentialFormat();
NumberingFormat numberingFormat21 = new NumberingFormat(){ NumberFormatId = (UInt32Value)165U, FormatCode = "yyyy/mm/dd" };
differentialFormat14.Append(numberingFormat21);
differentialFormats1.Append(differentialFormat1);
differentialFormats1.Append(differentialFormat2);
differentialFormats1.Append(differentialFormat3);
differentialFormats1.Append(differentialFormat4);
differentialFormats1.Append(differentialFormat5);
differentialFormats1.Append(differentialFormat6);
differentialFormats1.Append(differentialFormat7);
differentialFormats1.Append(differentialFormat8);
differentialFormats1.Append(differentialFormat9);
differentialFormats1.Append(differentialFormat10);
differentialFormats1.Append(differentialFormat11);
differentialFormats1.Append(differentialFormat12);
differentialFormats1.Append(differentialFormat13);
differentialFormats1.Append(differentialFormat14);
TableStyles tableStyles1 = new TableStyles(){ Count = (UInt32Value)0U, DefaultTableStyle = "TableStyleMedium2", DefaultPivotStyle = "PivotStyleLight16" };
StylesheetExtensionList stylesheetExtensionList1 = new StylesheetExtensionList();
StylesheetExtension stylesheetExtension1 = new StylesheetExtension(){ Uri = "{EB79DEF2-80B8-43e5-95BD-54CBDDF9020C}" };
stylesheetExtension1.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.SlicerStyles slicerStyles1 = new X14.SlicerStyles(){ DefaultSlicerStyle = "SlicerStyleLight1" };
stylesheetExtension1.Append(slicerStyles1);
StylesheetExtension stylesheetExtension2 = new StylesheetExtension(){ Uri = "{9260A510-F301-46a8-8635-F512D64BE5F5}" };
stylesheetExtension2.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");
X15.TimelineStyles timelineStyles1 = new X15.TimelineStyles(){ DefaultTimelineStyle = "TimeSlicerStyleLight1" };
stylesheetExtension2.Append(timelineStyles1);
stylesheetExtensionList1.Append(stylesheetExtension1);
stylesheetExtensionList1.Append(stylesheetExtension2);
stylesheet1.Append(numberingFormats1);
stylesheet1.Append(fonts1);
stylesheet1.Append(fills1);
stylesheet1.Append(borders1);
stylesheet1.Append(cellStyleFormats1);
stylesheet1.Append(cellFormats1);
stylesheet1.Append(cellStyles1);
stylesheet1.Append(differentialFormats1);
stylesheet1.Append(tableStyles1);
stylesheet1.Append(stylesheetExtensionList1);
workbookStylesPart1.Stylesheet = stylesheet1;
}
// Generates content of workbookStylesPart1.
private void GenerateWorkbookStylesPart1Content(WorkbookStylesPart workbookStylesPart1)
{
Stylesheet stylesheet1 = new Stylesheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" } };
stylesheet1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
stylesheet1.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
Fonts fonts1 = new Fonts(){ Count = (UInt32Value)2U };
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 };
FontCharSet fontCharSet1 = new FontCharSet(){ Val = 162 };
FontScheme fontScheme2 = new FontScheme(){ Val = FontSchemeValues.Minor };
font1.Append(fontSize1);
font1.Append(color1);
font1.Append(fontName1);
font1.Append(fontFamilyNumbering1);
font1.Append(fontCharSet1);
font1.Append(fontScheme2);
Font font2 = new Font();
FontSize fontSize2 = new FontSize(){ Val = 6D };
FontName fontName2 = new FontName(){ Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering2 = new FontFamilyNumbering(){ Val = 3 };
FontCharSet fontCharSet2 = new FontCharSet(){ Val = 128 };
FontScheme fontScheme3 = new FontScheme(){ Val = FontSchemeValues.Minor };
font2.Append(fontSize2);
font2.Append(fontName2);
font2.Append(fontFamilyNumbering2);
font2.Append(fontCharSet2);
font2.Append(fontScheme3);
fonts1.Append(font1);
fonts1.Append(font2);
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)10U };
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);
Border border2 = new Border();
LeftBorder leftBorder2 = new LeftBorder(){ Style = BorderStyleValues.Thin };
Color color2 = new Color(){ Indexed = (UInt32Value)8U };
leftBorder2.Append(color2);
RightBorder rightBorder2 = new RightBorder();
TopBorder topBorder2 = new TopBorder(){ Style = BorderStyleValues.Thin };
Color color3 = new Color(){ Indexed = (UInt32Value)8U };
topBorder2.Append(color3);
BottomBorder bottomBorder2 = new BottomBorder();
DiagonalBorder diagonalBorder2 = new DiagonalBorder();
border2.Append(leftBorder2);
border2.Append(rightBorder2);
border2.Append(topBorder2);
border2.Append(bottomBorder2);
border2.Append(diagonalBorder2);
Border border3 = new Border();
LeftBorder leftBorder3 = new LeftBorder(){ Style = BorderStyleValues.Thin };
Color color4 = new Color(){ Indexed = (UInt32Value)65U };
leftBorder3.Append(color4);
RightBorder rightBorder3 = new RightBorder();
TopBorder topBorder3 = new TopBorder(){ Style = BorderStyleValues.Thin };
Color color5 = new Color(){ Indexed = (UInt32Value)8U };
topBorder3.Append(color5);
BottomBorder bottomBorder3 = new BottomBorder();
DiagonalBorder diagonalBorder3 = new DiagonalBorder();
border3.Append(leftBorder3);
border3.Append(rightBorder3);
border3.Append(topBorder3);
border3.Append(bottomBorder3);
border3.Append(diagonalBorder3);
Border border4 = new Border();
LeftBorder leftBorder4 = new LeftBorder(){ Style = BorderStyleValues.Thin };
Color color6 = new Color(){ Indexed = (UInt32Value)65U };
leftBorder4.Append(color6);
RightBorder rightBorder4 = new RightBorder(){ Style = BorderStyleValues.Thin };
Color color7 = new Color(){ Indexed = (UInt32Value)8U };
rightBorder4.Append(color7);
TopBorder topBorder4 = new TopBorder(){ Style = BorderStyleValues.Thin };
Color color8 = new Color(){ Indexed = (UInt32Value)8U };
topBorder4.Append(color8);
BottomBorder bottomBorder4 = new BottomBorder();
DiagonalBorder diagonalBorder4 = new DiagonalBorder();
border4.Append(leftBorder4);
border4.Append(rightBorder4);
border4.Append(topBorder4);
border4.Append(bottomBorder4);
border4.Append(diagonalBorder4);
Border border5 = new Border();
LeftBorder leftBorder5 = new LeftBorder(){ Style = BorderStyleValues.Thin };
Color color9 = new Color(){ Indexed = (UInt32Value)8U };
leftBorder5.Append(color9);
RightBorder rightBorder5 = new RightBorder();
TopBorder topBorder5 = new TopBorder(){ Style = BorderStyleValues.Thin };
Color color10 = new Color(){ Indexed = (UInt32Value)65U };
topBorder5.Append(color10);
BottomBorder bottomBorder5 = new BottomBorder();
DiagonalBorder diagonalBorder5 = new DiagonalBorder();
border5.Append(leftBorder5);
border5.Append(rightBorder5);
border5.Append(topBorder5);
border5.Append(bottomBorder5);
border5.Append(diagonalBorder5);
Border border6 = new Border();
LeftBorder leftBorder6 = new LeftBorder(){ Style = BorderStyleValues.Thin };
Color color11 = new Color(){ Indexed = (UInt32Value)65U };
leftBorder6.Append(color11);
RightBorder rightBorder6 = new RightBorder();
TopBorder topBorder6 = new TopBorder(){ Style = BorderStyleValues.Thin };
Color color12 = new Color(){ Indexed = (UInt32Value)65U };
topBorder6.Append(color12);
BottomBorder bottomBorder6 = new BottomBorder();
DiagonalBorder diagonalBorder6 = new DiagonalBorder();
border6.Append(leftBorder6);
border6.Append(rightBorder6);
border6.Append(topBorder6);
border6.Append(bottomBorder6);
border6.Append(diagonalBorder6);
Border border7 = new Border();
LeftBorder leftBorder7 = new LeftBorder(){ Style = BorderStyleValues.Thin };
Color color13 = new Color(){ Indexed = (UInt32Value)65U };
leftBorder7.Append(color13);
RightBorder rightBorder7 = new RightBorder(){ Style = BorderStyleValues.Thin };
Color color14 = new Color(){ Indexed = (UInt32Value)8U };
rightBorder7.Append(color14);
TopBorder topBorder7 = new TopBorder(){ Style = BorderStyleValues.Thin };
Color color15 = new Color(){ Indexed = (UInt32Value)65U };
topBorder7.Append(color15);
BottomBorder bottomBorder7 = new BottomBorder();
DiagonalBorder diagonalBorder7 = new DiagonalBorder();
border7.Append(leftBorder7);
border7.Append(rightBorder7);
border7.Append(topBorder7);
border7.Append(bottomBorder7);
border7.Append(diagonalBorder7);
Border border8 = new Border();
LeftBorder leftBorder8 = new LeftBorder(){ Style = BorderStyleValues.Thin };
Color color16 = new Color(){ Indexed = (UInt32Value)8U };
leftBorder8.Append(color16);
RightBorder rightBorder8 = new RightBorder();
TopBorder topBorder8 = new TopBorder(){ Style = BorderStyleValues.Thin };
Color color17 = new Color(){ Indexed = (UInt32Value)65U };
topBorder8.Append(color17);
BottomBorder bottomBorder8 = new BottomBorder(){ Style = BorderStyleValues.Thin };
Color color18 = new Color(){ Indexed = (UInt32Value)8U };
bottomBorder8.Append(color18);
DiagonalBorder diagonalBorder8 = new DiagonalBorder();
border8.Append(leftBorder8);
border8.Append(rightBorder8);
border8.Append(topBorder8);
border8.Append(bottomBorder8);
border8.Append(diagonalBorder8);
Border border9 = new Border();
LeftBorder leftBorder9 = new LeftBorder(){ Style = BorderStyleValues.Thin };
Color color19 = new Color(){ Indexed = (UInt32Value)65U };
leftBorder9.Append(color19);
RightBorder rightBorder9 = new RightBorder();
TopBorder topBorder9 = new TopBorder(){ Style = BorderStyleValues.Thin };
Color color20 = new Color(){ Indexed = (UInt32Value)65U };
topBorder9.Append(color20);
BottomBorder bottomBorder9 = new BottomBorder(){ Style = BorderStyleValues.Thin };
Color color21 = new Color(){ Indexed = (UInt32Value)8U };
bottomBorder9.Append(color21);
DiagonalBorder diagonalBorder9 = new DiagonalBorder();
border9.Append(leftBorder9);
border9.Append(rightBorder9);
border9.Append(topBorder9);
border9.Append(bottomBorder9);
border9.Append(diagonalBorder9);
Border border10 = new Border();
LeftBorder leftBorder10 = new LeftBorder(){ Style = BorderStyleValues.Thin };
Color color22 = new Color(){ Indexed = (UInt32Value)65U };
leftBorder10.Append(color22);
RightBorder rightBorder10 = new RightBorder(){ Style = BorderStyleValues.Thin };
Color color23 = new Color(){ Indexed = (UInt32Value)8U };
rightBorder10.Append(color23);
TopBorder topBorder10 = new TopBorder(){ Style = BorderStyleValues.Thin };
Color color24 = new Color(){ Indexed = (UInt32Value)65U };
topBorder10.Append(color24);
BottomBorder bottomBorder10 = new BottomBorder(){ Style = BorderStyleValues.Thin };
Color color25 = new Color(){ Indexed = (UInt32Value)8U };
bottomBorder10.Append(color25);
DiagonalBorder diagonalBorder10 = new DiagonalBorder();
border10.Append(leftBorder10);
border10.Append(rightBorder10);
border10.Append(topBorder10);
border10.Append(bottomBorder10);
border10.Append(diagonalBorder10);
borders1.Append(border1);
borders1.Append(border2);
borders1.Append(border3);
borders1.Append(border4);
borders1.Append(border5);
borders1.Append(border6);
borders1.Append(border7);
borders1.Append(border8);
borders1.Append(border9);
borders1.Append(border10);
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)11U };
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 };
CellFormat cellFormat4 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyBorder = true };
CellFormat cellFormat5 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyBorder = true };
CellFormat cellFormat6 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyBorder = true };
CellFormat cellFormat7 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyBorder = true };
CellFormat cellFormat8 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)5U, FormatId = (UInt32Value)0U, ApplyBorder = true };
CellFormat cellFormat9 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)6U, FormatId = (UInt32Value)0U, ApplyBorder = true };
CellFormat cellFormat10 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)7U, FormatId = (UInt32Value)0U, ApplyBorder = true };
CellFormat cellFormat11 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyBorder = true };
CellFormat cellFormat12 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyBorder = true };
cellFormats1.Append(cellFormat2);
cellFormats1.Append(cellFormat3);
cellFormats1.Append(cellFormat4);
cellFormats1.Append(cellFormat5);
cellFormats1.Append(cellFormat6);
cellFormats1.Append(cellFormat7);
cellFormats1.Append(cellFormat8);
cellFormats1.Append(cellFormat9);
cellFormats1.Append(cellFormat10);
cellFormats1.Append(cellFormat11);
cellFormats1.Append(cellFormat12);
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)1U };
DifferentialFormat differentialFormat1 = new DifferentialFormat();
NumberingFormat numberingFormat1 = new NumberingFormat(){ NumberFormatId = (UInt32Value)164U, FormatCode = "dd/mm/yyyy" };
differentialFormat1.Append(numberingFormat1);
differentialFormats1.Append(differentialFormat1);
TableStyles tableStyles1 = new TableStyles(){ Count = (UInt32Value)0U, DefaultTableStyle = "TableStyleMedium2", DefaultPivotStyle = "PivotStyleLight16" };
StylesheetExtensionList stylesheetExtensionList1 = new StylesheetExtensionList();
StylesheetExtension stylesheetExtension1 = new StylesheetExtension(){ Uri = "{EB79DEF2-80B8-43e5-95BD-54CBDDF9020C}" };
stylesheetExtension1.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.SlicerStyles slicerStyles1 = new X14.SlicerStyles(){ DefaultSlicerStyle = "SlicerStyleLight1" };
stylesheetExtension1.Append(slicerStyles1);
StylesheetExtension stylesheetExtension2 = new StylesheetExtension(){ Uri = "{9260A510-F301-46a8-8635-F512D64BE5F5}" };
stylesheetExtension2.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");
X15.TimelineStyles timelineStyles1 = new X15.TimelineStyles(){ DefaultTimelineStyle = "TimeSlicerStyleLight1" };
stylesheetExtension2.Append(timelineStyles1);
stylesheetExtensionList1.Append(stylesheetExtension1);
stylesheetExtensionList1.Append(stylesheetExtension2);
stylesheet1.Append(fonts1);
stylesheet1.Append(fills1);
stylesheet1.Append(borders1);
stylesheet1.Append(cellStyleFormats1);
stylesheet1.Append(cellFormats1);
stylesheet1.Append(cellStyles1);
stylesheet1.Append(differentialFormats1);
stylesheet1.Append(tableStyles1);
stylesheet1.Append(stylesheetExtensionList1);
workbookStylesPart1.Stylesheet = stylesheet1;
}
public LogFont(string faceName, FontCharSet charSet) : this()
{
CharSet = charSet;
FaceName = faceName;
PitchAndFamily = FontPitchAndFamily.PitchDefault;
}
public SpreadsheetStylesManager(WorkbookPart workbookPart)
{
_workbookPart = workbookPart;
_styles = new Dictionary <string, int>();
_fonts = new Dictionary <FontKey, int>();
_fills = new Dictionary <System.Drawing.Color, int>();
var stylesPart = _workbookPart.AddNewPart <WorkbookStylesPart>();
_stylesheet = new Stylesheet();
stylesPart.Stylesheet = _stylesheet;
_stylesheet.Fills = new Fills();
_stylesheet.Fills.AppendChild(new Fill {
PatternFill = new PatternFill {
PatternType = PatternValues.None
}
}); // required, reserved by Excel
_stylesheet.Fills.AppendChild(new Fill {
PatternFill = new PatternFill {
PatternType = PatternValues.Gray125
}
}); // required, reserved by Excel
_stylesheet.Fills.Count = 2;
stylesPart.Stylesheet.Fonts = new Fonts();
stylesPart.Stylesheet.Fonts.Count = 2;
stylesPart.Stylesheet.Fonts.AppendChild(new Font());
Font hyperLinkFont = new Font();
Underline underline1 = new Underline();
FontSize fontSize2 = new FontSize()
{
Val = 11D
};
Color color2 = new Color()
{
Theme = (UInt32Value)10U
};
FontName fontName2 = new FontName()
{
Val = "Calibri"
};
FontFamilyNumbering fontFamilyNumbering2 = new FontFamilyNumbering()
{
Val = 2
};
FontCharSet fontCharSet2 = new FontCharSet()
{
Val = 238
};
FontScheme fontScheme2 = new FontScheme()
{
Val = FontSchemeValues.Minor
};
hyperLinkFont.Append(underline1);
hyperLinkFont.Append(fontSize2);
hyperLinkFont.Append(color2);
hyperLinkFont.Append(fontName2);
hyperLinkFont.Append(fontFamilyNumbering2);
hyperLinkFont.Append(fontCharSet2);
hyperLinkFont.Append(fontScheme2);
stylesPart.Stylesheet.Fonts.AppendChild(hyperLinkFont);
stylesPart.Stylesheet.Borders = new Borders();
stylesPart.Stylesheet.Borders.Count = 1;
stylesPart.Stylesheet.Borders.AppendChild(new Border());
stylesPart.Stylesheet.CellStyleFormats = new CellStyleFormats();
stylesPart.Stylesheet.CellStyleFormats.Count = 2;
stylesPart.Stylesheet.CellStyleFormats.AppendChild(new CellFormat());
stylesPart.Stylesheet.CellFormats = new CellFormats();
// empty one for index 0, seems to be required
stylesPart.Stylesheet.CellFormats.AppendChild(new CellFormat());
CellFormat hyperLinkFormt = new CellFormat()
{
NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, ApplyNumberFormat = false, ApplyFill = false, ApplyBorder = false, ApplyAlignment = false, ApplyProtection = false
};
stylesPart.Stylesheet.CellFormats.AppendChild(hyperLinkFormt);
stylesPart.Stylesheet.CellFormats.Count = 2;
_hyperlinkStyles[new SpreadsheetStyle().GetIdentifier()] = 1;
Borders borders = new Borders()
{
Count = (UInt32Value)1U
};
Border border = new Border();
LeftBorder leftBorder = new LeftBorder();
RightBorder rightBorder = new RightBorder();
TopBorder topBorder = new TopBorder();
BottomBorder bottomBorder = new BottomBorder();
DiagonalBorder diagonalBorder = new DiagonalBorder();
border.AppendChild(leftBorder);
border.AppendChild(rightBorder);
border.AppendChild(topBorder);
border.AppendChild(bottomBorder);
border.AppendChild(diagonalBorder);
borders.AppendChild(border);
_stylesheet.Borders = borders;
CellStyles cellStyles = new CellStyles()
{
Count = (UInt32Value)1U
};
CellStyle cellStyle = new CellStyle()
{
Name = "Normal", FormatId = (UInt32Value)0U, BuiltinId = (UInt32Value)0U
};
cellStyles.AppendChild(cellStyle);
_stylesheet.CellStyles = cellStyles;
var dateTimeFormatInfo = DateTimeFormatInfo.CurrentInfo;
var dateTimeFormat = "d.mm.yyyy hh:mm:ss";
if (dateTimeFormatInfo != null)
{
dateTimeFormat = dateTimeFormatInfo.ShortDatePattern + " " + dateTimeFormatInfo.LongTimePattern;
dateTimeFormat = dateTimeFormat.Replace("/", "\\/");
dateTimeFormat = dateTimeFormat.Replace("tt", "AM/PM");
}
NumberingFormats numberingFormats = new NumberingFormats()
{
Count = (UInt32Value)1U
};
NumberingFormat numberingFormat1 = new NumberingFormat()
{
NumberFormatId = (UInt32Value)164U, FormatCode = dateTimeFormat
};
numberingFormats.Append(numberingFormat1);
_stylesheet.NumberingFormats = numberingFormats;
}
// Generates content of workbookStylesPart1.
private void GenerateWorkbookStylesPart1Content(WorkbookStylesPart workbookStylesPart1)
{
Stylesheet stylesheet1 = new Stylesheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" } };
stylesheet1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
stylesheet1.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
Fonts fonts1 = new Fonts(){ Count = (UInt32Value)2U };
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 };
FontCharSet fontCharSet1 = new FontCharSet(){ Val = 128 };
FontScheme fontScheme1 = new FontScheme(){ Val = FontSchemeValues.Minor };
font1.Append(fontSize1);
font1.Append(color1);
font1.Append(fontName1);
font1.Append(fontFamilyNumbering1);
font1.Append(fontCharSet1);
font1.Append(fontScheme1);
Font font2 = new Font();
FontSize fontSize2 = new FontSize(){ Val = 6D };
FontName fontName2 = new FontName(){ Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering2 = new FontFamilyNumbering(){ Val = 2 };
FontCharSet fontCharSet2 = new FontCharSet(){ Val = 128 };
FontScheme fontScheme2 = new FontScheme(){ Val = FontSchemeValues.Minor };
font2.Append(fontSize2);
font2.Append(fontName2);
font2.Append(fontFamilyNumbering2);
font2.Append(fontCharSet2);
font2.Append(fontScheme2);
fonts1.Append(font1);
fonts1.Append(font2);
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 };
Alignment alignment1 = new Alignment(){ Vertical = VerticalAlignmentValues.Center };
cellFormat1.Append(alignment1);
cellStyleFormats1.Append(cellFormat1);
CellFormats cellFormats1 = new CellFormats(){ Count = (UInt32Value)1U };
CellFormat cellFormat2 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U };
Alignment alignment2 = new Alignment(){ Vertical = VerticalAlignmentValues.Center };
cellFormat2.Append(alignment2);
cellFormats1.Append(cellFormat2);
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 = "TableStyleMedium2", DefaultPivotStyle = "PivotStyleLight16" };
StylesheetExtensionList stylesheetExtensionList1 = new StylesheetExtensionList();
StylesheetExtension stylesheetExtension1 = new StylesheetExtension(){ Uri = "{EB79DEF2-80B8-43e5-95BD-54CBDDF9020C}" };
stylesheetExtension1.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.SlicerStyles slicerStyles1 = new X14.SlicerStyles(){ DefaultSlicerStyle = "SlicerStyleLight1" };
stylesheetExtension1.Append(slicerStyles1);
StylesheetExtension stylesheetExtension2 = new StylesheetExtension(){ Uri = "{9260A510-F301-46a8-8635-F512D64BE5F5}" };
stylesheetExtension2.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");
X15.TimelineStyles timelineStyles1 = new X15.TimelineStyles(){ DefaultTimelineStyle = "TimeSlicerStyleLight1" };
stylesheetExtension2.Append(timelineStyles1);
stylesheetExtensionList1.Append(stylesheetExtension1);
stylesheetExtensionList1.Append(stylesheetExtension2);
stylesheet1.Append(fonts1);
stylesheet1.Append(fills1);
stylesheet1.Append(borders1);
stylesheet1.Append(cellStyleFormats1);
stylesheet1.Append(cellFormats1);
stylesheet1.Append(cellStyles1);
stylesheet1.Append(differentialFormats1);
stylesheet1.Append(tableStyles1);
stylesheet1.Append(stylesheetExtensionList1);
workbookStylesPart1.Stylesheet = stylesheet1;
}
// Generates content of fontTablePart1.
private void GenerateFontTablePart1Content(FontTablePart fontTablePart1)
{
Fonts fonts1 = new Fonts();
Font font1 = new Font() { Name = "Times New Roman" };
Panose1Number panose1Number1 = new Panose1Number() { Val = "02020603050405020304" };
FontCharSet fontCharSet1 = new FontCharSet() { Val = "00" };
FontFamily fontFamily1 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch1 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature1 = new FontSignature() { UnicodeSignature0 = "20002A87", UnicodeSignature1 = "80000000", UnicodeSignature2 = "00000008", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font1.Append(panose1Number1);
font1.Append(fontCharSet1);
font1.Append(fontFamily1);
font1.Append(pitch1);
font1.Append(fontSignature1);
Font font2 = new Font() { Name = "Wingdings" };
Panose1Number panose1Number2 = new Panose1Number() { Val = "05000000000000000000" };
FontCharSet fontCharSet2 = new FontCharSet() { Val = "02" };
FontFamily fontFamily2 = new FontFamily() { Val = FontFamilyValues.Auto };
Pitch pitch2 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature2 = new FontSignature() { UnicodeSignature0 = "00000000", UnicodeSignature1 = "10000000", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "80000000", CodePageSignature1 = "00000000" };
font2.Append(panose1Number2);
font2.Append(fontCharSet2);
font2.Append(fontFamily2);
font2.Append(pitch2);
font2.Append(fontSignature2);
Font font3 = new Font() { Name = "MS Mincho" };
AltName altName1 = new AltName() { Val = "ＭＳ 明朝" };
Panose1Number panose1Number3 = new Panose1Number() { Val = "02020609040205080304" };
FontCharSet fontCharSet3 = new FontCharSet() { Val = "80" };
FontFamily fontFamily3 = new FontFamily() { Val = FontFamilyValues.Modern };
Pitch pitch3 = new Pitch() { Val = FontPitchValues.Fixed };
FontSignature fontSignature3 = new FontSignature() { UnicodeSignature0 = "A00002BF", UnicodeSignature1 = "68C7FCFB", UnicodeSignature2 = "00000010", UnicodeSignature3 = "00000000", CodePageSignature0 = "0002009F", CodePageSignature1 = "00000000" };
font3.Append(altName1);
font3.Append(panose1Number3);
font3.Append(fontCharSet3);
font3.Append(fontFamily3);
font3.Append(pitch3);
font3.Append(fontSignature3);
Font font4 = new Font() { Name = "Arial" };
Panose1Number panose1Number4 = new Panose1Number() { Val = "020B0604020202020204" };
FontCharSet fontCharSet4 = new FontCharSet() { Val = "00" };
FontFamily fontFamily4 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch4 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature4 = new FontSignature() { UnicodeSignature0 = "20002A87", UnicodeSignature1 = "80000000", UnicodeSignature2 = "00000008", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font4.Append(panose1Number4);
font4.Append(fontCharSet4);
font4.Append(fontFamily4);
font4.Append(pitch4);
font4.Append(fontSignature4);
Font font5 = new Font() { Name = "Tahoma" };
Panose1Number panose1Number5 = new Panose1Number() { Val = "020B0604030504040204" };
FontCharSet fontCharSet5 = new FontCharSet() { Val = "00" };
FontFamily fontFamily5 = new FontFamily() { Val = FontFamilyValues.Swiss };
NotTrueType notTrueType1 = new NotTrueType();
Pitch pitch5 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature5 = new FontSignature() { UnicodeSignature0 = "00000003", UnicodeSignature1 = "00000000", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "00000001", CodePageSignature1 = "00000000" };
font5.Append(panose1Number5);
font5.Append(fontCharSet5);
font5.Append(fontFamily5);
font5.Append(notTrueType1);
font5.Append(pitch5);
font5.Append(fontSignature5);
Font font6 = new Font() { Name = "Arial Unicode MS" };
Panose1Number panose1Number6 = new Panose1Number() { Val = "020B0604020202020204" };
FontCharSet fontCharSet6 = new FontCharSet() { Val = "00" };
FontFamily fontFamily6 = new FontFamily() { Val = FontFamilyValues.Roman };
NotTrueType notTrueType2 = new NotTrueType();
Pitch pitch6 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature6 = new FontSignature() { UnicodeSignature0 = "00000003", UnicodeSignature1 = "00000000", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "00000001", CodePageSignature1 = "00000000" };
font6.Append(panose1Number6);
font6.Append(fontCharSet6);
font6.Append(fontFamily6);
font6.Append(notTrueType2);
font6.Append(pitch6);
font6.Append(fontSignature6);
Font font7 = new Font() { Name = "Cambria" };
Panose1Number panose1Number7 = new Panose1Number() { Val = "02040503050406030204" };
FontCharSet fontCharSet7 = new FontCharSet() { Val = "00" };
FontFamily fontFamily7 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch7 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature7 = new FontSignature() { UnicodeSignature0 = "A00002EF", UnicodeSignature1 = "4000004B", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000009F", CodePageSignature1 = "00000000" };
font7.Append(panose1Number7);
font7.Append(fontCharSet7);
font7.Append(fontFamily7);
font7.Append(pitch7);
font7.Append(fontSignature7);
Font font8 = new Font() { Name = "Calibri" };
Panose1Number panose1Number8 = new Panose1Number() { Val = "020F0502020204030204" };
FontCharSet fontCharSet8 = new FontCharSet() { Val = "00" };
FontFamily fontFamily8 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch8 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature8 = new FontSignature() { UnicodeSignature0 = "A00002EF", UnicodeSignature1 = "4000207B", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000009F", CodePageSignature1 = "00000000" };
font8.Append(panose1Number8);
font8.Append(fontCharSet8);
font8.Append(fontFamily8);
font8.Append(pitch8);
font8.Append(fontSignature8);
fonts1.Append(font1);
fonts1.Append(font2);
fonts1.Append(font3);
fonts1.Append(font4);
fonts1.Append(font5);
fonts1.Append(font6);
fonts1.Append(font7);
fonts1.Append(font8);
fontTablePart1.Fonts = fonts1;
}
public static Fonts GenerateFonts()
{
Fonts fonts1 = new Fonts()
{
Count = (UInt32Value)1U, KnownFonts = true
};
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
};
FontCharSet fontCharSet1 = new FontCharSet()
{
Val = 204
};
FontScheme fontScheme1 = new FontScheme()
{
Val = FontSchemeValues.Minor
};
font1.Append(fontSize1);
font1.Append(color1);
font1.Append(fontName1);
font1.Append(fontFamilyNumbering1);
font1.Append(fontCharSet1);
font1.Append(fontScheme1);
fonts1.Append(font1);
return(fonts1);
/*
* Fonts fonts1 = new Fonts() { Count = (UInt32Value)1U, KnownFonts = true };
*
* Font font1 = new Font();
* FontSize fontSize1 = new FontSize() { Val = 10D };
* Color color1 = new Color() { Theme = (UInt32Value)1U };
* FontName fontName1 = new FontName() { Val = "Times New Roman" };
* //FontName fontName1 = new FontName() { Val = "Calibri" };
* FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering() { Val = 1 };
* FontCharSet fontCharSet1 = new FontCharSet() { Val = 204 };
* //FontScheme fontScheme1 = new FontScheme() { Val = FontSchemeValues.Minor };
*
* font1.Append(fontSize1);
* font1.Append(color1);
* font1.Append(fontName1);
* font1.Append(fontFamilyNumbering1);
* font1.Append(fontCharSet1);
* //font1.Append(fontScheme1);
*
* fonts1.Append(font1);
* return fonts1;*/
}
// Generates content of fontTablePart1.
private void GenerateFontTablePart1Content(FontTablePart fontTablePart1)
{
Fonts fonts1 = new Fonts() { MCAttributes = new MarkupCompatibilityAttributes() { Ignorable = "w14 w15 w16se" } };
fonts1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
fonts1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
fonts1.AddNamespaceDeclaration("w", "http://schemas.openxmlformats.org/wordprocessingml/2006/main");
fonts1.AddNamespaceDeclaration("w14", "http://schemas.microsoft.com/office/word/2010/wordml");
fonts1.AddNamespaceDeclaration("w15", "http://schemas.microsoft.com/office/word/2012/wordml");
fonts1.AddNamespaceDeclaration("w16se", "http://schemas.microsoft.com/office/word/2015/wordml/symex");
Font font1 = new Font() { Name = "Symbol" };
Panose1Number panose1Number1 = new Panose1Number() { Val = "05050102010706020507" };
FontCharSet fontCharSet1 = new FontCharSet() { Val = "02" };
FontFamily fontFamily1 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch1 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature1 = new FontSignature() { UnicodeSignature0 = "00000000", UnicodeSignature1 = "10000000", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "80000000", CodePageSignature1 = "00000000" };
font1.Append(panose1Number1);
font1.Append(fontCharSet1);
font1.Append(fontFamily1);
font1.Append(pitch1);
font1.Append(fontSignature1);
Font font2 = new Font() { Name = "Times New Roman" };
Panose1Number panose1Number2 = new Panose1Number() { Val = "02020603050405020304" };
FontCharSet fontCharSet2 = new FontCharSet() { Val = "00" };
FontFamily fontFamily2 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch2 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature2 = new FontSignature() { UnicodeSignature0 = "E0002EFF", UnicodeSignature1 = "C000784B", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font2.Append(panose1Number2);
font2.Append(fontCharSet2);
font2.Append(fontFamily2);
font2.Append(pitch2);
font2.Append(fontSignature2);
Font font3 = new Font() { Name = "Courier New" };
Panose1Number panose1Number3 = new Panose1Number() { Val = "02070309020205020404" };
FontCharSet fontCharSet3 = new FontCharSet() { Val = "00" };
FontFamily fontFamily3 = new FontFamily() { Val = FontFamilyValues.Modern };
Pitch pitch3 = new Pitch() { Val = FontPitchValues.Fixed };
FontSignature fontSignature3 = new FontSignature() { UnicodeSignature0 = "E0002EFF", UnicodeSignature1 = "C0007843", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font3.Append(panose1Number3);
font3.Append(fontCharSet3);
font3.Append(fontFamily3);
font3.Append(pitch3);
font3.Append(fontSignature3);
Font font4 = new Font() { Name = "Wingdings" };
Panose1Number panose1Number4 = new Panose1Number() { Val = "05000000000000000000" };
FontCharSet fontCharSet4 = new FontCharSet() { Val = "02" };
FontFamily fontFamily4 = new FontFamily() { Val = FontFamilyValues.Auto };
Pitch pitch4 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature4 = new FontSignature() { UnicodeSignature0 = "00000000", UnicodeSignature1 = "10000000", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "80000000", CodePageSignature1 = "00000000" };
font4.Append(panose1Number4);
font4.Append(fontCharSet4);
font4.Append(fontFamily4);
font4.Append(pitch4);
font4.Append(fontSignature4);
Font font5 = new Font() { Name = "Calibri" };
Panose1Number panose1Number5 = new Panose1Number() { Val = "020F0502020204030204" };
FontCharSet fontCharSet5 = new FontCharSet() { Val = "00" };
FontFamily fontFamily5 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch5 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature5 = new FontSignature() { UnicodeSignature0 = "E0002AFF", UnicodeSignature1 = "C000247B", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font5.Append(panose1Number5);
font5.Append(fontCharSet5);
font5.Append(fontFamily5);
font5.Append(pitch5);
font5.Append(fontSignature5);
Font font6 = new Font() { Name = "Arial" };
Panose1Number panose1Number6 = new Panose1Number() { Val = "020B0604020202020204" };
FontCharSet fontCharSet6 = new FontCharSet() { Val = "00" };
FontFamily fontFamily6 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch6 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature6 = new FontSignature() { UnicodeSignature0 = "E0002EFF", UnicodeSignature1 = "C0007843", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font6.Append(panose1Number6);
font6.Append(fontCharSet6);
font6.Append(fontFamily6);
font6.Append(pitch6);
font6.Append(fontSignature6);
Font font7 = new Font() { Name = "Cambria" };
Panose1Number panose1Number7 = new Panose1Number() { Val = "02040503050406030204" };
FontCharSet fontCharSet7 = new FontCharSet() { Val = "00" };
FontFamily fontFamily7 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch7 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature7 = new FontSignature() { UnicodeSignature0 = "E00002FF", UnicodeSignature1 = "400004FF", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000019F", CodePageSignature1 = "00000000" };
font7.Append(panose1Number7);
font7.Append(fontCharSet7);
font7.Append(fontFamily7);
font7.Append(pitch7);
font7.Append(fontSignature7);
Font font8 = new Font() { Name = "Verdana" };
Panose1Number panose1Number8 = new Panose1Number() { Val = "020B0604030504040204" };
FontCharSet fontCharSet8 = new FontCharSet() { Val = "00" };
FontFamily fontFamily8 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch8 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature8 = new FontSignature() { UnicodeSignature0 = "A10006FF", UnicodeSignature1 = "4000205B", UnicodeSignature2 = "00000010", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000019F", CodePageSignature1 = "00000000" };
font8.Append(panose1Number8);
font8.Append(fontCharSet8);
font8.Append(fontFamily8);
font8.Append(pitch8);
font8.Append(fontSignature8);
Font font9 = new Font() { Name = "Tahoma" };
Panose1Number panose1Number9 = new Panose1Number() { Val = "020B0604030504040204" };
FontCharSet fontCharSet9 = new FontCharSet() { Val = "00" };
FontFamily fontFamily9 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch9 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature9 = new FontSignature() { UnicodeSignature0 = "E1002EFF", UnicodeSignature1 = "C000605B", UnicodeSignature2 = "00000029", UnicodeSignature3 = "00000000", CodePageSignature0 = "000101FF", CodePageSignature1 = "00000000" };
font9.Append(panose1Number9);
font9.Append(fontCharSet9);
font9.Append(fontFamily9);
font9.Append(pitch9);
font9.Append(fontSignature9);
Font font10 = new Font() { Name = "Arial Black" };
Panose1Number panose1Number10 = new Panose1Number() { Val = "020B0A04020102020204" };
FontCharSet fontCharSet10 = new FontCharSet() { Val = "00" };
FontFamily fontFamily10 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch10 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature10 = new FontSignature() { UnicodeSignature0 = "A00002AF", UnicodeSignature1 = "400078FB", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000009F", CodePageSignature1 = "00000000" };
font10.Append(panose1Number10);
font10.Append(fontCharSet10);
font10.Append(fontFamily10);
font10.Append(pitch10);
font10.Append(fontSignature10);
Font font11 = new Font() { Name = "MS Gothic" };
AltName altName1 = new AltName() { Val = "ＭＳ ゴシック" };
Panose1Number panose1Number11 = new Panose1Number() { Val = "020B0609070205080204" };
FontCharSet fontCharSet11 = new FontCharSet() { Val = "80" };
FontFamily fontFamily11 = new FontFamily() { Val = FontFamilyValues.Modern };
Pitch pitch11 = new Pitch() { Val = FontPitchValues.Fixed };
FontSignature fontSignature11 = new FontSignature() { UnicodeSignature0 = "E00002FF", UnicodeSignature1 = "6AC7FDFB", UnicodeSignature2 = "08000012", UnicodeSignature3 = "00000000", CodePageSignature0 = "0002009F", CodePageSignature1 = "00000000" };
font11.Append(altName1);
font11.Append(panose1Number11);
font11.Append(fontCharSet11);
font11.Append(fontFamily11);
font11.Append(pitch11);
font11.Append(fontSignature11);
Font font12 = new Font() { Name = "MS Mincho" };
AltName altName2 = new AltName() { Val = "Yu Gothic UI" };
Panose1Number panose1Number12 = new Panose1Number() { Val = "02020609040205080304" };
FontCharSet fontCharSet12 = new FontCharSet() { Val = "80" };
FontFamily fontFamily12 = new FontFamily() { Val = FontFamilyValues.Modern };
Pitch pitch12 = new Pitch() { Val = FontPitchValues.Fixed };
FontSignature fontSignature12 = new FontSignature() { UnicodeSignature0 = "E00002FF", UnicodeSignature1 = "6AC7FDFB", UnicodeSignature2 = "00000012", UnicodeSignature3 = "00000000", CodePageSignature0 = "0002009F", CodePageSignature1 = "00000000" };
font12.Append(altName2);
font12.Append(panose1Number12);
font12.Append(fontCharSet12);
font12.Append(fontFamily12);
font12.Append(pitch12);
font12.Append(fontSignature12);
Font font13 = new Font() { Name = "Segoe UI" };
Panose1Number panose1Number13 = new Panose1Number() { Val = "020B0502040204020203" };
FontCharSet fontCharSet13 = new FontCharSet() { Val = "00" };
FontFamily fontFamily13 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch13 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature13 = new FontSignature() { UnicodeSignature0 = "E4002EFF", UnicodeSignature1 = "C000E47F", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font13.Append(panose1Number13);
font13.Append(fontCharSet13);
font13.Append(fontFamily13);
font13.Append(pitch13);
font13.Append(fontSignature13);
fonts1.Append(font1);
fonts1.Append(font2);
fonts1.Append(font3);
fonts1.Append(font4);
fonts1.Append(font5);
fonts1.Append(font6);
fonts1.Append(font7);
fonts1.Append(font8);
fonts1.Append(font9);
fonts1.Append(font10);
fonts1.Append(font11);
fonts1.Append(font12);
fonts1.Append(font13);
fontTablePart1.Fonts = fonts1;
}
// Generates content of fontTablePart1.
private void GenerateFontTablePart1Content(FontTablePart fontTablePart1)
{
Fonts fonts1 = new Fonts();
fonts1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
fonts1.AddNamespaceDeclaration("w", "http://schemas.openxmlformats.org/wordprocessingml/2006/main");
Font font1 = new Font() { Name = "Calibri" };
Panose1Number panose1Number1 = new Panose1Number() { Val = "020F0502020204030204" };
FontCharSet fontCharSet1 = new FontCharSet() { Val = "00" };
FontFamily fontFamily1 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch1 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature1 = new FontSignature() { UnicodeSignature0 = "A00002EF", UnicodeSignature1 = "4000207B", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000009F", CodePageSignature1 = "00000000" };
font1.Append(panose1Number1);
font1.Append(fontCharSet1);
font1.Append(fontFamily1);
font1.Append(pitch1);
font1.Append(fontSignature1);
Font font2 = new Font() { Name = "Times New Roman" };
Panose1Number panose1Number2 = new Panose1Number() { Val = "02020603050405020304" };
FontCharSet fontCharSet2 = new FontCharSet() { Val = "00" };
FontFamily fontFamily2 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch2 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature2 = new FontSignature() { UnicodeSignature0 = "E0002AEF", UnicodeSignature1 = "C0007841", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font2.Append(panose1Number2);
font2.Append(fontCharSet2);
font2.Append(fontFamily2);
font2.Append(pitch2);
font2.Append(fontSignature2);
Font font3 = new Font() { Name = "Tahoma" };
Panose1Number panose1Number3 = new Panose1Number() { Val = "020B0604030504040204" };
FontCharSet fontCharSet3 = new FontCharSet() { Val = "00" };
FontFamily fontFamily3 = new FontFamily() { Val = FontFamilyValues.Swiss };
NotTrueType notTrueType1 = new NotTrueType();
Pitch pitch3 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature3 = new FontSignature() { UnicodeSignature0 = "00000003", UnicodeSignature1 = "00000000", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "00000001", CodePageSignature1 = "00000000" };
font3.Append(panose1Number3);
font3.Append(fontCharSet3);
font3.Append(fontFamily3);
font3.Append(notTrueType1);
font3.Append(pitch3);
font3.Append(fontSignature3);
Font font4 = new Font() { Name = "Cambria" };
Panose1Number panose1Number4 = new Panose1Number() { Val = "02040503050406030204" };
FontCharSet fontCharSet4 = new FontCharSet() { Val = "00" };
FontFamily fontFamily4 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch4 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature4 = new FontSignature() { UnicodeSignature0 = "A00002EF", UnicodeSignature1 = "4000004B", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000009F", CodePageSignature1 = "00000000" };
font4.Append(panose1Number4);
font4.Append(fontCharSet4);
font4.Append(fontFamily4);
font4.Append(pitch4);
font4.Append(fontSignature4);
fonts1.Append(font1);
fonts1.Append(font2);
fonts1.Append(font3);
fonts1.Append(font4);
fontTablePart1.Fonts = fonts1;
}
public override int GetHashCode()
{
unchecked
{
int hash = 17;
hash = hash * 23 + Name.GetHashCode();
if (Size != null)
{
hash = hash * 23 + Size.GetHashCode();
}
if (FontFamily != null)
{
hash = hash * 23 + FontFamily.GetHashCode();
}
if (VerticalTextAlignment != null)
{
hash = hash * 23 + VerticalTextAlignment.GetHashCode();
}
if (Underline != null)
{
hash = hash * 23 + Underline.GetHashCode();
}
if (Shadow != null)
{
hash = hash * 23 + Shadow.GetHashCode();
}
if (Extend != null)
{
hash = hash * 23 + Extend.GetHashCode();
}
if (FontCharSet != null)
{
hash = hash * 23 + FontCharSet.GetHashCode();
}
if (Condense != null)
{
hash = hash * 23 + Condense.GetHashCode();
}
if (Strike != null)
{
hash = hash * 23 + Strike.GetHashCode();
}
if (Italic != null)
{
hash = hash * 23 + Italic.GetHashCode();
}
if (Bold != null)
{
hash = hash * 23 + Bold.GetHashCode();
}
if (Color != null)
{
hash = hash * 23 + Color.GetHashCode();
}
if (FontScheme != null)
{
hash = hash * 23 + FontScheme.GetHashCode();
}
return(hash);
}
}
// Generates content of fontTablePart2.
private void GenerateFontTablePart2Content(FontTablePart fontTablePart2)
{
Fonts fonts2 = new Fonts();
fonts2.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
fonts2.AddNamespaceDeclaration("w", "http://schemas.openxmlformats.org/wordprocessingml/2006/main");
Font font5 = new Font() { Name = "Calibri" };
Panose1Number panose1Number5 = new Panose1Number() { Val = "020F0502020204030204" };
FontCharSet fontCharSet5 = new FontCharSet() { Val = "00" };
FontFamily fontFamily5 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch5 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature5 = new FontSignature() { UnicodeSignature0 = "A00002EF", UnicodeSignature1 = "4000207B", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000009F", CodePageSignature1 = "00000000" };
font5.Append(panose1Number5);
font5.Append(fontCharSet5);
font5.Append(fontFamily5);
font5.Append(pitch5);
font5.Append(fontSignature5);
Font font6 = new Font() { Name = "Times New Roman" };
Panose1Number panose1Number6 = new Panose1Number() { Val = "02020603050405020304" };
FontCharSet fontCharSet6 = new FontCharSet() { Val = "00" };
FontFamily fontFamily6 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch6 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature6 = new FontSignature() { UnicodeSignature0 = "E0002AEF", UnicodeSignature1 = "C0007841", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font6.Append(panose1Number6);
font6.Append(fontCharSet6);
font6.Append(fontFamily6);
font6.Append(pitch6);
font6.Append(fontSignature6);
Font font7 = new Font() { Name = "Tahoma" };
Panose1Number panose1Number7 = new Panose1Number() { Val = "020B0604030504040204" };
FontCharSet fontCharSet7 = new FontCharSet() { Val = "00" };
FontFamily fontFamily7 = new FontFamily() { Val = FontFamilyValues.Swiss };
NotTrueType notTrueType2 = new NotTrueType();
Pitch pitch7 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature7 = new FontSignature() { UnicodeSignature0 = "00000003", UnicodeSignature1 = "00000000", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "00000001", CodePageSignature1 = "00000000" };
font7.Append(panose1Number7);
font7.Append(fontCharSet7);
font7.Append(fontFamily7);
font7.Append(notTrueType2);
font7.Append(pitch7);
font7.Append(fontSignature7);
Font font8 = new Font() { Name = "Cambria" };
Panose1Number panose1Number8 = new Panose1Number() { Val = "02040503050406030204" };
FontCharSet fontCharSet8 = new FontCharSet() { Val = "00" };
FontFamily fontFamily8 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch8 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature8 = new FontSignature() { UnicodeSignature0 = "A00002EF", UnicodeSignature1 = "4000004B", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000009F", CodePageSignature1 = "00000000" };
font8.Append(panose1Number8);
font8.Append(fontCharSet8);
font8.Append(fontFamily8);
font8.Append(pitch8);
font8.Append(fontSignature8);
fonts2.Append(font5);
fonts2.Append(font6);
fonts2.Append(font7);
fonts2.Append(font8);
fontTablePart2.Fonts = fonts2;
}
// Generates content of fontTablePart1.
private void GenerateFontTablePart1Content(FontTablePart fontTablePart1)
{
Fonts fonts1 = new Fonts() { MCAttributes = new MarkupCompatibilityAttributes() { Ignorable = "w14 w15" } };
fonts1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
fonts1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
fonts1.AddNamespaceDeclaration("w", "http://schemas.openxmlformats.org/wordprocessingml/2006/main");
fonts1.AddNamespaceDeclaration("w14", "http://schemas.microsoft.com/office/word/2010/wordml");
fonts1.AddNamespaceDeclaration("w15", "http://schemas.microsoft.com/office/word/2012/wordml");
Font font1 = new Font() { Name = "Calibri" };
Panose1Number panose1Number1 = new Panose1Number() { Val = "020F0502020204030204" };
FontCharSet fontCharSet1 = new FontCharSet() { Val = "00" };
FontFamily fontFamily1 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch1 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature1 = new FontSignature() { UnicodeSignature0 = "E00002FF", UnicodeSignature1 = "4000ACFF", UnicodeSignature2 = "00000001", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000019F", CodePageSignature1 = "00000000" };
font1.Append(panose1Number1);
font1.Append(fontCharSet1);
font1.Append(fontFamily1);
font1.Append(pitch1);
font1.Append(fontSignature1);
Font font2 = new Font() { Name = "Times New Roman" };
Panose1Number panose1Number2 = new Panose1Number() { Val = "02020603050405020304" };
FontCharSet fontCharSet2 = new FontCharSet() { Val = "00" };
FontFamily fontFamily2 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch2 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature2 = new FontSignature() { UnicodeSignature0 = "E0002EFF", UnicodeSignature1 = "C0007843", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font2.Append(panose1Number2);
font2.Append(fontCharSet2);
font2.Append(fontFamily2);
font2.Append(pitch2);
font2.Append(fontSignature2);
Font font3 = new Font() { Name = "Arial" };
Panose1Number panose1Number3 = new Panose1Number() { Val = "020B0604020202020204" };
FontCharSet fontCharSet3 = new FontCharSet() { Val = "00" };
FontFamily fontFamily3 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch3 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature3 = new FontSignature() { UnicodeSignature0 = "E0002EFF", UnicodeSignature1 = "C0007843", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font3.Append(panose1Number3);
font3.Append(fontCharSet3);
font3.Append(fontFamily3);
font3.Append(pitch3);
font3.Append(fontSignature3);
Font font4 = new Font() { Name = "Calibri Light" };
Panose1Number panose1Number4 = new Panose1Number() { Val = "020F0302020204030204" };
FontCharSet fontCharSet4 = new FontCharSet() { Val = "00" };
FontFamily fontFamily4 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch4 = new Pitch() { Val = FontPitchValues.Variable };
FontSignature fontSignature4 = new FontSignature() { UnicodeSignature0 = "A00002EF", UnicodeSignature1 = "4000207B", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000019F", CodePageSignature1 = "00000000" };
font4.Append(panose1Number4);
font4.Append(fontCharSet4);
font4.Append(fontFamily4);
font4.Append(pitch4);
font4.Append(fontSignature4);
fonts1.Append(font1);
fonts1.Append(font2);
fonts1.Append(font3);
fonts1.Append(font4);
fontTablePart1.Fonts = fonts1;
}
public static extern IntPtr CreateFont(int h, int w, int e, int o, FontWeight weight,
bool italic, bool underline, bool strikeout,
FontCharSet charset, FontPrecision outPrecision, FontClipPrecision clipPrecision,
FontQuality quality, FontPitchAndFamily pitchAFam, string face);
/// <summary>
/// Renders the <see cref="Duality.Resources.Font"/> using the specified system font family.
/// </summary>
private RenderedFontData RenderGlyphs(FontFamily fontFamily, float emSize, FontStyle style, FontCharSet extendedSet, bool antialiasing, bool monospace)
{
// Determine System.Drawing font style
SysDrawFontStyle systemStyle = SysDrawFontStyle.Regular;
if (style.HasFlag(FontStyle.Bold))
{
systemStyle |= SysDrawFontStyle.Bold;
}
if (style.HasFlag(FontStyle.Italic))
{
systemStyle |= SysDrawFontStyle.Italic;
}
// Create a System.Drawing font
SysDrawFont internalFont = null;
if (fontFamily != null)
{
try { internalFont = new SysDrawFont(fontFamily, emSize, systemStyle); }
catch (Exception e)
{
Log.Editor.WriteError(
"Failed to create System Font '{1} {2}, {3}' for rendering Duality Font glyphs: {0}",
Log.Exception(e),
fontFamily.Name,
emSize,
style);
}
}
// If creating the font failed, fall back to a default one
if (internalFont == null)
{
internalFont = new SysDrawFont(FontFamily.GenericMonospace, emSize, systemStyle);
}
// Render the font's glyphs
using (internalFont)
{
return(this.RenderGlyphs(
internalFont,
FontCharSet.Default.MergedWith(extendedSet),
antialiasing,
monospace));
}
}
/// <summary>
/// Создает стилевую составляющую документа
/// </summary>
/// <param name="workbookStylesPart">Стилевая часть книги</param>
private void GenerateStyles(WorkbookStylesPart workbookStylesPart)
{
Stylesheet stylesheet = new Stylesheet()
{
MCAttributes = new MarkupCompatibilityAttributes()
{
Ignorable = "x14ac"
}
};
stylesheet.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
stylesheet.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
#region Fonts
Fonts fonts = new Fonts()
{
Count = 1U,
KnownFonts = true
};
Font font = new Font();
FontSize fontSize = new FontSize()
{
Val = 11D
};
Color color1 = new Color()
{
Theme = 1U
};
FontName fontName = new FontName()
{
Val = "Calibri"
};
FontFamilyNumbering fontFamilyNumbering = new FontFamilyNumbering()
{
Val = 2
};
FontCharSet fontCharSet = new FontCharSet()
{
Val = 204
};
FontScheme fontScheme = new FontScheme()
{
Val = FontSchemeValues.Minor
};
font.Append(fontSize);
font.Append(color1);
font.Append(fontName);
font.Append(fontFamilyNumbering);
font.Append(fontCharSet);
font.Append(fontScheme);
fonts.Append(font);
#endregion
#region Fills
Fills fills = new Fills()
{
Count = 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);
fills.Append(fill1);
fills.Append(fill2);
#endregion
#region Borders
Borders borders = new Borders()
{
Count = 1U
};
Border border1 = new Border();
LeftBorder leftBorder1 = new LeftBorder();
RightBorder rightBorder1 = new RightBorder();
TopBorder topBorder1 = new TopBorder();
BottomBorder bottomBorder = new BottomBorder();
DiagonalBorder diagonalBorder1 = new DiagonalBorder();
border1.Append(leftBorder1);
border1.Append(rightBorder1);
border1.Append(topBorder1);
border1.Append(bottomBorder);
border1.Append(diagonalBorder1);
borders.Append(border1);
#endregion
#region Cell Styles And Formats
CellStyleFormats cellStyleFormats = new CellStyleFormats()
{
Count = 1U
};
CellFormat cellFormat1 = new CellFormat()
{
NumberFormatId = 0U,
FontId = 0U,
FillId = 0U,
BorderId = 0U
};
cellStyleFormats.Append(cellFormat1);
CellFormats cellFormats = new CellFormats()
{
Count = 1U
};
CellFormat cellFormat2 = new CellFormat()
{
NumberFormatId = 0U,
FontId = 0U,
FillId = 0U,
BorderId = 0U,
FormatId = 0U
};
cellFormats.Append(cellFormat2);
CellStyles cellStyles = new CellStyles()
{
Count = 1U
};
CellStyle cellStyle = new CellStyle()
{
Name = "Обычный",
FormatId = 0U,
BuiltinId = 0U
};
cellStyles.Append(cellStyle);
#endregion
DifferentialFormats differentialFormats = new DifferentialFormats()
{
Count = 0U
};
TableStyles tableStyles = new TableStyles()
{
Count = 0U,
DefaultTableStyle = "TableStyleMedium2",
DefaultPivotStyle = "PivotStyleLight16"
};
#region Stylesheet Extensions
StylesheetExtensionList stylesheetExtensionList = new StylesheetExtensionList();
StylesheetExtension stylesheetExtension1 = new StylesheetExtension()
{
Uri = "{EB79DEF2-80B8-43e5-95BD-54CBDDF9020C}"
};
stylesheetExtension1.AddNamespaceDeclaration("x14",
"http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.SlicerStyles slicerStyles = new X14.SlicerStyles()
{
DefaultSlicerStyle = "SlicerStyleLight1"
};
stylesheetExtension1.Append(slicerStyles);
StylesheetExtension stylesheetExtension2 = new StylesheetExtension()
{
Uri = "{9260A510-F301-46a8-8635-F512D64BE5F5}"
};
stylesheetExtension2.AddNamespaceDeclaration("x15",
"http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");
OpenXmlUnknownElement unknownElement =
OpenXmlUnknownElement.CreateOpenXmlUnknownElement(
"<x15:timelineStyles defaultTimelineStyle=\"TimeSlicerStyleLight1\" xmlns:x15=\"http://schemas.microsoft.com/office/spreadsheetml/2010/11/main\" />");
stylesheetExtension2.Append(unknownElement);
stylesheetExtensionList.Append(stylesheetExtension1);
stylesheetExtensionList.Append(stylesheetExtension2);
#endregion
stylesheet.Append(fonts);
stylesheet.Append(fills);
stylesheet.Append(borders);
stylesheet.Append(cellStyleFormats);
stylesheet.Append(cellFormats);
stylesheet.Append(cellStyles);
stylesheet.Append(differentialFormats);
stylesheet.Append(tableStyles);
stylesheet.Append(stylesheetExtensionList);
workbookStylesPart.Stylesheet = stylesheet;
}
public static extern IntPtr CreateFont(int nHeight, int nWidth, int nEscapement, int nOrientation, FontWeight fnWeight, FontItalic fdwItalic, FontUnderline fdwUnderline, FontStrikeOut fdwStrikeOut,
FontCharSet fdwCharSet, FontOutputPrecision fdwOutputPrecision, FontClipPrecision fdwClipPrecision, FontQuality fdwQuality, FontPitchAndFamily fdwPitchAndFamily, string lpszFace);
//описвывает форматы ячеек
protected void GenWorkbookStylesPart(WorkbookStylesPart workbookStylesPart)
{
Stylesheet stylesheet = new Stylesheet();
Fonts fonts1 = new Fonts();
Font font1 = new Font();
Font font2 = new Font();
FontSize fontSize2 = new FontSize() { Val = 11D };
Color color1 = new Color() { Rgb = "FF00B050" };
FontName fontName2 = new FontName() { Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering() { Val = 2 };
FontCharSet fontCharSet1 = new FontCharSet() { Val = 204 };
font2.Append(fontSize2);
font2.Append(color1);
font2.Append(fontName2);
font2.Append(fontFamilyNumbering1);
font2.Append(fontCharSet1);
//fonts1.Append(font2);
fonts1.Append(font1);
Fills fills1 = new Fills();
Fill fill1 = new Fill();
Fill fill2 = new Fill();
Fill fill3 = new Fill();
PatternFill patternFill3 = new PatternFill() { PatternType = PatternValues.Solid };
ForegroundColor foregroundColor1 = new ForegroundColor() { Rgb = "0000FF" };
patternFill3.Append(foregroundColor1);
fill3.Append(patternFill3);
fills1.Append(fill1);
fills1.Append(fill2);
fills1.Append(fill3);
Borders borders1 = new Borders();
Border border1 = new Border();
borders1.Append(border1);
//Переопределяем номера формата 164U, 166U, 167U, 168U,
NumberingFormats numberingFormats1 = new NumberingFormats() { Count = (UInt32Value)3U };
NumberingFormat numberingFormat1 = new NumberingFormat() { NumberFormatId = (UInt32Value)164U, FormatCode = "[$-F800]dddd\\,\\ mmmm\\ dd\\,\\ yyyy" };
NumberingFormat numberingFormat2 = new NumberingFormat() { NumberFormatId = (UInt32Value)166U, FormatCode = "#,##0.000\"р.\"" };
NumberingFormat numberingFormat3 = new NumberingFormat() { NumberFormatId = (UInt32Value)167U, FormatCode = "#,##0\"р.\"" }; //"#,##0.00\"р.\"" };
NumberingFormat numberingFormat4 = new NumberingFormat() { NumberFormatId = (UInt32Value)168U, FormatCode = "#,##0.00\"р.\"" };
numberingFormats1.Append(numberingFormat1);
numberingFormats1.Append(numberingFormat2);
numberingFormats1.Append(numberingFormat3);
numberingFormats1.Append(numberingFormat4);
CellFormats cellFormats1 = new CellFormats() { Count = (UInt32Value)6U };
CellFormat cellFormat2 = new CellFormat() { NumberFormatId = (UInt32Value)0U }; // Формат № 0 по умолчанию общий
CellFormat cellFormat3 = new CellFormat() { NumberFormatId = (UInt32Value)164U }; // Формат № 1 для дат FormatCode = "[$-F800]dddd\\,\\ mmmm\\ dd\\,\\ yyyy"
CellFormat cellFormat4 = new CellFormat() { NumberFormatId = (UInt32Value)166U }; //формат № 2 для денег по тысяч. ###,### <-- (number/ 1000)
CellFormat cellFormat5 = new CellFormat() { NumberFormatId = (UInt32Value)14U }; //формат № 3 для дат * 14.03.2015
CellFormat cellFormat6 = new CellFormat() { NumberFormatId = (UInt32Value)2U }; //формат № 4 для чисел
CellFormat cellFormat7 = new CellFormat() { NumberFormatId = (UInt32Value)1U }; //более подходящий формат № 5U для чисел (5U)
CellFormat cellFormat8 = new CellFormat() { NumberFormatId = (UInt32Value)165U };//формат №6U для денег по умолчанию
CellFormat cellFormat9 = new CellFormat() { NumberFormatId = (UInt32Value)167U };// формат №7U для денег(переопределенный) по три разряда ### ### р.
CellFormat cellFormat10 = new CellFormat() { NumberFormatId = (UInt32Value)168U };// формат №8U для денег(переопределенный) ### ###,00 р.
cellFormats1.Append(cellFormat2);
cellFormats1.Append(cellFormat3);
cellFormats1.Append(cellFormat4);
cellFormats1.Append(cellFormat5);
cellFormats1.Append(cellFormat6);
cellFormats1.Append(cellFormat7);
cellFormats1.Append(cellFormat8);
cellFormats1.Append(cellFormat9);
cellFormats1.Append(cellFormat10);
stylesheet.Append(numberingFormats1);
stylesheet.Append(fonts1);
stylesheet.Append(fills1);
stylesheet.Append(borders1);
stylesheet.Append(cellFormats1);
workbookStylesPart.Stylesheet = stylesheet;
}
// Generates content of fontTablePart2.
private void GenerateFontTablePart2Content(FontTablePart fontTablePart2)
{
Fonts fonts2 = new Fonts(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "w14 w15" } };
fonts2.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
fonts2.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
fonts2.AddNamespaceDeclaration("w", "http://schemas.openxmlformats.org/wordprocessingml/2006/main");
fonts2.AddNamespaceDeclaration("w14", "http://schemas.microsoft.com/office/word/2010/wordml");
fonts2.AddNamespaceDeclaration("w15", "http://schemas.microsoft.com/office/word/2010/11/wordml");
Font font6 = new Font(){ Name = "Century" };
Panose1Number panose1Number6 = new Panose1Number(){ Val = "02040604050505020304" };
FontCharSet fontCharSet6 = new FontCharSet(){ Val = "00" };
FontFamily fontFamily6 = new FontFamily(){ Val = FontFamilyValues.Roman };
Pitch pitch6 = new Pitch(){ Val = FontPitchValues.Variable };
FontSignature fontSignature6 = new FontSignature(){ UnicodeSignature0 = "00000287", UnicodeSignature1 = "00000000", UnicodeSignature2 = "00000000", UnicodeSignature3 = "00000000", CodePageSignature0 = "0000009F", CodePageSignature1 = "00000000" };
font6.Append(panose1Number6);
font6.Append(fontCharSet6);
font6.Append(fontFamily6);
font6.Append(pitch6);
font6.Append(fontSignature6);
Font font7 = new Font(){ Name = "ＭＳ 明朝" };
AltName altName3 = new AltName(){ Val = "MS Mincho" };
Panose1Number panose1Number7 = new Panose1Number(){ Val = "02020609040205080304" };
FontCharSet fontCharSet7 = new FontCharSet(){ Val = "80" };
FontFamily fontFamily7 = new FontFamily(){ Val = FontFamilyValues.Roman };
Pitch pitch7 = new Pitch(){ Val = FontPitchValues.Fixed };
FontSignature fontSignature7 = new FontSignature(){ UnicodeSignature0 = "E00002FF", UnicodeSignature1 = "6AC7FDFB", UnicodeSignature2 = "00000012", UnicodeSignature3 = "00000000", CodePageSignature0 = "0002009F", CodePageSignature1 = "00000000" };
font7.Append(altName3);
font7.Append(panose1Number7);
font7.Append(fontCharSet7);
font7.Append(fontFamily7);
font7.Append(pitch7);
font7.Append(fontSignature7);
Font font8 = new Font(){ Name = "Times New Roman" };
Panose1Number panose1Number8 = new Panose1Number(){ Val = "02020603050405020304" };
FontCharSet fontCharSet8 = new FontCharSet(){ Val = "00" };
FontFamily fontFamily8 = new FontFamily(){ Val = FontFamilyValues.Roman };
Pitch pitch8 = new Pitch(){ Val = FontPitchValues.Variable };
FontSignature fontSignature8 = new FontSignature(){ UnicodeSignature0 = "E0002AFF", UnicodeSignature1 = "C0007841", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font8.Append(panose1Number8);
font8.Append(fontCharSet8);
font8.Append(fontFamily8);
font8.Append(pitch8);
font8.Append(fontSignature8);
Font font9 = new Font(){ Name = "ＭＳ ゴシック" };
AltName altName4 = new AltName(){ Val = "MS Gothic" };
Panose1Number panose1Number9 = new Panose1Number(){ Val = "020B0609070205080204" };
FontCharSet fontCharSet9 = new FontCharSet(){ Val = "80" };
FontFamily fontFamily9 = new FontFamily(){ Val = FontFamilyValues.Modern };
Pitch pitch9 = new Pitch(){ Val = FontPitchValues.Fixed };
FontSignature fontSignature9 = new FontSignature(){ UnicodeSignature0 = "E00002FF", UnicodeSignature1 = "6AC7FDFB", UnicodeSignature2 = "00000012", UnicodeSignature3 = "00000000", CodePageSignature0 = "0002009F", CodePageSignature1 = "00000000" };
font9.Append(altName4);
font9.Append(panose1Number9);
font9.Append(fontCharSet9);
font9.Append(fontFamily9);
font9.Append(pitch9);
font9.Append(fontSignature9);
Font font10 = new Font(){ Name = "Arial" };
Panose1Number panose1Number10 = new Panose1Number(){ Val = "020B0604020202020204" };
FontCharSet fontCharSet10 = new FontCharSet(){ Val = "00" };
FontFamily fontFamily10 = new FontFamily(){ Val = FontFamilyValues.Swiss };
Pitch pitch10 = new Pitch(){ Val = FontPitchValues.Variable };
FontSignature fontSignature10 = new FontSignature(){ UnicodeSignature0 = "E0002AFF", UnicodeSignature1 = "C0007843", UnicodeSignature2 = "00000009", UnicodeSignature3 = "00000000", CodePageSignature0 = "000001FF", CodePageSignature1 = "00000000" };
font10.Append(panose1Number10);
font10.Append(fontCharSet10);
font10.Append(fontFamily10);
font10.Append(pitch10);
font10.Append(fontSignature10);
fonts2.Append(font6);
fonts2.Append(font7);
fonts2.Append(font8);
fonts2.Append(font9);
fonts2.Append(font10);
fontTablePart2.Fonts = fonts2;
}
// Generates content of fontTablePart1.
private void GenerateFontTablePart1Content(FontTablePart fontTablePart1)
{
Fonts fonts1 = new Fonts();
fonts1.AddNamespaceDeclaration("w", "http://schemas.openxmlformats.org/wordprocessingml/2006/main");
fonts1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
Font font1 = new Font() { Name = "Times New Roman" };
FontCharSet fontCharSet1 = new FontCharSet() { Val = "00", StrictCharacterSet = new EnumValue<StrictCharacterSet>() { InnerText = "windows-1252" } };
FontFamily fontFamily1 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch1 = new Pitch() { Val = FontPitchValues.Variable };
font1.Append(fontCharSet1);
font1.Append(fontFamily1);
font1.Append(pitch1);
Font font2 = new Font() { Name = "Symbol" };
FontCharSet fontCharSet2 = new FontCharSet() { Val = "02" };
FontFamily fontFamily2 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch2 = new Pitch() { Val = FontPitchValues.Variable };
font2.Append(fontCharSet2);
font2.Append(fontFamily2);
font2.Append(pitch2);
Font font3 = new Font() { Name = "Arial" };
FontCharSet fontCharSet3 = new FontCharSet() { Val = "00", StrictCharacterSet = new EnumValue<StrictCharacterSet>() { InnerText = "windows-1252" } };
FontFamily fontFamily3 = new FontFamily() { Val = FontFamilyValues.Swiss };
Pitch pitch3 = new Pitch() { Val = FontPitchValues.Variable };
font3.Append(fontCharSet3);
font3.Append(fontFamily3);
font3.Append(pitch3);
Font font4 = new Font() { Name = "Liberation Serif" };
AltName altName1 = new AltName() { Val = "Times New Roman" };
FontCharSet fontCharSet4 = new FontCharSet() { Val = "cc", StrictCharacterSet = StrictCharacterSet.chsRussian };
FontFamily fontFamily4 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch4 = new Pitch() { Val = FontPitchValues.Variable };
font4.Append(altName1);
font4.Append(fontCharSet4);
font4.Append(fontFamily4);
font4.Append(pitch4);
Font font5 = new Font() { Name = "Times New Roman" };
FontCharSet fontCharSet5 = new FontCharSet() { Val = "cc", StrictCharacterSet = StrictCharacterSet.chsRussian };
FontFamily fontFamily5 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch5 = new Pitch() { Val = FontPitchValues.Variable };
font5.Append(fontCharSet5);
font5.Append(fontFamily5);
font5.Append(pitch5);
Font font6 = new Font() { Name = "Liberation Sans" };
AltName altName2 = new AltName() { Val = "Arial" };
FontCharSet fontCharSet6 = new FontCharSet() { Val = "cc", StrictCharacterSet = StrictCharacterSet.chsRussian };
FontFamily fontFamily6 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch6 = new Pitch() { Val = FontPitchValues.Variable };
font6.Append(altName2);
font6.Append(fontCharSet6);
font6.Append(fontFamily6);
font6.Append(pitch6);
Font font7 = new Font() { Name = "Symbol" };
FontCharSet fontCharSet7 = new FontCharSet() { Val = "cc", StrictCharacterSet = StrictCharacterSet.chsRussian };
FontFamily fontFamily7 = new FontFamily() { Val = FontFamilyValues.Roman };
Pitch pitch7 = new Pitch() { Val = FontPitchValues.Variable };
font7.Append(fontCharSet7);
font7.Append(fontFamily7);
font7.Append(pitch7);
fonts1.Append(font1);
fonts1.Append(font2);
fonts1.Append(font3);
fonts1.Append(font4);
fonts1.Append(font5);
fonts1.Append(font6);
fonts1.Append(font7);
fontTablePart1.Fonts = fonts1;
}
