Author Topic: Export to excel  (Read 1845 times)

Akihiro Inoue

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 32
    • View Profile
Export to excel
« on: December 17, 2018, 11:16:58 am »

Outputting column ("01","02","03"...) in PQgrid to Excel will change ("1","2","3"...).
But the Format Cells is General. We want it to set Text.
We want to output it as it is.

Please tell me what to do.

We wrote a sample in the jsfiddle.
http://jsfiddle.net/s_matsumoto/j1botfs7/4/

(We use pqGrid "ver 4.0.1")

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Export to excel
« Reply #1 on: December 18, 2018, 11:52:13 am »
Currently we don't have the feature to override/specify format of cells in Excel export.

May you can prepend the numbers with a letter to force them to format as strings like "a01", "a02", etc.

Akihiro Inoue

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 32
    • View Profile
Re: Export to excel
« Reply #2 on: December 18, 2018, 12:03:17 pm »
Thanks support.
I expect the next update.