We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Import dataTable to excell with Border

Hi ,
In our project we are using as-pose.cells DLL’s.
I need to import data table to excel sheet.
I am able to import using ImportDataTable.
Is there any way to create border for that table

Hi,


Well, there is no direct way to set borders when you use ImportDataTable() method. You have to set borders by yourself after or before you use ImportDataTable method to import data to fill the worksheet cells, see the sample document on how to set borders to the cells:
http://www.aspose.com/docs/display/cellsnet/Adding+Borders+to+Cells


or see the content/example under “Format Ranges…Adding Borders to a Named Range” in the document:
http://www.aspose.com/docs/display/cellsnet/Named+Ranges

Thank you.