You can save the data or the data and formatting in a Spread component to a Spread XML file or to a stream. All sheets in the component are saved to the file or stream if you use the Save method in the FpSpread class. If you choose to save the formatting, the saved data includes formatting characters, such as currency symbols, and other information such as cell types.

For more details on the methods used, refer to the Save methods in the FpSpread class or the SaveXml methods in the SheetView class.

For instructions for opening Spread-compatible XML files, see Opening a Spread XML File.

Using Code

Use the Save method of the FpSpread component to specify the path and file name of the Spread XML file or the Stream object, and whether to save data only.

Example

This example code saves the data and formatting in a Spread component to a Spread XML file.

// Save the data and formatting to an XML file.
fpSpread1.Save("C:\\SpWinFile1.xml", false);

' Save the data and formatting to an XML file.
fpSpread1.Save("C:\SpWinFile1.xml", False)

Using the Spread Designer

1. From the File menu, choose Save.

   The Save As dialog appears.

2. Change the Save as type box to XML files (*.xml).
3. Specify the path and file name to which to save the file, and then click Save.

   If the file is saved successfully, a message appears stating the file has been saved.

4. Click OK to close the Spread Designer.