nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Export To Excel - Downloaded only records in dialog view

GreggBreton

Hello,

Working with the Export Utility previously posted:

Export.zip

Customized to perform queries and export records. Notice only records within view of the data grid are actually downloaded. When you scroll down, only records in view are able to be downloaded. Attached are snapshots of examples.

If anyone has ideas on what is transpiring please let me know. I used firebug and all records seems to be downloaded to machine (not just 5, 10, or 15 records- but the entire recordset returned from query), but only those records within view of the dialog box are actually downloaded to csv file. Need to scroll down to actually get addtional records.

XAML and C# code have the same response (used C to query and return 6 states with a C) with the sample data. The screen shots are examples from the customized version that I used for another map service. If there is addtional data scrolling to the left or right, that data is not downloaded only records within view.

Appreciate any input on what on this issue - Thank you

Code Behind:

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using ESRI.ArcGIS.Client;
using ESRI.ArcGIS.Client.Tasks;

namespace ExportTest
{
    public partial class MainPage : UserControl
    {
        public MainPage()
        {
            InitializeComponent();
        }

        void QueryButton_Click(object sender, RoutedEventArgs e)
        {
            QueryTask queryTask =
                new QueryTask("http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Demographics/ESRI_Census_USA/MapServer/5");
            queryTask.ExecuteCompleted += QueryTask_ExecuteCompleted;
            queryTask.Failed += QueryTask_Failed;

            ESRI.ArcGIS.Client.Tasks.Query query = new ESRI.ArcGIS.Client.Tasks.Query();
            query.Text = StateNameTextBox.Text;

            query.OutFields.Add("*");
            queryTask.ExecuteAsync(query);
        }
        void QueryTask_ExecuteCompleted(object sender, ESRI.ArcGIS.Client.Tasks.QueryEventArgs args)
        {
            FeatureSet featureSet = args.FeatureSet;

            if (featureSet != null && featureSet.Features.Count > 0)
            {
                QueryDetailsDataGrid.ItemsSource = args.FeatureSet;
            }
            else
                MessageBox.Show("No features returned from query");
        }

        private void QueryTask_Failed(object sender, TaskFailedEventArgs args)
        {
            MessageBox.Show("Query execute error: " + args.Error);
        }
        private void Excel_Click(object sender, RoutedEventArgs e)
        {

            DataGridExtensions.ExportDataGrid(QueryDetailsDataGrid, null);
        }

    }

    public static class DataGridExtensions
    {
        public static void Export(this DataGrid dg, List<string> excludedColumns)
        {
            ExportDataGrid(dg, excludedColumns);
        }

        public static void ExportDataGrid(DataGrid dGrid, List<string> excludedColumns)
        {
            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;
                if (dGrid.HeadersVisibility == DataGridHeadersVisibility.Column || dGrid.HeadersVisibility == DataGridHeadersVisibility.All)
                {
                    var listFields = from col in dGrid.Columns
                                     where excludedColumns == null || !excludedColumns.Contains(col.Header.ToString())
                                     select col.Header.ToString();

                    BuildStringOfRow(strBuilder, listFields, strFormat);
                }
                foreach (Graphic data in dGrid.ItemsSource)
                {
                    var listFields = from col in dGrid.Columns
                                     where excludedColumns == null || !excludedColumns.Contains(col.Header.ToString())
                                     select GetValue(col.GetCellContent(data));

                    BuildStringOfRow(strBuilder, listFields, strFormat);
                }
                StreamWriter sw = new StreamWriter(objSFD.OpenFile());
                if (strFormat == "XML")
                {
                    //Let us write the headers for the Excel XML
                    sw.WriteLine("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
                    sw.WriteLine("<?mso-application progid=\"Excel.Sheet\"?>");
                    sw.WriteLine("<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\">");
                    sw.WriteLine("<DocumentProperties xmlns=\"urn:schemas-microsoft-com:office:office\">");
                    sw.WriteLine("<Author>Arasu Elango</Author>");
                    sw.WriteLine("<Created>" + DateTime.Now.ToLocalTime().ToLongDateString() + "</Created>");
                    sw.WriteLine("<LastSaved>" + DateTime.Now.ToLocalTime().ToLongDateString() + "</LastSaved>");
                    sw.WriteLine("<Company>Atom8 IT Solutions (P) Ltd.,</Company>");
                    sw.WriteLine("<Version>12.00</Version>");
                    sw.WriteLine("</DocumentProperties>");
                    sw.WriteLine("<Worksheet ss:Name=\"Silverlight Export\" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\">");
                    sw.WriteLine("<Table>");
                }
                sw.Write(strBuilder.ToString());
                if (strFormat == "XML")
                {
                    sw.WriteLine("</Table>");
                    sw.WriteLine("</Worksheet>");
                    sw.WriteLine("</Workbook>");
                }
                sw.Close();
            }
        }

        private static string GetValue(FrameworkElement frameworkElement)
        {
            return frameworkElement == null ? null
       : (frameworkElement is TextBlock ? (frameworkElement as TextBlock).Text : frameworkElement.ToString());

        }

        private static void BuildStringOfRow(StringBuilder strBuilder, IEnumerable<string> lstFields, string strFormat)
        {
            switch (strFormat)
            {
                case "XML":
                    strBuilder.AppendLine("<Row>");
                    strBuilder.AppendLine(String.Join("", lstFields.ToArray()));
                    strBuilder.AppendLine("</Row>");
                    break;
                case "CSV":
                    strBuilder.AppendLine(String.Join(",", lstFields.ToArray()));
                    break;
            }
        }
        private static string FormatField(string data, string format)
        {
            switch (format)
            {
                case "XML":
                    return String.Format("<Cell><Data ss:Type=\"String\">{0}</Data></Cell>", data);
                case "CSV":
                    return String.Format("\"{0}\"", data.Replace("\"", "\"\"\"").Replace("\n", "").Replace("\r", ""));
            }
            return data;
        }
    }
}

QueryExportReturnExcelScroll.jpg

QueryExportReturn.jpg

QueryExportReturnExcel.jpg

QueryExportReturnScroll.jpg

XAML.txt.zip

KerryKang_2-1784924100715.png

KerryKang_1-1784924079462.png

Laura_0-1784924055631.png

jcarlson_2-1623289117638.png

KerryKang_0-1784924020493.png

Vind meer berichten getagd met

Accepted answers

DarinaTchountcheva

Dominique, thanks for the solution! 😄
I think Gregg is getting the error when the attribute object is null (see image).

Greg, something like this should fix the problem (make sure you are using the new GetValue method that Dominique provided):

private static string GetValue(DataGridColumn col, Graphic graphic) {  if (col is DataGridBoundColumn)  {   var path = (col as DataGridBoundColumn).Binding.Path.Path;   var att = Regex.Replace(path, ".*\\[(.*)\\]", "$1");   return graphic.Attributes[att] == null ? string.Empty : graphic.Attributes[att].ToString();  }  return string.Empty; }

All comments

Anonymous User

Original User: darinatch

Hi Gregg,

It seems like the col.GetCellContent(data) in

var listFields = from col in dGrid.Columns
                                     where excludedColumns == null || !excludedColumns.Contains(col.Header.ToString())
                                     select GetValue(col.GetCellContent(data));

might be the problem.

The GetCellContent method returns a TextBlock, but the Text property of this TextBlock is an empty string once it hits cells that are not visible.
Try using the Graphic object, which represents each row of the grid to create a row for the export document.

DarinaTchountcheva

Gregg,

Here is my version of that portion of the code (Not as clean and elegant as yours, but works for me. Feel free to modify it and make it better using Linq if you would like. But this is the idea. ;-)) :

foreach (Graphic data in dGrid.ItemsSource)
                {
                    lstFields.Clear();
                    foreach (DataGridColumn col in dGrid.Columns)
                    {
                        string tempString = null;
                        if (col is DataGridTextColumn)
                        {
                            tempString = ((DataGridTextColumn)col).Binding.Path.Path.ToString();
                        }
                        else if (col is DataGridTemplateColumn)
                        {
                            //This is the case when the column has a hyperlink in the cell template
                            HyperlinkButton innerControl = ((DataGridTemplateColumn)col).CellTemplate.LoadContent() as HyperlinkButton;
                            if (innerControl != null)
                                tempString = innerControl.GetBindingExpression(HyperlinkButton.ContentProperty).ParentBinding.Path.Path.ToString();
                            else
                                tempString = string.Empty;
                        }

                        string attributeName = tempString.Replace("Attributes[", "").Replace("]", "");
                        string strValue = string.Empty;

                        if (excludedColumns != null)
                        {
                            foreach (string columnName in excludedColumns)
                            {
                                if (col.Header.ToString() == columnName)
                                {
                                    continue;
                                }
                                else
                                {
                                    if (data.Attributes[attributeName] != null)
                                        strValue = data.Attributes[attributeName].ToString();
                                    lstFields.Add(FormatField(strValue, strFormat));
                                }
                            }
                        }
                        else
                        {
                            if (data.Attributes[attributeName] != null)
                                strValue = data.Attributes[attributeName].ToString();
                            lstFields.Add(FormatField(strValue, strFormat));
                        }
                    }                   

                    BuildStringOfRow(strBuilder, lstFields, strFormat);
                }

Good Luck!

Anonymous User

Original User: gregg.breton

Hello Darina

I will give that a try - I am new to Silverlight, so the pretty code is not mine 🙂

I retrieved it from Export.zip

Dominique BROUX was nice enough to have customized the code and provide it to the Silverlight forum.

New to the forum- How were you able to post the code with the scroll bars? Much nicer than the code tags I used

I will try your idea and let you know how i do - thank you

DarinaTchountcheva

Gregg,

When you write your post, you will see a set of toolbars on the top. Hover over each tool to see what it does.
To post C# code, use the "#" tool. You will see the CODE tag. Paste your code in between the opening and closing tag. That's all.

Dominique is great! He is probably already looking into this. 😉

Anonymous User

Original User: gregg.breton

Thank you Darina,

I was not able to integrate your example into the Export solultion provided by Dominque. I will keep trying and like you said maybe Dominque will provide some insight to this issue.

DominiqueBroux

I updated the sample to fix the issue :

QueryWithoutMap.zip

Anonymous User

Original User: gregg.breton

Hello Dominque,

Opened up the QueryWithoutMap.zip and it contained the XAML(QueryWithoutMap.XAML), but the code behind was code for QueryRelatedRecords example (QueryRelatedRecords.xaml.cs).

Gregg

DominiqueBroux

Sorry I zipped the wrong file :

QueryWithoutMap.zip

Anonymous User

Original User: gregg.breton

Hello Dominque,

I get that null reference error. Tried your your solution from the previous post

private static string GetValue(FrameworkElement frameworkElement)
{
    return frameworkElement == null ? null
          frameworkElement is TextBlock ? (frameworkElement as TextBlock).Text : frameworkElement.ToString());
}

NullReferenceError.jpg

DominiqueBroux

In my latter version, I changed GetValue, it's now:

private static string GetValue(DataGridColumn col, Graphic graphic)
{
 if (col is DataGridBoundColumn)
 {
  var path = (col as DataGridBoundColumn).Binding.Path.Path;
  var att = Regex.Replace(path, ".*\\[(.*)\\]", "$1");
  return graphic.Attributes[att].ToString();
 }
 return string.Empty;
}

so it should solve your issue.

Anonymous User

Original User: gregg.breton

Dominque,

I utilized the updated sample and is works, and when I implement to try another application (Have null value?)

[ATTACH=CONFIG]18080[/ATTACH]

I just downloaded to make sure I am using the updated example

 if (col is DataGridBoundColumn)
            {
                var path = (col as DataGridBoundColumn).Binding.Path.Path;
                var att = Regex.Replace(path, ".*\\[(.*)\\]", "$1");
                return graphic.Attributes[att].ToString();
            }
            return string.Empty;

Still receiving that null reference error

If you need the reference webservice need more information just let me know. I have your previous sample working, but again just was not able to download all records, only those that were displayed in the window.

NullReferenceError.jpg

DarinaTchountcheva

private static string GetValue(DataGridColumn col, Graphic graphic) {  if (col is DataGridBoundColumn)  {   var path = (col as DataGridBoundColumn).Binding.Path.Path;   var att = Regex.Replace(path, ".*\\[(.*)\\]", "$1");   return graphic.Attributes[att] == null ? string.Empty : graphic.Attributes[att].ToString();  }  return string.Empty; }

Anonymous User

Original User: gregg.breton

Yes, that fixed the null reference error Darina!

Dominique thank you 😄 for the Export solution

GreggBreton

Darina,

Now that I got the DataGrid to work with the query, I wanted to do the same with the FeatureDataGrid

On this export to excel issue - "null reference error" you posted a solution file for a feature data grid using california.

Downloaded and replaced the dll's got it working with the sample data you used (California), customized to the same data I used above, and of course received a null reference error.

[ATTACH=CONFIG]18090[/ATTACH]

Would you be able to comment on how you would trap the null references in your original code?

NullReferenceError_FDG.jpg

Anonymous User

Original User: darinatch

Hi Gregg,

Looking at the code, I believe you need to change these lines in "public void ExportData(List<Graphic> graphics, string[] fields, string[] aliases)":

string strValue = string.Empty;
strValue = data.Attributes[field].ToString();

with this line:

string strValue = data.Attributes[field] != null ? data.Attributes[field].ToString() : string.Empty;

And change these lines in "public void ExportData(List<Graphic> graphics, ObservableCollection<DataGridColumn> columns)":

string strValue = string.Empty;
strValue = data.Attributes[field.Header.ToString()].ToString();

with this line:

string strValue = data.Attributes[field.Header.ToString()] != null ? data.Attributes[field.Header.ToString()].ToString() : string.Empty;

You could use Dominiques code for the FeatureDataGrid too with some little changes.
This is how your class would look like. The extra parameter "graphics" is added so you can export the selected graphics if this is what you want.

public static class DataGridExtensions
    {
        //added the extra parameter
        public static void Export(this FeatureDataGrid dg, IEnumerable<Graphic> graphics, List<string> excludedColumns)
        {
            ExportDataGrid(dg, graphics, excludedColumns);
        }

        //added the extra parameter
        public static void ExportDataGrid(FeatureDataGrid dGrid, IEnumerable<Graphic> graphics, List<string> excludedColumns)
        {
            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;
                if (dGrid.HeadersVisibility == DataGridHeadersVisibility.Column || dGrid.HeadersVisibility == DataGridHeadersVisibility.All)
                {
                    var listFields = from col in dGrid.Columns
                                     where excludedColumns == null || !excludedColumns.Contains(col.Header.ToString())
                                     select col.Header.ToString();

                    BuildStringOfRow(strBuilder, listFields, strFormat);
                }
                //this line changed a little
                foreach (Graphic graphic in graphics)
                {
                    var listValues = from col in dGrid.Columns
                                     where excludedColumns == null || !excludedColumns.Contains(col.Header.ToString())
                                     select GetValue(col, graphic);

                    BuildStringOfRow(strBuilder, listValues, strFormat);
                }
                StreamWriter sw = new StreamWriter(objSFD.OpenFile());
                if (strFormat == "XML")
                {
                    //Let us write the headers for the Excel XML
                    sw.WriteLine("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
                    sw.WriteLine("<?mso-application progid=\"Excel.Sheet\"?>");
                    sw.WriteLine("<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\">");
                    sw.WriteLine("<DocumentProperties xmlns=\"urn:schemas-microsoft-com:office:office\">");
                    sw.WriteLine("<Author>Arasu Elango</Author>");
                    sw.WriteLine("<Created>" + DateTime.Now.ToLocalTime().ToLongDateString() + "</Created>");
                    sw.WriteLine("<LastSaved>" + DateTime.Now.ToLocalTime().ToLongDateString() + "</LastSaved>");
                    sw.WriteLine("<Company>Atom8 IT Solutions (P) Ltd.,</Company>");
                    sw.WriteLine("<Version>12.00</Version>");
                    sw.WriteLine("</DocumentProperties>");
                    sw.WriteLine("<Worksheet ss:Name=\"Silverlight Export\" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\">");
                    sw.WriteLine("<Table>");
                }
                sw.Write(strBuilder.ToString());
                if (strFormat == "XML")
                {
                    sw.WriteLine("</Table>");
                    sw.WriteLine("</Worksheet>");
                    sw.WriteLine("</Workbook>");
                }
                sw.Close();
            }
        }

        private static string GetValue(DataGridColumn col, Graphic graphic)
        {
            if (col is DataGridBoundColumn)
            {
                var path = (col as DataGridBoundColumn).Binding.Path.Path;
                var att = Regex.Replace(path, ".*\\[(.*)\\]", "$1");
                return graphic.Attributes[att].ToString();
            }
            return string.Empty;
        }

        private static void BuildStringOfRow(StringBuilder strBuilder, IEnumerable<string> lstFields, string strFormat)
        {
            switch (strFormat)
            {
                case "XML":
                    strBuilder.AppendLine("<Row>");
                    strBuilder.AppendLine(String.Join("", lstFields.ToArray()));
                    strBuilder.AppendLine("</Row>");
                    break;
                case "CSV":
                    strBuilder.AppendLine(String.Join(",", lstFields.ToArray()));
                    break;
            }
        }
        private static string FormatField(string data, string format)
        {
            switch (format)
            {
                case "XML":
                    return String.Format("<Cell><Data ss:Type=\"String\">{0}</Data></Cell>", data);
                case "CSV":
                    return String.Format("\"{0}\"", data.Replace("\"", "\"\"\"").Replace("\n", "").Replace("\r", ""));
            }
            return data;
        }
    }

And then make these chanes in the event handlers to do the export:

//handle the Export All To Excel click
        private void exportAll_Click(object sender, RoutedEventArgs e)
        {
            FeatureLayer fe = (FeatureLayer)MyMap.Layers["California"];
            //ete.ExportData(fe.Graphics.ToList(), MyDataGrid.Columns);

            MyDataGrid.Export(fe.Graphics, null);
        }

        private void exportSelected_Click(object sender, RoutedEventArgs e)
        {
            FeatureLayer fe = (FeatureLayer)MyMap.Layers["California"];
            //ete.ExportData(fe.SelectedGraphics.ToList(), MyDataGrid.Columns);

            MyDataGrid.Export(fe.SelectedGraphics.ToList(), null);
        }

Good Luck!

GreggBreton

Hello Darina,

Entered those lines to change your existing code and it fixed the error and allowed me to download the excel file. Tried all three exports (Export All To Excel, Export Selected To Excel, Export Alias to Excel)

The downloaded excel files were empty with the field headings?

[ATTACH=CONFIG]18116[/ATTACH]

[ATTACH=CONFIG]18117[/ATTACH]

[ATTACH=CONFIG]18118[/ATTACH]

Records were downloaded to Feature Data Grid, and I know the code works with your sample from California. What is next?

Keep working on it and let you know Thank you Darina

Original User: darinatch

Gregg,

You probably have aliases set for the fields in your ArcMap document. And that is great.
Just the sample is old, and doesn't cover this scenario.

That's why you should use Dominique's solution. It is better!

I changed the sample to use Dominique's code. I commented out the code that you don't need anymore. Delete it.
Dominique's code is in the DataGridExtensions class. I made 2 changes to it. I used the FormatField method in 2 places to cover the scenario when a comma exists in the field value, and the user is exporting to CSV.

There is no more button to export fields with Aliases, because you can set your aliases in ArcMap and they get exported. Instead there is a button Export Only Some Columns to show you how to exclude some columns from the export if you don't want all of them.

The ExportToExcel class is still there, but you don't need it anymore. You can delete it.

I hope all works for you. If not, just post back. I will look at it tomorrow.

Good Luck!

Darina

TestDynamicLayer.zip

GreggBreton

Darina,

Ok, downloaded sample got it working with the California data

Customized to the my new feature service and came up with that nasty null reference error again

[ATTACH=CONFIG]18122[/ATTACH]

Made the edit from the previous post to ty and fix the null reference error

return graphic.Attributes[att] == null ? string.Empty : graphic.Attributes[att].ToString();

ran again and still come up with that error. - getting real close though samples load, sln file compiles just that nasty null reference error.

[ATTACH=CONFIG]18123[/ATTACH]

NullRefError.jpg

FDG_Export2.jpg

Anonymous User

Original User: dbroux

Null reference error should usually by very simple to fix with a debugger.

Look at the object that is null and add a check to avoid that case.

GreggBreton

Hello Dominique,

Just learning the debugging tools and the basics

so in this null reference error from the previous post, the object is var path?

and the check would be

return graphic.Attributes[path] == null ? string.Empty : graphic.Attributes[path].ToString();

referencing the previous check for [att], and it would be the same concept?

Thank you

Anonymous User

Original User: darinatch

Hi Gregg,

I am not sure why you get a null reference error there, but try using this GetValue method. It checks for most of the objects to see if they are null:

private static string GetValue(DataGridColumn col, Graphic graphic)
        {
            if (col is DataGridBoundColumn)
            {
                DataGridBoundColumn column = col as DataGridBoundColumn;
                if ((column.Binding != null) && (column.Binding.Path != null))
                {
                    string path = column.Binding.Path.Path;
                    if (!string.IsNullOrEmpty(path))
                    {
                        var att = Regex.Replace(path, ".*\\[(.*)\\]", "$1");
                        return graphic.Attributes[att].ToString();
                    }                    
                }                
            }
            return string.Empty;
        }

You should figure out what column is giving you the error though.
Look at the image below.

[ATTACH=CONFIG]18146[/ATTACH]

Add a break point by clicking on the grey line on the left where the red dot is. You will get the same red dot and red background for the line. Hit F5 to start debugging. Click a button to export some data (use a selection with 1-2 records only), and when you hit the break point a yellow line will appear on the break line. Use F10 to step through the code inside the method. Inspect the values of the variables in the Locals window as show in the image. You can also see their values by hoovering over a variable in the code window. Use F5 to continue. This will let you step through this code for every cell value in the grid, and will help you determine the column(s) that throw the exception.

In the Locals window you can see the properties of the objects by clicking on the plus sign. See image. The Path object is the one you are probably interested in.

Once you know what column is the problem, you might be able to fix the problem. It could be the special characters you have as field aliases (just a guess).

Search the web and/or Visual Studio help for how to debug applications. The above steps are only to give some heads up. 😄

Good Luck!

Debugging.png

GreggBreton

Hello Darina,

Servers are down for maintenance, so when they become available I will debug and let you know how I do

I would like to get the DataGridExtension you set up with Dominique's solution

Thank you for the assistance 🙂

Anonymous User

Original User: gregg.breton

Hello Darina,

Servers are up and running

It looks like Dissolved_Oxygen

[ATTACH=CONFIG]18237[/ATTACH]

How to trap a null reference for a particular field?

DissolvedOxygen.jpg

NoOverloadTakesTwoArguments.jpg

Anonymous User

Original User: darinatch

Hi Gregg,

Replace:

return graphic.Attributes[att].ToString();

With:

return graphic.Attributes[att] == null ? string.Empty : graphic.Attributes[att].ToString();

I am sorry, I forgot to make this change. This should fix the first error.

What version of the DataGridExtensions.cs are you using? The DataGridExtensions.cs should look like this (this is the version in the project I posted a few days ago):

public static class DataGridExtensions
    {

        public static void Export(this FeatureDataGrid dg, IEnumerable<Graphic> graphics, List<string> excludedColumns)
        {
            ExportDataGrid(dg, graphics, excludedColumns);
        }

        public static void ExportDataGrid(FeatureDataGrid dGrid, IEnumerable<Graphic> graphics, List<string> excludedColumns)
        {
            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;
                if (dGrid.HeadersVisibility == DataGridHeadersVisibility.Column || dGrid.HeadersVisibility == DataGridHeadersVisibility.All)
                {
                    var listFields = from col in dGrid.Columns
                                     where excludedColumns == null || !excludedColumns.Contains(col.Header.ToString())
                                     select FormatField(col.Header.ToString(), strFormat);

                    BuildStringOfRow(strBuilder, listFields, strFormat);
                }
                foreach (Graphic graphic in graphics)
                {
                    var listValues = from col in dGrid.Columns
                                     where excludedColumns == null || !excludedColumns.Contains(col.Header.ToString())
                                     select FormatField(GetValue(col, graphic), strFormat);

                    BuildStringOfRow(strBuilder, listValues, strFormat);
                }
                StreamWriter sw = new StreamWriter(objSFD.OpenFile());
                if (strFormat == "XML")
                {
                    //Let us write the headers for the Excel XML
                    sw.WriteLine("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
                    sw.WriteLine("<?mso-application progid=\"Excel.Sheet\"?>");
                    sw.WriteLine("<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\">");
                    sw.WriteLine("<DocumentProperties xmlns=\"urn:schemas-microsoft-com:office:office\">");
                    sw.WriteLine("<Author>Arasu Elango</Author>");
                    sw.WriteLine("<Created>" + DateTime.Now.ToLocalTime().ToLongDateString() + "</Created>");
                    sw.WriteLine("<LastSaved>" + DateTime.Now.ToLocalTime().ToLongDateString() + "</LastSaved>");
                    sw.WriteLine("<Company>Atom8 IT Solutions (P) Ltd.,</Company>");
                    sw.WriteLine("<Version>12.00</Version>");
                    sw.WriteLine("</DocumentProperties>");
                    sw.WriteLine("<Worksheet ss:Name=\"Silverlight Export\" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\">");
                    sw.WriteLine("<Table>");
                }
                sw.Write(strBuilder.ToString());
                if (strFormat == "XML")
                {
                    sw.WriteLine("</Table>");
                    sw.WriteLine("</Worksheet>");
                    sw.WriteLine("</Workbook>");
                }
                sw.Close();
            }
        }

        private static string GetValue(DataGridColumn col, Graphic graphic)
        {
            if (col is DataGridBoundColumn)
            {
                DataGridBoundColumn column = col as DataGridBoundColumn;
                if ((column.Binding != null) && (column.Binding.Path != null))
                {
                    string path = column.Binding.Path.Path;
                    if (!string.IsNullOrEmpty(path))
                    {
                        var att = Regex.Replace(path, ".*\\[(.*)\\]", "$1");
                        return graphic.Attributes[att].ToString();
                    }                    
                }                
            }
            return string.Empty;
        }

        private static void BuildStringOfRow(StringBuilder strBuilder, IEnumerable<string> lstFields, string strFormat)
        {
            switch (strFormat)
            {
                case "XML":
                    strBuilder.AppendLine("<Row>");
                    strBuilder.AppendLine(String.Join("", lstFields.ToArray()));
                    strBuilder.AppendLine("</Row>");
                    break;
                case "CSV":
                    strBuilder.AppendLine(String.Join(",", lstFields.ToArray()));
                    break;
            }
        }

        private static string FormatField(string data, string format)
        {
            switch (format)
            {
                case "XML":
                    return String.Format("<Cell><Data ss:Type=\"String\">{0}</Data></Cell>", data);
                case "CSV":
                    return String.Format("\"{0}\"", data.Replace("\"", "\"\"\"").Replace("\n", "").Replace("\r", ""));
            }
            return data;
        }
    }

Hope, this fixes the second error.

Darina

GreggBreton

Hello Darina,

That fixed the error 😄 😄

Thank you for all of your help

Anonymous User

Original User: bcales

The XML file opens up blank, in Excel, however the file itself if opened in notepad has the data. Also, Is there a way to handle fields that are multi-line.

e.g. I customed the output like this to have the Address lumped together, but when opening in Excel, it's single

resultFeature.Attributes.Add("OWNADDRESS_FULL",
                            resultFeature.Attributes["OWNADDRESS"] + "\r" + (resultFeature.Attributes["OWNCITYST"] + " " + resultFeature.Attributes["OWNZIPCODE"]).Trim()); // + "\r" + resultFeature.Attributes["OWNCOUNTRY"]);

BobNichols

Sorry I zipped the wrong file :

First off, thank you for providing this code. It works pretty well for me if I am not exporting more than 10-15 records at a time. Anymore than that then it starts either dropping data or wont save. Screencap of an exported csv. Are there limits to how much data can be exported? I have found that if I export data from a datagrid that has fewer columns I am able to export more records before it either doesn't work or stops populating columns.

[ATTACH=CONFIG]32152[/ATTACH]

Here is a screencap of the datagrid that I am exporting from.

[ATTACH=CONFIG]32153[/ATTACH]

Thanks in advance for the help!

grid.JPG

csverror.JPG

BobNichols

First off, thank you for providing this code. It works pretty well for me if I am not exporting more than 10-15 records at a time. Anymore than that then it starts either dropping data or wont save. Screencap of an exported csv. Are there limits to how much data can be exported? I have found that if I export data from a datagrid that has fewer columns I am able to export more records before it either doesn't work or stops populating columns.

Never mind everything is working like it is supposed to. I just received a new workstation from IT and its setup to not check for new webpages every time you visit a page. So my app is running on an old broken version. And the best part, all of the browser settings are locked so I cant change them or even clear the cache. Makes web development a little hard to troubleshoot... 😞

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.