无法读取上传的 excel 文件
本文关键字:excel 文件 读取 | 更新日期: 2023-09-27 18:37:22
您好,我正在尝试上传一个 excel 文件并将上传的 excel 工作表中的数据读取到另一个 excel 工作表,但我收到文件不可用错误。有人可以帮忙吗?
string filetest1;
protected void UploadButton_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
SaveFile(FileUpload1.PostedFile);
else
UploadStatusLabel1.Text = "You did not specify a file to upload.";
}
void SaveFile(HttpPostedFile file)
{
string savePath = "c:''Users''*****''Desktop''";
// Get the name of the file to upload.
string fileName = file.FileName;
// Create the path and file name to check for duplicates.
string pathToCheck = savePath + fileName;
// Create a temporary file name to use for checking duplicates.
string tempfileName = "";
// Check to see if a file already exists with the
// same name as the file to upload.
if (System.IO.File.Exists(pathToCheck))
{
int counter = 2;
while (System.IO.File.Exists(pathToCheck))
{
// if a file with this name already exists,
// prefix the filename with a number.
tempfileName = counter.ToString() + fileName;
pathToCheck = savePath + tempfileName;
counter++;
}
fileName = tempfileName;
// Notify the user that the file name was changed.
UploadStatusLabel1.Text = "A file with the same name already exists." +
"<br />Your file was saved as " + fileName;
}
else
{
// Notify the user that the file was saved successfully.
UploadStatusLabel1.Text = "Your file was uploaded successfully.";
}
// Append the name of the file to upload to the path.
savePath += fileName;
filetest1 = fileName;
MessageBox.Show(filetest1);
// Call the SaveAs method to save the uploaded
// file to the specified directory.
file.SaveAs(savePath);
}
protected void Compare_Click(object sender, EventArgs e)
{
string filetest1 = FileUpload1.PostedFile.FileName;
**MessageBox.Show(filetest1);**
-------------
obook = oAPP.Workbooks.Open(filetest1);
}
有 2 个消息框,第一个消息框返回上传文件的名称,但第二个消息框返回空消息框
将文件名存储在会话变量中,并在您想要的任何位置使用它