添加EPPlus引用
public void DataToExcel()
{
var ModelPath = System.Web.Hosting.HostingEnvironment.MapPath("~/");
var stream = FileToStream(ModelPath + "Files\\Model\\模板.xlsx");
var date = DateTime.Now.ToString("yyyyMMdd");
var url = ModelPath + "Files\\Uploads\\" + date + "\\";
var FileName = url + "测试.xlsx";
string dicrctoryName = Path.GetDirectoryName(url);
if (!string.IsNullOrEmpty(dicrctoryName))
{
Directory.CreateDirectory(dicrctoryName);
}
if (File.Exists(FileName))
{
File.Delete(FileName);
}
using (ExcelPackage package = new ExcelPackage(stream))
{
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
worksheet.Cells[1, 2].Value ="";
worksheet.Cells[2, 1].Value = "";
worksheet.Cells[3, 3].Value= "";
FileInfo fs = new FileInfo(FileName);
package.SaveAs(fs);
}
}
读取文件
public static Stream FileToStream(string filePath)
{
FileStream fileStream = new FileStream(filePath, FileMode.Open, FileAccess.Read, FileShare.Read);
byte[] bytes = new byte[fileStream.Length];
fileStream.Read(bytes, 0, bytes.Length);
fileStream.Close();
Stream stream = new MemoryStream(bytes);
return stream;
}