Old vsFlexGrid.SaveGrid to new C1.Win.C1FlexGrid.4?

Posted by: olivier941 on 1 March 2018, 10:59 pm EST

    • Post Options:
    • Link

    Posted 1 March 2018, 10:59 pm EST


    I have some old application in VB5 that use the old method vsFlexGrid.SaveGrid I have some files coming from this method How can I Load then into the new C1.Win.C1FlexGrid.4 ? I cant see any LoadGrid method in this new grid !


  • Posted 3 March 2018, 1:38 am EST


    We do offer LoadGrid method, with various overloads in C1FlexGrid. However, to use this method you need to add reference to C1.Win.C1FlexGrid.ImportExport.4.dll. Here’s the history URL informing about the migration of C1FlexGrid’s import/export methods to a different assembly named C1.Win.C1FlexGrid.ImportExport.4 (can be found at C:\Program Files (x86)\ComponentOne\WinForms Edition\bin\v4.0): WinForms Edition Documentation Also, you might to refer to following Documentation link for information about various import/export features in C1FlexGrid: WinForms Edition Documentation

    Let me know, if you need anything else.

    Regards, Ruchir Agarwal

  • Posted 16 May 2018, 7:10 am EST

    Should the C1.Win.C1FlexGrid.ImportExport.4 be included in licenses.licx? If so, what would be the format?

  • Posted 16 May 2018, 3:23 pm EST


    You need not add any entry for C1.Win.C1FlexGrid.ImportExport.4.dll in licenses.licx file. To use this dll methods, you just need to add reference of this dll in your project and add the Using/Imports statement for the namespace C1.Win.C1FlexGrid in your form.cs file.

    Thanks, Ruchir

  • Posted 26 November 2018, 4:32 am EST


    Sorry but it doesn’t work :frowning:

    Here’s in attachment, my old VB5 file create with VsFlexgrid7.SaveGrid method

    VsFlexgrid1.SaveGrid “c:\expor.TXT”, flexFileAll, True

    How can i Load this file in the New C1.Win.C1FlexGrid.4

    any sample code ?


  • Posted 26 November 2018, 4:36 pm EST

    Hello Olivier!

    I could not see any attachment in your post. However, I’m attaching a sample application for your reference. This should help you. Prj_LoadGrid.zip

    Regards, Meenakshi

  • Posted 26 November 2018, 8:38 pm EST

    Here’s the file



  • Posted 26 November 2018, 8:43 pm EST

    [quote]However, I’m attaching a sample application for your reference. This should help you.


    your sample use the FileFormatEnum.TextComma format

    but in my sample, i use the old flexFileAll format from VsFlexGrid

    see my attachment



  • Posted 28 November 2018, 5:31 pm EST


    I would like to inform you, in WinForms C1FlexGrid control, only text values are saved in/loaded from text file and not formatting information. In case you want to save/load values along with formatting, I suggest you to work with XML or Excel files.

    Please follow the given help pages, for detailed information on the same:

    1. WinForms Edition Documentation
    2. WinForms Edition Documentation

    Regards, Meenakshi

  • Posted 29 November 2018, 7:10 pm EST


    It meens that all my files saved with the old method (VB6) : VsFlexGrid.SaveGrid with the format flexFileAll http://helpcentral.componentone.com/docs/vsflexgrid8/savegridmethod.htm

    are unusable.

    what a pity :frowning:


  • Posted 3 December 2018, 7:32 pm EST


    I’m sorry, but please note that both the grids (C1FlexGrid and VSFlexGrid) are different in their architectural-designs. And hence, C1FlexGrid allows to save/load formatting information using Excel and XML files only, and not with text files.

    Best regards, Meenakshi

  • Posted 4 December 2018, 8:22 pm EST

    Hello, we have the same problem with VB6 (VSflexGrid8) to .NET

    I’m testing C1 V4 Vsflexgrid. Why is there no possibilty to open old Files (Format “flexFileAll”) ?? In our saved files are very important data. You are the manufactor of this software and this should not a problem to implement?

    Regards Daniel

  • Posted 4 December 2018, 11:21 pm EST

    I confirm that this is really very annoying. I hope they can find an issue !

    thanks olivier

  • Posted 5 December 2018, 11:02 pm EST

    HI Daniel/Olivier!

    Currently, due to different architectural designs of both the grids, this is not possible to load older text files. However, I’ve asked the development team to look into this issue if anything can be done. You’ll be notified once there is any update from them.

    Regards, Meenakshi

  • Posted 28 December 2018, 10:27 pm EST


    any news from the development team ?


  • Posted 1 January 2019, 8:36 pm EST

    Hi Olivier,

    The developers are discussing this case internally. I will update the thread once there is any conclusion from them.

    Thanks, Pragati

  • Posted 18 February 2019, 11:18 pm EST


    Have they had time to discuss?

    Some ideas :

    Take the code of the VsFlexGrid8.LoadGrid () method and redo it in a C1FlexGrid.LoadOldVsFlexgrid method


    Thank you


  • Posted 20 February 2019, 6:29 pm EST

    Hello Olivier,

    I have your feedback forwarded to the developers and they are still discussing about the feasibility of this feature in the control.

    Thanks, Ruchir

  • Posted 2 July 2019, 12:33 am EST

    Hello. I imagine that adding a function can take time, but now, it’s a lot of time :slight_smile: can you give me news? does it seem possible to do this function?

    thank you Olivier

  • Posted 7 August 2019, 9:10 pm EST

    Hello Olivier,

    Apologies for the delay. As per the discussion with the developer, there is a way: You can load the VSFlexGrid data files into a VSFlexGrid, then save them back as Excel files. These excel files can then be read by the C1FlexGrid.

    In addition to this, what I can try is request the developers to create a utility that shall expose a method for reading the files and loading them in C1FlexGrid. If that’s okay, I would request you to kindly confirm so I can request the developers for it.

    Regards, Ruchir

  • Posted 10 October 2019, 7:39 pm EST


    Yes please.

    Thanks Olivier

  • Posted 23 January 2020, 2:14 am EST


    and ?


  • Posted 26 January 2020, 5:01 pm EST

    Thanks Olivier for confirming. I have requested the developers for the same [ID:356551]. We will keep you updated with the progress over this.

    Best wishes, Ruchir

  • Posted 26 January 2020, 5:03 pm EST


    I have asked for an ETA for the utility and will share with you as soon as the developers share it.

    Regards, Ruchir

  • Posted 28 January 2020, 10:20 pm EST

    Hi Oliver,

    Would it be possible for you to share with us some of the older text files that includes the formatting information? The team would want to test the utility being prepared on these files.

    Thanks, Ruchir

  • Posted 21 April 2020, 12:03 am EST


    I have same problem just migrating from olf flexgrid to C1(but 2010 year version). In old grid we have in first column Tree with nodes with few levels and everything is saved “flexFileAll” so I tried to save to Excel format and Load with C1 as excel, but seems Loading method not reading everything cause I’m lacking a lot of rows. I tried:

    flexOld1.LoadGrid(file, VSFlex8L.SaveLoadSettings.flexFileAll); flexOld1.SaveGrid(file, VSFlex8L.SaveLoadSettings.flexFileExcel); flexC1.LoadGrid(file, FileFormatEnum.Excel);

    If I open new file with Excel I see a lot of hidden rows, and those rows not loaded into grid. Maybe I’m missing something?

    I’m new to flexgrid and C1. And i know we have an old 2 versions, but before we can update to newest version we need to rewrite everything from old flexgrid.

  • Posted 21 April 2020, 2:59 am EST

    Hello Here’s one file simple file

    thanks Olivier

  • Posted 21 April 2020, 3:35 pm EST

    Hello Julius,

    So, the problem you’re facing is that C1FlexGrid does not load the hidden rows from Excel? I tested this using C1FlexGrid version: 2.6.20101.545 and invoking either the LoadGrid or LoadExcel method, both works properly. See attached file. Do you see the issue running this application? If no, please modify it making it structurally similar to your application and share back so that I can have a look.

    Thanks, LoadingHiddenRows_C1FlexGridv2010.zip

  • Posted 21 April 2020, 3:36 pm EST

    Hello Olivier,

    I do not see any file attached with your reply. Could you please re-upload?


  • Posted 21 April 2020, 7:05 pm EST - Updated 3 October 2022, 2:06 pm EST

    here’s the file testFile.zip

  • Posted 21 April 2020, 8:48 pm EST

    Ty for reply. Because .SaveGrid saved collapsed rows in Excel as Hidden rows, .LoadExcel(and probably LoadGrid) cant see them. We save user grid, so next time he opens he will same window. Your workaround seems good. Thank you

  • Posted 22 April 2020, 9:24 pm EST

    So, as it seems the solution we provided works for you and the issue is now resolved. If you face any other problem, do create a post.

    Regards. Ruchir

  • Posted 22 April 2020, 9:25 pm EST

    [quote=“olivier941”] here’s the file testFile.zip [/quote]Thank you, Olivier. I have passed it to the developer for testing the utility.

    Thanks, Ruchir

  • Posted 22 April 2020, 10:39 pm EST

    To be precise, I used the old version : component One VsFlexGrid Light 7.1


  • Posted 22 April 2020, 10:48 pm EST

    For future who will read this to make it clear: Workaround for me “how to read old FlexGrid8L file with new C1Flexgrid” is in old flexgrid expand whole tree or make all rows visible and save(oldFlexGrid.SaveGrid(YourXlsFile, VSFlex8L.SaveLoadSettings.flexFileExcel) it in excel format(.xls), expand tree needed to make sure rows wont be hidden cause new grid wont see those rows, then the last thing need to use C1Flexgrid.LoadExcel and C1Flexgrid.SaveGrid to new format.

  • Posted 26 May 2021, 3:53 am EST


    I’m very disapointed :frowning: 2 years and style not have any issues for that

    can your developper can’t add a simple method ? do they have the old source code from vsFlexGrid7 ?

    here’s an attached file for sample

    it’s a file create with the .SaveGrid method from an old * "vsflexgrid7 " component and with * "arcAdd " option


    it’s vsFlexGrid 7 and * "NOT " 8

    for your purpose, it has : 32 columns and 445 rows

    thanks for any help


    To be precise, I used the old version : component One VsFlexGrid Light 7.1



  • Posted 26 May 2021, 11:17 pm EST


    Sorry for the inconvenience. The developers have tried creating the utility but did not get any breakthrough, and after that, they did not get time to look and work on it again due to other releases in hand. But it is on their to-do list, and they would definitely work on it again. We have asked the developers to take this as a priority, and we will let you know as soon as we get the update from their side.

    Regards, Prabhat Sharma.

  • Posted 26 May 2021, 11:49 pm EST

    Hello If you manage to do this function, I say a big thank you. I have a lot of files that are in the same configuration.

    thank you so much

  • Posted 28 April 2023, 8:30 pm EST



    *still nothing in my inbox ?



  • Posted 1 May 2023, 7:24 pm EST

    Hello Oliver,

    Apologies for the inconvenience.

    We are getting in touch with the developers to take an update on this and will get back to you on this soon.


    Prabhat Sharma.

  • Posted 1 May 2023, 7:25 pm EST

    Hello Oliver,

    Apologies for the inconvenience.

    We are getting in touch with the developers to take an update on this and will get back to you on this soon.


    Prabhat Sharma.

  • Posted 20 May 2023, 7:43 pm EST

    Hi Ruchir,

    I could not find this file in folder: C:\Program Files (x86)\ComponentOne\WinForms Edition\bin\v4.0

    How can I get this file.


    Duyet Le

Need extra support?

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

Learn More

Forum Channels