We can specify a range when importing from excel but we need a named range defined within the worksheet to be able to write to it. That should be fixed.
I agree with your recommendation. However, if you're on a Window's system and want that capability now, take a look at:
The macro described in that paper can already do what you're suggesting, as well as a number of other tasks that I wish were included in PROC EXPORT.
Art, CEO, AnalystFinder.com
The XLSX export code builds a range with the same name as the sheet.
You want to specify the name?
@HenryFeldman: I can't speak for @tomrvincent, but I don't think that proc export for xlsx can do the following. I have an existing worksheet and I want to paste sashelp.class into that worksheet, using a rectangle beginning at cell G10 and do so without affecting any of the worksheet's cells that are outside of that range.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.