Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kristi
 
Posts: n/a
Default Drop-down data not appearing in exported XML

I'm exporting data as XML from an Excel spreadsheet. Cells with plain
text in them work fine, but cells with a selection from a drop-down list do
not. The XML file shows everything is there, except data from cells with
drop-down selections. No error message generated, just no trace of the data.
Any suggestions?
thanks
kc


  #2   Report Post  
Kristi
 
Posts: n/a
Default

Fixed the problem. Found out that the drop-downs were actually objects
placed on top of the cell, the options were not coded into the cells
themselves.
"Kristi" wrote in message
...
I'm exporting data as XML from an Excel spreadsheet. Cells with plain
text in them work fine, but cells with a selection from a drop-down list

do
not. The XML file shows everything is there, except data from cells with
drop-down selections. No error message generated, just no trace of the

data.
Any suggestions?
thanks
kc




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Saving data in a worksheet within a workbook Homeuser Excel Discussion (Misc queries) 2 August 21st 05 10:49 PM
automatically drop data to next line ktjo2 Excel Discussion (Misc queries) 1 August 11th 05 05:43 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM


All times are GMT +1. The time now is 07:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"