Enable Datatypes on Columns and Cells

[Jatin Gundabathula]

I had requirement to enable predefined datatypes like Boolean(True,False), Real, Integer and String for particular columns and i also i have custom datatypes like Option list (ex: a,b,c )

So currently i am using syncfusion libraries to generate excel with some headers 

Technical Things:

I am using ExcelEngine  class to generate workbook and i have multiple worksheet so i am creating worksheet as below  
var worksheet = workbook.Worksheets.Create(dataTable.TableName); 

worksheet.ImportDataTable(dataTable, true, 1, 1);
Here dataTable is  DataTable object which has few columns and rows.

For Example it has column names like (ID, DataBoolean, DataReal, DataInt,DataString, Datalist)

now if i do the export i will have empty excel with all these column as headers in worksheet. when user tries to fill that sheet he can able to enter free text in all the cells because there is no DataValidation or Datatype was enable to all the columns.

So i need the example how we can enable the datatypes of each column so that user can enter valid values.

Please do let me know if you need more information 

currently i am trying this but performance is very slow

IDataValidation intvalidation = column.EntireColumn.DataValidation;

                                    intvalidation.DataRange = worksheet.UsedRange;

                                    intvalidation.AllowType = ExcelDataType.Integer;

you can reach out to me on [email protected] or call me on 9492300423

[Shamini Kiruba Sobers]

Hi Jatin, 

Greetings from Syncfusion. 

Please find the response for your queries from the below table. 

Query	Response
So i need the example how we can enable the datatypes of each column so that user can enter valid values.	We have prepared a working sample with few data types (that are supported with data validation) to enable the datatypes of each column, which validates the user input in particular columns and restricts the invalid values. Please find the sample from the following link.  https://www.syncfusion.com/downloads/support/directtrac/general/ze/F1525321559460932
currently i am trying this but performance is very slow    IDataValidation intvalidation = column.EntireColumn.DataValidation;  intvalidation.DataRange = worksheet.UsedRange;  intvalidation.AllowType = ExcelDataType.Integer;	Kindly look into the following link and try the below code to improve performance.  https://help.syncfusion.com/file-formats/xlsio/improving-performance#data-validation  IDataValidation intvalidation = column.EntireColumn.DataValidation;  intvalidation.BeginUpdate();  intvalidation.AllowType = ExcelDataType.Integer;  intvalidation.EndUpdate();

Kindly let us know if the provided solution helps. 

Regards, 

Shamini. 

[Jatin Gundabathula]

Thanks for information we can close this thread.

[Shamini Kiruba Sobers]

Hi Jatin,

Thanks for the update. We are glad that the provided information helped you. 

Regards, 

Shamini