Upload Excel file with cell properties using Closed XML

Question

Hi All,

 

We are using closedXML version 0.76.0.0 and our query is given below 

 

File Upload :  

We are trying to upload an excel file using closed xml. And we want to store excel cell value in db with its properties like comments and color code applied to each cell.

Currently, we are extracting the data from the sheet and converting it into Datatable. But we are not able to store cell properties into the datatable with appropriate mapping with the cell values.

 

Is there any way where we can get the cell values along with cell properties and save it into database? 

 

File Download :  

 We need to generate an excel file with cell values and properties like comments and color codes. Currently we are using datatable to generate excel file. But we are not able to apply cell properties to the cell with appropriate mapping with the cell values.

 

Is there any way where we can get the cell values along with cell properties from database and generate the excel file? 

 

Note : We need to extract the data dynamically, so using row index and column index is not an option for us for upload and download both.

 

 

Please find attached sample excel file with comments and color code applied.