topic Re: How to make Export() is work with ArcGIS API for Silverlight! in ArcGIS API for Silverlight Questions

How to make Export() is work with ArcGIS API for Silverlight!

AnhTruong — Fri, 09 Dec 2011 02:19:35 GMT

Hello ESRI expertise!

I like to export the data query from your ArcGIS API for Silverlight example to Excel.

You can see the data query at:
http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#QueryWithoutMap
to Excel file. In reality, I can export the data from silverlight datagrid using Export() function that you can refer to http://www.codeproject.com/KB/silverlight/SilverlightDataGridExport.aspx?msg=3297287

Please help to figure out how to export it in ArcGIS API for Silverlight??? Thanks.

Re: How to make Export() is work with ArcGIS API for Silverlight!

DominiqueBroux — Fri, 09 Dec 2011 08:01:04 GMT

Darina gave a solution in these threads:
- http://forums.arcgis.com/threads/245...d-Excel-Export
- http://forums.arcgis.com/threads/13460-Export-to-Excel...

Re: How to make Export() is work with ArcGIS API for Silverlight!

AnhTruong — Sat, 10 Dec 2011 11:14:50 GMT

Thank for showing me the example to export ARCGIS query data with Map to Excel. In my case, I need to export ArcGIS query data without map from ArcGIS API for Silverlight that I learn from ArcGIS Resource Center. I am newbie, so I am not confident to make any change from your test code with Map query. Any further help are much appreciated. Thanks.

Darina gave a solution in these threads:
- http://forums.arcgis.com/threads/245...d-Excel-Export
- http://forums.arcgis.com/threads/13460-Export-to-Excel...

Re: How to make Export() is work with ArcGIS API for Silverlight!

AnhTruong — Sun, 18 Dec 2011 02:48:42 GMT

Anyone know to export the QueryWithoutMap datagrid to excel file via Export button? I have read the Darina Tchountcheva FeatureDataGrid Excel Export with map, but I could not figure out how to modify without map in code. I am re-attached link http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#QueryWithoutMap for visualize what I need on data to export. I look forward any helps to solve my issue soon.

Re: How to make Export() is work with ArcGIS API for Silverlight!

DominiqueBroux — Mon, 26 Dec 2011 10:19:13 GMT

I tweaked the Darina's code to get it working with the sample you pointed out.

Attached are the sources and an example of output csv file.

Re: How to make Export() is work with ArcGIS API for Silverlight!

AnhTruong — Tue, 27 Dec 2011 03:07:04 GMT

Hello Dominique,

I really appreciate your time and your ArcGIS expertise to help me out on this issue. Thanks again.

I tweaked the Darina's code to get it working with the sample you pointed out.

Attached are the sources and an example of output csv file.

Re: How to make Export() is work with ArcGIS API for Silverlight!

MaciejGolebiewski — Sun, 12 Dec 2021 16:08:35 GMT

Hello,
I've got an error when implementing the code. 😞
It crashes when I click "Save" in "Save as... dialog", problem lies in this part:

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

The error says: "NullReferenceException was unhandled by user code"
I tried to workaround it this way:

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

But then it underlines "GetValue" and says: "'ESRIMinimalMapApplication3.DataGridExtensions.GetValue(System.Windows.FrameworkElement)': not all code paths return a value"

Please help

Re: How to make Export() is work with ArcGIS API for Silverlight!

DominiqueBroux — Sat, 11 Dec 2021 09:01:25 GMT

But then it underlines "GetValue" and says: "'ESRIMinimalMapApplication3.DataGridExtensions.GetValue(System.Windows.FrameworkElement)': not all code paths return a value"

Please help

Not sure why this method gets called with a null value but to compile it, you need to return a value in case of null value.
Something like:

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

Re: How to make Export() is work with ArcGIS API for Silverlight!

MaciejGolebiewski — Mon, 04 Mar 2013 08:48:19 GMT

Thanks Dominique - that was fast reply!
It works but not completely correct... 😞
It exports only those rows which are currently visible on the screen (5 of them), depending on where I scroll the datagrid, I want it to export all values, even though they are below the scrollbar.
Another problem is that it exports empty XML.
Any solution?
EDIT:
Same situation concerning the values far to the right of the datagrid 😞

Re: How to make Export() is work with ArcGIS API for Silverlight!

DominiqueBroux — Mon, 04 Mar 2013 09:11:32 GMT

There are discussions about enhancements of this program in these threads:
- http://forums.arcgis.com/threads/67767-Export-To-Excel-Downloaded-only-records-in-dialog-view
- http://forums.arcgis.com/threads/63895-Export-To-Excel-Null-Reference-Error

Unfortunately, I am not sure someone published a new version grouping all the fixes.

Re: How to make Export() is work with ArcGIS API for Silverlight!

MaciejGolebiewski — Sat, 11 Dec 2021 09:01:28 GMT

Glad we have you here Dominique!
I encountered another problem when implementing your code (print screen attached).
From where it gets the wrong path? Everything beside this seems to be OK.
I have "graphic.Attributes["NAMN"]" in further code, but it should only add values to query combobox:

private void QueryTask_ExecuteCompleted(object sender, ESRI.ArcGIS.Client.Tasks.QueryEventArgs args)
        {
            FeatureSet featureSet = args.FeatureSet;

            // If initial query to populate states combo box
            if ((args.UserState as string) == "initial")
            {
                // Just show on initial load
                QueryComboBox.Items.Add("Select...");
                
                foreach (Graphic graphic in args.FeatureSet.Features)
                {
                    QueryComboBox.Items.Add(graphic.Attributes["NAMN"].ToString());
                }


                QueryComboBox.SelectedIndex = 0;
                return;
            }

I also changed variable "graphic" to "graphic2" in ExportToExcel part of code, but it still gets wrong Path, just like it's looking in the wrong service.
I have no clue what I'm doing wrong... 😞

Re: How to make Export() is work with ArcGIS API for Silverlight!

DominiqueBroux — Mon, 04 Mar 2013 17:06:59 GMT

It seems Darina gave a fix second post of this thread.
Hopefully it's the same issue as yours.

Re: How to make Export() is work with ArcGIS API for Silverlight!

MaciejGolebiewski — Mon, 04 Mar 2013 20:24:46 GMT

Yes, I'm already using the code corrected by you actually (2nd zip).
Tomorrow I will try the last hope - Darina's suggestion to add "IEnumerable<Graphic> graphics"
If that doesn't work I have no idea how to fix it, I still got no clue why it's getting wrong binding path... 😕

Re: How to make Export() is work with ArcGIS API for Silverlight!

DominiqueBroux — Sat, 11 Dec 2021 09:01:31 GMT

From your screenshot, it seems you are not using the latest version which adds lots of checking.

It should be:

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[path] == null ? string.Empty : graphic.Attributes[path].ToString();
                    }                    
                }                
            }
            return string.Empty;
        }

Re: How to make Export() is work with ArcGIS API for Silverlight!

MaciejGolebiewski — Tue, 05 Mar 2013 09:20:27 GMT

Oh my...
The problem was I specified wrong Binding Path for a column in XAML, it couldn't find the attribute value, because such attribute field doesn't exist in specified service, that's the reason for my NullReference error...
So dumb mistake... :mad:
Sorry for bothering you and many thanks for your effort! 🙂

The problem with XML files is still up-to-date, but they aren't empty as i thought before - maybe it's a problem with my Excel?
Could you please check for me if the XML opens correctly into your Excel? (file attached)