ExcelOpenFlags in winForms 5

Posted by: grantes on 19 April 2023, 6:56 am EST

    • Post Options:
    • Link

    Posted 19 April 2023, 6:56 am EST

    It’s possible use ExcelOpenFlags to open excel in Winforms 5?

    if yes, how?

  • Posted 19 April 2023, 8:58 pm EST

    Hi Giancarlo,

    You can use ExcelOpenFlags enum as shown in the following line of code:

    fpSpread1.OpenExcel("..\\..\\..\\SumSample.xlsx", FarPoint.Excel.ExcelOpenFlags.TruncateEmptyRowsAndColumns);

    We request you to please clarify what you mean by stating “Winforms 5”. We weren’t sure if you meant the version of the target framework you’re using, i.e. 5.0 or the fpspread version you’re running.

    However, taking into account the first scenario, we created an example application using the latest version (v16) fpspread control on a.NET5 target framework. Please refer to the attached ExcelOpenFlags.zip.

    Please let us know if you still have any concerns.

    Thanks & Regards,


  • Posted 20 April 2023, 3:06 am EST


    5.0 is the fpspread control version

  • Posted 20 April 2023, 8:14 pm EST

    Hi Giancarlo,

    The code provided earlier in this thread can be used to implement the ExcelOpenFlags enum in Spread.NET v5 in the exact same way. However, Spread.NET v5 supports comparatively fewer enums than Spread.NET v16 because it is an older version. Please refer ExcelOpenFlags.zip to see enums supported by Spread.NET v5.

    Kindly let us know if you have any further concerns regarding this.

    Thanks & Regards,


  • Posted 25 April 2023, 1:33 am EST


    I still don’t understand how to use in spread v5

    Could you send me an example?

  • Posted 26 April 2023, 3:36 am EST

    Hi Giancarlo,

    Please find attached the sample application for your reference. Spread5ExcelFlags.zip

    You can use the enum value for ExcelOpenFlags as per your requirement.

    Kindly let us know if you have any further concerns.

    Thanks & Regards,


Need extra support?

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

Learn More

Forum Channels