xml export

Hey! I have excel .xlsx workbook with loaded xml source. I take one row from sheet "Clients" and copy it to row "Data", then export is as XML with name changed according the data from the copied row and then use it in other ways. I have found one VBA in this forum that helped me solve the...

Hey! I have excel .xlsx workbook with loaded xml source. I take one row from sheet "Clients" and copy it to row "Data", then export is as XML with name changed according the data from the copied row and then use it in other ways. I have found one VBA in this forum that helped me solve the...

Good day everyone! I share an Excel workbook through Dropbox. It's a character sheet for a roleplaying game. It allows users to pick from a plethora of options to create their character, those options then get calculated in a few other pages that the user can then export into PDF. They can...

The exported XML always contains elements for columns mapped to XSD xs:element with minoccurs="0", while there is no data in the cells. I would have expected Excel to not have created the elements at all. More in detail: An XML map is used to map the Excel columns. The XSD contains an...

Hi One of the local government agency is requiring us to now send them information in an XML format which is fine. My issue is some of the data is graphics of signatures etc. Is there away to get excel to include these pictures in the final xml output file? Are there any gotchas in doing this...

Hi all, I can't export a simple scheme from Excel as an XML file. I think that the problem lies in the fact that Excel automatically renames my column from "id" to "id2", "id3" and so on, when I have multiple "id" in my XML. I've checked that because when I map the "id2" column to "id" on the...

Hi, I am trying to format Excel sheet so that I can export to an XML file. The result I would like looks like the following: <xml> <transactions> <transaction type="import_lists" date ="123459" vaultname ="Type in the name of the vault here"> <!-- Just a list without links -->...

Maybe I have been asking the wrong questions? Is there a way to create an XML file without the XML declaration and schema reference? Our ancient inventory management system will not accept anything that is not an XML document without those two lines. I know, I know. I am pushing them to...

I am putting together a workbook so that our customer service can put all the credit memos into a spreadsheet and have a macro export each row as an individual XML file. The issue I am running into is where we can have from 1 to 12 parts listed in these memos. Does anyone have any pointers for...

I have an XML document and an Excel spreadsheet. I would like a VBA code that extracts specific cell information into specific parts of my XML code. I know that my XML code works however I am having trouble getting the information I need to transpose into the xml text file. HELP PLEASE?

Hi All Any suggestions for how to convert to XML lists in office for mac 2011? Thanks!

Hello all, I have a question regarding exporting something as a xml (or specifically a KML) file format. I have a series of rows of data which i have imported into excel from KML files. Let's say I have since altered these rows to fit my needs. I imagine this will require a macro command...