We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Delete Column for Excel doesn''t work

Thread ID:

Created:

Updated:

Platform:

Replies:

68332 Sep 18,2007 11:41 AM Dec 26,2007 12:35 AM Windows Forms 3
loading
Tags: XlsIO
Gurbhej Dhillon
Asked On September 18, 2007 11:41 AM

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 [Syncfusion]
Replied On September 18, 2007 09:20 PM

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
Replied On September 19, 2007 09:48 AM

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 [Syncfusion]
Replied On December 26, 2007 12:35 AM


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 salessupport@syncfusion.com.

Please let me know if this helps you.

Regards,
Jaya


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;