« Excel et CSharp avec EPPlus » : différence entre les versions
Aucun résumé des modifications |
|||
| Ligne 1 : | Ligne 1 : | ||
[[Category:CSharp]] | [[Category:CSharp]] | ||
= Liens = | = Liens = | ||
* [https://github.com/EPPlusSoftware/EPPlus EPPlus] | * [https://github.com/EPPlusSoftware/EPPlus EPPlus 5 on GitHub] | ||
* [https://github.com/JanKallman/EPPlus EPPlus 4 on GitHub] | |||
= Bases = | = Bases = | ||
Version du 19 juin 2020 à 21:22
Liens
Bases
|
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (var package = new ExcelPackage(new FileInfo(@"C:\folder\file.xlsx")))
{
var workbook = package.Workbook;
var worksheet = workbook.Worksheets[0];
// row, col, row, col
worksheet.Cells[1, 1, 3, 3].Sort(1); // sort by column 1 (0-based) the selected range
package.Save();
}
|