private Row GenerateRowForProperty(UInt32Value rowIndex, int linesToAdd, ProjectFile projectFile, String property)
        {
            Row row = new Row() { RowIndex = (UInt32Value)(rowIndex + linesToAdd), Spans = new ListValue<StringValue>() { InnerText = "3:9" }, DyDescent = 0.25D };
            ProjectProperty projectProperty = projectFile.ProjectProperties.FirstOrDefault(prop => prop.Type == property);
            if (projectProperty != null)
            {
                int sharedStringIndexForType = 0;

                for (int i = 0; i < SharedStrings.Count; i++)
                {
                    if (SharedStrings[i].Text.Text == projectProperty.Type)
                    {
                        sharedStringIndexForType = i;
                        break;
                    }
                }

                List<Cell> cells = new List<Cell>()
                    {
                        new Cell(){CellReference = GetCell(String.Format("C{0}", rowIndex.Value), linesToAdd),StyleIndex = (UInt32Value) 7U,DataType = CellValues.SharedString, CellValue = new CellValue(sharedStringIndexForType.ToString(CultureInfo.InvariantCulture))},
                        new Cell(){CellReference = GetCell(String.Format("D{0}", rowIndex.Value), linesToAdd),StyleIndex = (UInt32Value) 8U,DataType = CellValues.Number, CellValue = new CellValue(projectProperty.Rate.ToString(CultureInfo.InvariantCulture))},
                        new Cell(){CellReference = GetCell(String.Format("F{0}", rowIndex.Value), linesToAdd),StyleIndex = (UInt32Value) 9U,DataType = CellValues.Number, CellValue = new CellValue(projectProperty.Words.ToString(CultureInfo.InvariantCulture))},
                        new Cell(){CellReference = GetCell(String.Format("G{0}", rowIndex.Value), linesToAdd),StyleIndex = (UInt32Value) 9U,DataType = CellValues.Number, CellValue = new CellValue(projectProperty.Characters.ToString(CultureInfo.InvariantCulture))},
                        new Cell(){CellReference = GetCell(String.Format("H{0}", rowIndex.Value), linesToAdd),StyleIndex = (UInt32Value) 9U,DataType = CellValues.Number, CellValue = new CellValue(projectProperty.ValueByWords.ToString(CultureInfo.InvariantCulture))},
                        new Cell(){CellReference = GetCell(String.Format("I{0}", rowIndex.Value), linesToAdd),StyleIndex = (UInt32Value) 9U,DataType = CellValues.SharedString, CellValue = new CellValue("15")}
                    };
                row.Append(cells.ConvertAll(c => (OpenXmlElement) c));
            }
            return row;
        }
Example #2
0
        private void PrepareFilesList(String projectAnalyseFile)
        {
            ProjectFiles = new List<ProjectFile>();
            var projectsFile = new XPathDocument(projectAnalyseFile);
            var nav = projectsFile.CreateNavigator();
            const string expression = "task/file";
            var projectNodes = nav.Select(expression);

            ProjectFile file;
            while (projectNodes.MoveNext())
            {
                file = new ProjectFile(_template)
                    {
                        AnalyseFile = projectAnalyseFile,
                        IsSummary = false,
                        XMLNode = projectNodes.Current
                    };
                file.Prepare();
                ProjectFiles.Add(file);
            }

            file = new ProjectFile(_template)
            {
                AnalyseFile = projectAnalyseFile,
                IsSummary = true,
                FileName = (new UIResources(Settings.GetSavedCulture())).Summary,
                XMLNode = nav.SelectSingleNode("task/batchTotal")
            };
            file.Prepare();
            ProjectFiles.Add(file);
        }
 public override String GenerateHeader(ProjectFile file)
 {
     UIResources resources = new UIResources(Settings.GetSavedCulture());
     StringBuilder sb = new StringBuilder();
     sb.AppendLine("<TABLE><tbody>");
     sb.AppendLine(
         String.Format(
             "<TR><TD><b>{0}</b></TD> <TD><b>{1}</b></TD> <TD><b>{2}</b></TD> <TD><b>{3}</b></TD> <TD><b>{4}</b></TD></TR>",
             resources.Type, resources.Rates,
             resources.Words, resources.Characters, resources.Value));
     return sb.ToString();
 }
 private String GenerateJustLines(ProjectFile file)
 {
     UIResources resources = new UIResources(Settings.GetSavedCulture());
     StringBuilder sb = new StringBuilder();
     sb.AppendLine("<TABLE><tbody>");
     sb.AppendLine(String.Format("<TR><TD><b>{0}</b></TD> <TD><b>{1}</b></TD></TR>", resources.Type.PadRight(30, ' '), resources.Rates));
     foreach (var rate in AdditionalRates)
     {
         sb.AppendLine(String.Format("<TR><TD>{0}</TD> <TD>{1}</TD></TR>", rate.Type.PadRight(30, ' '), rate.Rate.ToString()));
     }
     sb.AppendLine("</tbody></TABLE>");
     sb.AppendLine("<br>"); 
     sb.AppendLine(resources.JustLines);
     sb.AppendLine("<br>");
     sb.AppendLine("<TABLE><tbody>");
     sb.AppendLine(String.Format("<TR><TD><b>{0}:</b></TD> <TD>{1} {2}</TD> <TD>{3} {4}</TD></TR>", resources.PaymentByCharacters, file.LinesByCharacters.ToString(), 
         resources.StandardLines, file.ValueByLbC.ToString(), resources.Euros));
     sb.AppendLine(String.Format("<TR><TD><b>{0}:</b></TD> <TD>{1} {2}</TD> <TD>{3} {4}</TD></TR>", resources.PaymentByKeystrokes, file.LinesByKeyStrokes.ToString(),
         resources.StandardLines, file.ValueByLbK.ToString(), resources.Euros));
     sb.AppendLine("</tbody></TABLE>");
     sb.AppendLine("<br>");
     return sb.ToString();
 }
 public virtual String GenerateHeader(ProjectFile file)
 {
     return String.Empty;
 }
        // Generates content of worksheet.
        protected override void GenerateWorksheetDataContent(SheetData sheetData, int linesToAdd, ProjectFile projectFile)
        {
            List<Row> rows = new List<Row>();
            List<Cell> cells = new List<Cell>();

            #region file name
            Row fileNameRow = new Row(){RowIndex = (UInt32Value)(2U + linesToAdd),Spans = new ListValue<StringValue>() { InnerText = "3:9" },DyDescent = 0.25D};

            if (FileNamesSharedStrings == null)
                FileNamesSharedStrings = new List<SharedStringItem>();
            FileNamesSharedStrings.Add(new SharedStringItem() { Text = new Text() { Text = String.Format("File: {0}", Path.GetFileName(projectFile.FileName)) } });

// ReSharper disable PossiblyMistakenUseOfParamsMethod
            fileNameRow.Append(new Cell()
            {
                CellReference = GetCell("C2", linesToAdd),
                StyleIndex = (UInt32Value)3U,
                DataType = CellValues.SharedString,
                CellValue = new CellValue((SharedStringsCount + FileNamesSharedStrings.Count).ToString(CultureInfo.InvariantCulture))
            }); rows.Add(fileNameRow);
// ReSharper restore PossiblyMistakenUseOfParamsMethod
            #endregion

            #region analysis results text
            Row arRow = new Row(){RowIndex = (UInt32Value) (3U+linesToAdd),Spans = new ListValue<StringValue>() {InnerText = "3:9"},DyDescent = 0.25D};

            cells = new List<Cell>()
                {
                    new Cell() {CellReference = GetCell("F3", linesToAdd), StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString, CellValue = new CellValue("0") },
                    new Cell() {CellReference = GetCell("G3", linesToAdd), StyleIndex = (UInt32Value) 1U},
                    new Cell() {CellReference = GetCell("H3", linesToAdd), StyleIndex = (UInt32Value) 1U},
                    new Cell() {CellReference = GetCell("I3", linesToAdd), StyleIndex = (UInt32Value) 1U}
                };
            arRow.Append(cells.ConvertAll(c => (OpenXmlElement)c));
            rows.Add(arRow);
            #endregion 

            #region header row
            Row headerRow = new Row(){RowIndex = (UInt32Value) (4U+linesToAdd),Spans = new ListValue<StringValue>() {InnerText = "3:9"},DyDescent = 0.25D};
            cells = new List<Cell>()
                {
                    new Cell() {CellReference = GetCell("C4", linesToAdd), StyleIndex = (UInt32Value) 3U, DataType = CellValues.SharedString, CellValue = new CellValue("1")},
                    new Cell() {CellReference = GetCell("D4", linesToAdd), StyleIndex = (UInt32Value) 4U, DataType = CellValues.SharedString, CellValue = new CellValue("2")},
                    new Cell() {CellReference = GetCell("F4", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.SharedString, CellValue = new CellValue("3")},
                    new Cell() {CellReference = GetCell("G4", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.SharedString, CellValue = new CellValue("4")},
                    new Cell() {CellReference = GetCell("H4", linesToAdd), StyleIndex = (UInt32Value) 6U, DataType = CellValues.SharedString, CellValue = new CellValue("5")},
                    new Cell() {CellReference = GetCell("I4", linesToAdd), StyleIndex = (UInt32Value) 2U}
                };

            headerRow.Append(cells.ConvertAll(c => (OpenXmlElement)c));
            rows.Add(headerRow);
            #endregion

            #region value rows
            rows.Add(GenerateRowForProperty(5U, linesToAdd, projectFile, Templates.Templates.PerfectMatch));
            rows.Add(GenerateRowForProperty(6U, linesToAdd, projectFile, Templates.Templates.ContextMatch));
            rows.Add(GenerateRowForProperty(7U, linesToAdd, projectFile, Templates.Templates.Repetitions));
            rows.Add(GenerateRowForProperty(8U, linesToAdd, projectFile, Templates.Templates.Percent100));
            rows.Add(GenerateRowForProperty(9U, linesToAdd, projectFile, Templates.Templates.Percent95));
            rows.Add(GenerateRowForProperty(10U, linesToAdd, projectFile, Templates.Templates.Percent85));
            rows.Add(GenerateRowForProperty(11U, linesToAdd, projectFile, Templates.Templates.Percent75));
            rows.Add(GenerateRowForProperty(12U, linesToAdd, projectFile, Templates.Templates.Percent50));
            rows.Add(GenerateRowForProperty(13U, linesToAdd, projectFile, Templates.Templates.New));
            rows.Add(GenerateRowForProperty(14U, linesToAdd, projectFile, Templates.Templates.Tags));
            #endregion

            #region total rows
            Row emptyRow = new Row() { RowIndex = (UInt32Value)(15U + linesToAdd), Spans = new ListValue<StringValue>() { InnerText = "3:9" }, DyDescent = 0.25D };
            cells = new List<Cell>()
                {
                    new Cell() {CellReference = GetCell("F15", linesToAdd), StyleIndex = (UInt32Value) 12U},
                    new Cell() {CellReference = GetCell("G15", linesToAdd), StyleIndex = (UInt32Value) 12U},
                    new Cell() {CellReference = GetCell("H15", linesToAdd), StyleIndex = (UInt32Value) 12U},
                    new Cell() {CellReference = GetCell("I15", linesToAdd), StyleIndex = (UInt32Value) 12U}
                };
            emptyRow.Append(cells.ConvertAll(c => (OpenXmlElement)c));
            rows.Add(emptyRow);

            Row totalRow = new Row() { RowIndex = (UInt32Value)(16U + linesToAdd), Spans = new ListValue<StringValue>() { InnerText = "3:9" }, DyDescent = 0.25D };

            Decimal totalWords = projectFile.ProjectProperties.Where(property => property.StandardType != StandardType.Global).Sum(property => property.Words);
            Decimal totalChars = projectFile.ProjectProperties.Where(property => property.StandardType != StandardType.Global).Sum(property => property.Characters);
            Decimal totalValue = projectFile.ProjectProperties.Where(property => property.StandardType != StandardType.Global).Sum(property => property.ValueByWords);

            cells = new List<Cell>()
                {
                    new Cell(){CellReference = GetCell("F16", linesToAdd),StyleIndex = (UInt32Value) 13U, DataType = CellValues.Number, CellValue = new CellValue(totalWords.ToString(CultureInfo.InvariantCulture))},
                    new Cell(){CellReference = GetCell("G16", linesToAdd),StyleIndex = (UInt32Value) 13U, DataType = CellValues.Number, CellValue = new CellValue(totalChars.ToString(CultureInfo.InvariantCulture))},
                    new Cell(){CellReference = GetCell("H16", linesToAdd),StyleIndex = (UInt32Value) 13U, DataType = CellValues.Number, CellValue =new CellValue(totalValue.ToString(CultureInfo.InvariantCulture))},
                    new Cell(){CellReference = GetCell("I16", linesToAdd), StyleIndex = (UInt32Value) 13U ,DataType = CellValues.SharedString, CellValue = new CellValue("15")}
                };
            totalRow.Append(cells.ConvertAll(c => (OpenXmlElement)c));
            rows.Add(totalRow);
            #endregion

            sheetData.Append(rows.ConvertAll(c => (OpenXmlElement)c));
        }
        protected override void GenerateWorksheetDataContent(SheetData sheetData, int linesToAdd, ProjectFile projectFile)
        {
            List<Row> rows = new List<Row>();
            List<Cell> cells = new List<Cell>();

            #region file name
            Row fileNameRow = new Row() { RowIndex = (UInt32Value)(2U + linesToAdd), Spans = new ListValue<StringValue>() { InnerText = "3:9" }, DyDescent = 0.25D };
            if (FileNamesSharedStrings == null)
                FileNamesSharedStrings = new List<SharedStringItem>();
            FileNamesSharedStrings.Add(new SharedStringItem() { Text = new Text() { Text = String.Format("File: {0}", Path.GetFileName(projectFile.FileName)) } });

// ReSharper disable PossiblyMistakenUseOfParamsMethod
            fileNameRow.Append(new Cell()
                {
                    CellReference = GetCell("C2", linesToAdd),
                    StyleIndex = (UInt32Value) 3U,
                    DataType = CellValues.SharedString,
                    CellValue = new CellValue((AdditionalSharedStrings.Count + SharedStringsCount + FileNamesSharedStrings.Count).ToString(CultureInfo.InvariantCulture))
                });
            rows.Add(fileNameRow);
// ReSharper restore PossiblyMistakenUseOfParamsMethod
            #endregion

            #region Rate
            Row rateRow1 = new Row() { RowIndex = (UInt32Value)(4U + linesToAdd), Spans = new ListValue<StringValue>() { InnerText = "3:9" }, DyDescent = 0.25D };

            cells = new List<Cell>()
                {
                    new Cell() {CellReference = GetCell("C4", linesToAdd), StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString, CellValue = new CellValue("16") },
                    new Cell() {CellReference = GetCell("D4", linesToAdd), StyleIndex = (UInt32Value) 1U, DataType = CellValues.Number, CellValue = new CellValue(projectFile.LineCharacters.ToString(CultureInfo.InvariantCulture))},
                    new Cell() {CellReference = GetCell("E4", linesToAdd), StyleIndex = (UInt32Value) 1U, DataType = CellValues.SharedString, CellValue = new CellValue("4")},
                };
            rateRow1.Append(cells.ConvertAll(c => (OpenXmlElement)c));
            rows.Add(rateRow1);

            Row rateRow2 = new Row() { RowIndex = (UInt32Value)(5U + linesToAdd), Spans = new ListValue<StringValue>() { InnerText = "3:9" }, DyDescent = 0.25D };

            cells = new List<Cell>()
                {
                    new Cell() {CellReference = GetCell("C5", linesToAdd), StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString, CellValue = new CellValue("17") },
                    new Cell() {CellReference = GetCell("D5", linesToAdd), StyleIndex = (UInt32Value) 1U, DataType = CellValues.Number, CellValue = new CellValue(projectFile.RatePerLine.ToString(CultureInfo.InvariantCulture))},
                    new Cell() {CellReference = GetCell("E5", linesToAdd), StyleIndex = (UInt32Value) 1U, DataType = CellValues.SharedString, CellValue = new CellValue("15")},
                };
            rateRow2.Append(cells.ConvertAll(c => (OpenXmlElement)c));
            rows.Add(rateRow2);
            #endregion

            #region lines payment infos
            Row justLinesRow = new Row() { RowIndex = (UInt32Value)(7U + linesToAdd), Spans = new ListValue<StringValue>() { InnerText = "3:9" }, DyDescent = 0.25D };
            justLinesRow.Append(new Cell() { CellReference = GetCell("C7", linesToAdd), StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString, CellValue = new CellValue("18") });
            rows.Add(justLinesRow);
            
            Row charsRow = new Row() { RowIndex = (UInt32Value)(8U + linesToAdd), Spans = new ListValue<StringValue>() { InnerText = "3:9" }, DyDescent = 0.25D };
            cells = new List<Cell>()
                {
                    new Cell() {CellReference = GetCell("C8", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.SharedString, CellValue = new CellValue("19")},
                    new Cell() {CellReference = GetCell("D8", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.Number, CellValue = new CellValue(projectFile.LinesByCharacters.ToString(CultureInfo.InvariantCulture))},
                    new Cell() {CellReference = GetCell("F8", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.SharedString, CellValue = new CellValue("20")},
                    new Cell() {CellReference = GetCell("G8", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.Number,  CellValue = new CellValue((projectFile.LinesByCharacters*projectFile.RatePerLine).ToString(CultureInfo.InvariantCulture))},
                    new Cell() {CellReference = GetCell("H8", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.SharedString, CellValue = new CellValue("15")}
                };

            charsRow.Append(cells.ConvertAll(c => (OpenXmlElement)c));
            rows.Add(charsRow);

            Row keysRow = new Row() { RowIndex = (UInt32Value)(9U + linesToAdd), Spans = new ListValue<StringValue>() { InnerText = "3:9" }, DyDescent = 0.25D };
            cells = new List<Cell>()
                {
                    new Cell() {CellReference = GetCell("C9", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.SharedString, CellValue = new CellValue("21")},
                    new Cell() {CellReference = GetCell("D9", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.Number, CellValue = new CellValue(projectFile.LinesByKeyStrokes.ToString(CultureInfo.InvariantCulture))},
                    new Cell() {CellReference = GetCell("F9", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.SharedString, CellValue = new CellValue("20")},
                    new Cell() {CellReference = GetCell("G9", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.Number, CellValue = new CellValue((projectFile.LinesByKeyStrokes*projectFile.RatePerLine).ToString(CultureInfo.InvariantCulture))},
                    new Cell() {CellReference = GetCell("H9", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.SharedString, CellValue = new CellValue("15")}
                };

            keysRow.Append(cells.ConvertAll(c => (OpenXmlElement)c));
            rows.Add(keysRow);
            #endregion

            #region header row
            Row headerRow = new Row() { RowIndex = (UInt32Value)(11U + linesToAdd), Spans = new ListValue<StringValue>() { InnerText = "3:9" }, DyDescent = 0.25D };
            cells = new List<Cell>()
                {
                    new Cell() {CellReference = GetCell("C11", linesToAdd), StyleIndex = (UInt32Value) 3U, DataType = CellValues.SharedString, CellValue = new CellValue("1")},
                    new Cell() {CellReference = GetCell("D11", linesToAdd), StyleIndex = (UInt32Value) 4U, DataType = CellValues.SharedString, CellValue = new CellValue("2")},
                    new Cell() {CellReference = GetCell("F11", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.SharedString, CellValue = new CellValue("22")},
                    new Cell() {CellReference = GetCell("G11", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.SharedString, CellValue = new CellValue("5")},
                    new Cell() {CellReference = GetCell("H11", linesToAdd), StyleIndex = (UInt32Value) 2U},
                    new Cell() {CellReference = GetCell("J11", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.SharedString, CellValue = new CellValue("23")},
                    new Cell() {CellReference = GetCell("K11", linesToAdd), StyleIndex = (UInt32Value) 5U, DataType = CellValues.SharedString, CellValue = new CellValue("5")},
                    new Cell() {CellReference = GetCell("L11", linesToAdd), StyleIndex = (UInt32Value) 2U}
                };

            headerRow.Append(cells.ConvertAll(c => (OpenXmlElement)c));
            rows.Add(headerRow);
            #endregion

            #region value rows
            rows.Add(GenerateRowForProperty(12U, linesToAdd, projectFile, Templates.Templates.PerfectMatch));
            rows.Add(GenerateRowForProperty(13U, linesToAdd, projectFile, Templates.Templates.ContextMatch));
            rows.Add(GenerateRowForProperty(14U, linesToAdd, projectFile, Templates.Templates.Repetitions));
            rows.Add(GenerateRowForProperty(15U, linesToAdd, projectFile, Templates.Templates.Percent100));
            rows.Add(GenerateRowForProperty(16U, linesToAdd, projectFile, Templates.Templates.Percent95));
            rows.Add(GenerateRowForProperty(17U, linesToAdd, projectFile, Templates.Templates.Percent85));
            rows.Add(GenerateRowForProperty(18U, linesToAdd, projectFile, Templates.Templates.Percent75));
            rows.Add(GenerateRowForProperty(19U, linesToAdd, projectFile, Templates.Templates.Percent50));
            rows.Add(GenerateRowForProperty(20U, linesToAdd, projectFile, Templates.Templates.New));
            rows.Add(GenerateRowForProperty(21U, linesToAdd, projectFile, Templates.Templates.Tags));
            #endregion

            #region total rows
            Row emptyRow = new Row() { RowIndex = (UInt32Value)(22U + linesToAdd), Spans = new ListValue<StringValue>() { InnerText = "3:9" }, DyDescent = 0.25D };
            cells = new List<Cell>()
                {
                    new Cell() {CellReference = GetCell("F22", linesToAdd), StyleIndex = (UInt32Value) 12U},
                    new Cell() {CellReference = GetCell("G22", linesToAdd), StyleIndex = (UInt32Value) 12U},
                    new Cell() {CellReference = GetCell("H22", linesToAdd), StyleIndex = (UInt32Value) 12U},
                    new Cell() {CellReference = GetCell("J22", linesToAdd), StyleIndex = (UInt32Value) 12U},
                    new Cell() {CellReference = GetCell("K22", linesToAdd), StyleIndex = (UInt32Value) 12U},
                    new Cell() {CellReference = GetCell("L22", linesToAdd), StyleIndex = (UInt32Value) 12U},
                };
            emptyRow.Append(cells.ConvertAll(c => (OpenXmlElement)c));
            rows.Add(emptyRow);

            Row totalRow = new Row() { RowIndex = (UInt32Value)(23U + linesToAdd), Spans = new ListValue<StringValue>() { InnerText = "3:9" }, DyDescent = 0.25D };

            Decimal totalValueC = projectFile.ProjectProperties.Where(property => property.StandardType != StandardType.Global).Sum(property => property.ValueByLbC);
            Decimal totalValueK = projectFile.ProjectProperties.Where(property => property.StandardType != StandardType.Global).Sum(property => property.ValueByLbK);

            cells = new List<Cell>()
                {
                    new Cell(){CellReference = GetCell("F23", linesToAdd),StyleIndex = (UInt32Value) 12U },
                    new Cell(){CellReference = GetCell("G23", linesToAdd),StyleIndex = (UInt32Value) 13U ,DataType = CellValues.Number, CellValue = new CellValue(totalValueC.ToString(CultureInfo.InvariantCulture))},
                    new Cell(){CellReference = GetCell("H23", linesToAdd), StyleIndex = (UInt32Value) 13U ,DataType = CellValues.SharedString, CellValue = new CellValue("15")},
                    new Cell(){CellReference = GetCell("J23", linesToAdd),StyleIndex = (UInt32Value) 12U },
                    new Cell(){CellReference = GetCell("K23", linesToAdd),StyleIndex = (UInt32Value) 13U ,DataType = CellValues.Number, CellValue = new CellValue(totalValueK.ToString(CultureInfo.InvariantCulture))},
                    new Cell(){CellReference = GetCell("L23", linesToAdd), StyleIndex = (UInt32Value) 13U ,DataType = CellValues.SharedString, CellValue = new CellValue("15")}
                };
            totalRow.Append(cells.ConvertAll(c => (OpenXmlElement)c));
            rows.Add(totalRow);
            #endregion

            sheetData.Append(rows.ConvertAll(c => (OpenXmlElement)c));
        }
 protected virtual void GenerateWorksheetDataContent(SheetData sheetData1, int linesToAdd, ProjectFile porjectFile)
 {
 }