文件上传下下载(不包含断点续传) Excel,Word导入导出基础

1、文件上传下载(MVC应用)

视图:form表单,编码方式为multipart/form-data

<body>
<div>
<form action="/Demo/FileUpload" enctype="multipart/form-data" method="post">
<input id="f1" type="file" name="f1" />
<input id="Submit1" type="submit" value="上传" />
</form>
<a href="/Demo/FileDownLoad">下载</a>
</div>
</body>

控制器

public ActionResult FileUpLoad(HttpPostedFileBase f1)
{
string path = Server.MapPath("~/Picture");
string filename = Path.Combine(path,f1.FileName);
f1.SaveAs(filename);
return Content("OK");
}
public ActionResult FileDownLoad()
{
string path = Server.MapPath(@"C:\Users\Administrator\Desktop\自己练习\上传下载\UpLoad\UpLoad\Picture\QQ图片20190228155326.png");
FileStream fs = new FileStream(path,FileMode.Open);
return File(fs,"text/plain","a.jpg");
}

2、将Excal导入datatable(控制台应用)

static void Main(string[] args)
{
Workbook wk = new Workbook(@"C:\Users\admin\Desktop\user.xlsx");
//获取数据所在的单元格
Cells cells = wk.Worksheets[].Cells;
for (int i = ; i < cells.MaxDataRow; i++)
{
for (int j = ; j < cells.MaxDataColumn; j++)
{
Console.Write(cells[i,j].Value+"\t");
}
}
Console.ReadKey();
}

3、提取数据库数据到Excel(控制台应用)

//提取数据到Excal
static void Main(string[] args)
{
//读取证书
License license = new License();
license.SetLicense(@"C:\Users\admin\Desktop\自己练习\表达式树\从数据库中读取数据到Excal\Aid\License.lic");
DataTable dt = GetDataTable();
//全新的工作簿
Workbook wb = new Workbook();
//工作表
Worksheet ws = wb.Worksheets[];
ws.Cells.ImportDataTable(dt,true,"A1");
wb.Save(@"C:\Users\admin\Desktop\\user.xlsx",SaveFormat.Xlsx);
Console.WriteLine("读取成功");
Console.ReadKey();
}
public static DataTable GetDataTable()
{
string sql = "select * from Student";
return DBHelper.GetDataTable(sql);
}

4、Word读取(控制台应用)

static void Main(string[] args)
{
using (StreamReader reader = new StreamReader(@"D:\《雪中悍刀行》作者:烽火戏诸侯.txt", Encoding.Default))
{
string line;
while ((line = reader.ReadLine()) != null)
{
Console.WriteLine(line);
}
}
Console.ReadKey();
}

5、Word写入(控制台应用)

static void Main(string[] args)
{
if (File.Exists(@"C:\Users\Administrator\Desktop\新建 Microsoft Word 文档"))
{
Console.WriteLine("文件已存在");
}
FileStream fs = new FileStream(@"C:\Users\Administrator\Desktop\新建 Microsoft Word 文档", FileMode.Create);
StreamWriter sw = new StreamWriter(fs);
sw.WriteLine("床前明月光");
sw.WriteLine("疑是地上霜");
sw.Close();
fs.Close();
Console.WriteLine("写入成功");
Console.ReadKey();
}
上一篇:QCustomplot使用分享(二) 源码解读


下一篇:Android开发14——监听内容提供者ContentProvider的数据变化