SharePoint Output to Excel Sheet Start in Cell

Question

I'm trying to write data to a specific sheet within an existing Excel workbook and have configured the output to Start in Cell A3.  The process writes to the correct file and sheet, but data is written starting in A5 in the Excel file rather than A3 that was configured in the output tool.  Any thoughts?

sreedergen11 · Answer

Thanks.  Good to know it's not just something I'm doing or missing.  I'll try what you suggested and go from there.

SPetrie · Answer

I get the same results. Interestingly, if you include headers it seems to be adding extra info into the sheets. I have no idea where the "Unnamed" headers came from, but they start in the A3 cell I specified. Then the actual data starts a few rows below it. Assuming that A3 becomes the new A1, then the data starting in A5 would make sense. I tested again with A4 as a starting location and the Unnamed column was in A4 with data starting in A7 which tracks with that logic. I may not be on the newest version of the output tool, so an update may be needed. If it still persists after an update, I would suggest submitting an bug report since it does seem to be behaving oddly.

sreedergen11 · Answer

There are no blank rows and I did not select headers.  When I use the regular Output tool and write to a local drive starting in A3 it works fine.  But when I use the SharePoint output tool I'm having this issue.  Additionally, if I have it Start in Cell A1, it writes to A1.  If I have it Start in Cell A2, it writes to A3.  If I have Start in A3, it writes to A5 and so on.