About flexGrid LoadExcel

About flexGrid LoadExcel

Posted by: toynnus on 18 September 2020, 10:38 am EST

• 

  toynnus

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 18 September 2020, 10:38 am EST - Updated 3 October 2022, 11:38 pm EST

  dear grapeCity Team.

  I am trying to parse excel through LoadExcel function of FiexGrid.
  
  The data of the merged cell is not displayed.
  
  Is there any way to solve it?

  

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 21 September 2020, 12:42 am EST - Updated 3 October 2022, 11:38 pm EST

  Hi Sungtae,

  You can use the FileFlags parameter as FileFlags.LoadMergedRanges to get the desired output. The code snippet is given below to do the same:

  c1FlexGrid1.LoadExcel(@"..\..\Book1.xlsx", FileFlags.LoadMergedRanges);
  
  

  If you need any other help, please let me know.

  Regards,
  
  Prabhat Sharma.

  

  1075×451 37.7 KB