C# (CSharp) XLSXWriter.NewRow Exemples

Exemple #1

        public void MissingRecord(string[] record, int missingRecordIndex)
        {
            writer.SetWorksheet("Missing Records");

            string fileLabel;

            if (missingRecordIndex == 0)
            {
                fileLabel = "MASTER";
                missingRowsInFirstFileCount++;
            }
            else
            {
                fileLabel = "VALIDATED";
                missingRowsInSecondFileCount++;
            }

            for (int i = 0; i < record.Length; i++)
            {
                if (i == ID_COLUMN_INDEX)
                {
                    continue;
                }
                writer.WriteInline(record[i], Styles.RED);
            }
            writer.WriteInline(record[ID_COLUMN_INDEX], Styles.RED);
            writer.WriteInline(string.Format("MISSING IN {0} FILE", fileLabel), Styles.RED);
            writer.NewRow();
        }