C1Datagrid as blank Excel sheet

Posted by: anildabral3k on 25 August 2019, 7:27 pm EST

  • Posted 25 August 2019, 7:27 pm 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.
  • Replied 26 August 2019, 6:28 pm 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.
  • Replied 27 August 2019, 1: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,
  • Replied 28 August 2019, 12: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.
  • Replied 4 September 2019, 4:11 pm EST

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

    Regards,
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels