In order to present your data (Excel file, Access database etc.) to the user in an attractive way in browser, mobile phone
or PDF format, the original data must first be converted to the necessary XML formats. XML documents and data can be available
in almost any structure whatsoever. Everyone can define his or her own XML document structure and describe it. However, a
standard database table (Excel spreadsheet, Oracle table/view) is a plane, two-dimensional representation of data content.
When you convert your data source table to XML format you get a plane column-row shaped XML output.
What to do if you need to get an especially structured XML file from your Excel source (or from other data storage)?
How to create an XML with your particular multi-level tagged tree structure from your specially formatted data source?
Besides creating an XML document the XML Converter allows you generate special XSL document for this final XML file. For this case you should go to the menu bar "Options" and check the question "Would you like to accompany your XML document with a template XSL style-sheet?"
Also you can select option "Fast converting mode for Excel workbooks". Excel sheets will be transformed much faster. But this way is good if you have homogeneous data for each excel sheet column. If you have deferent data types in one column (numbers, date or text) please do not check this box.
To designate the maximum width (in characters) of the text field you should enter an appropriate value in the "Width of Word document or text file in characters" box.
Converter also supports any delimited data source file (tab-delimited text file, *.csv etc). By checking "Delimited source" option on the "Options" form you let know Converter that data source is a delimited file. Symbol-delimiter is adjustable in a special textbox. You can specify not only one symbol for your source delimitation. Delimiter can be a combination of some chars. For a tab-delimited text file just insert "Tab" in the textbox.
The Rustemsoft XML Converter can support non-Latin characters in XML by accepting the UTF-8 and UTF-16 encodings. People around the world can easily use it. By playing on "Unicode UTF-8 encoding" section you can adjust non-Latin characters view in your final XML.
"Encode special Low ASCII chars with HTML encoding" - by checking this box you can be able to convert some chars in your final XML. Some XML parsers need low ASCII symbols be encoded in HTML presentation. For example, ' char (apostrophe) in an XML content should have the view: '
By clicking "XSL Setup" button you may call a special interface for adjusting an appearance view of your XML file along with an XSL style sheet. You can change the XSL style to what you wanted.
|