title: Spreadsheetgear: Exporting from DataGrid and DataList to single Excel file plus formatting
body: <p>Previously before installing <code>SpreadSheetGear</code>, I manage to have an export button that can export all the correct data from both the <code>DataList</code> and <code>DataGrid</code> into an Excel file, but the formatting is a big problem. After every row of data from the <code>DataList</code>, there will be another blank row. I need to bold the texts in a few cells and create borders, and currently there is no row to separate the <code>DataList</code> and <code>DataGrid</code>, they are joint together. </p>
  
  <p>How do I go about using <code>SpreadSheetGear</code> to export the <code>DataList</code> and <code>DataGrid</code> to a single Excel file?</p>
  
  <p>Or are there other libraries that can do this more efficiently?</p>
  
  <p>Edit: On SpreadSheetGear website, there are samples and How-To sections, but the closest I can find is from Excel to DataGrid, totally different from what I want.</p>