Created
January 12, 2023 11:16
-
-
Save devmnj/20c1817acbd4cbabf3f5b7c2d86221d4 to your computer and use it in GitHub Desktop.
Crreate a spreadsheet locally in C# using Closex XML, a wrapper around open xml sdk
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var workbook = new XLWorkbook(); | |
var ws = workbook.Worksheets.Add("TRIAL"); | |
var columnFromWorksheet = ws.Column(1); | |
columnFromWorksheet.Cell(1).Value = "TRIAL BALANCE"; | |
var columnFromRange = ws.Range("A1:K2").Merge().Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; | |
workbook.SaveAs("closedxl.xlsx"); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment