Export worksheet with formatting to a datatable

Aspose.Cells Product Family
1

Hi,


I use blow codes to export worksheet to a datatable & it work correctly.
now i apply some formatting to the worksheet.
How i can export worksheet to a datatable with these formatting

aDataTable = aWorksheet.Cells.ExportDataTable(0, 0,
aWorksheet.Cells.MaxRow + 1,
aWorksheet.Cells.MaxColumn + 1,
true);


aDataGrd.ItemsSource = aDataTable ;
2

Hi,

Thanks for using Aspose.Cells for .NET.

You cannot export formatting directly, but you can read/write cell/worksheet formattings.

Please see the following articles for your more help.


  1. Aproaches to Format Data in Cells
  2. Setting Display Formats of Numbers and Dates
  3. Configuring Alignment Settings
  4. Dealing with Font Settings
  5. Colors and Palette
  6. Formatting Selected Characters in a Cell
  7. Adding Borders to Cells
  8. Colors and Background Patterns
  9. Activating Sheets and Making an Active Cell in the Worksheet
  10. Formatting Rows and Columns
  11. Conditional Formatting
  12. Excel 2007 Themes and Colors