C1Datagrid as blank Excel sheet

C1Datagrid as blank Excel sheet

Posted by: anildabral3k on 26 August 2019, 4:27 am EST

• 

  anildabral3k

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 August 2019, 4:27 am EST

  Hi,
  
  How can I create an Excel like blank worksheet using C1Datagrid?
  
  Basically, I want a blank C1Datagrid with blank cells. User can enter/edit values in those cells, creating tables on the fly. Later I want to save this user data in the CSV format.
  
  Please help.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 27 August 2019, 3:28 am EST

  Hello,

  I would recommend you to use the “FlexSheet” control instead of “C1Datagrid” control to achieve your requirement.
  
  FlexSheet for WPF is a fast, lightweight, and powerful control that extends the functionality of C1FlexGrid to provide many Excel-like features.
  
  To know more about Flexsheet, please refer the following documentation link:
  
  https://help.grapecity.com/componentone/NetHelp/C1FlexSheetWPFSL/webframe.html#FlexSheetforWPFOverview.html
  
  https://help.grapecity.com/componentone/NetHelp/C1FlexSheetWPFSL/webframe.html#ExportingFlexSheet.html

  Thanks.

• 

  anildabral3k

  • Post Options:
  • Link
    Copy

  Posted 27 August 2019, 10:49 am EST

  Thank you for your response, Mohitg.
  
  I created a C1FlexSheet sample and typed in few values, creating a matrix of size 3x4 and left the remaining cells blank. When I exported the sheet to CSV, I got my 3x4 data but along with that I got lot of empty double quotes, for blank cells. How can I drop these empty cells (unused cells) during exporting to CSV?

  Thanks,

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 28 August 2019, 9:36 am EST

  Hello,

  I have escalated the same to our development team(395858) as an enhancement and will inform you once I get any reply from them.

  Thanks.

• 

  anildabral3k

  • Post Options:
  • Link
    Copy

  Posted 5 September 2019, 1:11 am EST

  Hi Mohitg,
  
  Thank you for the escalation. I will wait for the solution.

  Regards,

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 29 November 2019, 3:24 am EST

  Hello,

  I am glad to tell you that it is fixed in the latest build of C1WPF i.e 2019 V3. Please download the latest build to have this fix.

  Thanks,
  
  Mohit