コード例 #1
0
        public void WorksheetClearBorderTest()
        {
            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);

            //Now remove red
            writer.ClearBorder("B4", "D2");

            //Save to the memory stream, and then to a file
            SpreadsheetWriter.Save(doc);
            SpreadsheetWriter.StreamToFile(string.Format("{0}\\borderclear.xlsx", GetOutputFolder()), stream);
        }