Extra rows when a .csv file is opened in Excel.

DaleShearer

Hi, I am on my 4th day of using Python and making a lot of progress.  I am looping through a feature class and writing field data to a .csv file.  It all runs good.  The issue is when I open the .csv file in Excel there is an empty row between each row of data.

When writing a .csv file from VB.net there are no empty rows when the file is opened in Excel.  On the file created with Python all the data is there, just all spaced out with an empty row between.

I do not have a spacing character (if there is one) in the .writerow statement.

How can I fix this so there are no empty rows when I open the .csv file in Excel?

Thank you for your time.  Dale,

JamesCrandall

I realize you mentioned that you are just starting, but its also good to be exposed to advanced (maybe) techniques too.  Here's an alternative way to write out feature classes and tables to .csv output files using arcpy.da, numpy and pandas libraries.

 import pandas as pd import numpy as np  fc = r'H:\Documents\ArcGIS\Default.gdb\MyFeatureClass'  #generate a list of fields flds = [f.name for f in arcpy.ListFields(fc)]  #you cannot include Shape/Geometry or Date fields in a NumPyArrray, so remove them from the field list flds.remove('Shape') #this is the geometry field in my FeatureClass flds.remove('START_TEST') #this is a date field in my FeatureClass  #convert to a NumPyArray nmpyarr = arcpy.da.TableToNumPyArray(fc, flds)  #convert to a Pandas DataFrame dfFC = pd.DataFrame(nmpyarr)  #Write the .csv file csv_out = r'H:\Documents\csvOUTPUT.csv' dfFC.to_csv(csv_out)