Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Mapping XML to workbook
Hello, I'm trying to map XML elements to a workbook.
Each column in the workbook has hundreds of rows, so the .XML map file is formatted in a such a way that excel detects an XML list is being made. When I drag the XML elements onto the workbook - to complete the mapping process - only half the columns acquire a blue border. (The blue border signifies the columns' contents are mapped to respective XML elements.) The problem columns only have their top two cells blue-bordered (with a blue star in the last cell). This seems to be an issue of Excel finding an empty cell in a column and stopping the mapping process; I want the entire column mapped. Does anyone know how to remedy this? Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Mapping XML to workbook
I should also add that my goal is to take a large Excel workbook and export
its data as XML. So once all the columns are successfully mapped I will be exporting it as an XML file. "heliotropic" wrote: Hello, I'm trying to map XML elements to a workbook. Each column in the workbook has hundreds of rows, so the .XML map file is formatted in a such a way that excel detects an XML list is being made. When I drag the XML elements onto the workbook - to complete the mapping process - only half the columns acquire a blue border. (The blue border signifies the columns' contents are mapped to respective XML elements.) The problem columns only have their top two cells blue-bordered (with a blue star in the last cell). This seems to be an issue of Excel finding an empty cell in a column and stopping the mapping process; I want the entire column mapped. Does anyone know how to remedy this? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mapping | Excel Worksheet Functions | |||
mapping add-ins | Excel Discussion (Misc queries) | |||
mapping add-ins | Charts and Charting in Excel | |||
XML Mapping Issues | Excel Discussion (Misc queries) | |||
character mapping | Excel Discussion (Misc queries) |