这是我自己根据网上大神提供的源码,再。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);
}
生成excel表格
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();
}
生成pdf
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();
}
1、AngleSharp
var dom = htmlParser.Parse(html);
var result = dom.QuerySelectorAll("div.class").ToList();
我用这个包实现了了一个简单的网页爬虫。
爬虫简单例子