XL.Book.Save
------------

Writes excel file to container for storing in database.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [XL](component_XL.md) | [3.5](newinversion35.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "XL.Book.Save"; BookRef { ; FileName } ) 

**MBS**( **"XL.Book.Save";** /\* Writes excel file to container for storing in database. \*/  
**$BookRef**; /\* The reference number for the workbook.e.g. $ref \*/   
**$FileName**) /\* Optional; The new file name for the container value.e.g. "sheet.xls" \*/ 

### Parameters

| Parameter | Description | Example | Flags |
|---|---|---|---|
| BookRef | The reference number for the workbook. | $ref |  |
| FileName | The new file name for the container value. | "sheet.xls" | Optional |

### Result

Returns container value or error message.

### Description

Writes excel file to container for storing in database.  
### See also

- [XL.Book.AddFormat](XLBookAddFormat.md)
- [XL.Book.AddSheet](XLBookAddSheet.md)
- [XL.Book.DeleteSheet](XLBookDeleteSheet.md)
- [XL.Book.SaveToFile](XLBookSaveToFile.md)
- [XL.Font.SetColor](XLFontSetColor.md)
- [XL.Format.SetWrap](XLFormatSetWrap.md)
- [XL.LoadBookPartially](XLLoadBookPartially.md)
- [XL.Sheet.CellType](XLSheetCellType.md)
- [XL.Sheet.RemoveRow](XLSheetRemoveRow.md)
- [XL.Sheet.SetCol](XLSheetSetCol.md)

### Example Databases

- [XL/AutoFilter](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/AutoFilter.shtml#1ScriptAnchor_)
- [XL/Change Column Names](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Change%20Column%20Names.shtml#4ScriptAnchor_)
- [XL/Conditional Formatting](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Conditional%20Formatting.shtml#1ScriptAnchor_)
- [XL/Converter](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Converter.shtml#1ScriptAnchor_)
- [XL/Export records](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Export%20records.shtml#2ScriptAnchor_)
- [XL/Writing data](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Writing%20data.shtml#1ScriptAnchor_)
- [XL/XL Import and Export](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/XL%20Import%20and%20Export.shtml#2ScriptAnchor_)

### Blog Entries

- [MBS Plugin Advent calendar: 13 - XL](https://www.mbsplugins.de/archive/2023-12-13/MBS_Plugin_Advent_calendar_13_/monkeybreadsoftware_blog_filemaker)
- [New column names in an Excel document](https://www.mbsplugins.de/archive/2019-05-14/New_column_names_in_an_Excel_d/monkeybreadsoftware_blog_filemaker)
- [How to use XL functions with MBS FileMaker Plugin](https://www.mbsplugins.de/archive/2015-02-09/How_to_use_XL_functions_with_M/monkeybreadsoftware_blog_filemaker)

### FileMaker Magazin

- [Ausgabe 5/2022, Seite 22](https://filemaker-magazin.de/neuigkeit/4196-Appetithappen-FMM_202205)

This function checks for a license.

Created 18th August 2014 , last changed 9th July 2015

  
[XL.Book.RemoveVBA](XLBookRemoveVBA.md) - [XL.Book.SaveToFile](XLBookSaveToFile.md)

[HTML Version](XLBookSave.shtml)