.net core项目中常用的几款类库详解（值得收藏）

public static class Pinyin
 {
 public static string ConvertEncoding(string text, Encoding srcEncoding, Encoding dstEncoding);
 public static string GetChineseText(string pinyin);
 public static string GetChineseText(string pinyin, Encoding encoding);
 public static string GetInitials(string text);
 public static string GetInitials(string text, Encoding encoding);
 public static string GetPinyin(string text);
 public static string GetPinyin(string text, Encoding encoding);
 public static string GetPinyin(char ch);
 public static string GetPinyin(char ch, Encoding encoding);
 }

string sFileName = $"{Guid.NewGuid()}.xlsx";
 FileInfo file = new FileInfo(sFileName);
 string[] title = { "货品编号",
 "货品名称",
 "条码",
 "规格",
 "基本单位",
 "当前库存",
 "库存下限",
 "库存上限"
 };
 using (ExcelPackage package = new ExcelPackage(file))
 {
 ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("库存信息");
 int index = 1;
 foreach (string t in title)
 {
 worksheet.Cells[1, index++].Value = t;
 }
 index = 2;
 foreach (var d in list)
 {
 worksheet.Cells[index,1].Value = d.ProductCode;
 worksheet.Cells[index, 2].Value = d.ProductName;
 worksheet.Cells[index, 3].Value = d.BarCode;
 worksheet.Cells[index, 4].Value = d.SpecValues;
 worksheet.Cells[index, 5].Value = d.BaseUnit;
 worksheet.Cells[index, 6].Value = d.Quantity;
 worksheet.Cells[index, 7].Value = d.DownLimitQuantity;
 worksheet.Cells[index, 8].Value = d.UpLimitQuantity;
 index++;
 }
 package.Save();
 }

string tempFilePath = $"{Guid.NewGuid()}.pdf";
 string[] title = { "货品编号",
 "货品名称",
 "条码",
 "规格",
 "基本单位",
 "当前库存",
 "库存下限",
 "库存上限"
 };
 using (FileStream wfs = new FileStream(tempFilePath, FileMode.OpenOrCreate)) {
 //PageSize.A4.Rotate();当需要把PDF纸张设置为横向时
 Document docPDF = new Document(PageSize.A4,10, 10, 20,20);
 PdfWriter write = PdfWriter.GetInstance(docPDF, wfs);
 docPDF.Open();
 //在这里需要注意的是，itextsharp不支持中文字符，想要显示中文字符的话需要自己设置字体 
 BaseFont bsFont = BaseFont.CreateFont(@"C:\Windows\Fonts\simsun.ttc,0", BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
 Font font = new Font(bsFont);

 float[] clos = new float[] { 40,40,40,20,20,30,30,30};// 宽度
 PdfPTable tablerow1 = new PdfPTable(clos);
 foreach (string t in title)
 {
 PdfPCell cell = new PdfPCell(new Paragraph(t, font));
 cell.MinimumHeight = 4f;
 tablerow1.AddCell(cell);
 }
 foreach (var d in list)
 {
 tablerow1.AddCell(new PdfPCell(new Paragraph(d.ProductCode, font)));
 tablerow1.AddCell(new PdfPCell(new Paragraph(d.ProductName, font)));
 tablerow1.AddCell(new PdfPCell(new Paragraph(d.BarCode, font)));
 tablerow1.AddCell(new PdfPCell(new Paragraph(d.SpecValues, font)));
 tablerow1.AddCell(new PdfPCell(new Paragraph(d.BaseUnit, font)));
 tablerow1.AddCell(new PdfPCell(new Paragraph(d.Quantity.ToString(), font)));
 tablerow1.AddCell(new PdfPCell(new Paragraph(d.DownLimitQuantity.ToString(), font)));
 tablerow1.AddCell(new PdfPCell(new Paragraph(d.UpLimitQuantity.ToString(), font)));
 }
 docPDF.Add(tablerow1);//将表格添加到pdf文档中
 docPDF.Close();//关闭
 write.Close();
 wfs.Close();
 }