Delete Column for Excel doesn''t work

[Gurbhej Dhillon]

Hi,

I am trying to delete several columns in my sheet but it seems like only the last column is deleted. Should I do anything after deleting any columns?

I am using Syncfusion.ExcelRW.Windows v3.301

Code
----------------------
IWorkbook myWorkBook = ExcelUtils.CreateWorkbook(1);
IWorksheet sheet = myWorkBook.Worksheets[0];

sheet.DeleteColumn(1);
sheet.DeleteColumn(8);
sheet.DeleteColumn(9);
sheet.DeleteColumn(12);

Only column 12 gets deleted.

[Sarathi D]

Hi Gurbhej,

Thank you for posting your query to us.

I am afraid that i am not ab;e to reproduce the issue you stated. i have attached the sample under which i tried to reproduce the issue and the sample is available here.

http://www.syncfusion.com/Support/user/uploads/GridData_74c77d48.zip

Please have a look at the above sample and if still the issue exists, could you please try reproducing it
in the above sample or send us the reproducing steps so that we could sort out the cause of the issue
and provide you a solution?

Regards,
Sarathi

[Gurbhej Dhillon]

Hi,

This sample is using the latest version of Syncfusion. Can you please try using version 3.301.0.0 (.NET Version 1.1) and provide an example with that version if you are not able to reproduce.

Thanks,

Gurbhej

>Hi Gurbhej,

Thank you for posting your query to us.

I am afraid that i am not ab;e to reproduce the issue you stated. i have attached the sample under which i tried to reproduce the issue and the sample is available here.

http://www.syncfusion.com/Support/user/uploads/GridData_74c77d48.zip

Please have a look at the above sample and if still the issue exists, could you please try reproducing it
in the above sample or send us the reproducing steps so that we could sort out the cause of the issue
and provide you a solution?

Regards,
Sarathi

[Administrator]

Hi Gurbhej,

I am not able to reproduce the above specified issue in Syncfusion Essential Studio 2008 Volume 1 Final version which is available for download in the below location.

Download link:

http://www2.syncfusion.com/installs/v6.1.0.34/syncfusionessentialstudiosetup.exe (113 MB)

Unlock key:

If your Essential Studio license is current, you will be able to obtain the key to install this version from your account in DirectTrac. Otherwise, please contact your Syncfusion Sales Representative or e-mail [email protected].

Please let me know if this helps you.

Regards,
Jaya