Exemplo n.º 1
0
        private string WriteHeaderRow(ExcelOutputTextFormat Format, bool hasTextQ, int row, CultureInfo ci)
        {
            var sb = new StringBuilder();

            for (int col = _fromCol; col <= _toCol; col++)
            {
                if (hasTextQ)
                {
                    sb.Append(Format.TextQualifier);
                }
                var v = GetCellStoreValue(row, col);
                sb.Append(ValueToTextHandler.GetFormattedText(v._value, _workbook, v._styleId, false, ci));
                if (hasTextQ)
                {
                    sb.Append(Format.TextQualifier);
                }
                if (col < _toCol)
                {
                    sb.Append(Format.Delimiter);
                }
            }
            if (row != _toRow)
            {
                sb.Append(Format.EOL);
            }
            return(sb.ToString());
        }
Exemplo n.º 2
0
 /// <summary>
 /// Converts a range to text in CSV format.
 /// Invariant culture is used by default.
 /// </summary>
 /// <param name="Format">Information how to create the csv text</param>
 /// <returns>A string containing the text</returns>
 public string ToText(ExcelOutputTextFormat Format)
 {
     using (var ms = RecyclableMemory.GetStream())
     {
         SaveToText(ms, Format);
         ms.Position = 0;
         var sr = new StreamReader(ms);
         return(sr.ReadToEnd());
     }
 }
Exemplo n.º 3
0
        /// <summary>
        /// Converts a range to text in CSV format.
        /// Invariant culture is used by default.
        /// </summary>
        /// <param name="Format">Information how to create the csv text</param>
        /// <returns>A string containing the text</returns>
        public string ToText(ExcelOutputTextFormat Format)
        {
            var ms = new MemoryStream();

            SaveToText(ms, Format);
            ms.Position = 0;
            var sr = new StreamReader(ms);

            return(sr.ReadToEnd());
        }
Exemplo n.º 4
0
        /// <summary>
        /// Converts a range to text in CSV format.
        /// Invariant culture is used by default.
        /// </summary>
        /// <param name="Format">Information how to create the csv text</param>
        /// <returns>A string containing the text</returns>
        public async Task <string> ToTextAsync(ExcelOutputTextFormat Format)
        {
            using (var ms = RecyclableMemory.GetStream())
            {
                await SaveToTextAsync(ms, Format).ConfigureAwait(false);

                ms.Position = 0;
                var sr = new StreamReader(ms);
                return(await sr.ReadToEndAsync().ConfigureAwait(false));
            }
        }
Exemplo n.º 5
0
        private static CultureInfo GetCultureInfo(ExcelOutputTextFormat Format)
        {
            var ci = (CultureInfo)(Format.Culture.Clone() ?? CultureInfo.InvariantCulture.Clone());

            if (Format.DecimalSeparator != null)
            {
                ci.NumberFormat.NumberDecimalSeparator = Format.DecimalSeparator;
            }
            if (Format.ThousandsSeparator != null)
            {
                ci.NumberFormat.NumberGroupSeparator = Format.ThousandsSeparator;
            }

            return(ci);
        }
Exemplo n.º 6
0
        private string GetText(ExcelOutputTextFormat Format, int maxFormats, CultureInfo ci, int row, int col, out bool isText)
        {
            var v = GetCellStoreValue(row, col);

            var ix = col - _fromCol;

            isText = false;
            string fmt;

            if (ix < maxFormats)
            {
                fmt = Format.Formats[ix];
            }
            else
            {
                fmt = "";
            }
            string t;

            if (string.IsNullOrEmpty(fmt))
            {
                if (Format.UseCellFormat)
                {
                    t = ValueToTextHandler.GetFormattedText(v._value, _workbook, v._styleId, false, ci);
                    if (!ConvertUtil.IsNumericOrDate(v._value))
                    {
                        isText = true;
                    }
                }
                else
                {
                    if (ConvertUtil.IsNumeric(v._value))
                    {
                        t = ConvertUtil.GetValueDouble(v._value).ToString("r", ci);
                    }
                    else if (v._value is DateTime date)
                    {
                        t = date.ToString("G", ci);
                    }
                    else
                    {
                        t      = v._value.ToString();
                        isText = true;
                    }
                }
            }
            else
            {
                if (fmt == "$")
                {
                    if (Format.UseCellFormat)
                    {
                        t = ValueToTextHandler.GetFormattedText(v._value, _workbook, v._styleId, false, ci);
                    }
                    else
                    {
                        t = v._value.ToString();
                    }
                    isText = true;
                }
                else if (ConvertUtil.IsNumeric(v._value))
                {
                    t = ConvertUtil.GetValueDouble(v._value).ToString(fmt, ci);
                }
                else if (v._value is DateTime date)
                {
                    t = date.ToString(fmt, ci);
                }
                else if (v._value is TimeSpan ts)
                {
#if NET35
                    t = ts.Ticks.ToString(ci);
#else
                    t = ts.ToString(fmt, ci);
#endif
                }
                else
                {
                    t      = v._value.ToString();
                    isText = true;
                }
            }
            return(t);
        }
Exemplo n.º 7
0
 private bool SkipLines(ExcelOutputTextFormat Format, int row, int skipLinesBegining)
 {
     return(skipLinesBegining > row - _fromRow ||
            Format.SkipLinesEnd > _toRow - row);
 }
Exemplo n.º 8
0
        /// <summary>
        /// Converts a range to text in CSV format.
        /// Invariant culture is used by default.
        /// </summary>
        /// <param name="stream">The strem to write to</param>
        /// <param name="Format">Information how to create the csv text</param>
        public async Task SaveToTextAsync(Stream stream, ExcelOutputTextFormat Format)
        {
            if (Format == null)
            {
                Format = new ExcelOutputTextFormat();
            }
            var sw = new StreamWriter(stream, Format.Encoding);

            if (!string.IsNullOrEmpty(Format.Header))
            {
                sw.Write(Format.Header + Format.EOL);
            }
            int maxFormats = Format.Formats == null ? 0 : Format.Formats.Length;

            bool   hasTextQ             = Format.TextQualifier != '\0';
            string encodedTextQualifier = "";

            if (hasTextQ)
            {
                if (Format.EncodedTextQualifiers == null)
                {
                    encodedTextQualifier = new string(Format.TextQualifier, 2);
                }
                else
                {
                    encodedTextQualifier = Format.EncodedTextQualifiers;
                }
            }
            var         skipLinesBegining = Format.SkipLinesBeginning + (Format.FirstRowIsHeader ? 1 : 0);
            CultureInfo ci = GetCultureInfo(Format);

            for (int row = _fromRow; row <= _toRow; row++)
            {
                if (row == _fromRow && Format.FirstRowIsHeader)
                {
                    await sw.WriteAsync(WriteHeaderRow(Format, hasTextQ, row, ci)).ConfigureAwait(false);

                    continue;
                }

                if (SkipLines(Format, row, skipLinesBegining))
                {
                    continue;
                }

                for (int col = _fromCol; col <= _toCol; col++)
                {
                    string t = GetText(Format, maxFormats, ci, row, col, out bool isText);

                    if (hasTextQ && isText)
                    {
                        await sw.WriteAsync(Format.TextQualifier + t.Replace(Format.TextQualifier.ToString(), encodedTextQualifier) + Format.TextQualifier).ConfigureAwait(false);
                    }
                    else
                    {
                        await sw.WriteAsync(t).ConfigureAwait(false);
                    }
                    if (col != _toCol)
                    {
                        await sw.WriteAsync(Format.Delimiter).ConfigureAwait(false);
                    }
                }
                if (row != _toRow - Format.SkipLinesEnd)
                {
                    await sw.WriteAsync(Format.EOL).ConfigureAwait(false);
                }
            }
            if (!string.IsNullOrEmpty(Format.Footer))
            {
                await sw.WriteAsync(Format.EOL + Format.Footer).ConfigureAwait(false);
            }
            sw.Flush();
        }
Exemplo n.º 9
0
        /// <summary>
        /// Converts a range to text in CSV format.
        /// Invariant culture is used by default.
        /// </summary>
        /// <param name="file">The file to write to</param>
        /// <param name="Format">Information how to create the csv text</param>
        public async Task SaveToTextAsync(FileInfo file, ExcelOutputTextFormat Format)
        {
            var fileStream = file.Open(FileMode.Create, FileAccess.Write, FileShare.Write);

            await SaveToTextAsync(fileStream, Format).ConfigureAwait(false);
        }
Exemplo n.º 10
0
        /// <summary>
        /// Converts a range to text in CSV format.
        /// Invariant culture is used by default.
        /// </summary>
        /// <param name="file">The file to write to</param>
        /// <param name="Format">Information how to create the csv text</param>
        public void SaveToText(FileInfo file, ExcelOutputTextFormat Format)
        {
            var fileStream = file.Open(FileMode.Create, FileAccess.Write, FileShare.Write);

            SaveToText(fileStream, Format);
        }