topic Re: Python script to generate xls report in Python Questions

Python script to generate xls report

VictoriaWyeth — Thu, 24 Oct 2013 08:29:15 GMT

Hello

I wonder if someone can help me please.
I am trying to write a python script which will generate a report in Excel but I need the "Use cell merging" function to be set to true for the final report. I have got the script to generate the report ok but I don't know how to implement to function for cell merging.

import arcpy
mxd = arcpy.mapping.MapDocument(r"C:\test.mxd")
df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]
lyr = arcpy.mapping.ListLayers(mxd, "Wells", df)[0]
arcpy.mapping.ExportReport(lyr,
                           r"C:\MyRLF.rlf",
                           r"C:\ProjectReport.xls",
                           "EXTENT",
                           extent=df.extent)
del mxd

Is someone able to help me please?

Re: Python script to generate xls report

XanderBakker — Thu, 24 Oct 2013 11:47:35 GMT

Hi,

Not sure what you exactly want:

merge cells together so that for instance Cel A1 and B1 apear as a single cell?

or combine data into 1 field.

Considering the first option, I really don't know. If this is not something you can define in your report layout file, then you would have to dig into the Excel model and program it.

In case you just want to concatenate data from 2 (or more) fields into 1 field, you can prepare the data itself (add a column and use the field calculator) or do this in your report layout file.

Merge data together in Report Layout

On the right side of the screen you will see "Fields" and below that "Calculated"

Right click on Calculated and choose "Add":

[ATTACH=CONFIG]28566[/ATTACH]

Your field will be named "Field1"

In the properties specify a formula like: myFieldName1 + " - " + myFieldName2

[ATTACH=CONFIG]28567[/ATTACH]

Reference your new (calculated) field "Field1" in your report designer

[ATTACH=CONFIG]28568[/ATTACH]

Hope this works for you.

Kind regards,

Xander

Re: Python script to generate xls report

VictoriaWyeth — Thu, 24 Oct 2013 13:19:42 GMT

Thanks for your reply Xander.

Unfortunately it is the first option you mentioned which I require. However, your idea about programming it in Excel is a good one and that is the way I have done it by writing a small macro.

Thanks for your help.