Silverlight的DataGrid中:导出到Excel或CSV 3

Silverlight的DataGrid中:导出到Excel或CSV 3,第1张

概述  using System; using System.Windows; using System.Windows.Data; using System.Windows.Media; using System.Windows.Controls; using System.Collections; using System.Collections.Generic; using System.Col  

using System;
using System.windows;
using System.windows.Data;
using System.windows.Media;
using System.windows.Controls;
using System.Collections;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.linq;
using System.Text;
using System.IO;
using System.Reflection;
using System.Xml.linq;

public static class DataGrIDExtensions
{
    public static voID Export(this DataGrID dg)
    {
        ExportDataGrID(dg);//dg is DataGrID name
    }

    public static voID ExportDataGrID(DataGrID dGrID)
    {
        SavefileDialog obJsFD = new SavefileDialog() { DefaultExt = "csv",Filter = "CSV files (*.csv)|*.csv|Excel XML (*.xml)|*.xml|All files (*.*)|*.*",FilterIndex = 1 };
        if (obJsFD.ShowDialog() == true)
        {
            string strFormat = obJsFD.Safefilename.Substring(obJsFD.Safefilename.IndexOf('.') + 1).toupper();
            StringBuilder strBuilder = new StringBuilder();
            if (dGrID.ItemsSource == null) return;
            List<string> lstFIElds = new List<string>();
            if (dGrID.headersVisibility == DataGrIDheadersVisibility.Column || dGrID.headersVisibility == DataGrIDheadersVisibility.All)
            {
                foreach (DataGrIDColumn dgcol in dGrID.Columns)
                    lstFIElds.Add(FormatFIEld(dgcol.header.ToString(),strFormat));
                BuildStringOfRow(strBuilder,lstFIElds,strFormat);
            }
            foreach (object data in dGrID.ItemsSource)
            {
                lstFIElds.Clear();
                foreach (DataGrIDColumn col in dGrID.Columns)
                {
                    string strValue = "";         

总结

以上是内存溢出为你收集整理的Silverlight的DataGrid中:导出到Excel或CSV 3全部内容,希望文章能够帮你解决Silverlight的DataGrid中:导出到Excel或CSV 3所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。

欢迎分享,转载请注明来源:内存溢出

原文地址:https://www.54852.com/web/1073249.html

(0)
打赏 微信扫一扫微信扫一扫 支付宝扫一扫支付宝扫一扫
上一篇 2022-05-26
下一篇2022-05-26

发表评论

登录后才能评论

评论列表(0条)

    保存