How can I export the data of sfdatagrid to txt?

[nam ki hun]

The export method of sfdatagrid seems to have html and pdf.

I want to export as a tab-delimited txt file.

Is there a way?

[Vijayarasan Sivanandham]

Hi nam ki hun,

Thank you for contacting Syncfusion support.

Your requirement can be achieved export the SfDataGrid into Excel. The exported workbook can be saved as txt file by using the SaveAs method. Please refer the below code snippet, 

private void BtnExportExcel_Click(object sender, EventArgs e) 

{ 

            var options = new ExcelExportingOptions(); 

            options.ExcelVersion = ExcelVersion.Excel2013; 

            var excelEngine = sfDataGrid.ExportToExcel(sfDataGrid.View, options); 

            var workBook = excelEngine.Excel.Workbooks[0]; 

            workBook.SaveAs("Sample.txt", "\t");             

}   

Sample Link: https://www.syncfusion.com/downloads/support/forum/165669/ze/Sample1581333262 

UG Link: https://help.syncfusion.com/windowsforms/datagrid/exporttoexcel#export-to-csv

Please let us know if you have any concerns in this.

Regards,
Vijayarasan S 

[nam ki hun]

Thank you.

solved ^^

[Vijayarasan Sivanandham]

Hi nam ki hun,

Thanks for the update.

We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you😊.

Regards, 

Vijayarasan S