Thom Lamb
2cd6df6481
Establishes the foundational structure, core Excel functionality, and tooling. - Implements base components for cells, ranges, columns, and rows. - Integrates a custom calculation engine with a wide range of Excel functions. - Adds comprehensive support for styling, conditional formatting, data validation, comments, pictures, and charts. - Configures build setup, project metadata (NuGet), and developer guidelines. - Includes editor and Git attributes for consistent code style and line endings.
56 lines
1.4 KiB
C#
56 lines
1.4 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using ClosedXML.Excel;
|
|
using System.IO;
|
|
|
|
namespace ClosedXML_Examples
|
|
{
|
|
class EditingComments : IXLExample
|
|
{
|
|
|
|
public void Create(string filePath) {
|
|
|
|
// Exercise(@"path/to/test/resources/comments");
|
|
|
|
}
|
|
|
|
public void Exercise(string basePath)
|
|
{
|
|
|
|
// INCOMPLETE
|
|
|
|
var book = new XLWorkbook(Path.Combine(basePath, "EditingComments.xlsx"));
|
|
var sheet = book.Worksheet(1);
|
|
|
|
// no change
|
|
// A1
|
|
|
|
// edit existing comment
|
|
sheet.Cell("B3").Comment.AddNewLine();
|
|
sheet.Cell("B3").Comment.AddSignature();
|
|
sheet.Cell("B3").Comment.AddText("more comment");
|
|
|
|
// delete
|
|
//sheet.Cell("C1").DeleteComment();
|
|
|
|
// clear contents
|
|
sheet.Cell("D3").Clear(XLClearOptions.Contents);
|
|
|
|
// new basic
|
|
sheet.Cell("E1").Comment.AddText("non authored comment");
|
|
|
|
// new with author
|
|
sheet.Cell("F3").Comment.AddSignature();
|
|
sheet.Cell("F3").Comment.AddText("comment from author");
|
|
|
|
// TODO: merge with cells
|
|
// TODO: resize with cells
|
|
// TODO: visible
|
|
|
|
book.SaveAs(Path.Combine(basePath, "EditingComments_modified.xlsx"));
|
|
}
|
|
}
|
|
}
|