Skip to content

Instantly share code, notes, and snippets.

@chuongmep
Last active October 28, 2020 02:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save chuongmep/20d485fd5caf37505d6c0ad3e057a87d to your computer and use it in GitHub Desktop.
Save chuongmep/20d485fd5caf37505d6c0ad3e057a87d to your computer and use it in GitHub Desktop.
Console.WriteLine("start write excel :" + DateTime.Now.ToString("h:mm:ss tt") + "\n");
string fileName = @"D:\test.xlsx";
using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(fileName, false))
{
WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
WorksheetPart worksheetPart = workbookPart.WorksheetParts.First();
SheetData sheetData = worksheetPart.Worksheet.Elements<SheetData>().First();
string text;
foreach (Row r in sheetData.Elements<Row>())
{
foreach (Cell c in r.Elements<Cell>())
{
text = c.CellValue.Text;
Console.Write(text + " ");
}
}
}
Console.WriteLine("end write excel :" + DateTime.Now.ToString("h:mm:ss tt") + "\n");
Console.ReadKey();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment