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.
Syncfusion Feedback

Block row and column

Thread ID:

Created:

Updated:

Platform:

Replies:

94726 May 30,2010 08:05 AM UTC Jun 2,2010 06:57 AM UTC Windows Forms 6
loading
Tags: XlsIO
Domenico Pagnotta
Asked On May 30, 2010 08:05 AM UTC

Hi,

is it possible to insert a Block top line(row) and/or first block column?

Regards




Sathish Babu R [Syncfusion]
Replied On May 31, 2010 07:15 AM UTC

Hi Domenico,

Thank you for your interest in Syncfusion Products.

In Our XlsIO, we have two “InsertRow()” and “InsertColumn()” methods to insert the row and column in the worksheet respectively, please use the below code snippet in your program and also we have created the sample for your reference with the assembly version 8.2.0.18 in 3.5 .Net Framework. Could you please get the sample from the below link and let us know if this helps you.

Code-Snippet:
IWorksheet worksheet = workbook.Worksheets[0];
worksheet.InsertRow(1);
worksheet.InsertColumn(1);

Sample:
http://help.syncfusion.com/samples/xlsio.windows/samples/F94726.zip

Please, let me know if you need any clarifications.

Regards,
Sathish

Domenico Pagnotta
Replied On June 1, 2010 07:04 AM UTC

Thanks for your reply.
I create a new file xlsx with the ImportDataTable, I use the Syncfusion version 7.403.0.20.
I want to lock or freeze specific rows and/or columns in order to make them visible when you scroll in the worksheet.

Regards



Example_42af57aa.zip

Sathish Babu R [Syncfusion]
Replied On June 1, 2010 11:41 AM UTC

Hi Domenico,

Thank you for your interest in Syncfusion Products.

In XlsIO, to freeze or unfreeze the row or column please use the below code snippet in your code and also we have created a sample and tested with the 7.4.0.20 Assemblies (3.5 framework). Please try the sample from the below link and let us know if this helps you.

Code-Snippet:

To Freeze:
worksheet.Range[2, 1].FreezePanes();

To UnFreeze:
worksheet.RemovePanes();

Sample:
http://help.syncfusion.com/samples/xlsio.windows/supports/F94726.zip

Online Documentation Link:
http://help.syncfusion.com/ug_82/Reporting_XlsIO/FreezePane.html

Please let us know if you have any queries.

Regards,
Sathish

Domenico Pagnotta
Replied On June 1, 2010 04:52 PM UTC

Thanks, it's very good

Domenico Pagnotta
Replied On June 1, 2010 04:52 PM UTC

Thanks, it's very good

Sathish Babu R [Syncfusion]
Replied On June 2, 2010 06:57 AM UTC

Hi Domenico,

Thanks for the update and please let us if you have any other queries.

Regards,
Sathish

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.

Warning Icon 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.Close Icon

;