Index zero based error when trying to export datatable to excel

[Alejo Yanczuk]

Hello, I'm currently trying to export a datatable to excel using the example https://support.syncfusion.com/kb/article/8133/export-datatable-to-excel-with-formatting-in-c-vb-net

but when I try to execute the funcion it gives me the error

System.FormatException: 'Index (zero based) must be greater than or equal to zero and less than the size of the argument list.'

Here's the code:

// Export class using System.Data;
using Syncfusion.XlsIO;

namespace WinForm.Helpers
{
public class ExcelExport
{
public void Export(DataTable table, string path)
{
using (ExcelEngine excelEngine = new ExcelEngine())
{
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2016;

IWorkbook workbook = application.Workbooks.Create(1);

IWorksheet worksheet = workbook.Worksheets[0];
worksheet.ImportDataTable(table, true, 1, 1);
worksheet.UsedRange.AutofitColumns();

workbook.SaveAs(path);
}
}
}
}

// Here I use a public variable named Table that is already filled with a datatable when it reaches this step private void excelExportBtn_Click(object sender, EventArgs e)
{
string path = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments).ToString();
string fileName = string.Format("{0}.xlsx", NombreTabla);

string fullPath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments).ToString() + "\\" + fileName;

ExcelExport excelExport = new ExcelExport();
excelExport.Export(Table, fullPath);
MessageBox.Show("Success", "Export");
}

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Alejo,

The shared code snippet looks fine. We suspect there might be an issue with the data in the data table. We request you to share an issue reproducing sample to investigate the query further.

Regards,

Keerthi.

[Alejo Yanczuk]

Thanks for the response, I found the problem. 

I was using string.Format() in another line and I was not passing an argument so it returned the index zero based error. The sfdatagrid, excel converter and datatable were fine.

[Konduru Keerthi Konduru Ravichandra Raju]

Alejo, we are glad that the issue is resolved at your end. Please get back to us if you need any further assistance.