Output Excel File Coloums are Not Auto Adjusting to data.

Anveshmallela

Summary

Output Excel File Coloums are Not Auto Adjusting to data.

Content

Excel Output Columns are shrinking. I used the the table wizard to create the RTF from xml file.

I need the output columns to adjust to data.

I need the output file like:

XML file :

<<XXERT_CONSHP_SUM>  <LIST_G_CLIENT_NAME>    <G_CLIENT_NAME>        <CLIENT_NAME>Actelion Clinical Research, Inc.</CLIENT_NAME>        <STUDY_NAME>AC060B202</STUDY_NAME>      <PROGRAM/>        <PROJECT_CODE>C</PROJECT_CODE>        <PROJECT_MANAGER>Gough, Gena</PROJECT_MANAGER>        <ITEM>Palm TX</ITEM>        <ITEM_TYPE>LogPad</ITEM_TYPE>        <CONTRACT_QUANTITY>797</CONTRACT_QUANTITY>        <CONTRACT_ACTDEVICE_QTY>776</CONTRACT_ACTDEVICE_QTY>        <IN_FIELD_NOW>0</IN_FIELD_NOW>        <IM_IN_FIELD_NOW>0</IM_IN_FIELD_NOW>        <UST_IN_FIELD_NOW>0</UST_IN_FIELD_NOW>        <TR_IN_FIELD_NOW>0</TR_IN_FIELD_NOW>        <ACTIVESITE_IN_FIELD_NOW>0</ACTIVESITE_IN_FIELD_NOW>        <IN_FIELD_NOW_OVER_ACTCONTRACT>0</IN_FIELD_NOW_OVER_ACTCONTRACT>        <PERCENTAGEOFCONTRACT>0</PERCENTAGEOFCONTRACT>        <TOTAL_REQUESTED_AND_SHIPPED>794</TOTAL_REQUESTED_AND_SHIPPED>    </G_CLIENT_NAME>    <G_CLIENT_NAME>        <CLIENT_NAME>Actelion Clinical Research, Inc.</CLIENT_NAME>        <STUDY_NAME>AC060B202</STUDY_NAME>       <PROGRAM/>        <PROJECT_CODE>C</PROJECT_CODE>        <PROJECT_MANAGER>Gough, Gena</PROJECT_MANAGER>        <ITEM>SimpleSend Internet</ITEM>        <ITEM_TYPE>Modem</ITEM_TYPE>        <CONTRACT_QUANTITY>8</CONTRACT_QUANTITY>        <CONTRACT_ACTDEVICE_QTY>8</CONTRACT_ACTDEVICE_QTY>        <IN_FIELD_NOW>0</IN_FIELD_NOW>        <IM_IN_FIELD_NOW>0</IM_IN_FIELD_NOW>        <UST_IN_FIELD_NOW>0</UST_IN_FIELD_NOW>        <TR_IN_FIELD_NOW>0</TR_IN_FIELD_NOW>        <ACTIVESITE_IN_FIELD_NOW>0</ACTIVESITE_IN_FIELD_NOW>        <IN_FIELD_NOW_OVER_ACTCONTRACT>0</IN_FIELD_NOW_OVER_ACTCONTRACT>        <PERCENTAGEOFCONTRACT>0</PERCENTAGEOFCONTRACT>        <TOTAL_REQUESTED_AND_SHIPPED>8</TOTAL_REQUESTED_AND_SHIPPED>    </G_CLIENT_NAME>  </LIST_G_CLIENT_NAME></XXERT_CONSHP_SUM>