将excel文件的内容转换为MemoryStream流,使得文件可在浏览器中下载,在浏览器中下载文件可用相应的File()函数即可。
TemplateFilePath是文件存放的路径,包括文件名。
public static MemoryStream file_to_ms(string TemplateFilePath)
{
FileStream fileStream = new FileStream(TemplateFilePath, FileMode.Open);
byte[] buffer = new byte[10000];
MemoryStream outputStream = new MemoryStream();
int sourceBytes;
int i = 1;
do
{
sourceBytes = fileStream.Read(buffer, 0, buffer.Length);
if (i == 0)
{
foreach (byte b in buffer)
{
Console.WriteLine(b);
}
}
i += 1;
//文件写入到流中
if (sourceBytes != 0)
{
outputStream.Write(buffer, 0, sourceBytes);
}