Help with not displaying hidding columns when exporting to excel or PDF

Help with not displaying hidding columns when exporting to excel or PDF

Posted by: Victor.m.charles.civ on 5 February 2020, 10:22 am EST

• 

  Victor.m.charles.civ

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 February 2020, 10:22 am EST

  Hello,

  When exporting to excel or PDF from my C1TrueDBGrid, how do I avoid including hiding columns?

  Thanks,

  Victor

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 6 February 2020, 12:44 am EST

  Hi Victor,

  You can use the ExportToPDF and ExportToExcel methods of TrueDBGrid for exporting and it will not include hidden columns.

  C1TrueDBGrid1.ExportToPDF("demo.pdf")
  C1TrueDBGrid1.ExportToExcel("demo.xlsx")
  

  Please find the attached sample implementing the same.

  Regards,
  
  Prabhat Sharma.
  
  TDBDemoVB.zip