DevExpress从SpreadsheetControl拷贝粘贴到richeditcontrol

最新推荐文章于 2022-04-20 11:21:44 发布

jjhua

最新推荐文章于 2022-04-20 11:21:44 发布

阅读量2.9k

点赞数

分类专栏： DevExpress应用

本文链接：https://blog.csdn.net/jjhua/article/details/40020325

版权

DevExpress应用专栏收录该内容

78 篇文章 7 订阅

订阅专栏

            PropertyInfo propertyInfo = spreadsheetControl1.Document.Worksheets[0].Workbook.Options.Export.GetType().GetProperty("Html", BindingFlags.Instance | BindingFlags.NonPublic);
            object value = propertyInfo.GetValue(spreadsheetControl1.Document.Worksheets[0].Workbook.Options.Export, null);

            HtmlDocumentExporterOptions options = propertyInfo.GetValue(spreadsheetControl1.Document.Worksheets[0].Workbook.Options.Export, null) as HtmlDocumentExporterOptions;
            //propertyInfo = options.GetType().GetProperty("Range", BindingFlags.Instance | BindingFlags.NonPublic);
            //propertyInfo.SetValue(options, "$A$1:$B$2", null);

            options.Range = "$A$1:$L$30";
            MemoryStream ms = new MemoryStream();
            ms.Position = 0;

            byte[] bytes = spreadsheetControl1.Document.Worksheets[0].Workbook.SaveDocument(new DocumentFormat(6));
            Encoding encoding = options.Encoding;
            string htmlText = encoding.GetString(bytes);
            richEditControl1.BeginUpdate();
            richEditControl1.Document.InsertHtmlText(richEditControl1.Document.Range.Start, htmlText);
            richEditControl1.EndUpdate();

devexpress 14.1.17