• 0

Mapping Excel 2007 spreadsheet to XML


Question

Hello,

I am new to this forum, and hope that I will find the help that I need.

Where I work, we receive Excel spreadsheets that list any number of task numbers which we need to complete. These tasks are written in S1000D XML, and stored on a database. In order to write the procedures, they must first exist on the database. For this specification, there is a file called a Data Module List. It is an XML file that lists any number of data modules (XML files). The project we are working on is on the order of 2800 xml files that need to be entered into the DB before my writers can begin. In the past we have been entering each data module into the DB by hand. After some thought I "dis-assembled" spreadsheet that we are sent into a CSV, giving all the info required for the tags in XML.

I have begun trying to map the info to the schema that governs this list. I have only been successful in mapping two of the elements. When I try to map the numbers, I get ta dialog box that says:

"The operation cannot be completed because the result would overlap an external data range or Pivot table"

I am not sure what this means, or how to resolve the issue.

If anyone can help, i would be very greatful.

Tom

0 answers to this question

Recommended Posts

There have been no answers to this question yet

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.