.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(); }