PCD to excel specific cells

Is there a script that will export a dimension to a specific cell on a specific sheet of a specific workbook in excel?

i.e. Dim A export to workbook(XXXX), sheet(XXXX), Cell(B12)
Dim B export to workbook(XXXX), sheet(XXXX), Cell(F14)

I know there is pcd2excel, but that dumps everything onto an unspecified sheet or sheet 1.
Anyone have any ideas?

Parents

Rondog over 11 years ago

There might be a script in existence some where. I saw one on this form in the previous post for example.

How do you picture this to work? Is there any pattern to how the data is moved into the spreadsheet or do you literally mean something like dimension <NAME.AXIS> to cell <Column,Row>

If the output isn't ordered (random cell placement) then you would need to supply the data for each dimension item that you want to report. This could be quite a task even for a small program.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Rondog over 11 years ago

There might be a script in existence some where. I saw one on this form in the previous post for example.

How do you picture this to work? Is there any pattern to how the data is moved into the spreadsheet or do you literally mean something like dimension <NAME.AXIS> to cell <Column,Row>

If the output isn't ordered (random cell placement) then you would need to supply the data for each dimension item that you want to report. This could be quite a task even for a small program.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data