我在角10中创建了前端,后端在.net核心3.1中创建
需求:从前端上传文件(.xlsx),在web中进行解析,提取的数据存储在Server中。
使用下面的代码从角上传文件
const formData = new FormData();
for (const file of fileToUpload) {
formData.append(file.name, file);
}我在web中得到了IFormFileCollection格式的文件。
我无法读取web中的文件内容。
(预先谢谢:)
发布于 2022-07-13 13:55:36
IFormFile postedFile = file[0];
string fileName = Path.GetFileName(postedFile.FileName);
string filePath = Path.Combine(Path.GetTempPath(), fileName);
using (FileStream stream = new FileStream(filePath, FileMode.Create))
{
postedFile.CopyTo(stream);
}
string excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=Excel 12.0;";
using (OleDbConnection connection = new OleDbConnection(excelConnectionString))
{
connection.Open();
if (workBook != string.Empty)
{
//To apply query on the worksheet we need to apply '$' sign after worksheet name
workBook = workBook + "$";
//Select all records from worksheet table
OleDbCommand command = new OleDbCommand("Select * FROM [" + workBook + "]", connection);
//Execute the reader
using (OleDbDataReader dr = command.ExecuteReader())
{
try
{
//Create table
sqlConn = new SqlConnection(connString);
sqlConn.Open();
cmd = new SqlCommand { Connection = sqlConn };
// Bulk Copy to created table
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connString))
{
bulkCopyData.DestinationTableName = TABLE_NAME;
bulkCopyData.WriteToServer(dr);
}
}
}
}https://stackoverflow.com/questions/67514617
复制相似问题