Aspose::Words::Saving::XlsxSectionMode enum

XlsxSectionMode enum

Specifies how sections are handled when saving a document in the XLSX format.

enum class XlsxSectionMode

Values

NameValueDescription
MultipleWorksheets0Specifies that a separate worksheet is created for each section of a document.
SingleWorksheet1Specifies that all sections of a document are saved on one worksheet.

Examples

Shows how to save document as a separate worksheets.

auto doc = System::MakeObject<Aspose::Words::Document>(get_MyDir() + u"Big document.docx");

// Each section of a document will be created as a separate worksheet.
// Use 'SingleWorksheet' to display all document on one worksheet.
auto xlsxSaveOptions = System::MakeObject<Aspose::Words::Saving::XlsxSaveOptions>();
xlsxSaveOptions->set_SectionMode(Aspose::Words::Saving::XlsxSectionMode::MultipleWorksheets);

doc->Save(get_ArtifactsDir() + u"XlsxSaveOptions.SelectionMode.xlsx", xlsxSaveOptions);

See Also