|
You can export one or more Workbooks to an XML file. The associated Worksheets will be included in the XML file automatically.

This feature is NOT inteded for a complete backup of your Workbooks.
Table data is NOT included in the XML file, just the Workbook and Worksheet definition, including the SQL query etc etc. Open the XML file in a text editor and you see the included fields.
The intended use for this feature is to make it easy to
- Export one or more Workbooks from one server and import it into another server
- Make it easy to share reports between peers. If someone comes up with a nifty query, how to dump data for a certain Joomla extension. Post it in the SQL 2 Excel Forum for others to download and use!
- Export and Import works between the free and Pro version of SQL 2 Excel.
- Extra fields used by Pro version are ignored by the Free version when importing.
- Missing fields will be set to default when importing a XML file from SQL 2 Excel into SQL 2 Excel Pro.
 |