generate excel with validation list
-
You ought to be little more descriptive to aide others in help and troubleshoot with your problem on hand with an elegant expedited solution.
Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson -
You ought to be little more descriptive to aide others in help and troubleshoot with your problem on hand with an elegant expedited solution.
Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis LevinsonHi Thanks for replying. I want the Excel to have a drop-down list. I have a string of xml like this: xml.txt
<?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns: o ="urn:schemas-microsoft-com:office:office" xmlns: x ="urn:schemas-microsoft-com:office:excel" xmlns:ss ="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html ="http://www.w3.org/TR/REC-html40"> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> <Author>Mee</Author> <LastAuthor>Mee</LastAuthor> <Created>2008-05-07T06:18:28Z</Created> <Company>Ram</Company> <Version>11.5606</Version> </DocumentProperties> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> <WindowHeight>8700</WindowHeight> <WindowWidth>12315</WindowWidth> <WindowTopX>0</WindowTopX> <WindowTopY>120</WindowTopY> <ProtectStructure>False</ProtectStructure> <ProtectWindows>False</ProtectWindows> </ExcelWorkbook> <Styles> <Style ss:ID="Default" ss:Name="Normal"> <Alignment ss:Vertical="Bottom"/> <Borders/> <Font x:CharSet="222"/> <Interior/> <NumberFormat/> <Protection/> </Style> </Styles> <Names> <NamedRange ss:Name="x" ss:RefersTo="=Sheet2!R1C1:R2C1"/> </Names> <Worksheet ss:Name="Sheet1"> <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1"> <Row> <Cell><Data ss:Type="String">data</Data></Cell> </Row> </Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <Selected/> <Panes> <Pane> <Number>3</Number> <ActiveRow>2</ActiveRow> </Pane> </Panes> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> <DataValidation xmlns="urn:schemas-microsoft-com:office:excel"> <Range>R2C1</Range> <Type>List</Type> <Value>x</Value> </DataValidation> </Worksheet> <Worksheet ss:Name="Sheet2"> <Table ss:ExpandedColumnCount="1" ss:Expande