- Home
- Forum
- ASP.NET Web Forms
- Remove rows on excel
Remove rows on excel
I need remove de two first rows of excel. I do this:
string filename = MapPath("operacionespendientesZeus.xlsx");
string fileoutput = MapPath("operacionespendientesZeusModified.xlsx");
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2013;
IWorkbook workbook = application.Workbooks.Open(filename);
IWorksheet worksheet = workbook.Worksheets[0];
worksheet.DeleteRow(1, 2);
if (File.Exists(fileoutput))
File.Delete(fileoutput);
workbook.SaveAs(fileoutput);
workbook.Close();
excelEngine.Dispose();
But the excel saved is corrupt.
I attach an example project
Hi Manolo
We are unable to reproduce the reported issue from our side. We have shared a simple sample for your reference which can be downloaded from following link.
Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Sample1204723539.zip
We suspect that this issue might be due to the input excel file. Please share us the input excel file or issue reproducing sample (which you have forgot to attach in your previous post) along with your working Syncfusion assembly version which will be helpful for us to provide you a prompt solution at the earliest.
Regards,
Dilli babu.
Can you test my project? When I save the excel, the result is an excel corrupt
Attachment: ExcelModification_50134e70.zip
Hi Manolo,
We were able to reproduce the problem and have logged defect report regarding this. A support incident to track the status of this defect has been created under your account. Please log on to our support website to check for further updates
https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents
Please let me know if you have any questions.
Regards,
Dilli babu.
You can follow the incident regarding the reported issue in this forum and please let us know if you need any further assistance on this.
Regards,
Dilli babu.
- 5 Replies
- 2 Participants
-
MA Manolo
- Mar 10, 2016 09:11 AM UTC
- Mar 15, 2016 04:20 AM UTC