コード例 #1
0
        public DataTable GetSpreadTable(string tableName, SpreadsheetWithCopyToBookOptions options = null)
        {
            DataTable result = null;

            ExecuteSynchronized(options, () => DoGetSpreadTable(options, tableName, out result));
            return(result);
        }
コード例 #2
0
        protected virtual void DoGetSpreadTable(SpreadsheetWithCopyToBookOptions options, string tableName, out DataTable result)
        {
            var spread = options?.Spreadsheet?.Workbook ?? Workbook;

            var range = SpreadsheetUtils.GetWorkbookRange(spread, tableName);

            result = SpreadsheetUtils.GetDataTable(range);

            CopyRangeToBook(range, options);
            AddComments(range, options.Comment);
        }
コード例 #3
0
        protected void CopyRangeToBook(CellRange range, SpreadsheetWithCopyToBookOptions options)
        {
            options.CopyToBook |= (options.TargetBook != null);
            if (!options.CopyToBook)
            {
                return;
            }

            var book = options.TargetBook?.Document ?? Host?.Book?.Document;

            if (book == Host?.Book?.Document)
            {
                base.ExecuteSynchronized(() => DoCopyRangeToBook(range, book, options));
            }
            else
            {
                DoCopyRangeToBook(range, book, options);
            }
        }
コード例 #4
0
        protected void CopyImageToBook(Image image, float?scaleX, float?scaleY, SpreadsheetWithCopyToBookOptions options)
        {
            options.CopyToBook |= (options.TargetBook != null);
            if (!options.CopyToBook)
            {
                return;
            }

            var book = options.TargetBook?.Document ?? Host?.Book?.Document;

            if (book == Host?.Book?.Document)
            {
                base.ExecuteSynchronized(() => DoCopyImageToBook(image, book, scaleX, scaleY, options));
            }
            else
            {
                DoCopyImageToBook(image, book, scaleX, scaleY, options);
            }
        }
コード例 #5
0
        protected virtual void DoCopyRangeToBook(CellRange range, Document book, SpreadsheetWithCopyToBookOptions options)
        {
            string htmlTable;

            var sheet    = range.Worksheet;
            var workbook = sheet.Workbook;

            var htmlOptions = new DevExpress.XtraSpreadsheet.Export.HtmlDocumentExporterOptions()
            {
                SheetIndex = workbook.Sheets.IndexOf(sheet),
                Range      = range.Worksheet.GetDataRange().GetReferenceA1(),
                Encoding   = Encoding.Unicode
            };

            using (var stream = new MemoryStream())
            {
                workbook.ExportToHtml(stream, htmlOptions);
                stream.Seek(0, SeekOrigin.Begin);

                using var reader = new StreamReader(stream, Encoding.UTF8);
                htmlTable        = reader.ReadToEnd();
            }

            using (new UsingProcessor(() => book.BeginUpdate(), () => book.EndUpdate()))
            {
                var documentRange = book.AppendHtmlText(htmlTable, DevExpress.XtraRichEdit.API.Native.InsertOptions.KeepSourceFormatting);
                book.Paragraphs.Append();

                if (options.RepeatAsHeaderRow || options.BreakRowsAcrossPages)
                {
                    options.RepeatAsHeaderRowCount = Utils.ValueInRange(options.RepeatAsHeaderRowCount, 1, 100);

                    var tables = book.Tables.Get(documentRange);
                    foreach (var table in tables)
                    {
                        using (new UsingProcessor(() => table.BeginUpdate(), () => table.EndUpdate()))
                        {
                            if (options.RepeatAsHeaderRow)
                            {
                                for (int i = 0; i < Math.Max(options.RepeatAsHeaderRowCount, table.Rows.Count); i++)
                                {
                                    table.Rows[i].RepeatAsHeaderRow = true;
                                }
                            }

                            if (options.BreakRowsAcrossPages)
                            {
                                for (int i = 0; i < table.Rows.Count; i++)
                                {
                                    table.Rows[i].BreakAcrossPages = true;
                                }
                            }
                        }
                    }
                }


                AddBookComments(book, documentRange, options);

                book.CaretPosition = documentRange.End;
                ScrollToCaret();
            }
        }
コード例 #6
0
        protected static void AddBookComments(Document book, DocumentRange range, SpreadsheetWithCopyToBookOptions options)
        {
            var comment = options.BookComment;

            if (!string.IsNullOrWhiteSpace(comment))
            {
                var bookComment = book.Comments.Create(range, Environment.UserName);
                var docComment  = bookComment.BeginUpdate();
                try
                {
                    if (options.BookCommentHtml)
                    {
                        docComment.AppendHtmlText(comment, InsertOptions.KeepSourceFormatting);
                    }
                    else
                    {
                        docComment.AppendText(comment);
                    }
                }
                finally
                {
                    bookComment.EndUpdate(docComment);
                }
            }

            var bookmark = options.BookBookmark;

            if (!string.IsNullOrWhiteSpace(bookmark))
            {
                var oldBookmark = book.Bookmarks[bookmark];
                if (oldBookmark != null)
                {
                    book.Bookmarks.Remove(oldBookmark);
                }

                book.Bookmarks.Create(range, bookmark);
            }

            var hyperlink = options.BookHyperlink;

            if (!string.IsNullOrWhiteSpace(hyperlink))
            {
                var hyperlinkBookmark = book.Bookmarks[hyperlink];
                var link = book.Hyperlinks.Create(range);
                if (hyperlinkBookmark != null)
                {
                    link.Anchor = hyperlinkBookmark.Name;
                }
                else
                {
                    link.NavigateUri = hyperlink;
                }

                if (!string.IsNullOrWhiteSpace(options.BookHyperlinkTooltip))
                {
                    link.ToolTip = options.BookHyperlinkTooltip;
                }

                if (!string.IsNullOrWhiteSpace(options.BookHyperlinkTarget))
                {
                    link.Target = options.BookHyperlinkTarget;
                }
            }
        }
コード例 #7
0
        protected virtual void DoCopyImageToBook(Image image, Document book, float?scaleX, float?scaleY, SpreadsheetWithCopyToBookOptions options)
        {
            using (new UsingProcessor(() => book.BeginUpdate(), () => book.EndUpdate()))
            {
                var docImage = book.Images.Append(image);

                if (scaleX.HasValue)
                {
                    docImage.ScaleX = scaleX.Value;
                }
                if (scaleY.HasValue)
                {
                    docImage.ScaleY = scaleY.Value;
                }

                book.Paragraphs.Append();

                AddBookComments(book, docImage.Range, options);

                book.CaretPosition = docImage.Range.End;
                Book.SCBook.ResetBookFormatting(book, book.CaretPosition);
                ScrollToCaret();
            }
        }