Issues with Spire xls deleting column

[soumyam]

I am trying to delete column using workbook.DeleteColumn(index) but it doesn't delete the column and shows some error after generating the excel as need to format the excel.
After using the SaveTofile() method also it is not working

[Simon.yang]

Hello,

Thanks for your post. After an initial test with Spire.XLS Pack(Hotfix) Version:8.4.6, I was unable to reproduce the issue. Please use the version and try again. If you still encounter the issue, please share us with your Excel file and full code for further investigation.

Best regards,
Simon
E-iceblue support team

[soumyam]

Hi ,

Thanks for the reply i am using spire 7.4.7.7040.Do i have upgrade to latest package or is there any work around?

[Simon.yang]

Hello,

Please first update to the latest version and give it a try. In case the issue still exists, please share us with your input Excel file and full code.

Best regards,
Simon
E-iceblue support team

[soumyam]

Hey Simon,

Thanks for quick response and tried with latest spire version but facing the same issues.
Cannot share the file but there is a formatting existing for all the columns so do i have to clear the filter and clear the formatting before deleting the column?

[Simon.yang]

Hello,

Thank you very much for your details. I encountered a 'System.NullReferenceException' when saving the document after deleting the column that had filter. I have logged the issue into our bug tracking system. If any update, we will let you know.

Best regards,
Simon
E-iceblue support team

[soumyam]

Hi Simon,

Thanks a lot i was also getting the same exception and please let me know if you guys have any work around or fix in the future versions.

Regards,
Soumya

[Simon.yang]

Hello Soumya,

Thanks for your inquiry. The issue has been fixed and it's at the test stage. Once the new version is available, we will inform you.

Best regards,
Simon
E-iceblue support team

[soumyam]

Thanks a lot

[Simon.yang]

Hello,

The new version(Spire.XLS Pack(Hotfix) Version:8.5.1) is available now. Please download it and have a try.

Best regards,
Simon
E-iceblue support team

[Simon.yang]

Hello,

Has the hotfix resolved your issue?
We will appreciate it if you could give us some feedback.

Best regards,
Simon
E-iceblue support team

[soumyam]

HI Simon,

I will try the new version and let you know thanks for your help and support.

Regards,
Soumya

[soumyam]

Hi,

I have downloaded the latest Spire version and the issue is fixed. Thanks for helping out.You saved me

[Simon.yang]

Hi Soumya,

Glad to hear that the hotfix has resolved your issue. It's my pleasure. If there is any other question, please feel free to contact us.

Best regards,
Simon
E-iceblue support team