Extract data to Excel without replacing document header

[Dennis86]

I have an excel document with a document header reserving rows 1-12.

When i use "extract data" in autocad, i don't want the excel header to disappear. Can i set another cell than A1 to be the starting cell in Excel? Or how do i keep the header in the document?

[steven-g]

Which command are you using, I use ATTEXT (2013LT) so the results first go to a text file which needs to be imported into Excel, with that you have the option to choose the starting cell, or simply select the starting cell first in Excel before beggining the Import. The best way to find out is try, always make a backup of your files before you do anything your not sure of, that way any errors are not disasterous.

[Dennis86]

I am using AutoCAD 2012 and the function is "Extract data" (insert tab). Currently i use a method quite like yours. I export the data to an empty excel sheet and then i copy it to the "final document" with the header and everything. I just wondered if there is a solution that could help me do this in one step straight to the "final document".

[steven-g]

I can only assume that full Autocad operates differently, I don't have that option in the insert tab, I hope someone else will be able to step in with an answer, but it sounds like it should be possible.

[Dennis86]

Ok, maybe. Thank you anyway.

[steven-g]

Ok no idea if this will work, as I said I use LT, so different options, but on page 5 of the data extraction wizard (http://www.kxcad.net/autodesk/autocad/AutoCAD_2008_Command_Reference/d0e25736.htm) there is the option to add external data from an Excel file. If you saved your header information in a file, maybe you could link that together with your drawing to create a new merged document.