Plz solve my problem, it''s urgent

[Sachin]

Hi,
How can i add column to excel sheet using the syncfusion control. I want to add one more column to the alredy present excel sheet.
Thanks in advance

[Melba Winshia]

Hi Sachin,

By using Essential XlsIO you can insert a column into the worksheet at any location by calling the InsertColumn method. InsertColumn method takes the index of the column where the new column will be inserted. Please refer the following code snippet that illustrates the above:

[C#]

//Inserting a column into the worksheet
sheet.InsertColumn(1);

// Insert Multiple Columns.
sheet.InsertColumn(3,5);

[VB.NET]

'Inserting a column into the worksheet
sheet.InsertColumn(1)

'Insert Multiple columns.
sheet.InsertColumn(3,5)

Please refer the following sample which implements the above said feature:

InsertColumn.zip

Please take a look at the sample above and let me know if you have any other questions.

Best Regards,
Melba