Problem in Loading Excel File While Deleting First Row

[nathabhishek]

Hi !

I get an exception error " ERROR: Could not find a part of the path 'C:\Program Files\Common Files\Microsoft Shared\DevServer\test\Book3.xls'."

The code used is-
try
{

FileUpload1.SaveAs(Server.MapPath("/test/" + FileUpload1.FileName));
Label1.Text = "File name: " +
FileUpload1.PostedFile.FileName + "<br>" +
FileUpload1.PostedFile.ContentLength + " kb<br>" +
"Content type: " +
FileUpload1.PostedFile.ContentType;
//initialize a new Workbook object
Workbook workbook = new Workbook();
//open an excel file
workbook.LoadFromFile(@"..\test\Book3.xls");
//get the first worksheet
Worksheet sheet = workbook.Worksheets[0];
//delete the twelfth row of the first sheet
sheet.DeleteRow(1);
//delete the second column of the first sheet
// sheet.DeleteColumn(2);
//save the excel file
workbook.SaveToFile("Book3.xls", ExcelVersion.Version2007);
//launch the excel file
System.Diagnostics.Process.Start(workbook.FileName);


}
catch (Exception ex)
{
Label1.Text = "ERROR: " + ex.Message.ToString();
}

I even tired Server.MapPath but got the same error.
Excel sheet is attached
Please let me know how can i solve this problem.

[amy.zhao]

Dear nathabhishek,

Thanks for your inquiry.
We find that file extension of the saved file is not correct in your code. Please refer to the code snippet below to solve this issue.

Code: Select all

            Workbook workbook = new Workbook();
            workbook.LoadFromFile(Server.MapPath("Book3.xls"));
            workbook.Version = ExcelVersion.Version2007;
            Worksheet sheet = workbook.Worksheets[0];

            sheet.DeleteRow(1);

            workbook.SaveToHttpResponse("sample.xlsx", Response, HttpContentType.Excel2007);


If you still have this issue, please tell us.

Have a nice day!

Best Regards,
Amy
E-iceblue support team

[harry.support]

Dear nathabhishek,

Does our previous code solve your problem?
Please give you a feedback on this issue at your early convenience.
Thank you!
If you have other any problem, please tell us.

Best regards,

[nathabhishek]

Hi !
The problem is solved ! Thanks to Amy and Hary..!

[amy.zhao]

Dear nathabhishek,

Thanks for your feedback.
We are happy to hear that.
If you have any issues, please feel free to contact us.
Have a nice day!

Best Regards,
Amy
E-iceblue support team