jie zou

Thursday, 07 December 2017 08:44

Apply Transparency to Text in PowerPoint in C#, VB.NET

It is possible to add text transparency to any text shape in PowerPoint. In order to make the text transparent, we’d need to apply the transparency level to the text shape. This article will show you how to set the transparency level of text using Spire.Presentation.

Step 1: Create a Presentation instance.

Presentation ppt = new Presentation();

Step 2: Add a shape to the first slide.

IAutoShape textboxShape = ppt.Slides[0].Shapes.AppendShape(ShapeType.Rectangle, new RectangleF(50, 70,300, 120));
textboxShape.ShapeStyle.LineColor.Color = Color.Transparent;
textboxShape.Fill.FillType = FillFormatType.None;

Step 3: Add text to shape.

textboxShape.TextFrame.Text = "Text Transparency";

Step 4: Set the fill type of TextRange to solid, and fill the TextRange using the color created with specified alpha value.

textboxShape.TextFrame.TextRange.Fill.FillType = FillFormatType.Solid;
int alpha = 55;
textboxShape.TextFrame.TextRange.Fill.SolidColor.Color = Color.FromArgb(alpha, Color.Purple);

Step 5:Save the file.

ppt.SaveToFile("result.pptx", FileFormat.Pptx2013);

Output:

Apply Transparency to Text in PowerPoint in C#, VB.NET

Full Code:

[C#]

using Spire.Presentation;
using Spire.Presentation.Drawing;
using System.Drawing;
namespace ApplyTransparency
{
    class Program
    {
        static void Main(string[] args)
        {

            //create a PowerPoint document
            Presentation ppt = new Presentation();
            ppt.SlideSize.Type = SlideSizeType.Screen16x9;

            //add a shape
            IAutoShape textboxShape = ppt.Slides[0].Shapes.AppendShape(ShapeType.Rectangle, new RectangleF(50, 70, 300, 120));
            textboxShape.ShapeStyle.LineColor.Color = Color.Transparent;
            textboxShape.Fill.FillType = FillFormatType.None;

            //remove default blank paragraphs
            textboxShape.TextFrame.Paragraphs.Clear();

            //add three paragraphs, apply color with different alpha values to text
            int alpha = 55;
            for (int i = 0; i < 3; i++)
            {
                textboxShape.TextFrame.Paragraphs.Append(new TextParagraph());
                textboxShape.TextFrame.Paragraphs[i].TextRanges.Append(new TextRange("Text Transparency"));
                textboxShape.TextFrame.Paragraphs[i].TextRanges[0].Fill.FillType = FillFormatType.Solid;
                textboxShape.TextFrame.Paragraphs[i].TextRanges[0].Fill.SolidColor.Color = Color.FromArgb(alpha, Color.Purple);
                alpha += 100;
            }

            //save to file
            ppt.SaveToFile("result.pptx", FileFormat.Pptx2013); 

        }
    }
}

[VB.NET]

Imports Spire.Presentation
Imports Spire.Presentation.Drawing
Imports System.Drawing
Namespace ApplyTransparency
	Class Program
		Private Shared Sub Main(args As String())

			'create a PowerPoint document
			Dim ppt As New Presentation()
			ppt.SlideSize.Type = SlideSizeType.Screen16x9

			'add a shape
			Dim textboxShape As IAutoShape = ppt.Slides(0).Shapes.AppendShape(ShapeType.Rectangle, New RectangleF(50, 70, 300, 120))
			textboxShape.ShapeStyle.LineColor.Color = Color.Transparent
			textboxShape.Fill.FillType = FillFormatType.None

			'remove default blank paragraphs
			textboxShape.TextFrame.Paragraphs.Clear()

			'add three paragraphs, apply color with different alpha values to text
			Dim alpha As Integer = 55
			For i As Integer = 0 To 2
				textboxShape.TextFrame.Paragraphs.Append(New TextParagraph())
				textboxShape.TextFrame.Paragraphs(i).TextRanges.Append(New TextRange("Text Transparency"))
				textboxShape.TextFrame.Paragraphs(i).TextRanges(0).Fill.FillType = FillFormatType.Solid
				textboxShape.TextFrame.Paragraphs(i).TextRanges(0).Fill.SolidColor.Color = Color.FromArgb(alpha, Color.Purple)
				alpha += 100
			Next

			'save to file
			ppt.SaveToFile("result.pptx", FileFormat.Pptx2013)

		End Sub
	End Class
End Namespace

Published in Paragraph and Text

Tagged under

ppt net Paragraph Text

Tuesday, 29 August 2017 07:01

using NPOI.XWPF.UserModel;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace NPOI
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create document
            XWPFDocument doc = new XWPFDocument();

            //Create paragraph
            XWPFParagraph para1 = doc.CreateParagraph();
            para1.Alignment = ParagraphAlignment.CENTER;

            //Set style of the paragraph text
            XWPFRun run1 = para1.CreateRun();
            run1.SetColor("Blue");
            run1.FontSize = 18;
            run1.SetText("This is the first paragraph");
            run1.SetBold(true);

            XWPFParagraph para2 = doc.CreateParagraph();
            para2.Alignment = ParagraphAlignment.LEFT;
            para2.BorderTop = Borders.WAVE;   

            XWPFRun run2 = para2.CreateRun();
            run2.Subscript = VerticalAlign.BASELINE;            
            run2.SetColor("Red");
            run2.IsItalic = true;
            run2.SetUnderline(UnderlinePatterns.Dash);
            run2.SetText("This is the second paragraph");

            //Save the file
            using (FileStream file = File.Create("TextStyle.docx"))
            {
                doc.Write(file);
            }

            //Launch
            System.Diagnostics.Process.Start("TextStyle.docx");
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Doc;
using Spire.Doc.Documents;
using System.Drawing;
using Spire.Doc.Fields;

namespace Spire.Doc
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create document
            Document doc = new Document();
            Section section = doc.AddSection();

            //Declare a paragraph style
            ParagraphStyle style1 = new ParagraphStyle(doc);
            style1.Name = "Style1";
            style1.CharacterFormat.Bold = true;
            style1.CharacterFormat.TextColor = Color.Gray;
            style1.CharacterFormat.FontSize = 18;
            doc.Styles.Add(style1);

            //Add paragraph and apply the declared style
            Paragraph para1 = section.AddParagraph();
            para1.Format.HorizontalAlignment = HorizontalAlignment.Center;
            para1.AppendText("This is the first paragraph");
            para1.ApplyStyle(style1.Name);


            //Add paragraph and set its style
            Paragraph para2 = section.AddParagraph();
            para2.Format.HorizontalAlignment = HorizontalAlignment.Left;
            TextRange range=para2.AppendText("This is the second paragraph");
            range.CharacterFormat.Italic = true;
            range.CharacterFormat.TextColor = Color.Red;
            range.CharacterFormat.UnderlineStyle = UnderlineStyle.Dash;
            range.CharacterFormat.SubSuperScript = SubSuperScript.BaseLine;
            range.CharacterFormat.Border.BorderType = Spire.Doc.Documents.BorderStyle.Wave;
            range.CharacterFormat.Border.Color = Color.Green;

            //Save and Launch
            doc.SaveToFile("TextStyle.docx", FileFormat.Docx2013);
            System.Diagnostics.Process.Start("TextStyle.docx");


        }
    }
}

TextStyle.zip

Published in NPOI

Tuesday, 29 August 2017 06:59

Insert image in word document

NPOI
Spire.Doc
Download Sample Code

using NPOI.XWPF.UserModel;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace NPOI
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create document
            XWPFDocument doc = new XWPFDocument();
            XWPFParagraph para = doc.CreateParagraph();
            XWPFRun run = para.CreateRun();

            //Insert image and set its size
            using (FileStream picFile = new FileStream("../../../Data/image.jpg", FileMode.Open,FileAccess.Read))
            {
                run.AddPicture(picFile, (int)PictureType.PNG, "image", 300 * 12857, 168 * 12857);
            }

            //Save the file
            using (FileStream file = File.Create("Image.docx"))
            {
                doc.Write(file);
            }

            //Launch
            System.Diagnostics.Process.Start("Image.docx");
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Doc;
using Spire.Doc.Documents;
using Spire.Doc.Fields;
using System.Drawing;

namespace Spire.Doc
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create Document
            Document document = new Document();
            Section s = document.AddSection();
            Paragraph p = s.AddParagraph();

            //Insert image and set its size
            DocPicture Pic = p.AppendPicture(Image.FromFile("../../../Data/image.jpg"));
            Pic.Width = 400;
            Pic.Height = 200;

            //Save and Launch
            document.SaveToFile("Image.docx", FileFormat.Docx);
            System.Diagnostics.Process.Start("Image.docx");

        }
    }
}

InsertImage.zip

Published in NPOI

Tuesday, 29 August 2017 06:58

Create table in word document

NPOI
Spire.Doc
Download Sample Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using NPOI.XWPF.UserModel;
using System.IO;

namespace NPOI
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create document
            XWPFDocument doc = new XWPFDocument();

            //Create table
            int row = 3;
            int col = 2;
            XWPFTable table = doc.CreateTable(row, col);

            //Set table width
            table.Width = 4000; 
          
            //Loop through the table
            for (int i = 0; i < row; i++)
            {
                for (int j = 0; j < col; j++)
                {
                    XWPFTableCell cell = table.GetRow(i).GetCell(j);

                    //Set style of the table
                    XWPFParagraph para=cell.AddParagraph();
                    XWPFRun run=para.CreateRun();
                    run.SetBold(true);
                    run.FontFamily = "NSimSun";
                    run.SetText("Row" + i + " " + "Col" + j);
                    table.GetRow(i).SetHeight(800);
                    para.Alignment = ParagraphAlignment.CENTER;
                    cell.SetVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);
                }
            }

            //Save the file
            FileStream file = new FileStream("Table.docx", FileMode.Create);
            doc.Write(file);
            file.Close();

            //Launch
            System.Diagnostics.Process.Start("Table.docx");
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Doc;
using Spire.Doc.Documents;

namespace Spire.Doc
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create document
            Document doc = new Document();
            doc.AddSection();

            //Declare a paragraph style
            ParagraphStyle style = new ParagraphStyle(doc);
            style.Name = "Style";
            style.CharacterFormat.Bold = true;
            style.CharacterFormat.FontName = "NSimSun";
            doc.Styles.Add(style);

            //Add table
            Table table = doc.Sections[0].AddTable(true);
            table.ResetCells(3, 2);  
          
            //Loop through the table
            for (int i = 0; i < 3; i++)
            {
                for (int j = 0; j < 2; j++)
                {
                    TableCell cell = table.Rows[i].Cells[j];

                    //Add paragraph and fill text 
                    Paragraph para=cell.AddParagraph();
                    para.Text = "Row" + i + " " + "Col" + j; 
                 
                    //Apply paragraph style and set table style
                    para.ApplyStyle(style.Name);
                    para.Format.HorizontalAlignment = Spire.Doc.Documents.HorizontalAlignment.Center;
                    cell.CellFormat.VerticalAlignment = VerticalAlignment.Middle;
                    table.Rows[i].Height = 60;                                       
                }
            }

            //Save and Launch
            doc.SaveToFile("Table.docx", FileFormat.Docx2013);
            System.Diagnostics.Process.Start("Table.docx");
        }
    }
}

CreateTable.zip

Published in NPOI

Tuesday, 29 August 2017 06:56

Create multi-level list numbering in word document

NPOI
Spire.Doc
Download Sample Code

using NPOI.OpenXmlFormats.Wordprocessing;
using NPOI.XWPF.UserModel;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace NPOI
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create document
            XWPFDocument doc = new XWPFDocument();

            //Create numbering
            XWPFNumbering numbering = doc.CreateNumbering();
            string abstractNumId = numbering.AddAbstractNum();
            string numId = numbering.AddNum(abstractNumId);            

            //Create paragragh and set its list level
            XWPFParagraph para1 = doc.CreateParagraph();
            XWPFRun run1 = para1.CreateRun();
            run1.SetText("The first paragraph");
            para1.SetNumID(numId, "0");

            //Create paragragh and set the list level
            XWPFParagraph para2 = doc.CreateParagraph();
            XWPFRun run2 = para2.CreateRun();
            run2.SetText("The second paragraph");
            para2.SetNumID(numId, "0");

            //Create paragragh and apply multi level list 
            XWPFParagraph para3 = doc.CreateParagraph();
            XWPFRun run3 = para3.CreateRun();
            run3.SetText("The third paragraph");
            para3.SetNumID(numId, "0");
            para3 = doc.CreateParagraph();
            run3 = para3.CreateRun();
            run3.SetText("The first sub-item");
            para3.SetNumID(numId, "1");
            para3 = doc.CreateParagraph();
            run3 = para3.CreateRun();
            run3.SetText("The second sub-item");
            para3.SetNumID(numId, "1");
            para3 = doc.CreateParagraph();
            run3 = para3.CreateRun();
            run3.SetText("The sub-sub-item");
            para3.SetNumID(numId, "2");

            //Save the file and Launch
            using (FileStream sw = new FileStream("ListNumbering.doc", FileMode.Create))
            {
                doc.Write(sw);
            }
            System.Diagnostics.Process.Start("ListNumbering.doc");
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Doc;
using Spire.Doc.Documents;

namespace Spire.Doc
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create document
            Document document = new Document();
            Section section = document.AddSection();

            //Define a new multi-level list style
            ListStyle listStyle = new ListStyle(document, ListType.Bulleted);
            listStyle.Name = "levelstyle";
            listStyle.Levels[0].PatternType = ListPatternType.Bullet;
            listStyle.Levels[1].PatternType = ListPatternType.Bullet;
            listStyle.Levels[2].PatternType = ListPatternType.Bullet;
            document.ListStyles.Add(listStyle);

            //Create paragraph and apply the defined list style
            Paragraph paragraph = section.AddParagraph();
            paragraph.AppendText("The first paragraph");
            paragraph.ApplyStyle(BuiltinStyle.Heading1);
            paragraph.ListFormat.ApplyStyle("levelstyle");

            //Create paragraph and apply the defined list style
            paragraph = section.AddParagraph();
            paragraph.AppendText("The second paragraph");
            paragraph.ApplyStyle(BuiltinStyle.Heading1);
            paragraph.ListFormat.ApplyStyle("levelstyle");

            //Create paragragh and apply multi level list by setting different ListLevelNumber 
            paragraph = section.AddParagraph();
            paragraph.AppendText("The third paragraph");
            paragraph.ApplyStyle(BuiltinStyle.Heading1);
            paragraph.ListFormat.ApplyStyle("levelstyle");

            paragraph = section.AddParagraph();
            paragraph.AppendText("The first sub-item");
            paragraph.ApplyStyle(BuiltinStyle.Heading2);
            paragraph.ListFormat.ListLevelNumber = 1;
            paragraph.ListFormat.ApplyStyle("levelstyle");

            paragraph = section.AddParagraph();
            paragraph.AppendText("The second sub-item");
            paragraph.ApplyStyle(BuiltinStyle.Heading2);
            paragraph.ListFormat.ContinueListNumbering();
            paragraph.ListFormat.ApplyStyle("levelstyle");

            paragraph = section.AddParagraph();
            paragraph.AppendText("The sub-sub-item");
            paragraph.ApplyStyle(BuiltinStyle.Heading5);
            paragraph.ListFormat.ListLevelNumber = 2;
            paragraph.ListFormat.ApplyStyle("levelstyle");

            //Save and Launch
            document.SaveToFile("ListNumbering.docx", FileFormat.Docx);
            System.Diagnostics.Process.Start("ListNumbering.docx");
        }
    }
}

ListNumbering.zip

Published in NPOI

Tuesday, 29 August 2017 06:53

Create bookmark in word document

NPOI
Spire.Doc
Download Sample Code

using NPOI.OpenXmlFormats.Wordprocessing;
using NPOI.XWPF.UserModel;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace NOPI
{
    class Program
    {
        static void Main(string[] args)
        {
            //Creat document
            XWPFDocument doc = new XWPFDocument();
            CT_P para = doc.Document.body.AddNewP();

            //Bookmark start
            CT_Bookmark bookmark = new CT_Bookmark();
            bookmark.name = "MyBookmak";
            para.Items.Add(bookmark);
            int idCount = para.Items.Count;
            bookmark.id = idCount.ToString();
            para.ItemsElementName.Add(ParagraphItemsChoiceType.bookmarkStart);
            para.AddNewR().AddNewT().Value = "This is the bookmark";

            //Bookmark end
            bookmark = new CT_Bookmark();
            bookmark.id = idCount.ToString();
            para.Items.Add(bookmark);
            para.ItemsElementName.Add(ParagraphItemsChoiceType.bookmarkEnd);

            //Save the file
            using (FileStream file = File.Create("Bookmark.docx"))
            {
                doc.Write(file);
            }

            //Launch
            System.Diagnostics.Process.Start("Bookmark.docx");
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Doc;
using Spire.Doc.Documents;

namespace Spire.Doc
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create document
            Document doc = new Document();
            Section section = doc.AddSection();
            Paragraph para=section.AddParagraph();
            para.AppendText("This is the bookmark");

            //Insert bookmark
            para.AppendBookmarkStart("MyBookmark");
            para.AppendBookmarkEnd("MyBookmark");

            //Save and Launch
            doc.SaveToFile("Bookmark.docx", FileFormat.Docx2013);
            System.Diagnostics.Process.Start("Bookmark.docx");
        }
    }
}

CreateBookmark.zip

Published in NPOI

Tuesday, 29 August 2017 06:51

Convert document to other formats in word document

NPOI
Spire.Doc
Download Sample Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using NPOI.XWPF.UserModel;
using System.IO;

namespace NPOI
{
    class Program
    {
        static void Main(string[] args)
        {
            //Load document
            XWPFDocument doc = new XWPFDocument(new FileStream("../../../Data/Sample.doc", FileMode.Open));

            //Save the file
            using (FileStream sw = File.Create("ConvertedFile.docx"))
            {
                doc.Write(sw);
            }
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Doc;

namespace Spire.Doc
{
    class Program
    {
        static void Main(string[] args)
        {
            //Load document
            Document doc = new Document();
            doc.LoadFromFile("../../../Data/Sample.doc");

            //Save the file to other format
            string fileName = "ConvertedFile";
            doc.SaveToFile(fileName+".xlsx",FileFormat.Docx2010);
            doc.SaveToFile(fileName+".pdf",FileFormat.PDF);
            doc.SaveToFile(fileName + ".txt", FileFormat.Txt);
            doc.SaveToFile(fileName + ".svg", FileFormat.SVG);
        }
    }
}

Conversion.zip

Published in NPOI

Tuesday, 29 August 2017 06:41

Add header and footer in word document

NPOI
Spire.Doc
Download Sample Code

using NPOI.OpenXmlFormats.Wordprocessing;
using NPOI.XWPF.UserModel;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace NPOI
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create document
            XWPFDocument doc = new XWPFDocument();
            XWPFParagraph para=doc.CreateParagraph();
            XWPFRun run = para.CreateRun();
            run.SetText("Spire.Doc for .NET");

            doc.Document.body.sectPr = new CT_SectPr();
            CT_SectPr secPr = doc.Document.body.sectPr;

            //Create header and set its text
            CT_Hdr header = new CT_Hdr();
            header.AddNewP().AddNewR().AddNewT().Value = "This is Header";

            //Create footer and set its text
            CT_Ftr footer = new CT_Ftr();
            footer.AddNewP().AddNewR().AddNewT().Value = "This is Footer";

            //Create the relation of header
            XWPFRelation relation1 = XWPFRelation.HEADER;
            XWPFHeader myHeader = (XWPFHeader)doc.CreateRelationship(relation1, XWPFFactory.GetInstance(), doc.HeaderList.Count + 1);

            //Create the relation of footer
            XWPFRelation relation2 = XWPFRelation.FOOTER;
            XWPFFooter myFooter = (XWPFFooter)doc.CreateRelationship(relation2, XWPFFactory.GetInstance(), doc.FooterList.Count + 1);

            //Set the header
            myHeader.SetHeaderFooter(header);
            CT_HdrFtrRef myHeaderRef = secPr.AddNewHeaderReference();
            myHeaderRef.type = ST_HdrFtr.@default;
            myHeaderRef.id = myHeader.GetPackageRelationship().Id;

            //Set the footer
            myFooter.SetHeaderFooter(footer);
            CT_HdrFtrRef myFooterRef = secPr.AddNewFooterReference();
            myFooterRef.type = ST_HdrFtr.@default;
            myFooterRef.id = myFooter.GetPackageRelationship().Id;

            //Save the file
            using (FileStream stream = File.Create("HeaderAndFooter.docx"))
            {
                doc.Write(stream);
            }

            //Launch
            System.Diagnostics.Process.Start("HeaderAndFooter.docx");
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Doc;
using Spire.Doc.Documents;
using Spire.Doc.Fields;

namespace Spire.Doc
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create document
            Document doc = new Document();
            Section section = doc.AddSection();
            Paragraph para = section.AddParagraph();
            para.AppendText("Spire.Doc for .NET");

            //Add header
            HeaderFooter header = section.HeadersFooters.Header;
            Paragraph HParagraph = header.AddParagraph();
            TextRange HText = HParagraph.AppendText("This is Header");

            //Add footer
            HeaderFooter footer = section.HeadersFooters.Footer;
            Paragraph FParagraph = footer.AddParagraph();
            TextRange FText = FParagraph.AppendText("This is Footer");

            //Save and Launch
            doc.SaveToFile("HeaderAndFooter.docx", FileFormat.Docx2013);
            System.Diagnostics.Process.Start("HeaderAndFooter.docx");
        }
    }
}

HeaderAndFooter.zip

Published in NPOI

Monday, 28 August 2017 07:01

Set cell style in Excel

VSTO
Spire.XLS
Download Sample Code

using NPOI.HSSF.Util;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace NPOI
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create workbook
            IWorkbook workbook = new XSSFWorkbook();
            ISheet sheet = workbook.CreateSheet("MySheet");

            //Create cell and set its value
            ICell cell = sheet.CreateRow(1).CreateCell(3);
            cell.SetCellValue("Spire");

            //Create style
            ICellStyle style = workbook.CreateCellStyle();

            //Set border style 
            style.BorderBottom = BorderStyle.Double;
            style.BottomBorderColor = HSSFColor.Yellow.Index;

            //Set font style
            IFont font = workbook.CreateFont();
            font.Color = HSSFColor.Red.Index;
            font.FontName = "Arial";
            font.FontHeight = 13;
            font.IsItalic = true;
            style.SetFont(font);

            //Set background color
            style.FillBackgroundColor = IndexedColors.Black.Index;
            style.FillPattern = FillPattern.SolidForeground;

            //Apply the style
            cell.CellStyle = style;

            //Save the file
            FileStream file = File.Create("CellStyle.xlsx");
            workbook.Write(file);
            file.Close();

            //Launch the file
            System.Diagnostics.Process.Start("CellStyle.xlsx");
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Xls;
using System.Drawing;

namespace Spire.XLS
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create workbook
            Workbook workbook = new Workbook();
            Worksheet sheet = workbook.CreateEmptySheet("MySheet");

            //Get the cell and set its text
            CellRange range = sheet.Range["C3"];
            range.Text="Spire";

            //Create style 
            CellStyle style = workbook.Styles.Add("MyStyle");

            //Set background color
            style.Color = Color.Black;
            style.FillPattern = ExcelPatternType.Solid;

            //Set border style
            style.Borders.Color = Color.Yellow;
            style.Borders.LineStyle = LineStyleType.Thin;
            style.Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
            style.Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;

            //Set font style
            style.Font.FontName = "Arial";
            style.Font.IsItalic=true;
            style.Font.Color = Color.Red;
            style.Font.Size = 13;
            
            //Apply the style
            range.CellStyleName = style.Name;

            //Save and Launch
            workbook.SaveToFile("CellStyle.xlsx", ExcelVersion.Version2013);
            System.Diagnostics.Process.Start("CellStyle.xlsx");
        }
    }
}

SetStyle.zip

Published in NPOI

Monday, 28 August 2017 06:59

Protect excel worksheet

NPOI
Spire.XLS
Download Sample Code

using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace NPOI
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create workbook
            IWorkbook workbook = new XSSFWorkbook();

            //Create a new sheet
            ISheet sheet = workbook.CreateSheet("newSheet");

            //Protect the sheet
            sheet.ProtectSheet("test");          

            //Save the file
            FileStream file = File.Create("Protected.xlsx");
            workbook.Write(file);
            file.Close();

            //Launch
            System.Diagnostics.Process.Start("Protected.xlsx");
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Xls;

namespace Spire.XLS
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create workbook
            Workbook workbook = new Workbook();

            //Create an empty worksheet
            Worksheet sheet = workbook.CreateEmptySheet("newSheet");

            //Protect the sheet
            sheet.Protect("test");

            //Save and Launch
            workbook.SaveToFile("Protected.xlsx", ExcelVersion.Version2013);
            System.Diagnostics.Process.Start("Protected.xlsx");
        }
    }
}

ProtectSheet.zip

Published in NPOI