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; } } }

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

AnhTruong

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.

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

DominiqueBroux

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...

AnhTruong

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...

AnhTruong

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.

DominiqueBroux

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.

Export.zip

QueryWithoutMap.zip

AnhTruong

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.

MaciejGolebiewski

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

DominiqueBroux

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;
        }

MaciejGolebiewski

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 😞

DominiqueBroux

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.

MaciejGolebiewski

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... 😞

wrongpath.jpg

DominiqueBroux

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

MaciejGolebiewski

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... 😕

DominiqueBroux

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;
        }

MaciejGolebiewski

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)

export.zip

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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