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

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

  • Posted 1 March 2018, 10:59 pm EST

    Hello

    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 !

    thanks
  • Replied 3 March 2018, 1:38 am EST

    Hi,

    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): http://help.grapecity.com/componentone/NetHelp/WinForms_ReleaseHistory/webframe.html#2017v3.html
    Also, you might to refer to following Documentation link for information about various import/export features in C1FlexGrid: http://help.grapecity.com/componentone/NetHelp/c1flexgrid/webframe.html#savingloadingandprinting.html

    Let me know, if you need anything else.

    Regards,
    Ruchir Agarwal
  • Replied 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?
  • Replied 16 May 2018, 3:23 pm EST

    Hello,

    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
  • Replied 26 November 2018, 4:32 am EST

    Hello

    Sorry but it doesn't work :-(

    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 ?

    thanks

  • Replied 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
  • Replied 26 November 2018, 8:38 pm EST

    Here's the file

    thanks

    expor.zip
  • Replied 26 November 2018, 8:43 pm EST

    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

    thanks


    expor.zip
  • Replied 28 November 2018, 5:31 pm EST

    Olivier!

    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. http://help.grapecity.com/componentone/NetHelp/c1flexgrid/webframe.html#C1.Win.C1FlexGrid.ImportExport.4~C1.Win.C1FlexGrid.FileFormatEnum.html
    2. http://help.grapecity.com/componentone/NetHelp/c1flexgrid/webframe.html#C1.Win.C1FlexGrid.ImportExport.4~C1.Win.C1FlexGrid.FileFlags.html

    Regards,
    Meenakshi
  • Replied 29 November 2018, 7:10 pm EST

    Hello

    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 :-(

    thanks





  • Replied 3 December 2018, 7:32 pm EST

    Hello!

    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
  • Replied 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
  • Replied 4 December 2018, 11:21 pm EST

    daniel.franke said:
    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?



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

    thanks
    olivier
  • Replied 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
  • Replied 28 December 2018, 10:27 pm EST

    Hello

    any news from the development team ?

    thanks
  • Replied 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
  • Replied 18 February 2019, 11:18 pm EST

    Hello.

    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

    olivier
  • Replied 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
  • Replied 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 :-)
    can you give me news?
    does it seem possible to do this function?

    thank you
    Olivier
  • Marked as Answer

    Replied 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
  • Replied 10 October 2019, 7:39 pm EST

    Hello

    Ruchir.Agarwal said:
    Hello Olivier,
    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



    Yes please.

    Thanks
    Olivier
  • Replied 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
  • Replied 23 January 2020, 2:14 am EST

    Hello

    and ?

    thanks
  • Replied 26 January 2020, 5:03 pm EST

    Hello,

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

    Regards,
    Ruchir
  • Replied 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
  • Replied 21 April 2020, 12:03 am EST

    Hello,

    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.
  • Replied 21 April 2020, 2:59 am EST

    Ruchir.Agarwal said:
    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.

    Ruchir



    Hello
    Here's one file simple file

    thanks
    Olivier
  • Replied 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
  • Replied 21 April 2020, 3:36 pm EST

    Hello Olivier,

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

    Thanks,
  • Replied 21 April 2020, 8:48 pm EST

    Ruchir.Agarwal said:
    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


    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
  • Replied 21 April 2020, 7:05 pm EST

    Ruchir.Agarwal said:
    Hello Olivier,

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

    Thanks,


    here's the file
    testFile.zip
  • Replied 22 April 2020, 9:24 pm EST

    julius said:
    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


    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
  • Replied 22 April 2020, 9:25 pm EST

    olivier941 said:
    here's the file
    testFile.zip
    Thank you, Olivier. I have passed it to the developer for testing the utility.

    Thanks,
    Ruchir
  • Replied 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.
  • Replied 22 April 2020, 10:39 pm EST

    Ruchir.Agarwal said:
    [quote]olivier941 said:
    here's the file
    testFile.zip

    Thank you, Olivier. I have passed it to the developer for testing the utility.

    Thanks,
    Ruchir


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

    thanks
  • Replied 26 May 2021, 3:53 am EST

    Hello

    I'm very disapointed :-(
    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

    http://helpcentral.componentone.com/docs/vsflexgrid8/archivemethod.htm

    it's vsFlexGrid 7 and
      NOT
    8


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


    thanks for any help







    olivier941 said:
    [quote]Ruchir.Agarwal said:
    [quote]olivier941 said:
    here's the file
    testFile.zip

    Thank you, Olivier. I have passed it to the developer for testing the utility.

    Thanks,
    Ruchir


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

    thanks
    [/quote]tablesnew2.zip
  • Replied 26 May 2021, 11:17 pm EST

    Hello,

    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.
  • Replied 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
Need extra support?

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

Learn More

Forum Channels