Skip to content

siwigor/OpenXmlExcel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 

Repository files navigation

OpenXmlExcel

Class for creating and opening files Excel. Based on the Open XML SDK.

Example:

---New Document----
ExcelDocument doc = new ExcelDocument(saveDlg.FileName);
ExcelSheet sheet = doc.Sheets.AddNew("MySheetTest");
ExcelCell cell = sheet["A5"];
cell.Value = "test";
cell = sheet["B6"];
cell.Value = "test";
cell = sheet["C5"];
cell.Value = "01234";
cell = sheet.Rows[7].Cells[2];
cell.Value = "testi";
cell = sheet.Rows[7].Cells[3];
cell.Value = "testi";
cell = sheet.Rows[8].Cells[2];
cell.Value = "testi";
sheet["D8"].Value = "test test";
doc.Close();
-----Open Document------
ExcelDocument doc = new ExcelDocument(openDlg.FileName);
doc.Sheets[1]["A5"].Value = "test";
ExcelSheet sheet = doc.Sheets.AddNew("Test");
sheet["D5"].Value = "test";
doc.Close();

About

Class for creating and opening files Excel. Based on the Open XML SDK.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages