public void WorksheetSetStylesTest()
{
List <string> values = new List <string>(new string[] { "alpha", "beta", "charlie", "delta" });
List <string> values2 = new List <string>(new string[] { "echo", "foxtrot", "golf", "hotel" });
//Write to the spreadsheet
MemoryStream stream = SpreadsheetReader.Create();
SpreadsheetDocument doc = SpreadsheetDocument.Open(stream, true);
WorksheetPart worksheetPart = SpreadsheetReader.GetWorksheetPartByName(doc, "Sheet1");
WorksheetWriter writer = new WorksheetWriter(doc, worksheetPart);
writer.PasteValues("A2", values, CellValues.String);
writer.PasteValues("A3", values2, CellValues.String);
//The centre four styles should be aligned to center
SpreadsheetStyle style = SpreadsheetReader.GetDefaultStyle(doc);
style.SetHorizontalAlignment(HorizontalAlignmentValues.Center);
writer.SetStyle(style, "B2", "C3");
//Set style in non existing cells
writer.SetStyle(style, "B5", "C6");
//Save to the memory stream, and then to a file
SpreadsheetWriter.Save(doc);
SpreadsheetWriter.StreamToFile(string.Format("{0}\\stylerange.xlsx", GetOutputFolder()), stream);
}
public void WorksheetAddAlignmentTest()
{
MemoryStream stream = SpreadsheetReader.Create();
SpreadsheetDocument doc = SpreadsheetDocument.Open(stream, true);
WorksheetPart worksheetPart = SpreadsheetReader.GetWorksheetPartByName(doc, "Sheet1");
SpreadsheetStyle style = SpreadsheetReader.GetDefaultStyle(doc);
WorksheetWriter writer = new WorksheetWriter(doc, worksheetPart);
style.IsWrapped = true;
writer.PasteText("E5", "Wrapped text", style);
style.IsWrapped = false;
style.SetHorizontalAlignment(HorizontalAlignmentValues.Center);
writer.PasteText("E7", "Aligned Test", style);
//Save to the memory stream, and then to a file
SpreadsheetWriter.Save(doc);
SpreadsheetWriter.StreamToFile(string.Format("{0}\\wrapped.xlsx", GetOutputFolder()), stream);
}