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,
  • Marked as Answer

    Replied 28 November 2019, 6:24 pm 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
Need extra support?

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

Learn More

Forum Channels