Preserve formatting

[Aakanksha_chandak]

How to get data just filled in the table already existing in the input file.

[RaphaelSilva]

Can you explain a bit further your situation? 

[peterr_h]

If I'm understanding your question, you want the output to be put over an existing table in a spreadsheet?

If you set up the connection in the Output tool to the existing document, image 1 shows the options you should select. 

Where the image says to select range, you need to set the output file name as follows:

.\Output.xlsx|||Sheet1$A1:B2

• .\                Output folder location
• Output       File name
• .xlsx           Extension
• |||Sheet1    Sheet name
• $A1:B2      Output range - this will be where the existing table with required formatting exists. This can be any range required, in this case, cells A1:B2.

Hope this helps!

[acolten1]

cancel that-- I figured it out!!

HI there. Where do you type in the range information? there is no option to enter the range.