C1XLBook to DataSet / C1Sheet to DataTable

C1XLBook to DataSet / C1Sheet to DataTable

Posted by: ivan.stanojkovski on 6 June 2022, 7:37 am EST

• 

  ivan.stanojkovski

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 June 2022, 7:37 am EST

  Hi,

  Is there any simplified way to convert C1XLBook to DataSet or C1Sheet to DataTable.
  
  We encounter a problem where we want to detect DataType and Precision on columns if they are String, Decimal, Integer, Date, DateTime, etc.
  
  How can we achieve this when creating a new DataTable and defining its columns names with the correct types and sizes.

  Best regards

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 7 June 2022, 5:22 am EST

  Hi,

  Unfortunately, there is no direct way to convert the C1XLbook to a DataSet or XLSheet to a DataTable. You will need to manually generate the DataTables by reading the Data from the XLSheet(s) and then adding these Tables to the DataSet. Please refer to the attached sample showing a simple implementation of the same.

  C1ExcelToDataSet.zip

  Kind Regards,
  
  Kartik