How to retrieve from DataTable?

[aomcastor]

My small tool is kind of complicated to explain. But it is better to get to the point.

How can I insert a single row, cell or column from a DataTable? I am not refering in DataColumn or DataRow, but single data from a DataTable.

Can it be possible?

[amy.zhao]

Hi,

Thanks for your inquiry.
Sorry that I don't understand your problem well. Do you want to insert a single row, cell or column from a DataTable into an excel file?

I am not refering in DataColumn or DataRow, but single data from a DataTable.

Sorry that I am not clear that, please provide me an example.

Thank you.

Best Regards,
Amy
E-iceblue support team

[aomcastor]

Sorry, I meant to use InsertDataTable instead of InsertDataColumn for the same porpuse.
Also, if that works to insert rows, cells and ranges. Can it be possible?

[amy.zhao]

Hi,

The method

Code: Select all

InsertDataTable(DataTable dataTable, bool columnHeaders, int firstRow, int firstColumn, int maxRows, int maxColumns); 

can do it, please try it.
Examples:
//Add the first row of dataTable to sheet
sheet.InsertDataTable(dataTable, false, 1, 1, 1,dataTable.Columns.Count);
//Add the first cell of dataTable to sheet
sheet.InsertDataTable(dataTable, false, 1, 1, 1,1);
//Add the data from row1column1 to row1column3 of dataTable to sheet
sheet.InsertDataTable(dataTable, false, 1, 1, 1,3);

Best Regards,
Amy
E-iceblue support team

[amy.zhao]

Hi,

Has your issue been resolved?
Thanks for your feedback.

Best Regards,
Amy
E-iceblue support team

[aomcastor]

Well, honestly I solved the problem of my code by myself with another method. My problem happened on the iteration over the datatable and a Mysql connection, which it had duplicated the data I was asking for.

Sorry, thanks for the quick response but I did not use it... yet.

Although I congrats you for your service.

[amy.zhao]

Hi,

Thanks for your feedback.
I am glad that your issue has been resolved.
Welcome to feel free to write to us again for further problems. We are here to help you.

Best Regards,
Amy
E-iceblue support team