| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import XML into Excel just get first line (=file)
Hi,
I have some XML-files that I need to import to XML. I have no XSD. If I do it with one file Iget a question if I want to creat a XML mapping from the file and clicking OK makes it work. If I select several files I just get a message saying it cannot find an XML mapping... So I create a XML mapping from one file via the menu entry XML-source and then the button XML-mappings. I get a nice structur in the mapping-source-window. Then I chose Import and only the first line i imported, every othe line/file generates an error message... Anybody got a clue? (The worst is that I managed to import all 1008 files once but cannot repeat it...) -- Claes Wedin Altcom AB |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Import XML into Excel just get first line (=file)
Hi, set the async, validateOnParse and resolveExternals attributes of XML to
false. Always remember to close an xml file after you have processed it and then proceed with the next file. I hope these should solve your issue. "ClaesWedin" wrote: Hi, I have some XML-files that I need to import to XML. I have no XSD. If I do it with one file Iget a question if I want to creat a XML mapping from the file and clicking OK makes it work. If I select several files I just get a message saying it cannot find an XML mapping... So I create a XML mapping from one file via the menu entry XML-source and then the button XML-mappings. I get a nice structur in the mapping-source-window. Then I chose Import and only the first line i imported, every othe line/file generates an error message... Anybody got a clue? (The worst is that I managed to import all 1008 files once but cannot repeat it...) -- Claes Wedin Altcom AB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
| multi-line text file import to excel | Excel Programming | |||
| Import & Parsing a small 400 line CSV file | Excel Programming | |||
| Text File Import leaves a blank row after each line | Setting up and Configuration of Excel | |||
| import huge text file line-by-line? | Excel Programming | |||
Linear Mode
