ExcelOpenFlags in winForms 5

ExcelOpenFlags in winForms 5

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

• 

  grantes

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 19 April 2023, 6:56 am EST

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

  if yes, how?

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  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,
  
  Aastha

• 

  grantes

  • Post Options:
  • Link
    Copy

  Posted 20 April 2023, 3:06 am EST

  Hi

  5.0 is the fpspread control version

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  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,
  
  Aastha

• 

  grantes

  • Post Options:
  • Link
    Copy

  Posted 25 April 2023, 1:33 am EST

  Hi

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

  Could you send me an example?

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  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,
  
  Aastha