ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Drop-down data not appearing in exported XML (https://www.excelbanter.com/excel-discussion-misc-queries/49217-drop-down-data-not-appearing-exported-xml.html)

Kristi

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



Kristi

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






All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com