[Sv] - Can i combine multi export option?

[The GridLock]

Hi,

I tried exporting data contains datetime format to datatable,I need to combine 2 conditions with or without header and require detectdatatype.

Can i do this?

sheet.ExportDataTable (sheet.Range ["A1: C4"], ExcelExportDataTableOptions.DetectColumnTypes &&ExcelExportDataTableOptions.columnname);

Thanks you!

[Shamini Kiruba Sobers]

Hi Khanh Dang, 

Greetings from Syncfusion. 

You can achieve your requirement by slightly modifying your code with ‘|’ symbol to utilize multi export option as below. 

Code snippet: 

sheet.ExportDataTable(sheet.Range["A1:C4"], ExcelExportDataTableOptions.DetectColumnTypes | ExcelExportDataTableOptions.ColumnNames); 

Kindly let us know if it helps. 

Regards, 

Shamini 

[The GridLock]

Thanks Shamini,

This will help me soon.

[Shamini Kiruba Sobers]

Hi Khanh Dang, 

We are glad that you are happy with the solution. 

Regards, 

Shamini 

[Christoph]

Hi,

but what about NO ColumnNames?

I what the first row as data row and not for column names.

I can use  ExcelExportDataTableOptions.ColumnNames but what is the opposite?

Regards

Christoph

[Kurmitha Manickhaperumal]

Hi Christoph, 

Greetings from Syncfusion. 

You can achieve your requirement by slightly modifying your code as below. 

Code snippet:

sheet.ExportDataTable(sheet.Range["A1:C4"], ExcelExportDataTableOptions.DetectColumnTypes); 

Kindly let us know if it helps. 

Regards, 

Kurmitha M.