Forum Discussion
Fitness__69
Mar 22, 2023Copper Contributor
Excel to XML
I need to convert Excel to XML. I have the XML Schema and data available. Any idea where to start?
- Jul 24, 2023
Select the cells with the dates.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'less than or equal to' from the second drop down.
In the box next to it, enter the formula
=EDATE(TODAY(),-54)
If you use comma as decimal separator, change the formula to
=EDATE(TODAY();-54)
In Dutch:
=ZELFDE.DAG(VANDAAG();-54)
Click Format...
Activate the Fill tab.
Select orange.
Click OK, then click OK again.
Repeat these steps, but with the formula
=EDATE(TODAY(),-60)
or if you use comma as decimal separator
=EDATE(TODAY();-60)
and red as fill color.
NikolinoDE
Mar 22, 2023Gold Contributor
To convert Excel to XML, you can follow these steps:
- Create an Excel spreadsheet.
- Create an XML schema.
- Enable the Developer tab.
- Open the XML Source pane.
- Map XML file to Excel file.
- Convert Excel file to XML file.
- Save the XML file.
You can find more detailed instructions on how to convert Excel to XML in this Udemy Blog article.
You may have heard of Extensible Markup Language (XML), and you may have heard many reasons why your organization should use it. But what is XML, exactly?
This links explains the basics of XML — what it is and how it works.
In this link
- A brief look at mark up, markup, and tags
- So what makes it XML?
- A word about well-formed data
- A quick look at schemas
- A quick look at transforms
- A peek at XML in the Microsoft Office System
Hope I could help you with these information / links.
I know I don't know anything (Socrates)
- Fitness__69Mar 22, 2023Copper ContributorThat's perfect information thank you. The Udemy Blog made it very simple
- NikolinoDEMar 22, 2023Gold ContributorI'm glad that you can support your project with this information.
I wish you continued success with Excel.