This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Is it possible to output without headers to excel?
I can use the dynarmic rename tool to make the first line of data headers but if there are duplicates the values become 1_2, 1_3, and any nulls become Field_1, field_2. Since the outputs are integers this makes the entire thing useless.
I need to drop output values from my workflow into specific cells in a P&L format in excel (updating an existing worksheet with other data in it). At the moment I either get unwanted headers above the data or a first row of data with issues with nulls or duplicate values. I would like to achieve it without manual intervention. Will upload an example tomorrow
Two quick thoughts which spring to mind based on your description:
If you have a template file an only need certain cells populated, could you create a "data" sheet on run and point to that via excel formulas in your template file?
If you can install the 2010 32-bit Access driver, you could use the legacy xls driver which can sometimes work. This driver's output options include "delete data & append" which might do what you need. If it doesn't, this driver also has Pre Create and Post Create "Sql statements", which you might be able to play with to try programmatically deleting the header row. Unfortunately I don't have that driver installed, so I can't test this option.