XDoc.Excel
Features
Tech Specs
How-to C#
Pricing

C# Excel How-Tos

PM > Install-Package XDoc.Excel

Overview Install Get to Start Basic SDK Concept Formats Supported Load, Save XLSX Preview XLSX Excel Conversion Document, Sheets Process Annotate Excel Text Search Edit Images Excel Thumbnail

C# Excel Library
C# Excel - Sort Excel Pages Order in C#.NET


Support Customizing Page Order of Excel Document in C# Project





RasterEdge C#.NET Excel document page reordering control SDK (XDoc.Excel) is a thread-safe .NET library that can be used to adjust the Excel document pages order. This Excel document page reorganizing control condenses quick Excel page sorting functions into a compact library, which is compatible with .NET-compliant programming language C#.

Using this C#.NET Excel document page reorganizing library control, developers can swap or adjust the order of all or several Excel document pages, or just change the position of certain one Excel page in an extremely easy and quick way using C# code.

Besides C#.NET Excel document page sorting function, RasterEdge has also offered other .NET Excel page processing functions, like Excel documents merging, Excel page rotating, Excel image extracting, Excel page inserting, Excel page deleting and Excel document splitting.


Swap Two Excel Pages Position Using C#



You may choose two pages of Excel file and exchange their position. 

String filepath = @"";
String outPutFilePath = @"";
XLSXDocument doc = new XLSXDocument(filepath);

// Swap page 0 and page 1.
doc.SwapTwoPages(0, 1);

// Save Excel document.
doc.Save(outPutFilePath);


Sort Multiple Excel Pages with a Certain Order in C#.NET



Use C# sample code below to sort several pages of Excel file to your desired order. 

//  get XLSXDocument object from a source file
String inputFilePath = Program.RootPath + "\\" + "1.xlsx";
XLSXDocument doc = new XLSXDocument(inputFilePath);

//  show page count of the document
int pageCount = doc.GetPageCount();
Console.WriteLine("Page Count: " + pageCount);

//  define the new order for all pages
//  1. the length of the array MUST BE equal to pageCount
//  2. each page index SHOULD be in the array and only once
//  otherwise, the method would throw exception
int[] pageOrders = new int[] { 1, 3, 0, 5, 4, 6, 2 };
doc.SortPage(pageOrders);

//  save the XLSXDocument
String outputFilePath = Program.RootPath + "\\" + "Output.xlsx";
doc.Save(outputFilePath);