topic Re: How to export attributes to excel in ArcGIS API for Silverlight Questions

How to export attributes to excel

DonFreeman — Tue, 15 Feb 2011 13:51:06 GMT

Can someone point me to instructions on how to export a FeatureLayer's attribute table to an excel or CSV file?
Thanks

Re: How to export attributes to excel

JMcNeil — Tue, 15 Feb 2011 22:48:59 GMT

I have a python scipt to export selected records from a GP service/task to a excel and then I serve the excel up as a zip download. Not exactly what you need and not as clean as you want it to be but say the word and it is yours!

Re: How to export attributes to excel

DonFreeman — Wed, 16 Feb 2011 13:05:45 GMT

I have a python scipt to export selected records from a GP service/task to a excel and then I serve the excel up as a zip download. Not exactly what you need and not as clean as you want it to be but say the word and it is yours!

Hmmm. . .
And this can be triggered from a Silverlight page?
Actually, I already have a routine that I like but which requires a data context. I don't know how to create a data context for my FeatureLayer. I'm still too new to all this stuff. (shrug)

Re: How to export attributes to excel

DavidAshton — Wed, 23 Feb 2011 15:45:01 GMT

dfreeman2005
Have you seen this post?
http://forums.arcgis.com/threads/13460-Export-to-Excel...?p=79906#post79906

I'm trying to get this code working and was wondering if you saw this and/or if you have had any success with your efforts.

Dave

Re: How to export attributes to excel

DonFreeman — Wed, 23 Feb 2011 16:23:30 GMT

Hmmm. . .
And this can be triggered from a Silverlight page?
Actually, I already have a routine that I like but which requires a data context. I don't know how to create a data context for my FeatureLayer. I'm still too new to all this stuff. (shrug)

No success yet. We broke the SQL/SDE install so right now that has my attention. (groan)

Re: How to export attributes to MS word

pavankalvala — Tue, 26 Apr 2011 19:10:42 GMT

I am trying to export attributes of a feature to MS word. I created a Microsoft word template with a table that has attribute field names to the left and onto the right, I would like to pass the values that are related to that field in Word.

Please let me know.

I Created a .dot template and would like to pull data from attribute table to this word document.

here is what I did so far:

          //Start Word and create a new document.
           Word._Application oWord;
            Word._Document oDoc;
            oWord = new Word.Application();
            oWord.Visible = true;

            //start word template
            object oTemplate = "c:\\Mobile projects\\Annual Patrol Form 2010 final.dot";
            oDoc = oWord.Documents.Add(ref oTemplate, ref oMissing,
                ref oMissing, ref oMissing);

Please guide me.
Thanks

Re: How to export attributes to excel

DonFreeman — Sat, 11 Dec 2021 17:39:51 GMT

Looks like you are trying to do it with automation. I have not done it with ESRI but in other environments I do it this way:

1. Design your template with bookmarks where you want the fields to be placed.
2. Then open the template and make it the active document as you describe above.
3. Select the bookmark and place the data into it like this:

 .ActiveDocument.Bookmarks("TCTime").select
 .selection.TypeText(transform(pei.tctime))

In this example pei is the tablename and tctime is the field. This is VB but C# should be similar.
Good luck.

Re: How to export attributes to excel

pavankalvala — Wed, 27 Apr 2011 14:51:06 GMT

Thanks Don for your reply.

I do not have any table to populate into the word template. Since I need to run my code through ESRI ArcMap, I was thinking to first export attribute data to an excel file and then populate field values from that excel file to word template bookmark.

Would there be any proper c# code that helps me to pull data from excel file into the Word bookmarks?

Let me know if there is any other way.

Thanks.

Re: How to export attributes to excel

DonFreeman — Sat, 11 Dec 2021 17:39:54 GMT

You can read the data out of excel if you know what cell the data you want is in, but that sounds terribly convoluted. Why not skip the excel part and read it directly out of the attribute data. How are you getting a hook to the data in esri? If you have access to plug it into excel then you should also have access to plug it into Word. Just loop through the fields and plug them into your template.

If you really want to work with excel you can do something like this.

oX = createobject('Excel.Application')
oX.visible = .t.
oX.Workbooks.open(filename)
oBook = oX.Workbooks(1)
oSheet = oBook.Worksheets(sheetnumber)
myvariable = oSheet.range('B2').value

After that you can do whatever you want with the variable. The above is foxcode but you should be able to convert it to C# fairly easy.

Re: How to export attributes to excel

pavankalvala — Wed, 27 Apr 2011 17:21:22 GMT

Hi Don,

1. I first converted the attribute table to Excel sheet and saved it onto my local ("C:\Documents
   and Settings\username\exportexcel.xls").
   My Excel sheet looks like this for example:
           A               B                    C
1      FID        OBJECTID         LANDKEY
2      0            558300          AZ145

    *** the excel sheet name is "sheet1"
    *** the excel is saved as Exportexcel.xls

2. I created a word document and saved it into (C:\Documents and Settings\username\test.doc")
3. I made a bookmark called "abc" in this doc.
3. Now I want ObjectID value "558300" from Excel to populate in word bookmark "abc".

I am currently testing this in VBA and this is what I have so far. I am calling CreateWordreport from a button click.

Sub createWordReport1()
Dim ExApp As Excel.Application
Dim wdApp As Word.Application

Set ExApp = New Excel.Application
Set wdApp = New Word.Application

'With wdApp
'.Visible = True
'.WindowState = wdWindowStateMaximize
'End With

ExApp.Workbooks.Open ("C:\Documents and Settings\username\exportexcel.xls")
wdApp.Documents.Open ("C:\Documents and Settings\username\test.doc")

'wdApp.ActiveDocument.Bookmarks.Value = ExApp.ActiveWorkbook.Sheets("Sheet1").Range("b2").Value    '// I tried this, but i dont know if this is correct

wdApp.ActiveDocument.Bookmarks("LANDKEY").Select
wdApp.Selection.TypeText (Transform(Sheet1.LANDKEY))
End Sub

Please correct me.
Thanks.

Re: How to export attributes to excel

DonFreeman — Wed, 27 Apr 2011 19:29:31 GMT

I suggest you leave the apps visible so you can see what is happening. Refer to the sheet by its number and capture the variable.

myvar = ExApp.ActiveWorkbook.Sheet(1).Range("b2").Value

Then place the variable into your document.

wdApp.ActiveDocument.Bookmarks("LANDKEY").Select
wdApp.Selection.TypeText (Transform(myvar))

Are you successfully getting both applications started? If you can't see them visibly, use task manager to check the processes.

Re: How to export attributes to excel

Anonymous User — Wed, 27 Apr 2011 20:26:10 GMT

Have you considered using the Open Office SDk For MS Office?

http://msdn.microsoft.com/en-us/library/bb448854.aspx

I've had great success creating Excel and Word docs from Silverlight and Flex Data grids with this.
Essentially you end up creating an xml document which will open in MS office.

Re: How to export attributes to excel

pavankalvala — Wed, 27 Apr 2011 20:41:08 GMT

Hi Don,

I got it finally. Thanks for your help.

Here is the code I got to pull values from excel to word.

Sub createWordReportFrom Excel()
'On Error GoTo errorHandler
Dim wdApp As Word.Application
Dim myDoc As Word.Document
Dim mywdRange As Word.Range
Dim A As Excel.Range
Dim B As Excel.Range

Set wdApp = New Word.Application
With wdApp
.Visible = True
.WindowState = wdWindowStateMaximize
End With

Set myDoc = wdApp.Documents.Add(Template:="C:\projects\FINAL.doc")
Set A = Sheets("Mobile").Range("A2")       Set B = Sheets("Mobile").Range("B2")

With myDoc.Bookmarks
.Item("FID").Range.InsertAfter A        //FID is the bookmark name in word doc
.Item("division").Range.InsertAfter B   //division is the bookmark name in word doc

End With

'errorHandler:
'Set wdApp = Nothing
'Set myDoc = Nothing
'Set mywdRange = Nothing
End Sub

Thanks.

Re: How to export field values to doc template

pavankalvala — Wed, 04 May 2011 15:02:54 GMT

Is there a way to populate field values from an identify dialog box to a doc template?

I created a doc template with few bookmarks in it. (Bookmarks are to populate the needed values from a source).

When I select a feature in ArcMap and identify the feature, we get an "identify dialog box" with "field name" to the left and "field values" to the right.

Is there a way to programmatically loop through this identify dialog box and populate field values to a MS word doc template.

Please guide me.
Thanks.

Re: How to export attributes to excel

TroyProctor — Wed, 07 Aug 2013 18:40:30 GMT

Have you considered using the Open Office SDk For MS Office?

http://msdn.microsoft.com/en-us/library/bb448854.aspx

I've had great success creating Excel and Word docs from Silverlight and Flex Data grids with this.
Essentially you end up creating an xml document which will open in MS office.

Michael,
How were you able to use the Open Office SDK when it's references DocumentFormat.OpenXml, etc. are not Silverlight assemblies?

Thanks for your time,
Troy