public void WorksheetOverlappingBorderTest()
{
MemoryStream stream = SpreadsheetReader.Create();
SpreadsheetDocument doc = SpreadsheetDocument.Open(stream, true);
WorksheetPart worksheetPart = SpreadsheetReader.GetWorksheetPartByName(doc, "Sheet1");
WorksheetWriter writer = new WorksheetWriter(doc, worksheetPart);
//Also use coordinates that are reversed
writer.DrawBorder("B4", "D2", "FF0000", BorderStyleValues.Medium);
writer.DrawBorder("E5", "C3", "0000FF", BorderStyleValues.Medium);
//Save to the memory stream, and then to a file
SpreadsheetWriter.Save(doc);
SpreadsheetWriter.StreamToFile(string.Format("{0}\\borderoverlap.xlsx", GetOutputFolder()), stream);
}
public void WorksheetBorderTest()
{
MemoryStream stream = SpreadsheetReader.Create();
SpreadsheetDocument doc = SpreadsheetDocument.Open(stream, true);
WorksheetPart worksheetPart = SpreadsheetReader.GetWorksheetPartByName(doc, "Sheet1");
WorksheetWriter writer = new WorksheetWriter(doc, worksheetPart);
//Fill a background cell to make sure it is not overwritten
SpreadsheetStyle style = SpreadsheetReader.GetDefaultStyle(doc);
style.SetBackgroundColor("C0C0C0");
//(grey)
writer.SetStyle(style, "B2");
writer.DrawBorder("B2", "D4", "FF0000", BorderStyleValues.Medium);
//Save to the memory stream, and then to a file
SpreadsheetWriter.Save(doc);
SpreadsheetWriter.StreamToFile(string.Format("{0}\\border.xlsx", GetOutputFolder()), stream);
}
