Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Developer's Guide / File Operations / Saving Data to a File / Saving to a Spread XML File
In This Topic
    Saving to a Spread XML File
    In This Topic

    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.

    C#
    Copy Code
    // Save the data and formatting to an XML file.
    fpSpread1.Save("C:\\SpWinFile1.xml", false);
    
    VB
    Copy Code
    ' 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.
    See Also