NPOI

This project is migrated from Tony Qu's NPOI by .NET Core Community.

NuGet Package

Install-Package DotNetCore.NPOI

How can it work on Linux?

On Linux, you need install libgdiplus. Since 1.2.0 libdl is also required.

• Ubuntu 16.04 and above:

  • apt-get install libgdiplus libc6-dev
  • cd /usr/lib
  • ln -s libgdiplus.so gdiplus.dll

• Fedora 23 and above:

  • dnf install libgdiplus
  • cd /usr/lib64/
  • ln -s libgdiplus.so.0 gdiplus.dll

• CentOS 7 and above:

  • yum install autoconf automake libtool
  • yum install freetype-devel fontconfig libXft-devel
  • yum install libjpeg-turbo-devel libpng-devel giflib-devel libtiff-devel libexif-devel
  • yum install glib2-devel cairo-devel
  • git clone https://github.com/mono/libgdiplus
  • cd libgdiplus
  • ./autogen.sh
  • make
  • make install
  • cd /usr/lib64/
  • ln -s /usr/local/lib/libgdiplus.so gdiplus.dll

• Docker

  • Alpine

  # base sdk-alpine/aspnetcore-runtime-alpine images
  RUN echo "http://dl-cdn.alpinelinux.org/alpine/edge/testing" >> /etc/apk/repositories
  RUN apk --update add libgdiplus
  

  • Debian

  FROM microsoft/dotnet:2.1-aspnetcore-runtime
  RUN apt-get update && apt-get install -y libgdiplus libc6-dev && ln -s /usr/lib/libgdiplus.so /usr/lib/gdiplus.dll
  ...
  

Getting Started

Export Excel

varnewFile=@"newbook.core.xlsx";using(varfs=newFileStream(newFile,FileMode.Create,FileAccess.Write)){IWorkbookworkbook=newXSSFWorkbook();ISheetsheet1=workbook.CreateSheet("Sheet1");sheet1.AddMergedRegion(newCellRangeAddress(0,0,0,10));varrowIndex=0;IRowrow=sheet1.CreateRow(rowIndex);row.Height=30*80;row.CreateCell(0).SetCellValue("this is content");sheet1.AutoSizeColumn(0);rowIndex++;varsheet2=workbook.CreateSheet("Sheet2");varstyle1=workbook.CreateCellStyle();style1.FillForegroundColor=HSSFColor.Blue.Index2;style1.FillPattern=FillPattern.SolidForeground;varstyle2=workbook.CreateCellStyle();style2.FillForegroundColor=HSSFColor.Yellow.Index2;style2.FillPattern=FillPattern.SolidForeground;varcell2=sheet2.CreateRow(0).CreateCell(0);cell2.CellStyle=style1;cell2.SetCellValue(0);cell2=sheet2.CreateRow(1).CreateCell(0);cell2.CellStyle=style2;cell2.SetCellValue(1);workbook.Write(fs);}

Export Word

varnewFile2=@"newbook.core.docx";using(varfs=newFileStream(newFile2,FileMode.Create,FileAccess.Write)){XWPFDocumentdoc=newXWPFDocument();varp0=doc.CreateParagraph();p0.Alignment=ParagraphAlignment.CENTER;XWPFRunr0=p0.CreateRun();r0.FontFamily="microsoft yahei";r0.FontSize=18;r0.IsBold=true;r0.SetText("This is title");varp1=doc.CreateParagraph();p1.Alignment=ParagraphAlignment.LEFT;p1.IndentationFirstLine=500;XWPFRunr1=p1.CreateRun();r1.FontFamily="·ÂËÎ";r1.FontSize=12;r1.IsBold=true;r1.SetText("This is content, content content content content content content content content content");doc.Write(fs);}