Does anybody put the Excel sheet struture into xml file?

Question

Hi to All,

           I want to put the excel sheet structure into a xml configuration file.so, I will read the configuration file and then create the appropriate workbook sheet programatically using apache poi3.6 & java.

Xml Structure may be like this...

        <workbook_name>stockdemo.xls</workbook_name><!--  put the excel file name -->
        <workbook_default_headers_footers> <!-- Common to all Sheets present in the workbook -->

                            <header new_row="true">
                                    <text>Manufacturing Operations</text>
                                    <format_information>
                                                <face>Xerox Sans</face>
                                                <bold>true</bold>
                                                <size>20</size>
                                                <color>red</color>
                                                <alignment>left</alignment>
                                    </format_information>           
                             </header>
</workbook_default_headers_footers>

4

                    <sheet_details>                                                                                                 <!-- Represent the each Indiviual sheet in the workbook-->
                                <sheet_name>Head Office</sheet_name>
                                <column_header>
                                                <column_name type="string">Center Name</column_name>
                                                <column_name type="date">Date</column_name>
                                                <column_name type="int">Target</column_name>
                                                <column_name type="int">Status</column_name>
                                                <column_name type="int">Completed</column_name>
                                                <column_name type="int">Defects</column_name>
                                                <column_name type="int">Pending</column_name>
                                                <column_name type="date">Estimated date of completion</column_name>
                                                <column_name type="string">comments</column_name>
                                </column_header>

                                <row_header>
                                        <row_name>Chennai</row_name>
                                        <row_name>Coimbatore</row_name>
                                        <row_name>Madurai</row_name>
                                        <row_name>Total</row_name>
                                </row_header>

                                <formula_column row_name="Total">
                                                <formula column_name="Target">SUM</formula> 
                                                <formula column_name="Status">SUM</formula>
                                                <formula column_name="Completed">SUM</formula>
                                                <formula column_name="Defects">SUM</formula>
                                                <formula column_name="Pending">SUM</formula>
                                </formula_column>
                 </sheet_details>   


    </sheets_descriptions>

---

Does anybody done it already like this...please send me the sample structure of your xml configuration file.

Advance Thanks to All,

Thanks & Regards, P.SARAVANAN