The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
When I have a spreadsheet that has formulas in the cells, and I use ExportDataTable of the worksheet object to populate a datatable, the data comes in as the formula and not as the display text. Is there a workaround?
GMGeetha M Syncfusion Team September 16, 2009 01:05 PM UTC
Hi Mialee,
By default, only the cell values are used to when exporting to datatable and if you want to have DisplayText, then you may need to iterate through each and every cell and add it to the table.
Please let me know if you have any further questions.